Inserting Data using storeproc..

ALTER procedure [dbo].[Registration]

	@Profile_Name varchar(50),
	@Gender varchar(10),
	@First_Name varchar(50),
	@Last_Name varchar(50),
	@Email varchar(50),
	@Password varchar(50),
	@Mobile_No varchar(20),
	@Region varchar(50) ,
	@Caste varchar(50) ,
	@DOB varchar(50) ,
	@Age int ,
	@Mother_Tounge varchar(50) ,
	@Edu_Id int ,
	@Occ_Id int,
	@Height varchar(10),
	@Weight varchar(15),
	@Country_Id int,
	@State_Id int,
	@City_Id int ,
	@Income  varchar(50),
	@Body_Type  varchar(30) ,
	@Complexion varchar(50),
	@Maritial_Status varchar(30),
	@Religion varchar(50),
	@Address varchar(500),
	@Pincode varchar(15),
	@About_Me varchar(1000),
	@About_Match varchar(1000),
	@About_Family varchar(1000) ,
	@Father varchar(50),
	@Mother varchar(50),
	@No_Of_Bro int ,
	@No_of_Married_Bro int,
	@No_Of_Sis int,
	@No_of_Married_Sis int,
	@Place_of_birth varchar(50),
	@Time_of_birth varchar(50) ,
	@Moon_Rashi varchar(50),
	@Manglik varchar(50),
	@Gotra varchar(50),
	@Nakshtra varchar(50),
	@Guna varchar(50),
	@Youni varchar(50),
	@Nadi varchar(50),
	@Drinking varchar(50),
	@Smoking varchar(50),
	@Eating varchar(50),
	@Image_Name varchar(50),
	@Image_Path nvarchar(100),
	@Profile_Created_By varchar(50),
	@IsActive bit
as
begin
Declare @U_ID varchar(50)
Declare @ID varchar(10)

set @ID=(select MAX(Reg_ID)from tbl_Registration)+1
set @U_ID = 'INV'+''+ @ID

insert into tbl_Registration(
	Unique_Id,
	Profile_Name,
	Gender,
	First_Name,
	Last_Name,
	Email,
	[Password],
	Mobile_No,
	Region,
	Caste,
	DOB,
	Age,
	Mother_Tounge,
	Edu_Id ,
	Occ_Id ,
	Height ,
	[Weight],
	Country_Id ,
	State_Id ,
	City_Id  ,
	Income ,
	Body_Type ,
	Complexion,
	Maritial_Status ,
	Religion,
	[Address] ,
	Pincode ,
	About_Me,
	About_Match,
	About_Family  ,
	Father,
	Mother,
	No_Of_Bro,
	No_of_Married_Bro,
	No_Of_Sis ,
	No_of_Married_Sis,
	Place_of_birth,
	Time_of_birth ,
	Moon_Rashi,
	Manglik,
	Gotra,
	Nakshtra,
	Guna ,
	Youni,
	Nadi,
	Drinking ,
	Smoking,
	Eating,
	Image_Name ,
	Image_Path,
	Profile_Created_By,
	IsActive 
 )Values(
	@U_ID,
	@Profile_Name,
	@Gender,
	@First_Name,
	@Last_Name,
	@Email,
	@Password,
	@Mobile_No,
	@Region,
	@Caste,
	@DOB,
	@Age,
	@Mother_Tounge,
	@Edu_Id ,
	@Occ_Id ,
	@Height ,
	@Weight,
	@Country_Id ,
	@State_Id ,
	@City_Id  ,
	@Income ,
	@Body_Type ,
	@Complexion,
	@Maritial_Status ,
	@Religion,
	@Address ,
	@Pincode ,
	@About_Me,
	@About_Match,
	@About_Family  ,
	@Father,
	@Mother,
	@No_Of_Bro,
	@No_of_Married_Bro,
	@No_Of_Sis ,
	@No_of_Married_Sis,
	@Place_of_birth,
	@Time_of_birth ,
	@Moon_Rashi,
	@Manglik,
	@Gotra,
	@Nakshtra,
	@Guna ,
	@Youni,
	@Nadi,
	@Drinking ,
	@Smoking,
	@Eating,
	@Image_Name ,
	@Image_Path,
	@Profile_Created_By,
	@IsActive 
 
  )
end

