c#无法写入数据库,很急,求各位指点
我想在button里加事件,点击button时,其他几个textbox的数据都传到数据库里,但是显示的是“连接数据库错误”,就是我catch里写的,是我的代码有问题吗,还是不能这样写
private void button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection sqlcon = new SqlConnection("Data Source=laptop-cl08flf2;Initial Catalog=hospital;User Id=LAPTOP-CL08FLF2\\lenovo;Integrated Security=SSPI");
sqlcon.Open();
string InsertSql = "insert into patient(身份证号,姓名,年龄,电话,科室,门诊类别,编号) values(" + textBox3.Text + "," + textBox1.Text + "," + textBox2.Text + "," + textBox4.Text + "," + listBox1.Text + "," + listBox2.Text + ")";
SqlCommand com = new SqlCommand(InsertSql, sqlcon);
com.ExecuteNonQuery();
SqlDataAdapter ada = new SqlDataAdapter("select * from patient", sqlcon);
DataSet mypatient = new DataSet();
ada.Fill(mypatient, "patient");
sqlcon.Close();
}
catch
{
MessageBox.Show("连接数据库失败");
}
}