how to check if user is SuperUser or not

See more:

ASP.NET

C#3.5

SQL-Server-2008R2

I have a login table in which i have four columns id, username, password and SuperUser. when i login i want to show specific pages to normal user and whole pages to superuser. what i tried is:

protected void LoginButton_Click(object sender, EventArgs e)
        {
            SqlConnection con=new SqlConnection(@"Data Source=ashish-pc\;Initial Catalog=HMS;Integrated Security=True");
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from Login where UserName=@UserName and Password=@Password", con);
            cmd.Parameters.AddWithValue("@UserName", UserName.Text.Trim() );
            cmd.Parameters.AddWithValue("@Password", Password.Text.Trim());
            cmd.Parameters.Add("IsSuperUser");

            
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataSet dt = new DataSet();
            
            da.Fill(dt);
            if (dt.Tables[0].Rows.Count>0)
            {
                

                
                Session["UserName"] = UserName.Text;
                Session.Timeout = 1;

                //Session["Login"] =     
                Response.Redirect("/Home.aspx");
                
            }
            else 
            {
                 Response.Write("Invalid username and password");
            }
            con.Close();
        }

please help