public DataTable Employee_details(ClsEmployee ObjClsEmployee) { DataTable objDataTable = new DataTable(); try { DataSet objDataset; objDBLibrary = new DBCon(); objDBLibrary._stringCommandText = "sp_employee_master"; objDBLibrary._CommandType = CommandType.StoredProcedure; objSqlParameter = new SqlParameter[9]; objSqlParameter[0] = new SqlParameter("@employee_id", SqlDbType.Int); objSqlParameter[0].Value = ObjClsEmployee.employee_id; objSqlParameter[1] = new SqlParameter("@employee_name", SqlDbType.VarChar, 50); objSqlParameter[1].Value = ObjClsEmployee.employee_name; objSqlParameter[2] = new SqlParameter("@father_name", SqlDbType.VarChar, 50); objSqlParameter[2].Value = ObjClsEmployee.father_name; objSqlParameter[3] = new SqlParameter("@mother_name", SqlDbType.VarChar, 50); objSqlParameter[3].Value = ObjClsEmployee.mother_name; objSqlParameter[4] = new SqlParameter("@DOB", SqlDbType.Date); objSqlParameter[4].Value = ObjClsEmployee.DOB; objSqlParameter[5] = new SqlParameter("@gender", SqlDbType.Int); objSqlParameter[5].Value = ObjClsEmployee.gender; objSqlParameter[6] = new SqlParameter("@marital_status", SqlDbType.Int); objSqlParameter[6].Value = ObjClsEmployee.marital_status; objSqlParameter[7] = new SqlParameter("@Address", SqlDbType.VarChar, 2000); objSqlParameter[7].Value = ObjClsEmployee.Address; objSqlParameter[8] = new SqlParameter("@Dml_Indicator", SqlDbType.VarChar, 10); objSqlParameter[8].Value = ObjClsEmployee.Dml_Indicator; objDataset = objDBLibrary.GetDataAdapter(objSqlParameter); if (objDataset != null && objDataset.Tables[0].Rows.Count > 0) { return(objDataset.Tables[0]); } } catch (Exception objException) { Exception objErr = objException.GetBaseException(); } return(objDataTable); }