protected void btnsubmit_Click(object sender, EventArgs e)
   {
       try
       {
           string father = " ";
           if (chklfather.Checked)
           {
               father = "Yes";
           }
           else
           {
               father = "No";
           }


           string mother = " ";
           if (chklmother.Checked)
           {
               mother = "Yes";
           }
           else
           {
               mother = "No";
           }


           string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
           FileUpload1.SaveAs(Server.MapPath("~/ProfileImages/" + filename));

           SqlConnection con = new SqlConnection(str);
           SqlCommand cmdins = new SqlCommand("Registration", con);
           cmdins.CommandType = CommandType.StoredProcedure;

           cmdins.Parameters.AddWithValue("@Profile_Name", txtprofilename.Text);
           cmdins.Parameters.AddWithValue("@Gender", rbtnlgender.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@First_Name", txtfirstname.Text);
           cmdins.Parameters.AddWithValue("@Last_Name", txtlastname.Text);
           cmdins.Parameters.AddWithValue("@Email", txtemail.Text);
           cmdins.Parameters.AddWithValue("@Password", txtpassword.Text);
           cmdins.Parameters.AddWithValue("@Mobile_No", txtmobno.Text);
           cmdins.Parameters.AddWithValue("@Region", ddlregion.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Caste", ddlcaste.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@DOB", (ddlday.SelectedItem.Text +' '+ ddlmonth.SelectedItem.Text +' '+ ddlyear.SelectedItem.Text));
           cmdins.Parameters.AddWithValue("@Age", Convert.ToInt32(txtage.Text));
           cmdins.Parameters.AddWithValue("@Mother_Tounge", txtmonthertounge.Text);
           cmdins.Parameters.AddWithValue("@Edu_Id", Convert.ToInt32(ddleducation.SelectedItem.Value));
           cmdins.Parameters.AddWithValue("@Occ_Id", Convert.ToInt32(ddloccupation.SelectedItem.Value));
           cmdins.Parameters.AddWithValue("@Height", ddlheight.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Weight", ddlweight.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Country_Id", Convert.ToInt32(ddlcountry.SelectedItem.Value));
           cmdins.Parameters.AddWithValue("@State_Id", Convert.ToInt32(ddlstate.SelectedItem.Value));
           cmdins.Parameters.AddWithValue("@City_Id", Convert.ToInt32(ddlcity.SelectedItem.Value));
           cmdins.Parameters.AddWithValue("@Income", ddlincome.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Body_Type", ddlbodytype.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Complexion", ddlcomplexion.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Maritial_Status", ddlmaritalstatus.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Religion", ddlreligion.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Address", txtaddress.Text);
           cmdins.Parameters.AddWithValue("@Pincode", txtpincode.Text);
           cmdins.Parameters.AddWithValue("@About_Me", txtaboutme.Text);
           cmdins.Parameters.AddWithValue("@About_Match", txtaboutmatch.Text);
           cmdins.Parameters.AddWithValue("@About_Family" , txtaboutfamily.Text);
           cmdins.Parameters.AddWithValue("@Father", father);
           cmdins.Parameters.AddWithValue("@Mother", mother);
           cmdins.Parameters.AddWithValue("@No_Of_Bro", ddlbro.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@No_of_Married_Bro", ddlmarriedbro.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@No_Of_Sis", ddlsis.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@No_of_Married_Sis", ddlmarriedsis.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Place_of_birth", txtplaceofbirth.Text);
           cmdins.Parameters.AddWithValue("@Time_of_birth", (ddlhours.SelectedItem.Text +' '+ ddlmins.SelectedItem.Text));
           cmdins.Parameters.AddWithValue("@Moon_Rashi", ddlmoonraashi.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Manglik", rbtnlmaanglik.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Gotra", ddlgotra.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Nakshtra", ddlnakshtra.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Guna", ddlguna.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Youni", ddlyouni.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Nadi", ddlnadi.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Drinking", rbtnldrink.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Smoking", rbtnlsmoke.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Eating", rbtnleat.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Profile_Created_By", ddlprofilecreatedby.SelectedItem.Text);
           cmdins.Parameters.AddWithValue("@Image_Name", filename);
           cmdins.Parameters.AddWithValue("@Image_Path", "~/ProfileImages/" + filename);
           cmdins.Parameters.AddWithValue("@IsActive", 1);


           con.Open();
           cmdins.ExecuteNonQuery();
           lblmsg.Text = "Registered Successfully";
           con.Close();
       }

       catch (Exception ex)
       {
           ex.ToString();
       }

   }