dataAdapter update problem

[Andy]

i have a few textboxes that i bind to a dataset and when i try to change the values after filling it and displaying it, i update the dataset but the database isn't modified.

the dataadapter_row updating or updated events arent fired either

here is my code.

Me.daCategories.Update(Me.DsCategories1.Categories)

any suggestions?

does it have something to do with the fact i'm using text boxes?

[Briantcva]

It's in C# but it should point you in the right direction.

this.BindingContext[Helper.IsecData.Agency].EndCurrentEdit();
CurrencyManager cm=(CurrencyManager)this.BindingContext[Helper.IsecData.Agency];
int cmPos=cm.Position;	
Helper.IsecData.Agency.Rows[cmPos][Helper.IsecData.Agency.LastUpdatedColumn.ToString()]=DateTime.Today;
DataAccess.UpdateAgencyTable(Helper.IsecData.Agency);
Helper.IsecData.Agency.AcceptChanges();

*IsecData is a typed dataset in the static Helper class.

[mar_zim]

Originally posted by Andy
i have a few textboxes that i bind to a dataset and when i try to change the values after filling it and displaying it, i update the dataset but the database isn't modified.

the dataadapter_row updating or updated events arent fired either

here is my code.

Me.daCategories.Update(Me.DsCategories1.Categories)

any suggestions?

does it have something to do with the fact i'm using text boxes?

i think you put some commandbuilder to your dataadapter...

dim cb as new sqlcommandbuilder(daCategories)
Me.daCategories.Update(Me.DsCategories1.Categories)

i dont if that the efficient one.