Question

sqlparameter 问题

protected void btn_onclick(object sender, EventArgs e)
{

// Parameter [] para= new Parameter[8];

SqlParameter[] para = new SqlParameter[] {new SqlParameter("@content", SqlDbType.NText) };

para[0].Value = txt1.Text;
string strSQL = "insert into t_test(content)values(@content)";
SqlCommand cmd = new SqlCommand(strSQL, dataclass.getCnn());
cmd.Parameters.Add(para);

cmd.ExecuteNonQuery();
}

请告诉错误在那里？

Answer 1

SqlParameter para = new SqlParameter("@content", SqlDbType.NText);
string strSQL = "insert into t_test ([content]) values (@content)";
SqlCommand cmd = new SqlCommand(strSQL, dataclass.getCnn());
cmd.Parameters.Add(para);