code for website

Question

I want code for creating website.. also code foe login page and sign up page. and how to connect database to website.. i want all code which is use for website for topic online food delivery. plz reply as soon as possible. thank you

Morcos Adel · Answer

You can try to use VS 2010 or VS 2012, You can create a new project and select ASP.NET Web application, a Project will be created for you with with a login form and a registration form and then all you have to do is to configure you connection string using the Wizard

Satyapriya Nayak · 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 Register_using_param { public partial class _Default : System.Web.UI.Page { public string GetConnectionString() { //sets the connection string from your web config file "ConnString" is the name of your Connection String return System.Configuration.ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString; } private void ExecuteInsert(string name, string username, string password, string gender, string age, string address) { SqlConnection conn = new SqlConnection(GetConnectionString()); string sql = "INSERT INTO tblRegistration (Name, UserName, Password, Gender, Age, Address) VALUES (@Name,@UserName,@Password,@Gender,@Age,@Address)"; try { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@Name", SqlDbType.VarChar, 50); param[1] = new SqlParameter("@UserName", SqlDbType.VarChar, 50); param[2] = new SqlParameter("@Password", SqlDbType.VarChar, 50); param[3] = new SqlParameter("@Gender", SqlDbType.Char, 10); param[4] = new SqlParameter("@Age", SqlDbType.Int, 100); param[5] = new SqlParameter("@Address", SqlDbType.VarChar, 50); param[0].Value = name; param[1].Value = username; param[2].Value = password; param[3].Value = gender; param[4].Value = age; param[5].Value = address; for (int i = 0; i < param.Length; i++) { cmd.Parameters.Add(param[i]); } cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex) { string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { conn.Close(); } } protected void btn_register_Click(object sender, EventArgs e) { if (TxtPassword.Text == TxtRePassword.Text) { //call the method to execute insert to the database ExecuteInsert(TxtName.Text, TxtUserName.Text, TxtPassword.Text, DropDownList1.SelectedItem.Text, TxtAge.Text, TxtAddress.Text); Response.Write("Record was successfully added!"); ClearControls(Page); } else { Response.Write("Password did not match"); TxtPassword.Focus(); } } public static void ClearControls(Control Parent) { if (Parent is TextBox) { (Parent as TextBox).Text = string.Empty; } else { foreach (Control c in Parent.Controls) ClearControls(c); } } } }

Satyapriya Nayak · Answer

Login Page Using Stored Procedure. 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 Untitled Page 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 Untitled Page 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"]; } } }

code for website

Answers (3)