Update field in data row

Hi guys. I know how to create a new record in a database. What I don't know is how to update one field in a database record.

This is the code I would use to create a new record.

VB Code:

Dim datAdapt As New OleDb.OleDbDataAdapter("Select * From CigUnits", cn2)
Dim commBuild As New OleDb.OleDbCommandBuilder(datAdapt)
Dim datSet As New Data.DataSet()
Dim datRow As Data.DataRow
 
datSet.Clear()
datAdapt.Fill(datSet, "CigUnits")
datRow = datSet.Tables("CigUnits").NewRow
datRow.Item("EmpID") = Request.Cookies("EmpID").Value
datRow.Item("Store") = datRead.Item("location")
datRow.Item("BusiDate") = datRead.Item("Date")
datRow.Item("PC") = datRead.Item("ProductCode")
datSet.Tables("CigUnits").Rows.Add(datRow)
datAdapt.Update(datSet, "CigUnits")

Can someone please give me an example of some code where I can find a particular record, and then update one field in that record.

Thanks!

VB Code:

Dim Conn As New OleDbConnection("Your Connectionstring")
Dim Cmd As New OleDbCommand("UPDATE TableName SET fieldName = whatever", Conn)
 
Try
   Conn.Open()
   Cmd.ExecuteNonQuery()
   Conn.Close()
Catch ex As Exception
   'catch the exception
End Try

The code that " Memnoch1207" used is exactly what i use, but just remember the 'WHERE' part of the update statement:

Quote:

---

Dim Cmd As New OleDbCommand("UPDATE TableName SET fieldName = whatever WHERE PrimaryKey/FieldName='" & IDofitem/CurrentNameofItem you want to update & "'", Conn)

---

If you don't specify the exact record, the update statement will act on all of the records in the DB.

:)

Memnoch1207, could you please show me an example of some code where you go through a do while loop, read one field from a record, then update another field?

Thanks for your help.

Quote:

---

If you don't specify the exact record, the update statement will act on all of the records in the DB.

---

Like, Duh! lol ;)

Memnoch1207, nevermind. I can use a data reader, get the one value, then use your code to update the other field...

Thanks again.