Incorrect syntax near some keyword in c# / sql

Question

I have the following code snippet :-

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
    string idd = Session["senderefirstname"].ToString();

    Query = " create table '"+ idd +"' (  senderid varchar(90) , recipientid     varchar(90),senderimage varchar(90), senderfirstname varchar(90), senderlastname varchar(90),    message varchar(max) ) ";
    adap = new SqlDataAdapter(Query, con);
    ds = new DataSet();
    adap.Fill(ds); 
    Response.Redirect("newmessage.aspx");
}

but m getting the error is

"Incorrect syntax near 'noah'"

noah is the string stored in session["senderfirstname"] I'm getting this error. Can anyone guide?

Soner Gönül · Accepted Answer · 2014-02-24 13:37:02Z

3

You don't need to use single quotes when you use CREATE TABLE.

Just use create table "+ idd +"

Take a look at syntax from CREATE TABLE (Transact-SQL)

But more important, I don't understand your code at all. I don't think you need to use SqlDataAdapter or DataSet because your query does not return anything.

Just execute your query with SqlCommand.ExecuteNonQuery method like;

Query = " create table "+ idd +"(senderid varchar(90), recipientid varchar(90),senderimage varchar(90), senderfirstname varchar(90), senderlastname varchar(90),message varchar(max)) ";
SqlCommand cmd = new SqlCommand(Query, con);
cmd.ExecuteNonQuery();

edited Feb 24, 2014 at 13:37

answered Feb 24, 2014 at 13:24

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

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

Comments

user3252833 · Accepted Answer · 2014-02-24 13:26:10Z

0

Query = " create table "+ idd +" (  senderid varchar(90) , recipientid     varchar(90),senderimage varchar(90), senderfirstname varchar(90), senderlastname varchar(90),    message varchar(max) ) ";

I think that should work.

answered Feb 24, 2014 at 13:26

user3252833

1299 bronze badges

Comments

Nagaraj S · Accepted Answer · 2014-02-24 13:27:02Z

0

Try this..

Query= "create table "+ idd +"(senderid varchar(90),recipientid varchar(90),senderimage varchar(90), senderfirstname varchar(90), senderlastname varchar(90),message varchar(max) ) ";

answered Feb 24, 2014 at 13:27

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

Collectives™ on Stack Overflow

Incorrect syntax near some keyword in c# / sql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related