how to exceute update query in below code
If DropDownList_table.SelectedIndex = 1 Then
Dim strCon As String = ("Provider=Microsoft.JET.OLEDB.4.0;" & "data source=D:\mdb\sal.mdb")
Dim strQuery As String = ("SELECT * FROM [" + DropDownList_table.SelectedItem.ToString() + "]")
Dim schemea As String = ""
Dim queryUpdtmaster As String = ""
Dim con As New OleDbConnection(strCon)
con.Open()
Dim cmd As New OleDbCommand(strQuery, con)
Dim rdr As OleDbDataReader = cmd.ExecuteReader()
While rdr.Read
If rdr.HasRows = True Then
Dim rst1 = rdr(0).ToString()
Dim rst2 = rdr(1).ToString()
Dim rst3 = rdr(2).ToString()
Dim rst4 = rdr(3).ToString()
Dim rst5 = rdr(4).ToS ...
Go to the complete details ...