DataGrid更新数据问题?
老是出错,各位帮忙看一下,多谢了.
protected void update_Click(Object Sender,DataGridCommandEventArgs e)
{
int id,isPb,import;
id=Convert.ToInt32(e.Item.Cells[0].Text);
CheckBox Pb=(CheckBox)e.Item.Cells[3].Controls[0];
CheckBox Imp=(CheckBox)e.Item.Cells[4].Controls[0];
if(Pb.Checked)
isPb=1;
else
isPb=0;
if(Imp.Checked)
import=1;
else
import=0;
UpdateAll(id,isPb,import);
activeList.EditItemIndex=-1;
LoadGrid();
}
private void UpdateAll(int id,int isPb,int import)
{
Db MyDb=new Db();
MyDb.NonQuery("UPDATE Activity SET auditing='"+isPb+"',auditingcategory='"+import+"' WHERE ID='"+id+"'");
}