How do I update a specific field in a SQL Data Base, using VB5?

Question

I have a SQL Table already bound in the form of Visual Basic 2005, containing several fields. When I want to update it, I use the commands:

BindingSource.EndEdit ()
TableAdapter.Update (DataSet.Table)

But I need  to update a specific field in that table, using the same form. How do I do this?

Answer 1

Hi WillianRobert,

if you want to update specific Field in SQL Server. then you have to execute Update SQL Query Like below.

"update TableName set FieldName=Value where UniqField=Id";

Regards

Anand

Answer 2

Hello,

Use the update query as Anand said like this

update tablename set columnvalue = value where <criteria>