1,977
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
public partial class formMain : Form
{
public bool modifi = false;
public string myname;
SqlDataAdapter adapter, adapter1, adapter2; //定义数据库读取对象
DataSet ds, ds1, ds2; //定义数据集
public formMain()
{
InitializeComponent();
//数据库连接字段,可以到www.connectionstrings.com查看更多的连接串
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 学生表";//sql 查询语句
adapter = new SqlDataAdapter(sqlstr, con);//执行查询语句,根据数据库连接读取数据库
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
adapter.InsertCommand = builder.GetInsertCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
ds = new DataSet();
adapter.Fill(ds, "学生表");//把查询到的结果,填充到数据集中保存
this.dataGrid1.DataSource = ds.Tables["学生表"]; //数据绑定,
con.Close(); //关闭数据链接,每次数据查询完成后,都要关闭数据库链接
}