update table in 2k5 (PICS)

[Pace]

Hi All,

I dont understand how you update a table on a database in Vb2005...

Does anyone know?

I have the appropriate Update statements in my .xsd file,

When I call the update method of the table adapter, im not exactly sure what I am supposed to be passing here... im too used to just updating the data adapter of the data set in 2k3...

Please help and if im talking nik-nak just say.

 

[Pace]

looking at an article on MSDN I guess if I re-create the DataSet, add the advanced setup parts there then I think the only thing I have to pass is the table name?

 

[Pace]

Answer...

[SIZE=2][COLOR=#0000ff]Private[/COLOR] [COLOR=#0000ff]Sub[/COLOR] btnSave_Click([COLOR=#0000ff]ByVal[/COLOR] sender [COLOR=#0000ff]As[/COLOR] System.Object, [COLOR=#0000ff]ByVal[/COLOR] e [COLOR=#0000ff]As[/COLOR] System.EventArgs) [COLOR=#0000ff]Handles[/COLOR] btnSave.Click
Me.CustomerBindingAdapter.EndEdit 'THATS MA BOI!
[COLOR=#0000ff]Me[/COLOR].CustomerTableAdapter.Update(DsCustBasic.Customer)
[COLOR=#0000ff]End[/COLOR] [COLOR=#0000ff]Sub[/COLOR][/SIZE]