Question

ASP.NET动态创建和浏览数据库的实现，用c#编程

全部用代码编写的，哪位高手帮帮忙，谢谢了
我的意思就是在vs2005里面用代码编写创建数据库和浏览数据库，我的论文题目是《.NET技术下动态创建或浏览数据库的实现》，不用vb.net编程，用c#编程，所以需要大家帮帮忙，我所有的分就这么多了，都给你们，跪谢了

Answer 1

SqlConnection conn = new SqlConnection();
string connToMaster = "Server=.\\sqlexpress;DataBase=master;Integrated Security=true";
string connToDb = "Server=.\\sqlexpress;DataBase=test1;Integrated Security=true";
string createDbStr = "Create database [test1]";
string createTableStr = "create table example ([id] int primary key,[name] Nchar(5))";
string insertStr = "insert into example values(1,'Mike')";
string selectStr = "select * from example";
SqlCommand cmd = new SqlCommand(createDbStr, conn);

conn.ConnectionString = connToMaster;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

conn.ConnectionString = connToDb;
conn.Open();
cmd.CommandText = createTableStr;
cmd.ExecuteNonQuery();
cmd.CommandText = insertStr;
cmd.ExecuteNonQuery();
conn.Close();

cmd.CommandText = selectStr;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

GridView gv = new GridView();
form1.Controls.Add(gv);
gv.AutoGenerateColumns = true;
gv.DataSource = dt;
gv.DataBind();

Answer 2

不懂意思

Answer 3

楼主说清楚点吧

Answer 4

数据库管理，这个一两句话说不清楚，还有你那个50分也太少了吧给200也不说

Answer 5

如果你用SQL 服务器的华 你可以参考一下 SMO