Problem in inserting data

Question

0.00/5 (No votes)

See more:

when i am trying to insert a data in a table it gives me syntax error
code is

C#

string str="insert into Company(CompanyName,Address1,Address2,Address3,City,State,PinCode,Phone1,Phone2,E-MailId,VATTIN,PinNo,TNGST,CST,ITNo,StartDate,UptoDate) values('"+txtName.Text+"','"+txtAddrs1.Text+"','"+txtAddrs2.Text+"','"+txtAddrs3.Text+"','"+txtCity.Text+"','"+txtState.Text+"',"+txtPinCode.Text+",'"+txtPhone1.Text+"','"+txtPhone2.Text+"','"+txtEmail.Text+"','"+txtVattin.Text+"','"+txtPinNo.Text+"','"+txtTngst.Text+"','"+txtCst.Text+"','"+txtItNo.Text+"','"+dteStartDate.Text+"','"+dteUptoDate.Text+"')";

plz help me!

Posted 1-Nov-12 22:28pm

NABIN SEN

Updated 1-Nov-12 23:14pm

Nelek

v2

Add a Solution

Comments

sarathtamil 2-Nov-12 4:36am

check the data definition of the each column in the table

sarathtamil 2-Nov-12 4:37am

what error ?

Manoj Kumar Choubey 2-Nov-12 5:18am

What was the error message ?

3 solutions

Solution 3

I think you are missing date format and data type of number/date , text box may be empty / and date format may be wrong .
Please provide the error message so i can give you better answer.

Posted 1-Nov-12 23:23pm

Manoj Kumar Choubey

Solution 4

You may missing datatype for any of the values.Check it with db for each and every value and send the values by parsing it. Check textbox values should not be empty.I suggest to use parameterized queries instead of this.

Posted 1-Nov-12 23:39pm

sulthana1

Add a Solution

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

OriginalGriff · Accepted Answer · 2012-11-01T22:55:00

Look at you tcolumn names: "E-MailId" is probably causing the problem. Either change it in the table definition (good idea) or remember to escape it each time you use it:

SQL

INSERT INTO Company(Phone2, [E-MailId], VATTIN) VALUES (...)

BTW: Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.

Problem in inserting data

3 solutions

Solution 3

Solution 2

Solution 4

Add your solution here

Preview 0

Problem in inserting data

3 solutions

Solution 3

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us