读书人

C#中如何同时像两个表中插入数据啊附上

发布时间: 2012-06-09 17:16:42 作者: rapoo

C#中怎么同时像两个表中插入数据啊?附上我的代码
string s= @"Data Source=.\SQLEXPRESS;Initial Catalog=学生管理系统;Integrated Security=True";
string sq = "Insert Into Student(StudentName,StudentNum,StudentSex,StudentAge,StudentSdept) Values('"; sq += textBox1.Text + "' , '"; sq += textBox2.Text + "' , '"; sq += textBox3.Text + "','"; sq += textBox4.Text + "','"; sq += textBox5.Text + "') , Insert Into Accommodation(DorID) Values('"; sq += textBox6.Text + "')";

SqlConnection conn=new SqlConnection(s);

conn.Open();

SqlCommand da=new SqlCommand(sq, conn);

da.ExecuteNonQuery();//执行SQL语句

conn.Close(); //关闭数据库连接

[解决办法]
Insert Into Accommodation 把这句前面的逗号换成分号

读书人网 >C#

热点推荐