469,568 Members | 1,446 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

create dataset from a datagrid

Hi all,
I have a datagrid which i am using for updating the data to the database. It
works fine for single row data however when i have multiple rows(records)
associated with the same criteria(billno) it updates both the rows with the
values for the row i updated.

I thought of reading both the rows into a dataset and update that to the
database table but am not able to do so.

Any help will be appreciated.

Thanks,
Abby
Nov 14 '06 #1
4 1082
Abby,

How do you populate that datagrid, your question seems a little bit strange
to me.

Cor

"Abby" <Ab**@discussions.microsoft.comschreef in bericht
news:AE**********************************@microsof t.com...
Hi all,
I have a datagrid which i am using for updating the data to the database.
It
works fine for single row data however when i have multiple rows(records)
associated with the same criteria(billno) it updates both the rows with
the
values for the row i updated.

I thought of reading both the rows into a dataset and update that to the
database table but am not able to do so.

Any help will be appreciated.

Thanks,
Abby

Nov 14 '06 #2
Hi Cor,
I use a dataset. I populate it and then bind it to the datagrid.

Let me explain the process again. Considering the dataset has 2 records in
it which are associated to the same billno say record 1 and record2. I need
to update the record 2 in the dataset.
But when i click on the update link after editing the data it updates both
the records with the same information.

so i was trying to catch the record that needs to be updated through a
dataset which i can create from the databind befor the update method is
executed.

Waiting for ur reply.

Thanks,
Abby

"Cor Ligthert [MVP]" wrote:
Abby,

How do you populate that datagrid, your question seems a little bit strange
to me.

Cor

"Abby" <Ab**@discussions.microsoft.comschreef in bericht
news:AE**********************************@microsof t.com...
Hi all,
I have a datagrid which i am using for updating the data to the database.
It
works fine for single row data however when i have multiple rows(records)
associated with the same criteria(billno) it updates both the rows with
the
values for the row i updated.

I thought of reading both the rows into a dataset and update that to the
database table but am not able to do so.

Any help will be appreciated.

Thanks,
Abby


Nov 14 '06 #3
Abby,

Is this a web datagrid or a windowforms datagrid, I assume web, but I am
still not sure,

Cor

"Abby" <Ab**@discussions.microsoft.comschreef in bericht
news:DB**********************************@microsof t.com...
Hi Cor,
I use a dataset. I populate it and then bind it to the datagrid.

Let me explain the process again. Considering the dataset has 2 records in
it which are associated to the same billno say record 1 and record2. I
need
to update the record 2 in the dataset.
But when i click on the update link after editing the data it updates both
the records with the same information.

so i was trying to catch the record that needs to be updated through a
dataset which i can create from the databind befor the update method is
executed.

Waiting for ur reply.

Thanks,
Abby

"Cor Ligthert [MVP]" wrote:
>Abby,

How do you populate that datagrid, your question seems a little bit
strange
to me.

Cor

"Abby" <Ab**@discussions.microsoft.comschreef in bericht
news:AE**********************************@microso ft.com...
Hi all,
I have a datagrid which i am using for updating the data to the
database.
It
works fine for single row data however when i have multiple
rows(records)
associated with the same criteria(billno) it updates both the rows with
the
values for the row i updated.

I thought of reading both the rows into a dataset and update that to
the
database table but am not able to do so.

Any help will be appreciated.

Thanks,
Abby



Nov 15 '06 #4
Cor,
its a web datagrid .

Abby

"Cor Ligthert [MVP]" wrote:
Abby,

Is this a web datagrid or a windowforms datagrid, I assume web, but I am
still not sure,

Cor

"Abby" <Ab**@discussions.microsoft.comschreef in bericht
news:DB**********************************@microsof t.com...
Hi Cor,
I use a dataset. I populate it and then bind it to the datagrid.

Let me explain the process again. Considering the dataset has 2 records in
it which are associated to the same billno say record 1 and record2. I
need
to update the record 2 in the dataset.
But when i click on the update link after editing the data it updates both
the records with the same information.

so i was trying to catch the record that needs to be updated through a
dataset which i can create from the databind befor the update method is
executed.

Waiting for ur reply.

Thanks,
Abby

"Cor Ligthert [MVP]" wrote:
Abby,

How do you populate that datagrid, your question seems a little bit
strange
to me.

Cor

"Abby" <Ab**@discussions.microsoft.comschreef in bericht
news:AE**********************************@microsof t.com...
Hi all,
I have a datagrid which i am using for updating the data to the
database.
It
works fine for single row data however when i have multiple
rows(records)
associated with the same criteria(billno) it updates both the rows with
the
values for the row i updated.

I thought of reading both the rows into a dataset and update that to
the
database table but am not able to do so.

Any help will be appreciated.

Thanks,
Abby


Nov 15 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Steve Donnor | last post: by
8 posts views Thread by ASP Yaboh | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.