Different ADO.net Db Update Methods-What is better?

[gengel]

Good day, What is the difference between these methods of updating and which is better: 1. Add new row to datatable Dim dr As DataRow = dt.NewRow dr.Item("OrderStatus") = "OPEN" dt.Rows.Add(dr) 'Update new row to database Dim qry As String = "SELECT * FROM Table" Conn.Open() Dim da1 As New SqlClient.SqlDataAdapter da1.SelectCommand = New SqlClient.SqlCommand(qry, MAIN.data.Conn) Dim cb1 As SqlClient.SqlCommandBuilder = New System.Data.SqlClient.SqlCommandBuilder(da1) da1.Update(MAIN.data.DS, "Table") conn.close 2. Execute non query - does this work as stored procedure? Dim strSQL As String = "INSERT INTO Table (OrderStatus)VALUES (@OrderStatus) Dim cmdAddNew As New SqlClient.SqlCommand(strSQL, Conn) cmdAddNew.Parameters.Add("@ScanStatus", SqlDbType.Varchar,50).Value = "OPEN" Conn.Open() cmdAddNew.ExecuteNonQuery() Conn.Close()

[Wayne Gaylard]

I would say it all depends on the situaton. If you have a DataGrid bound to a DataTable, and your user adds a record through the DataGrid, then the first instance would probably be better. If in your data Layer you need a function to Save an object then I would use the second option. In the second option a stored procedure would definitely work. You need to set strSQl to the name of your Stored procedure, and then add cmdAddNew.CommandType = CommandType.StoredProcedure .