Edit mode in oledb connection
-
Hello, I would like to ask if how will I edit existing database records like the edit mode. Any suggestion or comments are kindly appreciated. Thanks, dfan23
-
Hello, I would like to ask if how will I edit existing database records like the edit mode. Any suggestion or comments are kindly appreciated. Thanks, dfan23
Are you serious? A very cursory search will turn up many results. Have you tried that?
I know the language. I've read a book. - _Madmatt
-
Are you serious? A very cursory search will turn up many results. Have you tried that?
I know the language. I've read a book. - _Madmatt
Hello, Sorry for bothering you but I am just asking. This is a forum and I just post so that I can get idea's.
-
Hello, Sorry for bothering you but I am just asking. This is a forum and I just post so that I can get idea's.
It is expected that one does some research first. Even a modicum of such research would have yielded you a plethora of resources to answer the question yourself and perhaps learn in the process. Not doing any research and expecting to be given the answers is a waste of everyone's time and disrespectful to those who freely give their time here.
I know the language. I've read a book. - _Madmatt
-
Are you serious? A very cursory search will turn up many results. Have you tried that?
I know the language. I've read a book. - _Madmatt
Do you want to edit the data which you insert\add????If that is than the ans is
try con.open() Dim str As String = "update details set name='" & TextBox1.Text & "', address='" & TextBox2.Text & "', marks='" & Textbox.Text & "' where roll='" & Combobox1.Text & "'" cmd = New OleDb.OleDbCommand(str, con) cmd.ExecuteNonQuery() MsgBox("Record updated", MsgBoxStyle.Information, "Update") Catch ex As Exception MsgBox(ex.ToString) Finally con.Close() End Try -
Do you want to edit the data which you insert\add????If that is than the ans is
try con.open() Dim str As String = "update details set name='" & TextBox1.Text & "', address='" & TextBox2.Text & "', marks='" & Textbox.Text & "' where roll='" & Combobox1.Text & "'" cmd = New OleDb.OleDbCommand(str, con) cmd.ExecuteNonQuery() MsgBox("Record updated", MsgBoxStyle.Information, "Update") Catch ex As Exception MsgBox(ex.ToString) Finally con.Close() End TryThis most certainly NOT the answer. One, you have responded to the wrong post. Two, you are excepting direct, unvalidated input from user controls that can, and will, expose you to sql injection attacks and other nasty results. Three, it's VB
I know the language. I've read a book. - _Madmatt