关于用SQL更新数据
bluex 2003-02-11 09:44:44 DATAGRID的"更新"
private void DataGrid4_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
String aa = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
String bb =((TextBox)e.Item.Cells[2].Controls[0]).Text;
SqlConnection cn=new SqlConnection("data source=(local);initial catalog=qwer;user id=sa;password=;workstation id=BSERV" +"ER;packet size=4096");
SqlCommand cmd=new SqlCommand("update wwe set gq=aa,dm=bb",cn);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
错误:列名 'aa' 无效。列名 'bb' 无效。