新手关于插入数据库的一个问题
我的想法是把几个TEXTBOX里面的值插入到一个已经建立的表中
SqlConnection myConn = new SqlConnection("server=.; database=xsxx; uid=sa; pwd=;");
myConn.Open();
string str1 = this.TextBox1.Text.Trim();
string str2 = this.TextBox2.Text.Trim();
string str3 = this.TextBox3.Text.Trim();
string str4 = this.TextBox4.Text.Trim();
string str5 = this.TextBox5.Text.Trim();
string str6 = this.TextBox6.Text.Trim();
string sqlStr = "insert into xsxx values(str1,str2,str3,str4,str5,str6)";
SqlCommand myCmd = new SqlCommand(sqlStr, myConn);
myCmd.ExecuteNonQuery();
myConn.Close();
结果说是myCmd.ExecuteNonQuery();出错,不过我觉得应该是SQL语句的问题,本人菜鸟。希望高手指点下。。谢谢