need help in vb.net update code
SqlConnection1.Open()
Try
Dim str = "update tbluser set password='" & txtpass.Text & "',fname='" & txtfn.Text & "',lname='" & txtln.Text & "' where name='" & txtname.Text & "'"
Dim com = New SqlCommand(str, SqlConnection1)
com.ExecuteNonQuery()
lblmsg.Text = "Record Updated Successfully"
SqlDataAdapter1.Update(Ds1, "tbluser")
Catch ex As Exception
MsgBox(ex.ToString)
End Try
sqlconnection1.close()
the above is my code for updating textbox values...........
i am using vs.net IDE but its not updating the records........
there is no error but still not updation.........
its just like pain in the neck.............
need urgent help..............
Thanks in advance.....
|