c# SQLCOMMAND giving error

Question

Sqlcommand cmd=new Sqlcommand();
cmd.commandtext="select username, password from \"user\" where username = 'admin' 
 and password = 'password123' ";
adp.fill(ds);

Now above query is getting succesffuly executed in mysql and mssql,but my C# code is giving error incorrect sytax "user" Where I am wrong? NOTE:-I want above query to run in mysql and mssql both,and also note that user is reserved keyword in sql

juergen d · Accepted Answer · 2013-10-07 16:12:57Z

2

For MySQL use

from `user`

For SQL Server use

from [user]

For Oracle use

from "user"

answered Oct 7, 2013 at 16:12

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

4 Comments

Rajubhai Over a year ago

But I dont want to write 3 statements I want common C# code to run this query

juergen d Over a year ago

I don't think this is going to happen.

Dave Sexton Over a year ago

If you want to keep it generic why not just remove the quotes: FROM user

juergen d Over a year ago

@DaveSexton: That does not work for SQL Server. Only for MySQL as far as I know.

Collectives™ on Stack Overflow

c# SQLCOMMAND giving error

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related