having an error in the submit button

Question

0.00/5 (No votes)

See more:

these are my codes in a submit button.
but it shows that i have an error in my connection. what could be wrong? please help me

VB

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
       GridView1.Visible = True

       Dim myConn As OleDbConnection
       Dim cmd As OleDbCommand
       Dim sqlString, takenby, dest, client, car As String
       Dim recordno As Integer
       Dim dte, exptime As String

       recordno = Integer.Parse(TextBox4.Text)
       dte = TextBox1.Text
       car = ComboBox1.SelectedValue.ToString()
       takenby = ComboBox2.SelectedValue.ToString
       dest = ComboBox3.SelectedValue.ToString
       client = TextBox2.Text
       exptime = TextBox3.Text

       myConn = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source = |DataDirectory|Database - copy.accdb;")
       myConn.Open()
       sqlString = "INSERT INTO DETAILED GISTEC CARS(Record No, Date, Car, Taken By, Destination, Client, Expected Time to Return)VALUES('" + recordno + " ','" + dte + "','" + car + "','" + takenby + "','" + dest + "','" + client + "','" + exptime + " ')"

       cmd = New OleDbCommand(sqlString, myConn)
       cmd.ExecuteNonQuery()

       myConn.Close()

Posted 26-Jun-12 21:26pm

Tahany90

Updated 26-Jun-12 21:30pm

Vani Kulkarni

v2

Add a Solution

Comments

Sandeep Mewara 27-Jun-12 3:53am

What error? Putting all the details will just help you getting correct direction.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Om Prakash Pant · Accepted Answer · 2012-06-26T21:46:00

Solution 1

Please check the connectionstrings in the following link, which is required for connecting to Access 2007:

http://www.connectionstrings.com/access-2007[^]

Posted 26-Jun-12 21:46pm

Om Prakash Pant

frostcox · Accepted Answer · 2012-06-30T12:19:00

Hey I don't see why you dont just pass your variables in as paramaters?? As far as I can see you are passing in strings in between '' quotes. This means that every variable you are passing in is being interputed as a string/varchar/nvarchar whatever. So for instance if you have a value that expects an int/double/decimal/smallint ect.. you sql will throw an error. So you need to set the paramaters to whatever datatype type column expects. Hope this helps.

Tahany90 · Accepted Answer · 2012-06-26T22:08:00

Solution 2

SQL

sqlString = "INSERT INTO DETAILED GISTEC CARS(Record No, Date, Car, Taken By, Destination, Client, Expected Time to Return)VALUES('" + recordno + " ','" + dte + "','" + car + "','" + takenby + "','" + dest + "','" + client + "','" + exptime + " ')"

this is my error....it says Conversion from string "INSERT INTO DETAILED GISTEC CARS" to type 'Double' is not valid.

i have converted nothing to double

Posted 26-Jun-12 22:08pm