create dataset from a datagrid

[Abby]

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

[Cor Ligthert [MVP]]

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

[Abby]

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

[Cor Ligthert [MVP]]

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

[Abby]

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