Monday 26 September 2011

Simple Code Of Registration

Step 1. Make Table
Step 2. Make Store Procedure like this:-

ALTER procedure [dbo].[regis]
@name nvarchar(34),
@email nvarchar(45),
@password nvarchar(34),
@verify_password nvarchar(34),
@address nvarchar(78),
@phone nvarchar(23),
@state nvarchar(34),
@country nvarchar(23)
as
begin
insert into registration values(@name,@email,@password,@verify_password,@address,@phone,@state,@country);
end

Step 3. Take a Class library and write this code:-

public class connection
{
public bool save_data(string fname, string email, string password1, string verify_password, string address, string phone, string state, string country)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["con"].ToString());
        SqlCommand cmd = new SqlCommand("regis", con);
        cmd.Connection = con;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@name", fname);
        cmd.Parameters.AddWithValue("@email", email);
        cmd.Parameters.AddWithValue("@password",FormsAuthentication.HashPasswordForStoringInConfigFile ( password1,"Md5"));
        cmd.Parameters.AddWithValue("@verify_password",verify_password);
        cmd.Parameters.AddWithValue("@address", address);
        cmd.Parameters.AddWithValue("@phone", phone);
        cmd.Parameters.AddWithValue("@state", state);
        cmd.Parameters.AddWithValue("@country", country);
        con.Open();
        int i = cmd.ExecuteNonQuery();
        con.Close();
        if (i > 0)
            return true;
        return false;

    }
}

Step 4. Call this function on Registration button like this:-

protected void Registration_Click(object sender, EventArgs e)
    {
        connection ur = new connection();
        bool check = ur.save_data(Tname.Text.Trim(),Temail.Text.Trim(),Tpassword.Text.Trim(),Tverifypassword.Text.Trim(),
Taddress.Text.Trim(),Tphone.Text.Trim(),Tstate.Text.Trim(),Dcountry.SelectedItem.Text );
        if (check == true)
        {
            Response.Write("Congrachulations! you have succesfully registered");
        }
        else
        {
            Response.Write("Please fill information correctly");
        }
    }

No comments:

Post a Comment