Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
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();
}
}
}
}
Subscribe to:
Posts (Atom)