private void btnRegister_Click(object sender, EventArgs e)
{
string cs = "server= 127.0.0.1;uid=sa;pwd=110 ;database=yanshi";
SqlConnection sqlcon = new SqlConnection(cs);
sqlcon.Open();
string name = this.textBox1.Text;
string tel = this.textBox2.Text;
string sql = "insert into User (strName,strTel) values('" + name + "','" + tel + "')";
SqlCommand com = new SqlCommand(sql,sqlcon);
int i = Convert.ToInt32(com.ExecuteNonQuery());
if (i > 0)
{
sqlcon.Close();
MessageBox.Show(" 登记成功");
}
else
{
sqlcon.Close();
MessageBox.Show(" 登记失败");
} }
现在错误是:关键字 'User' 附近有语法错误,但是User表就2个字段:strName,strTel,请问究竟错在哪里?
{
string cs = "server= 127.0.0.1;uid=sa;pwd=110 ;database=yanshi";
SqlConnection sqlcon = new SqlConnection(cs);
sqlcon.Open();
string name = this.textBox1.Text;
string tel = this.textBox2.Text;
string sql = "insert into User (strName,strTel) values('" + name + "','" + tel + "')";
SqlCommand com = new SqlCommand(sql,sqlcon);
int i = Convert.ToInt32(com.ExecuteNonQuery());
if (i > 0)
{
sqlcon.Close();
MessageBox.Show(" 登记成功");
}
else
{
sqlcon.Close();
MessageBox.Show(" 登记失败");
} }
现在错误是:关键字 'User' 附近有语法错误,但是User表就2个字段:strName,strTel,请问究竟错在哪里?
string sql = "insert into [User] (strName,strTel) values('" + name + "','" + tel + "')";
string sql = "insert into User values('" + name + "','" + tel + "')";