Being new to Vb.Net 2003, I need help to determine whether to Create new Record or Update an exisitng record in SQL SERVER table.
In VB6 I used this logic to do that but in Vb.Net 2003, I am totally lost at it. Please Help me. Thanks.
Dim AdoRst as new ADODB.Recordset Dim AdoConn as new ADODB.Connection Dim connStr as string Dim strSql as string StrSql = "Select * from TblOrder where OrderId = " & txtOrderId.text Connstr = etc....... adoConn.connectionstring = connstr AdoConn.open if AdoRst.EOF and AdoRst.BOF then AdoRst.Fields("OrderId").value = txtOrderId.text endif AdoRst.fields("OrderQuantity").value = txtOrderQuantity.text