Unable to connect to SQL Server database in C#

Question

I am learning C# and I am trying to connect my program to a SQL Server database. For the learning purpose I followed the following video :

http://www.youtube.com/watch?v=Rwdedptaou0

This is my code:

using System.Data.SqlClient;

namespace TestDBMS
{
    public partial class MainWindow : Window
    {
        SqlConnection conn;
        SqlCommand cmd;

        public MainWindow()
        {
            InitializeComponent();
            conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Reventon\Documents\EmployeeDB.mdf;Integrated Security=True;Connect Timeout=30");
        }

        private void btnSave_Click(object sender, RoutedEventArgs e)
        {
            string query = "INSERT INTO Table VALUES(3, 'Sachin', '120000', 'Nagaur')";
            cmd = new SqlCommand();
            cmd.CommandText = query;
            cmd.Connection = conn;
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();

            MessageBox.Show("Record Saved");
        }
    }
}

After compiling the program I am getting an error

Incorrect Syntax Near the 'Table'

(for better representation i have captured the screenshot and uploaded on my Skydrive account). http://sdrv.ms/1bUDe3l

Please help me out.

I tried changing Table name but everything i am changing the name and pressing the save button the Save Dialogue Box is keep appearing to enter name again and again. Please checkout the ScreenShot : sdrv.ms/LTvowG — user3300068
– user3300068, Commented Feb 12, 2014 at 5:23

Mudassir Hasan · Accepted Answer · 2014-02-12 04:59:19Z

4

Table is keyword , can't be used as tablename. Change query to

 string query = "INSERT INTO yourTableName VALUES(3, 'Sachin', '120000', 'Nagaur')";

answered Feb 12, 2014 at 4:59

Mudassir Hasan

29k21 gold badges104 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3300068 Over a year ago

But sir, it was the default name of the table, Should i change it to any anonymous name?

Mudassir Hasan Over a year ago

Yes sir, change table name in database and then in code, the word Table is a SQL keyword .

user3300068 Over a year ago

Unable to Change Table name : I tried changing Table name but everything i am changing the name and pressing the save button the Save Dialogue Box is keep appearing to enter name again and again. Please checkout the ScreenShot : sdrv.ms/LTvowG

Amarnath Balasubramanian · Accepted Answer · 2014-02-12 06:29:10Z

1

Insert Query Syntax:

INSERT INTO yourtablename
(column1, column2, ... )
VALUES
(expression1, expression2, ... );

The error in your code is the table rename it to the appropriate table name like Customertable

INSERT INTO Customertable VALUES(3, 'Sachin', '120000', 'Nagaur')

Alter table name:

Use sp_rename to rename your table name:

    EXEC sp_rename 'table', 'Customertable'

    sp_rename old_table_name , new_table_name

ALTER TABLE TABLE_NAME RENAME TO NEW_TABLE_NAME Works only in Oracle DB.

Tutorial

You can find documentation on this procedure on MSDN.

In Server Explorer right click on Views and click New Query.
use this code to rename table:

EXEC sp_rename 'Table', 'NewName'

then click on Execute button.
after 5-30 seconds in server explorer click on refresh button.

enter image description here

edited Feb 12, 2014 at 6:29

answered Feb 12, 2014 at 5:09

Amarnath Balasubramanian

9,5028 gold badges38 silver badges62 bronze badges

5 Comments

user3300068 Over a year ago

Do i need to use SQL Server, Isn't it possible to change it via Visual Studio only?

Amarnath Balasubramanian Over a year ago

no to change the table name you should be using the database engine..!! i.e sql server

user3300068 Over a year ago

Yesssssssssssssssssssssssssssssssssssssssssssssssss. Its Done :) I am happy

user3300068 Over a year ago

Thank you so much. Sir can you guide me that which book i should learn to know this connectivity aspects?

Amarnath Balasubramanian Over a year ago

Glat that it helped..! :) Happy coding..! :)

MusicLovingIndianGirl · Accepted Answer · 2014-02-12 05:01:20Z

0

Table is a default SQL keyword. Give specific name to your table.

INSERT INTO Customer VALUES(3, 'Sachin', '120000', 'Nagaur')

answered Feb 12, 2014 at 5:01

MusicLovingIndianGirl

5,9459 gold badges38 silver badges65 bronze badges

3 Comments

user3300068 Over a year ago

How can i change the table name?

Crazy Programmer Over a year ago

Here You can see how to change the table name!

MusicLovingIndianGirl Over a year ago

ALTER TABLE table_name RENAME TO new_table_name;

Ajay · Accepted Answer · 2014-02-12 05:05:55Z

0

You can not use Table keyword as tablename. You should give some other name. Here is list of keywords in SQL Server: http://technet.microsoft.com/en-us/library/aa238507%28v=sql.80%29.aspx

Try this query :

string query = "INSERT INTO yourTableName VALUES (3, 'Sachin', '120000', 'Nagaur')";

OR

string query = "INSERT INTO yourTableName(Column1, Column2, Column3, Column4) VALUES (3, 'Sachin', '120000', 'Nagaur')";

answered Feb 12, 2014 at 5:05

Ajay

6,59818 gold badges83 silver badges135 bronze badges

3 Comments

user3300068 Over a year ago

Unable to Change Table name : I tried changing Table name but everything i am changing the name and pressing the save button the Save Dialogue Box is keep appearing to enter name again and again. Please checkout the ScreenShot : sdrv.ms/LTvowG

Ajay Over a year ago

Change your table name to DemoTable and in Insert query also

Ajay Over a year ago

But I see it in you database. change it in database also

Dmitriy Khaykin · Accepted Answer · 2014-02-12 05:15:37Z

0

Actually while all but one of the answers are correct, you CAN actually use the word Table as a table name, if you use square brackets [ ]

Create Table Table ( id int ) -- doesn't work!

However,

Create Table [Table] ( id int ) -- works!

I don't recommend this practice and agree it's best to use a name other than "Table" even with square brackets for your database table!

Just wanted to point out that technically speaking, there is actually a way to use the SQL keyword 'table' as a table name in SQL Server.

answered Feb 12, 2014 at 5:15

Dmitriy Khaykin

5,2581 gold badge22 silver badges32 bronze badges

Comments

Nagaraj S · Accepted Answer · 2014-02-12 05:17:28Z

0

Can you change your tablename?? and try again.Because table is a default keyword

INSERT INTO Tablename (col1,col2,col3,col4) VALUES(3, 'Sachin', '120000', 'Nagaur')";

edited Feb 12, 2014 at 5:17

answered Feb 12, 2014 at 5:02

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

Comments

SULFIKAR A N · Accepted Answer · 2014-02-12 05:34:12Z

0

string query = "INSERT INTO [Table] VALUES(3, 'Sachin', '120000', 'Nagaur')";

answered Feb 12, 2014 at 5:34

SULFIKAR A N

4464 silver badges13 bronze badges

Collectives™ on Stack Overflow

Unable to connect to SQL Server database in C#

7 Answers 7

3 Comments

5 Comments

3 Comments

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

3 Comments

5 Comments

3 Comments

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related