Data update

[Rado]

Hello.
I make connection with database, dataadapter and dataset.
How can I update only one item in my database.
no whole row.

If I want update whole row I can do it with this code:
Dim bm As BindingManagerBase

Dim drv As DataRowView

bm = Me.BindingContext(Me.dataadapter1, "table1")

drv = CType(bm.Current, DataRowView)

drv.EndEdit()

Me.dataadapter1.Update(Me.dataset1.table1)





Thanks for answers.

 

[Cor Ligthert]

Rado,

I make connection with database, dataadapter and dataset.
How can I update only one item in my database.
no whole row.

Using just the Executenonquery with an SQL updatestring

http://msdn.microsoft.com/library/d...clientsqlcommandclassexecutenonquerytopic.asp

I hope this helps?

Cor