Skip to main content

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");

        }

    }

}

Comments

Post a Comment

Popular posts from this blog

QueryString_Assignment

    Write a code for this-                                                                    1.Registration.aspx- Coding of SUBMIT button- using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Registration : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {     }     protected void Button1_Click(object sender, EventArgs e)     {         Response.Redirect("Login.aspx?name=" +TextBox1.Text + "&email=" + TextBox2.Text + "&mobile=" +TextBox3.Text + "&pass=" +TextBox4.Text + "&city=" + DropDownList1.Text);      } } 2. Login.aspx- Coding of LOGIN button- using System; using System.Collections.Generic; using System.Linq; using...
Post a Comment
Read more

Selecting directory using DropDownList

ASSIGNMENT- The objective is to write the name of directory in the first textbox and click on Create dir then all directories have to added in the below DropDownList. By Selecting the image from FileUpload control and the directory from dropdownlist we can put the image in the specific selected directory How to add the directories using code-     protected void CheckDir_Click(object sender, EventArgs e)     {         Directory.CreateDirectory(Server.MapPath(TextBox1.Text) + "/");          DropDownList1.Items.Add(TextBox1.Text);     }   UploadButton Code-      protected void Upload_Click(object sender, EventArgs e)     {         FileUpload1.SaveAs(Server.MapPath("~") + "//"+DropDownList1.Text+"//" + FileUpload1.FileName);     } Insert 4 directories- 1. pic1 2. pic 2  3. pic3  4. pic4  Selecting pic2 from the Drop Down List an...
Post a Comment
Read more

Link Button in Grid View [Usage of Session]

  Create a Link Button using Template Field.  Create an event of link button- Steps- 1. Select the Grid View.  2. Go to source. 3. Create the Event 'OnClick' in Link Button's attribute.  4. Create the Event of link button in code window-  protected void send_click(object sender, EventAgrs e) { // activate the control GridViewRow gr1 = ((LinkButton)sender.NamingContainer as GridViewRow;  // find control  LinkButton l1 = (LinkButton) gr1.FindControl("lb1"); ; Session["name"] = gr1.Cells[0].Text; Session["amu"] =  gr1.Cells[1].Text;  Response.Redirect("NextPage.aspx"); } 2. We have to call the Session in the page_load event of NextPage-  protected void Page_load(object sender, EventArgs e) { Label1.Text = (string) Session["name"]; Label2.Text = (string) Session["amu"]; } 
Post a Comment
Read more