Login And Registration Form With C#

Question

Please how can i create login and registration form for many users with c#. Than ks.

Yogesh Sharma · Answer

Hi,,,, You have to create class with insert method like... datalayer class : using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; using System.Configuration; /// /// Summary description for Datalayer /// /// public class Datalayer { SqlConnection con; SqlCommand cmd; SqlDataAdapter da; public Datalayer() { con = new SqlConnection(ConfigurationManager.ConnectionStrings["name"].ConnectionString); } public void insertdata(String query) { cmd = new SqlCommand(query,con); try { con.Open(); cmd.ExecuteNonQuery(); } catch (SqlException err) { throw err; } catch (Exception err1) { throw err1; } finally { con.Close(); } } finally { con.Close(); cmd.Dispose(); con.Dispose(); } } public string Bind_sites() { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Drishti"].ConnectionString); SqlCommand cmd = new SqlCommand("insert into Sites values('" + Acc_Email_ID + "','" + Sites + "')", con); cmd.CommandType = CommandType.Text; try { con.Open(); cmd.ExecuteNonQuery(); return "Site Stored"; } catch (SqlException err) { throw err; } catch (Exception err1) { throw err1; } finally { con.Close(); cmd.Dispose(); con.Dispose(); } } } create your reg. form on button click event write code : call datalayer method named insertdate as well : datalayer dl = new datalayer(); string query; query = string.format ("insert into table values('0')",'"+txtvalue.text+"'); dl.insertdata(query); This method is very useful for you because you can create no of methods in it... and call once on page methods like inserdata, delete data, get data, get data by reader, etc... Thank you... Hope you will enjoy this type of method ...... to insert data in sql table....

Amit Singh · Answer

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 = ""; } } } http://www.aspsnippets.com/Articles/Simple-User-Registration-Form-Example-in-ASPNet.aspx http://www.msdotnet.co.in/2013/04/how-to-make-registration-and-login-form.html#.VtAWF-b6jBU

Krishna Rajput Singh · Answer

Hello Oyetoke Toby thanks for writing below links i hope helpful for you....:) http://krishnasinghprogramming.blogspot.in/search/label/Window%20Application%20in%20C%23 http://www.msdotnet.co.in/2013/04/how-to-make-registration-and-login-form.html#.VtAdgfl97IU http://www.aspsnippets.com/Articles/Simple-User-Registration-Form-Example-in-ASPNet.aspx http://www.dreamincode.net/forums/topic/319301-c%23-loginregister-system-using-sql-compact/ http://www.aspdotnet-suresh.com/2011/12/how-to-create-simple-login-form-using.html if find helpful answer mark answer as correct or accept...

Shubham Kumar · Answer

Hi, try this link it may help you http://codemyne.net/articles/asp/creating-a-simple-registration-or-signup-and-login-or-signin-form-using-asp.net-and-sqlserver.aspx?visitid=171&type=2

Login And Registration Form With C#

Answers (4)