朋友你好
我有两个数据库中的表命名为学生和student1
学生表:
ID(主键),姓名,父亲姓名,电话号码
student1表:
ID(外键),部门名称
cs代码文件如下,这是由我编写。
string Strsql = select * from student; Select * from student1;
Connection.sqldataadapter = new SqlDataAdapter(Strsql, Connection.sqlconnection);
Connection.dataset = new DataSet();
Connection.sqldataadapter.Fill(Connection.dataset);
Connection.dataset.Tables[0].TableName = Student;
Connection.dataset.Tables[1].TableName = Student1;
Connection.sqldataadapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
dgvStudent.DataSource = Connection.dataset.Tables[0];
Connection.sqlcommandbuilder = new SqlCommandBuilder(Connection.sqldataadapter);
On Insert Button Click:
DataRow dr = Connection.dataset.Tables[0].NewRow();
dr["ID"] = textBox1.Text;
dr["Name"] = textBox2.Text;
dr["FatherName"] = textBox3.Text;
dr["PhoneNo"] = textBox4.Text;
Connection.dataset.Tables[0].Rows.Add(dr);
DataRow dr1 = Connection.dataset.Tables[1].NewRow();
dr1["ID"] = textBox1.Text;
dr1["DepartmentName"] = textBox5.Text;
Connection.dataset.Tables[1].Rows.Add(dr1);
textBox1.Text="";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
更新按钮的Click:
{C}
提交按钮的Click:这是我的DataAdapter更新按钮,但它提供了一些错误。它填补学生表中的数据,但它不填写student1数据。
缺少SourceColumn的"名字"的DataColumn'名'的DataTable Student1"。
Connection.sqldataadapter.Update(Connection.dataset.Tables[0]);
Connection.sqldataadapter.Update(Connection.dataset.Tables[1]); // on this point it gives error which is given below :
请帮助我尽快。解决我的问题,提前感谢......................| Sunil.yadava09:亨利时刻