ado.net question 1

[shannanl]

I use the following to insert a record into a table. How would I adapt this to update a record in the same table?

'-- INSERT A NEW STATE
Dim dt As DataTable
dt = DataSet11.Tables("State_T")

Dim dr As DataRow
dr = dt.NewRow()
dr("State_name") = myname
dr("State_abb") = myabb

dt.Rows.Add(dr)

SqlDataAdapter1.Update(DataSet11, "State_T")
DataSet11.AcceptChanges()

DataSet11.Clear()
SqlDataAdapter1.Fill(DataSet11)

Thanks,

Shannan

 

[chrissie1]

dt.rows(rownumberyouwanttoupadte).item(columnnameorcolumnnumberyouwanttoupdate) = value

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[shannanl]

I cant get this to work. It says I need a valid update command.

Public Sub UPDATESTATE(ByVal myname As String, ByVal myabb As String, ByVal myrow As Integer)
'-- UPDATE A STATE
Dim dt As DataTable
dt = DataSet11.Tables("State_T")

Dim dr As DataRow
dr = dt.Rows(myrow)
dr("State_name") = myname
dr("State_abb") = myabb

dt.Rows(myrow).Item("State_name") = myname
dt.Rows(myrow).Item("State_abb") = myabb

SqlDataAdapter1.Update(DataSet11, "State_T")
DataSet11.AcceptChanges()

DataSet11.Clear()
SqlDataAdapter1.Fill(DataSet11)
End Sub

Thanks,

Shannan

 

[shannanl]

Ok, sorry. Found the problem. I did not have an update statement in the data adapter.

Thanks,

Shannan

 

[shannanl]

Why would this not delete a row?

Public Sub DELETESTATE(ByVal myrow As Integer)
'-- DELETE A STATE
Dim dt As DataTable
dt = DataSet11.Tables("State_T")

Dim dr As DataRow
dr = dt.Rows(intState)

dt.Rows.Remove(dr)

SqlDataAdapter1.Update(DataSet11, "State_T")
DataSet11.AcceptChanges()

DataSet11.Clear()
SqlDataAdapter1.Fill(DataSet11)
End Sub

Thanks,

Shannan