这是我的代码
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connStr);
try
{
string updateStr = "update huangdao set ";
for (int i = 1; i < DetailsView2.Rows.Count - 1; i++)
{
TextBox stateTextBox = (TextBox)DetailsView2.Rows[i].Cells[1].Controls[0];
updateStr += DetailsView2.Rows[i].Cells[0].Text.ToString() + "='" + stateTextBox.Text + "',";
}
updateStr = updateStr.Substring(0, updateStr.Length - 1);
updateStr += " where id = " + xmid; Response.Write(updateStr);
System.Data.OleDb.OleDbCommand oledbCom = new System.Data.OleDb.OleDbCommand(updateStr,conn);
if (conn.State.ToString() == "Closed") conn.Open();
oledbCom.ExecuteNonQuery();
GridViewBind();
}
为什么我在detailsview里修改的字段值都没被提交呢?获取的值还是修改之前的,郁闷呀.
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connStr);
try
{
string updateStr = "update huangdao set ";
for (int i = 1; i < DetailsView2.Rows.Count - 1; i++)
{
TextBox stateTextBox = (TextBox)DetailsView2.Rows[i].Cells[1].Controls[0];
updateStr += DetailsView2.Rows[i].Cells[0].Text.ToString() + "='" + stateTextBox.Text + "',";
}
updateStr = updateStr.Substring(0, updateStr.Length - 1);
updateStr += " where id = " + xmid; Response.Write(updateStr);
System.Data.OleDb.OleDbCommand oledbCom = new System.Data.OleDb.OleDbCommand(updateStr,conn);
if (conn.State.ToString() == "Closed") conn.Open();
oledbCom.ExecuteNonQuery();
GridViewBind();
}
为什么我在detailsview里修改的字段值都没被提交呢?获取的值还是修改之前的,郁闷呀.
{
初始化
}
大家有没有detailsview的比较好的例子?