Unable insert data into Microsoft SQL Server

Question

5.00/5 (1 vote)

See more:

Currently I'm develop a web application using asp.net. But I unable to insert data into database.Any sample code can be provided?

VB

Dim constring As String = "Data Source = USER-PC\SQLEXPRESS; Initial catalog = PatientDiagnose; Persist Security Info= True; User ID = Thalassemia; Password = Ling123!@#"
Dim con As SqlConnection = New SqlConnection(constring)
Dim ds As New DataSet
Dim adapter As New SqlDataAdapter
 con.Open()
Dim insertCommand As String = "Insert into DoctorRecord (DocFirst,DocLast) values ('  " & TextBoxFirst.Text & ", " & TextBoxLast.Text & "')"
adapter.SelectCommand = New SqlCommand(insertCommand, con)
adapter.Fill(ds)


Error: There are more columns in the INSERT statement than the values specified in the VALUES clause.

Posted 20-Nov-11 22:33pm

HL22

Updated 20-Nov-11 22:49pm

demouser743

v2

Add a Solution

Comments

HL22 21-Nov-11 4:48am

Dim constring As String = "Data Source = USER-PC\SQLEXPRESS; Initial catalog = PatientDiagnose; Persist Security Info= True; User ID = Thalassemia; Password = Ling123!@#"
Dim con As SqlConnection = New SqlConnection(constring)
Dim ds As New DataSet
Dim adapter As New SqlDataAdapter
con.Open()
Dim insertCommand As String = "Insert into DoctorRecord (DocFirst,DocLast) values (' " & TextBoxFirst.Text & ", " & TextBoxLast.Text & "')"
adapter.SelectCommand = New SqlCommand(insertCommand, con)
adapter.Fill(ds)

Error: There are more columns in the INSERT statement than the values specified in the VALUES clause.

demouser743 21-Nov-11 4:48am

Post the code What you have tried so far.. Inserting the data to database is not a tough ask

demouser743 21-Nov-11 4:50am

Means you are trying to insert extra item to the table which is not defined. Check out your columns in the table

HL22 21-Nov-11 4:52am

For example, in my table I have 11 columns,when I only insert 1 data into 1 column.It can work.But if I insert 11 data into the table...then prompt this error message...

HL22 21-Nov-11 4:53am

Is there any error with my code for inserting data into database?

demouser743 21-Nov-11 4:55am

Why don't you create a stored procedure for inserting the values to DB rather than through query

HL22 21-Nov-11 4:57am

Actually I'm the new beginner of asp.net,so I'm not that familiar with stored procedure..

demouser743 21-Nov-11 5:01am

Give it a try as per the posted answer of mine if it doesn't wrk let me know

4 solutions

Solution 4

if you have posted exact code then go with the solution of Dorababu743

Posted 20-Nov-11 23:47pm

Prasad_Kulkarni

Comments

demouser743 21-Nov-11 6:20am

Why you post it as answer dude.. It seems to be a comment

Solution 3

You have missed some quote characters. Replace this one :

VB

Dim insertCommand As String = "Insert into DoctorRecord (DocFirst,DocLast) values ('  " & TextBoxFirst.Text & ", " &

With this one :

VB

Dim insertCommand As String = "Insert into DoctorRecord (DocFirst,DocLast) values ('" & TextBoxFirst.Text & "', '" &

The first code embraces two strings into one quoted string so you see that error.

Hope It Helps.

Posted 20-Nov-11 23:11pm

Amir Mahfoozi

Comments

HL22 21-Nov-11 5:12am

Thanks.It have been solved....

Amir Mahfoozi 21-Nov-11 5:18am

Good Luck

Solution 1

Please provide sample to proceed further.

Tell me the error what you getting

Posted 20-Nov-11 22:41pm

Member 8224699

Comments

demouser743 21-Nov-11 4:47am

Post this as a comment. Do you think this an answer :-o

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)

demouser743 · Accepted Answer · 2011-11-20T22:58:00

I don't know what's your error is but as i am not that much good with VB coding i will post the sample code for inserting values try this and let me know

C#

"INSERT INTO Customers(col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11) VALUES(" & _
                        "'" & txtData1.Text & "'," & _
                        "'" & txtData2.Text & "'," & _
                        "'" & txtData3.Text & "'," & _
                        "'" & txtData4.Text & "'," & _
                        "'" & txtData5.Text & "'," & _
                        "'" & txtData6.Text & "'," & _
                        "'" & txtData7.Text & "'," & _
                        "'" & txtData8.Text & "'," & _
                        "'" & txtData9.Text & "'," & _
                        "'" & txtData10.Text & "'," & _
                        "'" & txtData11.Text & "')"

Paste your controls instead of mine and give it a try

Unable insert data into Microsoft SQL Server

4 solutions

Solution 4

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us