}
public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e)
{
string dq1 = ((TextBox)e.Item.FindControl("edit_dq")).Text;
string sm1 = ((TextBox)e.Item.FindControl("edit_sm")).Text;
string yb1 = ((TextBox)e.Item.FindControl("edit_yb")).Text;
string qh1 = ((TextBox)e.Item.FindControl("edit_qh")).Text;
OpenDatabase();
String OleDb_edit = "UPDATE YBQH " +
"SET dq = '" + dq1.Replace("'","''")+ "'," +
"sm = '" + sm1.Replace("'","''")+ "'" +
"yb = '" + yb1.Replace("'","''")+ "'" +
"qh = '" + qh1.Replace("'","''")+ "'" +
" WHERE ID = " + MyDataGrid.DataKeys[e.Item.ItemIndex];
OleDbConnection myConnection = cn;
OleDbCommand OleDbCommandUpdate = new OleDbCommand(OleDb_edit,myConnection);
OleDbCommandUpdate.ExecuteNonQuery();
myConnection.Close();
MyDataGrid.EditItemIndex = -1;
BindGrid(); }
public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e)
{
string dq1 = ((TextBox)e.Item.FindControl("edit_dq")).Text;
string sm1 = ((TextBox)e.Item.FindControl("edit_sm")).Text;
string yb1 = ((TextBox)e.Item.FindControl("edit_yb")).Text;
string qh1 = ((TextBox)e.Item.FindControl("edit_qh")).Text;
OpenDatabase();
String OleDb_edit = "UPDATE YBQH " +
"SET dq = '" + dq1.Replace("'","''")+ "'," +
"sm = '" + sm1.Replace("'","''")+ "'" +
"yb = '" + yb1.Replace("'","''")+ "'" +
"qh = '" + qh1.Replace("'","''")+ "'" +
" WHERE ID = " + MyDataGrid.DataKeys[e.Item.ItemIndex];
OleDbConnection myConnection = cn;
OleDbCommand OleDbCommandUpdate = new OleDbCommand(OleDb_edit,myConnection);
OleDbCommandUpdate.ExecuteNonQuery();
myConnection.Close();
MyDataGrid.EditItemIndex = -1;
BindGrid(); }
"SET dq = '" + dq1.Replace("'","''")+ "'," +
"sm = '" + sm1.Replace("'","''")+ "'" +
"yb = '" + yb1.Replace("'","''")+ "'" +
"qh = '" + qh1.Replace("'","''")+ "'" +
" WHERE ID = " + MyDataGrid.DataKeys[e.Item.ItemIndex];
改成:
String OleDb_edit = "UPDATE YBQH SET dq="+dq1.Replace("'","''")+","+"sm="+sm1.Replace("'","''")+","+"yb="+yb1.Replace("'","''")+","+"qh="+qh1.Replace("'","''")+"WHERE ID="+MyDataGrid.DataKeys[e.Item.ItemIndex];
试试建议楼主用参数
不提示错误,但是数据跟新不了啊
string sm1 = ((TextBox)e.Item.FindControl("edit_sm")).Text;
string yb1 = ((TextBox)e.Item.FindControl("edit_yb")).Text;
string qh1 = ((TextBox)e.Item.FindControl("edit_qh")).Text;
用Label1.Text=dq1+sm1+yb1+qh1;怎么是没有改动前的数据阿,在线等谢谢了
<HeaderStyle Wrap="False" Width="40%"></HeaderStyle>
<ItemTemplate>
<%# DataBinder.Eval(Container, "DataItem.dq") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="edit_dq" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "dq") %>' >
</asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
-------------------------------------------------------------------------------------
好处很多,一个是写Sql语句很方便,不会存在引号和字符的问题,还有就是可以有效的防止SQL注入攻击。