Yes, here is my stored procedure:
ALTER PROCEDURE [dbo].[sp_CRUDempDetail]
@empcode int,
@gender nchar(10)=null,
@dob date=null,
@fhname varchar(50)=null,
@Nationality varchar(50)=null,
@marital varchar(30)=null,
@bgroup nchar(10)=null,
@email varchar(50)=null,
@mobno varchar(50)=null,
@altmobno varchar(50)=null,
@corr_add varchar(150)=null,
@corr_city varchar(80)=null,
@corr_state varchar(80)=null,
@corr_pin_code int=null,
@corr_country varchar(80)=null,
@pmt_add varchar(150)=null,
@pmt_city varchar(80)=null,
@pmt_state varchar(80)=null,
@pmt_pin_code int=0,
@pmt_country varchar(80)=null,
@status varchar(50)=null
AS
BEGIN
SET NOCOUNT ON;
IF @status='InsertEmpDetails'
BEGIN
UPDATE tblEmployee SET Gender=@gender,DOB=@dob,Father_Husband_Name=@fhname,Nationality=@Nationality,
Marital_Status=@marital,Blood_Group=@bgroup,Email=@email,Mob_No=@mobno,Alt_Mob_No=@altmobno,Corr_Address=@corr_add,
Corr_City=@corr_city,Corr_Country=@corr_country,Corr_PinCode=@corr_pin_code,Corr_State=@corr_state,Pmt_Address=@pmt_add,
Pmt_City=@pmt_city,Pmt_Country=@pmt_country,Pmt_PinCode=@pmt_pin_code,Pmt_State=@pmt_state
WHERE Emp_Code=@empcode
END
IF @status='SELECT'
BEGIN
SELECT * FROM tblEmployee
END
End
and here is my c# code:
protected void btnSave_Click(object sender, EventArgs e)
{
using (DataClassesDataContext ctx = new DataClassesDataContext())
{
var result = ctx.sp_CRUDempDetail(Convert.ToInt32(lblemp_code.InnerText),rdlGender.SelectedValue,Convert.ToDateTime(txtDOB.Text),txtFHname.Text.ToString(),txtNation.Text.ToString(),rdlmarital.SelectedValue,txtBloodGroup.Text.ToString(),txtemail.Text.ToString(),txtmob.Text.ToString(),txtMob2.Text.ToString(),txtcorAdd1.Text.ToString(),txtcorCity.Text.ToString(),txtcorState.Text.ToString(), Convert.ToInt32(txtcorpin.Text),txtcorcountry.Text.ToString(), txtPmtAdd1.Text.ToString(), txtPmtCity.Text.ToString(), txtPmtState.Text.ToString(), Convert.ToInt32(txtPmtpin.Text), txtPmtcountry.Text.ToString(), "InsertFamilyDetails");
Message("Saved Successfully!");
Clear();
}
}