An expression of non-boolean type specified in a context where a condition is expected, near ')'.

See more:

C#

SQL-Server-2008R2

ASP.NET4

first i submitted my code:

SqlConnection con = new SqlConnection("server=.; database=Hall_management_system;user=sa;password=11;integrated security=true;");
            con.Open();
            DataSet ds1 = new DataSet();
            DataTable FromTable1 = new DataTable();
            string cmdstr = "select total_pay,current_meal,total_meal_cost,total_cost,remaining from meal_member where regestration_number=@regestration_number and (select per_meal from bazar)";
            SqlCommand cmd = new SqlCommand(cmdstr, con);


            cmd.Parameters.AddWithValue("@regestration_number", Session["user"]);

            SqlDataAdapter adp1 = new SqlDataAdapter(cmd);
            adp1.Fill(ds1);
            DataList2.DataSource = ds1.Tables[0];
            DataList2.DataBind();

when i run this code then show this error massage-"

An expression of non-boolean type specified in a context where a condition is expected, near ')'.

why?

What I have tried:

I'm getting below error.
thank your in advance all of you..