C# Ado.net MSDE: Wrong Syntax Near The User Keyword

************* Edited by moderator Adec ***************


Inserted missing < code></ code> tags. Always include such


tags when including code in your postings. Many readers


disregard postings without the code tags.


**************************************************





Hello,





I have a big problem with some piece of code. I am new to C# and ado.net.


My MSDE 2000 is set up and running. But the following code produces the error


(translated from german) like "wrong syntax near the user keyword"





The connection to the database works fine. But trying to create a table or to drop


a table alwas leads to the error. Whats wrong with it?





try


{


SqlConnection myConnection = new SqlConnection( "server=(local);" +


"Trusted_Connection=yes;" +


"database=ergofun; " +


"connection timeout=10");


SqlCommand sqlCommand = new SqlCommand();





sqlCommand.Connection = myConnection;


sqlCommand.CommandText = "CREATE TABLE user ( userid INT," +


"nickname CHAR(20),"+


"password CHAR(20),"+


"birthday DATETIME,"+


"weight INT,"+


"size INT,"+


"puls INT,"+


"name CHAR(20),"+


"surname CHAR(20))";





sqlCommand.Connection.Open();


sqlCommand.ExecuteNonQuery();


sqlCommand.Connection.Close();


}


catch (Exception ex)


{


MessageBox.Show(ex.Message);


}