SqlCommandBuild er

[Jim Reynolds]

Hi,
I am using a SqlCommandBuild er to update a Db table via an updated DataSet
and SqlAdapter and it doesn't seem to be generating the activity commands
from the Select command. Here is a snippet.

sda = new SqlDataAdapter( );
sda.SelectComma nd = new SqlCommand(sql, dbcon);
SqlCommandBuild er scb = new SqlCommandBuild er(sda);

DataSet ds = new DataSet();
sda.Fill(ds,pag eName);

DataRow dr = ds.Tables[pageName].NewRow();

for(int x=0;x<14;x++)
{
dr[x] = newDataRow[x];
}
ds.Tables[pageName].Rows.Add(dr);
ds.AcceptChange s();
sda.Update(ds,p ageName);

Nothing happens, no update and no exceptions. Any ideas please?

Jim

[Marina]

Yes - you called AcceptChanges. This changes the states of all the rows to
unmodified. So when you go to update, it looks like there is nothing to
update.

Why call AcceptChanges to change all the row states if you then want to
update?

"Jim Reynolds" <Ji*********@di scussions.micro soft.com> wrote in message
news:F0******** *************** ***********@mic rosoft.com...

Hi,
I am using a SqlCommandBuild er to update a Db table via an updated DataSet
and SqlAdapter and it doesn't seem to be generating the activity commands
from the Select command. Here is a snippet.

sda = new SqlDataAdapter( );
sda.SelectComma nd = new SqlCommand(sql, dbcon);
SqlCommandBuild er scb = new SqlCommandBuild er(sda);

DataSet ds = new DataSet();
sda.Fill(ds,pag eName);

DataRow dr = ds.Tables[pageName].NewRow();

for(int x=0;x<14;x++)
{
dr[x] = newDataRow[x];
}
ds.Tables[pageName].Rows.Add(dr);
ds.AcceptChange s();
sda.Update(ds,p ageName);

Nothing happens, no update and no exceptions. Any ideas please?

Jim

[Jim Reynolds]

Doh!

Thanks very much Marina. Why would you need to call AcceptChanges on a
DataSet?

Jim

"Marina" wrote:

Yes - you called AcceptChanges. This changes the states of all the rows to
unmodified. So when you go to update, it looks like there is nothing to
update.

Why call AcceptChanges to change all the row states if you then want to
update?

"Jim Reynolds" <Ji*********@di scussions.micro soft.com> wrote in message
news:F0******** *************** ***********@mic rosoft.com...

Hi,
I am using a SqlCommandBuild er to update a Db table via an updated DataSet
and SqlAdapter and it doesn't seem to be generating the activity commands
from the Select command. Here is a snippet.

sda = new SqlDataAdapter( );
sda.SelectComma nd = new SqlCommand(sql, dbcon);
SqlCommandBuild er scb = new SqlCommandBuild er(sda);

DataSet ds = new DataSet();
sda.Fill(ds,pag eName);

DataRow dr = ds.Tables[pageName].NewRow();

for(int x=0;x<14;x++)
{
dr[x] = newDataRow[x];
}
ds.Tables[pageName].Rows.Add(dr);
ds.AcceptChange s();
sda.Update(ds,p ageName);

Nothing happens, no update and no exceptions. Any ideas please?

Jim

[Marina]

If you used GetChanges to get just the changes, and after the save was done,
you wanted to reset all the rows to unchanged, to match.

Or if you had application logic the required you for some reason to want
this to happen.

"Jim Reynolds" <Ji*********@di scussions.micro soft.com> wrote in message
news:6C******** *************** ***********@mic rosoft.com...

Doh!

Thanks very much Marina. Why would you need to call AcceptChanges on a
DataSet?

Jim

"Marina" wrote:

Yes - you called AcceptChanges. This changes the states of all the rows
to
unmodified. So when you go to update, it looks like there is nothing to
update.

Why call AcceptChanges to change all the row states if you then want to
update?

"Jim Reynolds" <Ji*********@di scussions.micro soft.com> wrote in message
news:F0******** *************** ***********@mic rosoft.com...

> Hi,
> I am using a SqlCommandBuild er to update a Db table via an updated
> DataSet
> and SqlAdapter and it doesn't seem to be generating the activity
> commands
> from the Select command. Here is a snippet.
>
> sda = new SqlDataAdapter( );
> sda.SelectComma nd = new SqlCommand(sql, dbcon);
> SqlCommandBuild er scb = new SqlCommandBuild er(sda);
>
> DataSet ds = new DataSet();
> sda.Fill(ds,pag eName);
>
> DataRow dr = ds.Tables[pageName].NewRow();
>
> for(int x=0;x<14;x++)
> {
> dr[x] = newDataRow[x];
> }
> ds.Tables[pageName].Rows.Add(dr);
> ds.AcceptChange s();
> sda.Update(ds,p ageName);
>
> Nothing happens, no update and no exceptions. Any ideas please?
>
> Jim

[Jim Reynolds]

Thanks very much.

"Marina" wrote:

If you used GetChanges to get just the changes, and after the save was done,
you wanted to reset all the rows to unchanged, to match.

Or if you had application logic the required you for some reason to want
this to happen.

"Jim Reynolds" <Ji*********@di scussions.micro soft.com> wrote in message
news:6C******** *************** ***********@mic rosoft.com...

Doh!

Thanks very much Marina. Why would you need to call AcceptChanges on a
DataSet?

Jim

"Marina" wrote:

Yes - you called AcceptChanges. This changes the states of all the rows
to
unmodified. So when you go to update, it looks like there is nothing to
update.

Why call AcceptChanges to change all the row states if you then want to
update?

"Jim Reynolds" <Ji*********@di scussions.micro soft.com> wrote in message
news:F0******** *************** ***********@mic rosoft.com...
> Hi,
> I am using a SqlCommandBuild er to update a Db table via an updated
> DataSet
> and SqlAdapter and it doesn't seem to be generating the activity
> commands
> from the Select command. Here is a snippet.
>
> sda = new SqlDataAdapter( );
> sda.SelectComma nd = new SqlCommand(sql, dbcon);
> SqlCommandBuild er scb = new SqlCommandBuild er(sda);
>
> DataSet ds = new DataSet();
> sda.Fill(ds,pag eName);
>
> DataRow dr = ds.Tables[pageName].NewRow();
>
> for(int x=0;x<14;x++)
> {
> dr[x] = newDataRow[x];
> }
> ds.Tables[pageName].Rows.Add(dr);
> ds.AcceptChange s();
> sda.Update(ds,p ageName);
>
> Nothing happens, no update and no exceptions. Any ideas please?
>
> Jim