iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
thank youGlenn Layaar .
when BatchUpdate,care:1、set keyvalue
2、get update insert delete command May more people get it!
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();}
Can anyone help me? thanks
thankyou
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname