Question

System.Data.SqlClient.SqlException: 列名无效

string sqlconnstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(sqlconnstr);
//建立Command对象
SqlCommand sqlcommand = new SqlCommand();
sqlcommand.Connection = sqlconn;
//把SQL语句赋给Command对象
sqlcommand.CommandText = "insert into 留言 liuyan values @liuyan";
sqlcommand.Parameters.AddWithValue("@liyan", TextBox1.Text);

sqlcommand = null;
sqlconn.Close();
sqlconn = null;

Answer 1

1.
sqlcommand.CommandText = "insert into 留言(liuyan) values @liuyan";//SQL语句写法问题

2.
sqlconn.Open();//打开连接
sqlcommand.Parameters.AddWithValue("@liyan", TextBox1.Text);
3.
sqlcommand.ExecuteNonQuery();//执行SQL语句
4.
sqlcommand = null;//这句不需要啦，可以删掉