DataBase Assignment

 

1. Registration page(Design) 

Note:- We used Range validator in Age 's textbox. 

Coding-

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls; 

using System.Data.SqlClient;

public partial class Registration : System.Web.UI.Page

{

    SqlConnection cn;

    SqlCommand cm;

    SqlDataReader dr;

    protected void Page_Load(object sender, EventArgs e)

    {

    } 

    //Coding of submit button

    protected void Button1_Click(object sender, EventArgs e)

    {

        string p=@"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";

        cn = new SqlConnection(p);

        cn.Open();

        string q = "insert into Chitransh_reg values ( '"+TextBox1.Text+"', '"+TextBox2.Text+"', '"+TextBox3.Text+"', '"+DropDownList1.Text+"', '"+TextBox4.Text+"', '"+TextBox5.Text+"')";

        cm = new SqlCommand(q,cn);

        cm.ExecuteNonQuery();

        TextBox1.Text = "";

        TextBox2.Text = "";

        TextBox3.Text = "";

        TextBox4.Text = "";

        TextBox5.Text = "";

        DropDownList1.SelectedIndex = 0;

    } 

   //Go to login page

    protected void Button2_Click(object sender, EventArgs e)

    {

     Response.Redirect("login.aspx");

    }

}

2. Login Form- 

Coding- 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

public partial class login : System.Web.UI.Page

{

    SqlConnection cn;

    SqlCommand cm;

    SqlDataReader dr;

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        string s =@"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";

        cn = new SqlConnection(s);

        cn.Open();

        string q = "select mobile,pass from Chitransh_reg where mobile='" + TextBox1.Text + "' and  pass='" + TextBox2.Text + "'";

        cm = new SqlCommand(q, cn);

        dr= cm.ExecuteReader();

        if (dr.Read())

        {

            Response.Write("Login Successfully Done..");

        }

        else

        {

            dr.Close();

            Response.Write("Invalid mobile or password");

        }

    }

}