How to update the database when data on a datagrid has changed?

[Alpha]

Hi, I have a datagrid and its source is a dataset. When I change information
on the grid does that automatically gets change in the dataset? If not then
how do I do that? I use the following update statement when the form is
closed to udpate the database but the changes are not there.
oleDbDataAdapte r1.Update(dsVeh icle, "vehDetail" );

Thanks, Alpha

[Phil Williams]

Hi,
You could try

dsVehicle.Table s[ "vehDetail" ].RowChanged +=
new DataRowChangeEv entHandler(data Row_Change);
..
..
..
private void DataRow_Change( object sender, DataRowChangeEv entArgs e)
{
oleDbDataAdapte r1.Update(dsVeh icle, "vehDetail" );
}

All the best,
Phil.

"Alpha" wrote:

Hi, I have a datagrid and its source is a dataset. When I change information
on the grid does that automatically gets change in the dataset? If not then
how do I do that? I use the following update statement when the form is
closed to udpate the database but the changes are not there.
oleDbDataAdapte r1.Update(dsVeh icle, "vehDetail" );

Thanks, Alpha

[Alpha]

I definitely see action with the code you gave me. Thank you very much.

However, I'm getting update error. One of the column in the dataset is a
primary key in the database. The update command is automatically generated
when I add the dbapater control to the form. It tries to update the primary
key columnas well.
Can you suggest how I can fix this problem? Thanks.

I'm gonna try to set that column in dataset to a primary key and see if that
would help.

"Phil Williams" wrote:

Hi,
You could try

dsVehicle.Table s[ "vehDetail" ].RowChanged +=
new DataRowChangeEv entHandler(data Row_Change);
.
.
.
private void DataRow_Change( object sender, DataRowChangeEv entArgs e)
{
oleDbDataAdapte r1.Update(dsVeh icle, "vehDetail" );
}

All the best,
Phil.

"Alpha" wrote:

Hi, I have a datagrid and its source is a dataset. When I change information
on the grid does that automatically gets change in the dataset? If not then
how do I do that? I use the following update statement when the form is
closed to udpate the database but the changes are not there.
oleDbDataAdapte r1.Update(dsVeh icle, "vehDetail" );

Thanks, Alpha

[Alpha]

I just open the dataset schema and it already has a primary key marked on the
correct column, VID. I don't understand why the dbadapter.Updat e command
would still try to update that.

"Phil Williams" wrote:

Hi,
You could try

dsVehicle.Table s[ "vehDetail" ].RowChanged +=
new DataRowChangeEv entHandler(data Row_Change);
.
.
.
private void DataRow_Change( object sender, DataRowChangeEv entArgs e)
{
oleDbDataAdapte r1.Update(dsVeh icle, "vehDetail" );
}

All the best,
Phil.

"Alpha" wrote:

Hi, I have a datagrid and its source is a dataset. When I change information
on the grid does that automatically gets change in the dataset? If not then
how do I do that? I use the following update statement when the form is
closed to udpate the database but the changes are not there.
oleDbDataAdapte r1.Update(dsVeh icle, "vehDetail" );

Thanks, Alpha