Insert DATA into Database in asp.net c#

Question

I want to insert data in database in asp.net using c#,but it showing me this exception.

exception

Please show your code and exception message as a plain text. — Soner Gönül, Dec 28 '15 at 12:07
`table` is a preserved keyword in every ANSI SQL language. Rename your table. — Patrick Hofman, Dec 28 '15 at 12:08

score 1 · Answer 1 · edited Jul 29 '20 at 18:28

It is really hard to tell to solve your problem on an image but my money is on Table is a reserved keyword on TSQL part. You can use it with square brackets like [Table] but I do not recommend this. Change it to non-reserved word as a best option.

But much more important, you should always use parameterized queries. This kind of string concatenations are open for SQL Injection attacks.

And use using statement to dispose your connection and command automatically instead of calling Close method manually.

Based on your column name, ID should be numeric type instead of character. Do not have a bad habit to choose wrong data type.

Also do not store your passwords as a plain text. Read Best way to store password in database

Thank you so very much Sir :) – G ABBAS Dec 28 '15 at 15:47 — G ABBAS, Dec 28 '15 at 15:47

score 0 · Answer 2 · answered Dec 28 '15 at 13:13

Query syntax is not correct so how can you fix it?

Steps:

Copy command text(cmd.CommandText in debug mode)
Open micro soft sql server management studio and open query analyzer and paste there.
Run the query and you will find the cause.
After fixing the syntax error there now you can construct query in same way for c# code

I trust it will help you. :)

Insert DATA into Database in asp.net c#

2 Answers2