You cannot use @Set_name as a variable name. That is SQL Server syntax. You have to declare a variable using C# syntax.

I do have @Set_Name delcared as a c# variable. As a test I hardcoded a set name into the sql query (to get rid of the error) and just print that variable out to an asp:label it works just fine.

This code works perfect. The only problem is that I can only print @Set_Name and can't use it in the query.

<code>
string @Set_Name;
string ConnectionString = "server=edev03;database=on_track;user id=johnrose; password=jrontrack";

string SelectCommand =
"SELECT smile_data.qsect_key, smile_data.ques_id, smile_data.esetq_id, smile_data.Ques_Order, smile_data.Q_Section, smile_data.Q_Text
FROM Smile_Data
WHERE Smile_Data.Set_Name='smile'
ORDER BY Smile_Data.Set_Name, Smile_Data.Sect_Order, Smile_Data.Ques_Order";

           void Page_Load(object sender, EventArgs e) {

                 if (!Page.IsPostBack) {
                    @Set_Name = Request.QueryString["Set_Name"];
                    lblsetName.Text = @Set_Name;
                    BindGrid();

                     }

                    }
</code>

Just for a test remove the @ from the variable and try it that way.

I had tried taking out the @ once before, but I tried again since I am getting desperate. Still nothing.

Thank you everyone for your help I finally figured it out.

this code needed to be added to make it a parameter.

<code>
System.Data.IDataParameter dbParam_Set_Name = new System.Data.SqlClient.SqlParameter();
dbParam_Set_Name.ParameterName = "@Set_Name";
dbParam_Set_Name.Value = Request.QueryString["@Set_Name"];
dbParam_Set_Name.DbType = System.Data.DbType.String;
dbCommand.Parameters.Add(dbParam_Set_Name);
</code>

Thanks again for all your help.