public partial class formMain : Form
{
public bool modifi = false;
public string myname;
SqlDataAdapter adapter, adapter1, adapter2;
DataSet ds, ds1, ds2;
public formMain()
{
InitializeComponent();
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.UpdateCommand = builder.GetUpdateCommand();
ds = new DataSet();
adapter.Fill(ds, "学生表");
this.dataGrid1.DataSource = ds.Tables["学生表"]; sqlstr = "select * from 课程表";
adapter1 = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder1 = new SqlCommandBuilder(adapter1);
adapter1.InsertCommand = builder1.GetInsertCommand();
adapter1.DeleteCommand = builder1.GetDeleteCommand();
adapter1.UpdateCommand = builder1.GetUpdateCommand();
ds1 = new DataSet();
adapter1.Fill(ds1, "课程表");
this.dataGrid2.DataSource = ds1.Tables["课程表"]; sqlstr = "select * from 选课表";
adapter2 = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder2 = new SqlCommandBuilder(adapter2);
adapter2.InsertCommand = builder2.GetInsertCommand();
adapter2.DeleteCommand = builder2.GetDeleteCommand();
adapter2.UpdateCommand = builder2.GetUpdateCommand();
ds2 = new DataSet();
adapter2.Fill(ds2, "选课表");
this.dataGrid3.DataSource = ds2.Tables["选课表"];
con.Close();
}
private void formMain_FormClosing_1(object sender, FormClosingEventArgs e)
{
Application.Exit();
} private void AddInf_Click_1(object sender, EventArgs e)
{
AddStudent adst = new AddStudent(); adst.Show();
} private void AddCourse_Click(object sender, EventArgs e)
{ formAdC adco = new formAdC();
adco.Show();
}
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["学生表"]; sqlstr = "select * from 课程表";
adapter1 = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder1 = new SqlCommandBuilder(adapter1);
adapter1.InsertCommand = builder1.GetInsertCommand();
adapter1.DeleteCommand = builder1.GetDeleteCommand();
adapter1.UpdateCommand = builder1.GetUpdateCommand();
ds1 = new DataSet();
adapter1.Fill(ds1, "课程表");
this.dataGrid2.DataSource = ds1.Tables["课程表"]; sqlstr = "select * from 选课表";
adapter2 = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder2 = new SqlCommandBuilder(adapter2);
adapter2.InsertCommand = builder2.GetInsertCommand();
adapter2.DeleteCommand = builder2.GetDeleteCommand();
adapter2.UpdateCommand = builder2.GetUpdateCommand();
ds2 = new DataSet();
adapter2.Fill(ds2, "选课表");
this.dataGrid3.DataSource = ds2.Tables["选课表"];
con.Close();
}
主要意思是什么?adpater怎么使用的?
{
public bool modifi = false;
public string myname;
SqlDataAdapter adapter, adapter1, adapter2;
DataSet ds, ds1, ds2;
public formMain()
{
InitializeComponent();
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.UpdateCommand = builder.GetUpdateCommand();
ds = new DataSet();
adapter.Fill(ds, "学生表");
this.dataGrid1.DataSource = ds.Tables["学生表"]; sqlstr = "select * from 课程表";
adapter1 = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder1 = new SqlCommandBuilder(adapter1);
adapter1.InsertCommand = builder1.GetInsertCommand();
adapter1.DeleteCommand = builder1.GetDeleteCommand();
adapter1.UpdateCommand = builder1.GetUpdateCommand();
ds1 = new DataSet();
adapter1.Fill(ds1, "课程表");
this.dataGrid2.DataSource = ds1.Tables["课程表"]; sqlstr = "select * from 选课表";
adapter2 = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder2 = new SqlCommandBuilder(adapter2);
adapter2.InsertCommand = builder2.GetInsertCommand();
adapter2.DeleteCommand = builder2.GetDeleteCommand();
adapter2.UpdateCommand = builder2.GetUpdateCommand();
ds2 = new DataSet();
adapter2.Fill(ds2, "选课表");
this.dataGrid3.DataSource = ds2.Tables["选课表"];
con.Close();
}
private void formMain_FormClosing_1(object sender, FormClosingEventArgs e)
{
Application.Exit();
} private void AddInf_Click_1(object sender, EventArgs e)
{
AddStudent adst = new AddStudent(); adst.Show();
} private void AddCourse_Click(object sender, EventArgs e)
{ formAdC adco = new formAdC();
adco.Show();
}
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["学生表"]; sqlstr = "select * from 课程表";
adapter1 = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder1 = new SqlCommandBuilder(adapter1);
adapter1.InsertCommand = builder1.GetInsertCommand();
adapter1.DeleteCommand = builder1.GetDeleteCommand();
adapter1.UpdateCommand = builder1.GetUpdateCommand();
ds1 = new DataSet();
adapter1.Fill(ds1, "课程表");
this.dataGrid2.DataSource = ds1.Tables["课程表"]; sqlstr = "select * from 选课表";
adapter2 = new SqlDataAdapter(sqlstr, con);
SqlCommandBuilder builder2 = new SqlCommandBuilder(adapter2);
adapter2.InsertCommand = builder2.GetInsertCommand();
adapter2.DeleteCommand = builder2.GetDeleteCommand();
adapter2.UpdateCommand = builder2.GetUpdateCommand();
ds2 = new DataSet();
adapter2.Fill(ds2, "选课表");
this.dataGrid3.DataSource = ds2.Tables["选课表"];
con.Close();
}
主要意思是什么?adpater怎么使用的?
获取课程表,学生表,选课表数据
添加课程
添加信息
课程表
选课表adpater怎么使用的?你的代码就是这个问题的答案。