public void DataGrid_UpdateCommand(Object sender,DataGridCommandEventArgs e)
{
//更新数据库中的信息
string strName = e.Item.Cells[1].Text;
int intChinese = Int32.Parse(((TextBox)e.Item.Cells[2].Controls[0]).Text);
int intMath = Int32.Parse(((TextBox)e.Item.Cells[3].Controls[0]).Text);
int intEnglish = Int32.Parse(((TextBox)e.Item.Cells[4].Controls[0]).Text);
///string newString=怎么写??? //更新数据库中的数据
string strUpdate = "Update Score Set Chinese="+intChinese+",Math="+intMath+",English="+intEnglish+" Where Name='"+strName+"'";
///string strUpdate = "Update Score Set Chinese="+intChinese+",Math="+intMath+",English="+intEnglish+",String='"+newString+"' Where Name='"+strName+"'";这样写对吗???? OleDbCommand MyComm = new OleDbCommand(strUpdate,MyConn);
MyComm.ExecuteNonQuery();
score.EditItemIndex = -1;
BindGrid();
}
偶想编辑一个文本类型的字段,该怎么写C#代码和SQL语句呢?
数据库是ACCESS~
{
//更新数据库中的信息
string strName = e.Item.Cells[1].Text;
int intChinese = Int32.Parse(((TextBox)e.Item.Cells[2].Controls[0]).Text);
int intMath = Int32.Parse(((TextBox)e.Item.Cells[3].Controls[0]).Text);
int intEnglish = Int32.Parse(((TextBox)e.Item.Cells[4].Controls[0]).Text);
///string newString=怎么写??? //更新数据库中的数据
string strUpdate = "Update Score Set Chinese="+intChinese+",Math="+intMath+",English="+intEnglish+" Where Name='"+strName+"'";
///string strUpdate = "Update Score Set Chinese="+intChinese+",Math="+intMath+",English="+intEnglish+",String='"+newString+"' Where Name='"+strName+"'";这样写对吗???? OleDbCommand MyComm = new OleDbCommand(strUpdate,MyConn);
MyComm.ExecuteNonQuery();
score.EditItemIndex = -1;
BindGrid();
}
偶想编辑一个文本类型的字段,该怎么写C#代码和SQL语句呢?
数据库是ACCESS~
------------------------------------------------------------------------------------
不对,应该这样写:
string strUpdate = "Update Score Set Chinese="+"'"+intChinese+"'"+",Math="+"'"+intMath+"'"+",English="+"'"+intEnglish+"'"+",String="+newString+" Where Name="+strName;
增加修改一些偶想达到编辑ACCSESS数据库文本字段的功能。