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();
}
报错:找不到类型或命名空间名称“GridView”(是否缺少 using 指令或程序集引用?)
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();
}
报错:找不到类型或命名空间名称“GridView”(是否缺少 using 指令或程序集引用?)
解决方案 »
- 用C#编程找文本中的重复行?
- Ini读取的字符串用于Dictionary键值查找出现错误.
- 如何自动关闭IE
- 请教链接问题
- 帮忙
- C#怎么获取LPT1上接的设备是否开启
- 在C#加WebForm程序时,使用WebControls.TreeView控件,为什么我在代码中的treeNode.Expand=True的语句不激发Expand事件
- 如何添加数组到list并读出来?谢谢
- C#如何在低版本的fastreport的条码控件添加QRcode选项的条码类型
- 本人有一笔新软件单子,是一个服装厂的ERP系统,要求用B/S结构,有会的请与我联系,共同开发
- 如何设置DropDownList的高度
- 自定义控件中有2个combox控件的keypress如何影响控件的keypress
{
//....
}
报错:命名空间“System.Web”中不存在类型或命名空间名称“UI”(是缺少程序集引用吗?)