HOW TO PROVIDE A CUSTOM LOGIN DEMO USING SQLSERVER WITH C#-ASP.NET

using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; //public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { DropDownList1.SelectedItem.Text.ToLower();//TO GET THE SELECTED ITEM IN LOWERCASE if ((DropDownList1.SelectedItem.Text != "") && (TextBox2.Text != "")) { string ss = ConfigurationManager.ConnectionStrings["con"].ToString(); SqlConnection c = new SqlConnection(ss); try { c.Open(); SqlCommand cmd = new SqlCommand("select statement " ",c); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read())//FOR FETCHING EACH RECODE { if ((DropDownList1.SelectedItem.Text == "admin") && (TextBox2.Text == "admin")) { string s = DropDownList1.SelectedItem.Text.ToString(); //Server.Transfer("defalut3.aspx?name='"+s+"'"); Server.Transfer("abcd.aspx?name='"+s+"'"); } else if ((DropDownList1.SelectedItem.Text == dr[0].ToString()) && (TextBox2.Text == dr[1].ToString())) { string s1 = DropDownList1.SelectedItem.Text; Server.Transfer("default2.aspx?a='" + s1 + "'"); } else { //string jScript; //jScript = //""; // Page.RegisterClientScriptBlock("warning", jScript);//TO ENABLE CLIENT SIDE SCRIPTING IN CODE BEHIND FILE } } } finally { c.Close(); } } } }