A Simple registration form

create a registration table in sql2005
sql query


CREATE TABLE [dbo].[MemberRegistration](
	[MemberName] [varchar](40) ,
	[DOB] [varchar](40) ,
	[FatherName] [varchar](40),
	[Occupation] [varchar](40),
	[Address] [varchar](200),
	[Country] [varchar](40),
	[State] [varchar](40),
	[City] [varchar](40),
	[Phone] [varchar](40),
	[Pincode] [varchar](40),
	[Mobile] [varchar](40),
	[Email] [varchar](40),
	[Qualification] [varchar](40),
	[InstituteName] [varchar](40),
	[Subject] [varchar](40),
	[SkillSet] [varchar](100),
	[Programming_Languages] [varchar](300),
	[Databases] [varchar](40),
	[WebServer] [varchar](40),
	[MemberID] [bigint] IDENTITY(1000,1) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[MemberID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

Create a registration.aspx page which contains all the fields present in the above Query

Drag a button and rename to SUBMIT
Double click on SUBMIT button to get registartion.aspx.cs

Under button click event write below code


 protected void btnSubmit_Click(object sender, EventArgs e)
    {
        con.Open();

        cmd = new SqlCommand("InsertMember", con);
        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add("@Name", SqlDbType.VarChar, 40);
        cmd.Parameters["@Name"].Value = txtMemberName.Text;

        cmd.Parameters.Add("@SponserID", SqlDbType.BigInt);
        cmd.Parameters["@SponserID"].Value = Convert.ToInt32(txtSponsorId.Text);
        
        cmd.Parameters.AddWithValue("@initial_amt", Amount);

        cmd.Parameters.Add("@DOB", SqlDbType.VarChar, 40);
        cmd.Parameters["@DOB"].Value = txtDob.Text;

        cmd.Parameters.Add("@FatherName", SqlDbType.VarChar, 40);
        cmd.Parameters["@FatherName"].Value = txtFathersName.Text;

        cmd.Parameters.Add("@Occupation", SqlDbType.VarChar, 40);
        cmd.Parameters["@Occupation"].Value = txtOccupation.Text;

        cmd.Parameters.Add("@Address", SqlDbType.VarChar, 200);
        cmd.Parameters["@Address"].Value = txtAddress1.Text;

        cmd.Parameters.Add("@Country", SqlDbType.VarChar, 40);
        cmd.Parameters["@Country"].Value = ddlCountry.SelectedValue;

        cmd.Parameters.Add("@State", SqlDbType.VarChar, 40);
        cmd.Parameters["@State"].Value = ddlState.SelectedValue;

        cmd.Parameters.Add("@City", SqlDbType.VarChar, 40);
        cmd.Parameters["@City"].Value = ddlCity.SelectedValue;

        cmd.Parameters.Add("@Phone", SqlDbType.VarChar, 40);
        cmd.Parameters["@Phone"].Value = txtPhone.Text;

        cmd.Parameters.Add("@Pincode", SqlDbType.VarChar, 40);
        cmd.Parameters["@Pincode"].Value = txtPincode.Text;

        cmd.Parameters.Add("@Mobile", SqlDbType.VarChar, 40);
        cmd.Parameters["@Mobile"].Value = txtMobile.Text;

        cmd.Parameters.Add("@Email", SqlDbType.VarChar, 40);
        cmd.Parameters["@Email"].Value = txtEmail.Text;

        cmd.Parameters.Add("@Qualification", SqlDbType.VarChar, 40);
        cmd.Parameters["@Qualification"].Value = txtQualification.Text;

        cmd.Parameters.Add("@InstituteName", SqlDbType.VarChar, 40);
        cmd.Parameters["@InstituteName"].Value = txtInstituteName.Text;

        cmd.Parameters.Add("@Subject", SqlDbType.VarChar, 40);
        cmd.Parameters["@Subject"].Value = txtSubject.Text;

        cmd.Parameters.Add("@SkillSet", SqlDbType.VarChar, 100);
        cmd.Parameters["@SkillSet"].Value = txtSkillset.Text;

        cmd.Parameters.Add("@Programming_Languages", SqlDbType.VarChar, 300);
        cmd.Parameters["@Programming_Languages"].Value = txtProgramlanguage.Text;

        cmd.Parameters.Add("@Databases", SqlDbType.VarChar, 40);
        cmd.Parameters["@Databases"].Value = txtDatabase.Text;

        cmd.Parameters.Add("@WebServer", SqlDbType.VarChar, 40);
        cmd.Parameters["@WebServer"].Value = txtWebServer.Text;

        cmd.Parameters.Add("@MemberID", SqlDbType.BigInt);
        cmd.Parameters["@MemberID"].Direction = ParameterDirection.Output;

        cmd.ExecuteNonQuery();        
        con.Close();

 

    }

now you can debugg the code.Run the code and insert each field values.

A simple registration form

A Simple registration form

Post Comment: