Friday, March 23, 2012

Incorrect syntax near ,. Sql Statement

SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString2"].ToString());
SqlCommand myCommand = new SqlCommand("SELECT (Deadline, Description, Headline, AddressField, OrganizationField, NameField, FileField, EmailField, CommentField) FROM RegistrationFormDB_Info WHERE (UserName = @.UserName AND TournamentName = @.TournamentName)", myConnection);

SqlParameter myParam = new SqlParameter();
myParam.ParameterName = "@.UserName";
myParam.Value = User.Identity.Name;

myCommand.Parameters.Add(myParam);

myParam = new SqlParameter();
myParam.ParameterName = "@.TournamentName";
myParam.Value = Request.QueryString["TournamentName"];

myCommand.Parameters.Add(myParam);

myConnection.Open();

SqlDataReader myReader = myCommand.ExecuteReader(); <======================

I continue to get this error and I can't figure out the problem! Anything helps. Thank you very much.

era86:

"SELECT (Deadline, Description, Headline, AddressField, OrganizationField, NameField, FileField, EmailField, CommentField) FROM RegistrationFormDB_Info WHERE (UserName = @.UserName AND TournamentName = @.TournamentName)"

Remove the ( ) from your select query. You final query would be:

"SELECT Deadline, Description, Headline, AddressField,OrganizationField, NameField, FileField, EmailField, CommentField FROMRegistrationFormDB_Info WHERE UserName = @.UserName AND TournamentName= @.TournamentName"

No comments:

Post a Comment