private void button1_Click(object sender, EventArgs e)
{
string qid=tb_id.Text; string qName = tb_Name.Text; string qAge = tb_Age.Text; string qemail = tb_email.Text; string qAddress = tb_Address.Text; SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=123;Integrated Security=False"); SqlCommand cmd = new SqlCommand("insert into USER( ID,Name,Age,email,Address)values("+qid+",'"+qName+"','"+qAge+"','"+qemail+"','"+qAddress+"')"); con.Open();
cmd.ExecuteNonQuery();
con.Close(); }运行程序向TextBox中添加数据然后点 按钮执行操作的时候提示“ExecuteNonQuery: Connection 属性尚未初始化”请问应该怎么改啊 谢谢了在线等~!
{
string qid=tb_id.Text; string qName = tb_Name.Text; string qAge = tb_Age.Text; string qemail = tb_email.Text; string qAddress = tb_Address.Text; SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=123;Integrated Security=False"); SqlCommand cmd = new SqlCommand("insert into USER( ID,Name,Age,email,Address)values("+qid+",'"+qName+"','"+qAge+"','"+qemail+"','"+qAddress+"')"); con.Open();
cmd.ExecuteNonQuery();
con.Close(); }运行程序向TextBox中添加数据然后点 按钮执行操作的时候提示“ExecuteNonQuery: Connection 属性尚未初始化”请问应该怎么改啊 谢谢了在线等~!
{
string qid=tb_id.Text; string qName = tb_Name.Text; string qAge = tb_Age.Text; string qemail = tb_email.Text; string qAddress = tb_Address.Text; SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=123;Integrated Security=False"); SqlCommand cmd = new SqlCommand("insert into USER( ID,Name,Age,email,Address)values("+qid+",'"+qName+"','"+qAge+"','"+qemail+"','"+qAddress+"')");
cmd.Connection=con;
con.Open();
cmd.ExecuteNonQuery();
con.Close(); }
记得将Command和Connection对象间建立关联, 疏忽了。
他开写不就好了么
偷懒技术没达到啊
string sql="insert into USER( ID,Name,Age,email,Address)values("+qid+",'"+qName+"','"+qAge+"','"+qemail+"','"+qAddress+"')";
SqlCommand cmd = new SqlCommand(sql, con);