void Page_Load(object sender, EventArgs e) {

string ConnectionString = "server=pong;database=todo;uid=sa;pwd=master;";
SqlConnection myConnection = new SqlConnection(ConnectionString);

DataSet ds = new DataSet();

string cmdText = "SELECT * FROM user";
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);

myCommand.Connection.Open();
Label1.Text=(myCommand.ExecuteNonQuery()).ToString();

myConnection.Close();

}


Ошибка :

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'user'.

Source Error:


Line 15:
Line 16: myCommand.Connection.Open();
Line 17: Label1.Text=(myCommand.ExecuteNonQuery()).ToString();
Line 18:
Line 19: myConnection.Close();

Почему?

Надо было - "SELECT [user].* FROM [user]"
Ja slischkom privik k FoxPro