Sir m inserting data to database using store proc but it is showing some error...pls help..thanks in advance
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
Error Msg
Object reference not set to an instance of an object.
CodeBehind
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();
}
}