Update

[OuTCasT]

Can someone please tell me how does a person use a commandbuilder to update a dataset so that i can update the table in the database.


[CODE=vb]sqlEarningsComm and = New SqlCommand("Sel ect * from earnings order by EmployeeID", sqlConnection)
sqlEarningsAdap ter = New SqlDataAdapter( sqlEarningsComm and)
sqlEarningsData table = New DataTable
sqlEarningsAdap ter.Fill(sqlEar ningsDatatable)

lblEarnings_tem p.DataBindings. Add("text", sqlEarningsData table, "EmployeeID ")
lblEarningsTota l.DataBindings. Add("text", sqlEarningsData table, "EarningTot al")
txtAnnualSalary .DataBindings.A dd("text", sqlEarningsData table, "AnnualSala ry")
lblNetTotal.Dat aBindings.Add(" text", sqlEarningsData table, "NetSalarytotal ")

Dim x As Integer
For x = 1 To 14
mtxtEarnings(x) .DataBindings.A dd("text", sqlEarningsData table, x.ToString)
Next

sqlmanager2 = DirectCast(Me.B indingContext(s qlEarningsDatat able), CurrencyManager )[/CODE]


button click event.

[CODE=vb]sqlConnection.O pen()
sqlmanager2.End CurrentEdit()
Dim sqlEmployeeDeta ilsUpdate As New SqlCommandBuild er(sqlAdapter)
Try
sqlAdapter.Upda te(sqlDataTable )
catch
end try[/CODE]

that works find for the datatable, i need to update a dataset cause i aint using a datatable.....

[jeffstl]

I am not sure what your specific issue is. If you need to update use UPDATE SQL.

sqlEarningsCommand = New SqlCommand("UPDATE Earnings set EmployeeName = '" & strEmpName & "',EmployeeAddress = '" & strEmpAddress & "' where EmployeeID = " & strEmpID & "", sqlConnection)