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