SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=(local)\SQLEXPRESS;Initial Catalog=EventClass;Integrated Security=True;Pooling=False";
con.Open();
DataColumn IDColumn = new DataColumn("ID", typeof(int));
IDColumn.ReadOnly = true;
IDColumn.AllowDBNull = false;
IDColumn.Unique = true;
DataColumn NameColumn = new DataColumn("Name", typeof(string));
DataTable testTable = new DataTable("TestTable");
testTable.Columns.AddRange(new DataColumn[] { IDColumn, NameColumn });
//重点:利用sqlcommand的create命令来创建表
string sql = "CREATE TABLE mytable (Name VARCHAR(25), Age INTEGER)";
SqlCommand cmd = new SqlCommand(sql,con);
cmd.ExecuteNonQuery();
con.Close();
如何使用代码新建一个表并将其添加进数据库
最新推荐文章于 2024-03-28 17:14:17 发布