Hi.

I have a dynamic ASPxGridView than receives a DataSet. I want change the data the ASPxGridView, but don't want save the database. The ASPxGridView  must save the data in database when the user click the button than out the ASPxGridView. There is how to do this?

Here's a piece of code

gv.DataSource = ds.Tables["TABLE"];

gv.SettingsDetail.ShowDetailRow =

true;

gv.SettingsDetail.ShowDetailButtons =

true;

gv.ID =

"ASPxGridView2";

gv.KeyFieldName =

"CODIGOPRODUTO";

gv.Templates.DetailRow =

new DetailRowTemplate(ds.Tables["TABLE3"]);

gv.ClientInstanceName =

"grid2";

gv.ClientSideEvents.RowClick =

"function(s, e) {grid2.StartEditRow(e.visibleIndex);}";

gv.SettingsEditing.Mode =

GridViewEditingMode.Inline;

gv.DataBind();

protected void gv_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{

    e.NewValues[

"campo0"] = 1;
}

When save the data and the event RowUpdating is execute, the message is show: "Specified Method is not supported"

Can Somebody help me?

Thanks

Hi,

These may help you:

Customize data updates using the RowUpdating event

Implement on-demand data posting (batch data update)

 Hi Harry.

Thanks for message, but I am not achieving use.

I want than when user click the button Update the data is not send the database. In Exemple than I am doing, the message is show: Specified method is not supported.

See the example than you show, Where the data are being saved when the Update button is executed? Its saving to session or xml?

Marcos,

Not sure but can you create a sample application (using access db), zip it and upload it here please? I'll see if I can help.

 Hi Mehul.

Marcos,

Why not just use a sqldatasource? It'll make these issues go away.

Harry,

I never wore the SqlDataSource and I don't know with it help me.

Hi Marcos,

The sqldatasource approach works very well and you can see it used in many of the demos.

As for your approach, you should see this tutorial: How to create a grid control programmatically