Question

c# 向数据库添加数据 没有错误提示 但是添加不上去 会出现添加失败 求教！！！！

namespace MyWork8
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{

try
{
string str = "Data Source=DESKTOP-5RB750F\\SQLEXPRESS;Initial Catalog=EMDB;Integrated Security=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string InsertSql = "insert into tb_stuInformation(sname,sclass,snation) values ('" + textBox1.Text + "','" + textBox2.Text + "','" + comboBox1.Text + "')";
SqlCommand com = new SqlCommand(InsertSql, conn);
com.ExecuteNonQuery();
conn.Close();

}
catch (Exception )
{
MessageBox.Show("添加失败!", "用户提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}

}

}
}

Answer 1

你SQL语句字符串有问题， 你试一下这个语句：string InsertSql=string.Format("insert into tb_stuInformation(sname,sclass,snation) values ('{0}','{1}','{2}')",textBox1.Text,textBox2.Text,comboBox1.Text);