How to create Registration page and login page using c# windows form application

Question

How to create Registration page and login page using c# windows form application using database Pls give me some links

kumaran k · Answer

http://kumaran198726.blogspot.in/2013/07/login-project-article-login-and.html see here

Satyapriya Nayak · Answer

Hi Suchetha, Try this... Registration page 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 Registration { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; string str; protected void btnadd_Click(object sender, EventArgs e) { ExecuteInsert(RegistrationText.Text, MakeText.Text, ModelText.Text, FuelTypeText.Text, CapacityText.Text, BhpText.Text, MileageText.Text); Response.Write("Record was successfully added!"); clear(); } private void ExecuteInsert(string RegistrationNumber, string Make, string Model, string FuelType, string Capacity, string Power, string Mileage) { SqlConnection con = new SqlConnection(connStr); str = "INSERT INTO Vehicles (RegistrationNumber, Make, Model, FuelType, Capacity, Power, Mileage) VALUES (@RegistrationNumber, @Make, @Model, @FuelType, @Capacity, @Power, @Mileage)"; try { con.Open(); com = new SqlCommand(str, con); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@RegistrationNumber", SqlDbType.NVarChar, 10); param[1] = new SqlParameter("@Make", SqlDbType.NVarChar, 30); param[2] = new SqlParameter("@Model", SqlDbType.NVarChar, 30); param[3] = new SqlParameter("@FuelType", SqlDbType.NVarChar, 10); param[4] = new SqlParameter("@Capacity", SqlDbType.Int, 4); param[5] = new SqlParameter("@Power", SqlDbType.Int, 4); param[6] = new SqlParameter("@Mileage", SqlDbType.Int, 8); param[0].Value = RegistrationNumber; param[1].Value = Make; param[2].Value = Model; param[3].Value = FuelType; param[4].Value = Capacity; param[5].Value = Power; param[6].Value = Mileage; for (int i = 0; i { com.Parameters.Add(param[i]); } com.CommandType = CommandType.Text; com.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex) { string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } void clear() { RegistrationText.Text = ""; MakeText.Text = ""; ModelText.Text = ""; FuelTypeText.Text = ""; CapacityText.Text = ""; BhpText.Text = ""; MileageText.Text = ""; } } } Thanks If this post helps you mark it as answer

Satyapriya Nayak · Answer

Hi Suchetha, Try this... Login page 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_page_Msaccess { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; string str; object obj = null; public Form1() { InitializeComponent(); } private void btn_login_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select count(*) from login where UserName=@UserName and Password =@Password"; com = new OleDbCommand(str, con); com.CommandType = CommandType.Text; com.Parameters.AddWithValue("@UserName", TextBox_user_name.Text); com.Parameters.AddWithValue("@Password", TextBox_password.Text); obj = com.ExecuteScalar(); if ((int)(obj) != 0) { lb1.Text = "WELLCOME :: " + TextBox_user_name.Text; } else { lb1.Text = "invalid user name and password"; } con.Close(); } } } Thanks If this post helps you mark it as answer

How to create Registration page and login page using c# windows form application

Answers (3)