Update field in data row

[indydavid32]

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.

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!