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["学生表"];
{
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["学生表"];
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["学生表"];
}