Updating database in vb

NETExport Data Grid View Data To Excel - Visual Basic . NETVisual Basic Tutorials Tic Tac Toe - Visual Basic .

NET System Tray - Notification Area - Visual Basic . NETRead (Lookup) records from Access Database - Visual Basic . NET Allow Numbers only in a Text Box - Visual Basic .

Item("col A") = lrow --this updates the value in memory, but not in the database l Row = l Row 1 Next I am using VB. For every record in tbl A where col B = 'abc', I want to update the value in col A.

If I need to use Insert Command, can I use the same Data Adapter/Data Set ? Update ---how can I use the same m_da SQL that is already filled with the "select * from tbl A where [col B] = 'abc'" ? In VB6, using ADO I can loop thru the recordset,set the values of col Aand call the Update method.

For every record in tbl A where col B = 'abc', I want to update the value in col A.

Item("col A") = lrow --this updates the value in memory, but not in the database l Row = l Row 1 Next Thank you. In my example, I Fill the dataset using Command Text "select * from tbl A where [col B] = 'abc'", before I update it. Fill(m_ds SQL) l Row = 0 For Each a Row In m_ds SQL. Rows() s SQL = "update tbl A set" s SQL = s SQL & (" col A = " & lrow) s SQL = s SQL & (" where [col B] = 'abc') m_da SQL. For every record in tbl A where col B = 'abc', I want to update the valuein col A.

Command Text = s SQL End With m_da SQL = New Sql Client. Select Command = "select * from tbl A where [col B] = 'abc'" m_da SQL. Sql Client Command("UPDATE tbl A blah, blah, blah") Dim ds As New Data Set da. Fill(ds, "tbl A") Dim i As Integer For i = 0 To ds.

In VB6, using ADO I can loop thru the recordset,set the values of col A and call the Update method. Select Command = Cmd 'the UPDATE cmd Cmd = New Sql Client.

Item("col A") = lrow --thisupdates the value in memory, but not in the database l Row = l Row 1Next lose the training wheels; learn how to WRITE SQL and don't rely on recordsets to update data fucking retard this is a simple command; if you can't write subqueries and shit then you should STFU and go work at mc Donalds -Aaron fniles wrote: I am using VB. For every record in tbl A where col B = 'abc', I want to update the value in col A. Sql Command( _ "select tbl AID, col A from tbl A where col B = 'abc'", _ Con) Adapter.