啊凡达与吊死男:c#连接数据库的问题
来源:百度文库 编辑:高校问答 时间:2024/06/29 21:05:51
哪个好心的大哥大姐教教俺下边的代码到底是什么意思啊
conn=new SqlConnection("server=.;database=stu_course;integrated security=true;");
ds=new DataSet();
daStu=new SqlDataAdapter("select * from student",conn);
daStu.Fill(ds,"student");
cmb.DataSource=ds.Tables["student"];
cmb.DisplayMember="Sname";
daSC=new SqlDataAdapter();
SqlCommand cmd=new SqlCommand();
cmd.CommandText="select * from course";
cmd.Connection=conn;
daSC.SelectCommand=cmd;
daSC.Fill(ds,"course");
dg.DataSource=ds.Tables["course"];
conn=new SqlConnection("server=.;database=stu_course;integrated security=true;");
ds=new DataSet();
daStu=new SqlDataAdapter("select * from student",conn);
daStu.Fill(ds,"student");
cmb.DataSource=ds.Tables["student"];
cmb.DisplayMember="Sname";
daSC=new SqlDataAdapter();
SqlCommand cmd=new SqlCommand();
cmd.CommandText="select * from course";
cmd.Connection=conn;
daSC.SelectCommand=cmd;
daSC.Fill(ds,"course");
dg.DataSource=ds.Tables["course"];
conn=new SqlConnection("server=.;database=stu_course;integrated security=true;");
ds=new DataSet();
daStu=new SqlDataAdapter("select * from student",conn);
daStu.Fill(ds,"student");
dg.DataSource=ds.Tables["student"];
理解这几行就中了!
几个对象需要掌握:
1、DATASET
2、SQLCONNECTIN
3、SQLDATAADAPTER
4、DATAGRID
简间的要死,你自己看吧!