求理解
private void button1_Click_1(object sender, EventArgs e){
string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Administrator\桌面\学生信息管理系统\WindowsApplication3\DATA\maojin.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection con = new SqlConnection(str);
string sqlstr = "select * from 学生表";
adapter = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
adapter.InsertCommand = builder.GetInsertCommand();
adapter.DeleteCommand = builder.GetDeleteCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
ds = new DataSet();
adapter.Fill(ds, "学生表");
this.dataGrid1.DataSource = ds.Tables["学生表"]; --------------------编程问答-------------------- 按下按钮从maojin.mdf(sqlserver express DB)中的“学生表”中取出全部数据,显示到Form上DataGridView上。。。
还有什么地方不理解? --------------------编程问答-------------------- 看看MSDN,查询数据获取绑定到dataGrid
http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlcommandbuilder.getinsertcommand.aspx --------------------编程问答--------------------
--------------------编程问答-------------------- 你怎么 把 文件 放在 桌面 上啊 ? --------------------编程问答-------------------- 哪不理解???不要说都不理解这么不负责的话。
private void button1_Click_1(object sender, EventArgs e)
{
//连接数据库的字符串
string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Administrator\桌面\学生信息管理系统\WindowsApplication3\DATA\maojin.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
连接对象,用来连接数据库
SqlConnection con = new SqlConnection(str);
//查询语句
string sqlstr = "select * from 学生表";
//适配器,
adapter = new SqlDataAdapter(sqlstr, con);
//配置SqlcommandBuilder
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
adapter.InsertCommand = builder.GetInsertCommand();
adapter.DeleteCommand = builder.GetDeleteCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
//创建数据集
ds = new DataSet();
//填充数据集
adapter.Fill(ds, "学生表");
//指定dataGrid1的数据源
this.dataGrid1.DataSource = ds.Tables["学生表"];
}
贴图片很累吧,用《Csdn收音机》截图功能轻松解决! --------------------编程问答--------------------
呵呵 --------------------编程问答--------------------
是的哈 下次注意了 --------------------编程问答--------------------
谢了` --------------------编程问答-------------------- 嘿嘿,我要是不回,你也不能回,Csdn限制3次。。。
《Csdn收音机》在线检测最新版本,让你永不过期!
补充:.NET技术 , C#