Metastorm Grid Problem : Not updating even if I change the DataSet.

Hi,

I've bind my Grid with a business object of type table (it has one primary key also). I've also taken a button and set it's action as "Server Operation". On the server Operation I've written a Code Activity with the following lines to do some manipulation with the dataset and then bind this dataset to the Grid. I don't understand why the Grid is not updating.. Please find the code below for reference..

DataSet ds = this.Current.boq_GridData1.Read();
DataView dv = new DataView(ds.Tables[0]);
dv.AllowEdit = true;

int currentRow = Convert.ToInt32(Local.txtCurrentRowSelected.ToString());

if(currentRow > 0)
{
int old = Convert.ToInt32(dv.Table.Rows[currentRow - 1]["ID"]);
dv.Table.Rows[currentRow - 1]["ID"] = Convert.ToInt32(dv.Table.Rows[currentRow]["ID"]);

dv.Table.Rows[currentRow]["ID"] = old;
}

dv.Sort = "ID";
DataTable dt = dv.Table.Clone();

foreach (DataRowView drv in dv)
dt.ImportRow(drv.Row);

DataSet dsnew = new DataSet();
dsnew.Tables.Add(dt);
this.Current.boq_GridData1.Write(dsnew);

Find more posts tagged with

BPM

Comments

Thilo_Menges

Did you check the option "Always refresh" in the "Data Access" area on the business object you are using?

Thilo

satyawan singh

Yes Thilo, That I've already done but it's still not working..

Carolyn Anderson

I think it's because the first line of code is creating a copy of the dataset rather than letting you work on the real data in the business object. You can either try to set your manipulated data back to your business object, or maybe try to work on the business object's data direct.

Jerome_Pearce

Is this an editable grid? If not, the grid will always refresh from the data source if set to refresh, regardless of what is in the BO.

If it is an editable gid, you cannot refresh it.

[edit] sorry, just saw the 'write' call.

Why not do the write in SQL? I do see a lot of raw dataset manipu;ation where I would just use SQL. Am I missing something or is just that .net developers will do it this way by habit?

Paul Lawrence

I tend to agree with Jerome. I would use the inbuilt SQL functionality of Metastorm and insert or update accordingly. Can't say I've had a problem using this method.

satyawan singh

You are right Jerome .net Developers do it this way by habit . Although changed my logic now so it's working. Thanks for your help.

Jerome_Pearce

Well, with all my condecension on the matter, it appears we now need to do the same thing, although in order to bind a business object to a web service rather than update the database.

If anyone is interestested in helping to get a solution together, please go here.