|
i trying to add info from user input n submit into the database
i use the insert into
--------------
Private Sub AddSubmitB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddSubmitB.Click
Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Jasmine\My Documents\member\db1.mdb"
Dim cmd As New OleDb.OleDbCommand
Dim con As OleDb.OleDbConnection
Dim dr As OleDb.OleDbDataReader
Dim strsql As String
con = New OleDb.OleDbConnection(strcon)
con.Open()
strsql = "Insert into member(BorrowerId, Fname, Lname, Gender, Address1, Address2, Address3) values('" & BorrowerIdTB.Text & "',' " & FnameTB.Text & "',' " & LnameTB.Text & "','" & GenderCLB.Text & "',' " & Add1TB.Text & "','" & Add2TB.Text & "',' " & Add3TB.Text & "')"
cmd.Connection = con
cmd.CommandText = strsql
cmd.ExecuteNonQuery()
con.Close()
MsgBox("Record Added")
Me.Close()
End Sub
--------------
when i run it the debugger stopped at cmd.ExecuteNonQuery()
i seriously duno wat the error is about
|
|
|
|
|
It would help greatly if we knew what the error was!
But, as a suggestion to clean up your code and make it easier to maintain, you might want to look into using parameterize queries instead of this string concantenation mess you've created. This is most likely where your problem is origination from. You can read more about parameterized queries and why they're a much better way to go in Colin Mackay's excellent article here[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
|
|
|
I already searched... after that posted here :P
SaRath.
"Where I am from, there is no plan B. So, take advantage of today becuase tomorrow is not promised. - 50 Cent"
My Blog | Understanding State Pattern
|
|
|
|
|
|
I think your link is misleading. it's going to one of my post at code project
SaRath.
"Where I am from, there is no plan B. So, take advantage of today becuase tomorrow is not promised. - 50 Cent"
My Blog | Understanding State Pattern
|
|
|
|
|
probably its not misleading it is telling you that just some time back you told some that not to put programming question here and you yourself are putting it here. 
Best Regards,
Apurva Kaushal
|
|
|
|
|
Ok. If you are considering this as programming question, nothing I can do...
:P
|
|
|
|
|
No offence intended but it is certainly a programming question. 
Best Regards,
Apurva Kaushal
|
|
|
|
|
apurva kaushal wrote: No offence intended but it is certainly a programming question.
No offence intended, but it is certainly not a programming question.
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
Ryan Binns wrote: No offence intended, but it is certainly not a programming question.
Hey Sandgroper, how about a little bit more information on why it isn't a programming question?
Never mind, seems I've already done that for you.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash 24/04/2004
|
|
|
|
|
Because he said it wasn't. He specifically said he wasn't wanting to write one, but wanted one that was already written.
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
Ryan Binns wrote: Because he said it wasn't. He specifically said he wasn't wanting to write one, but wanted one that was already written.
You must have missed my cunning and wry New South Wales sarcasm. I also mentioned I had done it for you. Just was too lazy to get a link to my reply which was immediately below yours.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash 24/04/2004
|
|
|
|
|
Michael Martin wrote: You must have missed my cunning and wry New South Wales sarcasm. I also mentioned I had done it for you.
Heh. I just automatically assume you eastern-states folks are insulting us westerners at every possible opportunity. It's rare that that's not the case 
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
apurva kaushal wrote: No offence intended but it is certainly a programming question.
Rat's arse it is. He didn't ask how to do it, nor for anyone to provide code, just links to where he can find the answers himself. Well within the parameters of Lounge usage.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash 24/04/2004
|
|
|
|
|
|
Hey toxy...
my brain is perfectly alright... I was looking for a software to do my task not to write my own...
we had have many discussions on some softwares and tools. how this could be programming question.
i think I should have rephrase that question.. anyway CP Police marked it as "Disabled"
|
|
|
|
|
Sarath. wrote: I was looking for a software to do my task not to write my own
hum hum, how do you understand this then :
Sarath. wrote: I need to create a screen saver from a text file
(quoted from your 1st post) ...so ?
|
|
|
|
|
|
Sarath. wrote: it's going to one of my post at code project
Yes exactly. That way you can tell yourself not to post programming questions in the lounge!
|
|
|
|
|
He didn't.
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
I'm not sure what everyone's going on about. Wanting a screensaver that can take data in a text file and display it. As in finding one that already exists, not writing one. Thick as two bricks, some people.
I can't think of any off the top of my head.
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
Ryan Binns wrote: Wanting a screensaver that can take data in a text file and display it. As in finding one that already exists, not writing one.
That was why I provided him the link for.
Maxwell Chen
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
