Use SQLCommandbuilder in ASP.NET, use it to generate addition, delete, select SQL statement, etc., it is more convenient, here is given an example
Private sub usecommandbuilder ()
DIM Connectionstring as string = _
"Integrated Security = SSPI; Persist Security Info = False;" _ _
"Initial catalog = northwind; data source = lap800"
DIM Connection As SqlConnection = _
New SqlConnection (Connectionstring)
Connection.Open ()
Try
Dim command as sqlcommand = _
New SqlCommand ("Select * from customers", connection)
Dim adapter as sqldataadapter = _
New SqldataAdapter (Command)
DIM builder as sqlcommandbuilder = _
New SQLCommandbuilder (Adapter)
'Show Commands
Console.writeline (Builder.getInsertCommand (). CommandText)
Console.writeline (Builder.getUpdateCommand (). CommandText)
Console.writeline (Builder.GetDeleteCommand (). CommandText)
DIM TABLE AS DATATABLE = New DataTable
Adapter.Fill (Table)
'Use INSERT
Dim row as datarow = Table.Newrow
Row ("Customerid") = "Paulk"
Row ("CompanyName") = "Pauly's Edibles"
ROW ("ContactName") = "Paul Kimmel"
Row ("ContactTitle") = "The Fat Man"
Table.Rows.Add (Row)
'Use Update
Dim Results () AS DATAROW = _
Table.select ("Customerid = 'ALFKI')
Results (0) ("region") = "de"
'Use delete
Dim deleteThese () as dataARow = _
Table.Select ("Customerid = 'Farla')
For Each Row in DeleteThese
Row.delete ()
NEXT
Adapter.Update (Table)
Table.acceptchange ()
Catch exception
Debug.writeline (ex.Message)
Throw
Finally
Connection.Close ()
END TRY
End Sub
End module
