如何使用代码新建一个表并将其添加进数据库

            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();