Login and Logout coding Asp.net C#

Login button Coding

{

string mycon = "Data Source=DESKTOP-79IQ2D8; Initial Catalog=LoginPageDb; Integrated Security= True";

        SqlConnection scon = new SqlConnection(mycon);

        string myquery = "Select * From Users";

        SqlCommand cmd = new SqlCommand();

        cmd.CommandText = myquery;

        cmd.Connection = scon;

        SqlDataAdapter SDA = new SqlDataAdapter();

        SDA.SelectCommand=cmd;

        DataSet ds = new DataSet();

        SDA.Fill(ds);

        String uname;

        String pass;

        uname=ds.Tables[0].Rows[0]["uname"].ToString();

        pass=ds.Tables[0].Rows[0]["pass"].ToString();

        scon.Close();

        if (uname== TextBox1.Text && pass== tb_pswrd.Text)

       {

               Session["username"]=uname;

            Response.Redirect("Adminhome.aspx");

       }

        else

       {

            Label2.Text="Invalid username and password. Please Relogin with true username and password";

       }

    }

}

Logout button&page coding

protected void Page_Load(object sender, EventArgs e)

    {

        if (Session["username"] == null)

        {

            Response.Redirect("Default.aspx");

        }

        else

        {

            Label2.Text = "Hello" + Session["username"].ToString();

        }

    }

    protected void btn_logout_Click(object sender, EventArgs e)

    {

        Session.Abandon();

        Response.Redirect("Signout.aspx");

    }

Database

ubaidsardar.blogspot.com