BatchUpdate issue

qq397472251 — Mon, 20 Sep 2010 03:00:45 GMT

thankyou

BatchUpdate issue

Glayaar — Sun, 19 Sep 2010 23:17:05 GMT

Based on my test, you will need to set the datakeyfield of the grid during the PrepareDataBinding event handler, here is the snippet:

protected void WebGrid1_PrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
{
    WebGrid1.RootTable.DataKeyField = "id";
    WebGrid1.RetrieveStructure();
    WebGrid1.RootTable.DataKeyField = "id";
}

You will also need to re-set the command during batch update event handler and invoke the RefreshAll client side method, here is the snippet:

protected void WebGrid1_BatchUpdate(object sender, ISNet.WebUI.WebGrid.BatchUpdateEventArgs e)
{
    DataSet dt = (DataSet)WebGrid1.GetCachedDataSource();
    DataSet changeDT = (DataSet)dt.GetChanges();

    da = new SqlDataAdapter("SELECT  * FROM logintbl;", conn);
    SqlCommandBuilder builder = new SqlCommandBuilder(da);

    da.InsertCommand = builder.GetInsertCommand();
    da.UpdateCommand = builder.GetUpdateCommand();
    da.DeleteCommand = builder.GetDeleteCommand();

    da.Update(changeDT);
    WebGrid1.ClientAction.RefreshAll();
}

BatchUpdate issue

qq397472251 — Sun, 19 Sep 2010 01:40:55 GMT

Can anyone help me? thanks

BatchUpdate issue

qq397472251 — Thu, 16 Sep 2010 23:54:27 GMT

thank youGlenn Layaar .

when BatchUpdate，care：
1、set keyvalue

2、get update insert delete command

May more people get it！

Intersoft Community - WebGrid Enterprise - BatchUpdate issue

BatchUpdate issue

BatchUpdate issue

BatchUpdate issue

BatchUpdate issue