Sample user login form

Question

yah i am using visual studio 2010 C#.net and ms sql server 2008 .please give a sample code to develope the user login form and progress bar . please give a good solution. because i want to become a software engineer.....

Satyapriya Nayak · Answer

Login Form in Csharp Using ProgressBar using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Login_Form_in_Csharp_Using_ProgressBar { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; OleDbDataAdapter oledbda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void btnlogin_Click(object sender EventArgs e) { if (txtusername.Text ==  || txtpassword.Text == ) { MessageBox.Show(Please enter User ID or Password); txtusername.Text = ; txtpassword.Text = ; } else { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select count(*) from login where userid=' + txtusername.Text.Trim() + ' and password=' + txtpassword.Text.Trim() + '; com = new OleDbCommand(str con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds login); long x; x = Convert.ToInt64(com.ExecuteScalar()); if (x == 1) { int y = 0; progressBar1.Visible = true; progressBar1.Minimum = 1; progressBar1.Maximum = 100000; progressBar1.Value = 1; progressBar1.Step = 1; for (y = 1; y { progressBar1.PerformStep(); } Form2 f1 = new Form2(); f1.Show(); this.Hide(); } else { MessageBox.Show(Invalid User ID or Password! Try Again!); txtusername.Text = ; txtpassword.Text = ; } con.Close(); } } } }

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Stored Procedure CREATE procedure login_pro ( @UserName varchar (50) @Password varchar (50) ) as declare @status int if exists ( select * from Login where UserName=@UserName and Password=@Password) set @status=1 else set @status=0 select @status Default.aspx @ Page Language =C# AutoEventWireup =true CodeBehind =Default.aspx.cs Inherits =Login_Page_Using_Stored_Procedure._Default %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> html xmlns =http://www.w3.org/1999/xhtml > head runat =server> title > Untitled Page title > head > body > form id =form1 runat =server> div > asp : Label ID =Label1 runat =server Text =Name Font-Bold =True Width =100px BackColor =#FFFF66 ForeColor =#FF3300> asp : Label > asp : TextBox ID =TextBox_user_name runat =server ForeColor =#993300 Width =100px> asp : TextBox > asp : RequiredFieldValidator ID =RequiredFieldValidator1 runat =server ControlToValidate =TextBox_user_name ErrorMessage =Please enter username> asp : RequiredFieldValidator > br /> asp : Label ID =Label2 runat =server Text =Password Font-Bold =True Width =100px BackColor =#FFFF66 ForeColor =#FF3300> asp : Label > asp : TextBox ID =TextBox_password runat =server ForeColor =#CC6600 TextMode =Password Width =100px> asp : TextBox > asp : RequiredFieldValidator ID =RequiredFieldValidator2 runat =server ControlToValidate =TextBox_password ErrorMessage =Please enter password> asp : RequiredFieldValidator > br /> asp : Button ID =btn_login runat =server Text =Login Font-Bold =True BackColor =#CCFF99 onclick =btn_login_Click /> br /> asp : Label ID =lblmessage runat =server Font-Bold =True ForeColor =#FF3300> asp : Label > br /> div > form > body > html > Default.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Login_Page_Using_Stored_Procedure { public partial class _Default : System.Web.UI. Page { string strConnString = ConfigurationManager .ConnectionStrings[ ConnectionString ].ConnectionString; SqlCommand com; SqlParameter UserName Password; protected void btn_login_Click( object sender EventArgs e) { UserName = new SqlParameter (); Password = new SqlParameter (); SqlConnection con = new SqlConnection (strConnString); com= new SqlCommand (); com.Connection = con; con.Open(); Session[ UserName ] = TextBox_user_name.Text; com.CommandType = CommandType .StoredProcedure; com.CommandText = login_pro ; UserName.SqlDbType = SqlDbType .VarChar; UserName.Size = 50; UserName.ParameterName = @UserName ; UserName.Value = TextBox_user_name.Text.ToString(); UserName.Direction = ParameterDirection .Input; Password.SqlDbType = SqlDbType .VarChar; Password.Size = 50; Password.ParameterName = @Password ; Password.Value = TextBox_password.Text.ToString(); Password.Direction = ParameterDirection .Input; com.Parameters.Add(UserName); com.Parameters.Add(Password); int status; status = Convert .ToInt16(com.ExecuteScalar()); if (status == 1) { Response.Redirect( Welcome.aspx ); } else { lblmessage.Text = Invalid UserName and Password... ; } con.Close(); } } } Welcome.aspx @ Page Language =C# AutoEventWireup =true CodeBehind =Welcome.aspx.cs Inherits =Login_Page_Using_Stored_Procedure.Welcome %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> html xmlns =http://www.w3.org/1999/xhtml > head runat =server> title > Untitled Page title > head > body > form id =form1 runat =server> div > asp : Label ID =lb1 runat =server Font-Bold =True ForeColor =#FF3300> asp : Label > br /> div > form > body > html > Welcome.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; namespace Login_Page_Using_Stored_Procedure { public partial class Welcome : System.Web.UI. Page { protected void Page_Load( object sender EventArgs e) { lb1.Text = WELLCOME ::  + Session[ UserName ]; } } } /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:Times New Roman;mso-bidi-theme-font:minor-bidi;}