Public Function Del_Rec

Public Function Del_Rec(ByVal sqlstr As String)
cmd = New SqlCommand(sqlstr, con)
con.Open()
result = cmd.ExecuteNonQuery()
con.Close()
End Function

Public Function Edit_Rec :

Public Function Edit_Rec :

This method is used to update the modified row in the database
It accepts one argument namely sqlstr.
ExecuteNonQuery method of cmd object executes the given query and returns number of records.



Public Function Edit_Rec(ByVal sqlstr As String)
Try
cmd = New SqlCommand(sqlstr, con)
'MsgBox(sqlstr)
con.Open()
result = cmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.Message.ToString)
Finally
con.Close()
End Try
End Function