public DataSet GetEmailDetails(EmailSchema ObjEmailSchema) { SqlConnection objConn = SQLHelper.OpenConnection(); try { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ApplicationID", SqlDbType.VarChar); param[0].Value = ObjEmailSchema.ApplicationID; using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetEmailIDDetails", param)) { return(ds); } } catch (Exception ex) { return(null); } finally { SQLHelper.CloseConnection(objConn); } }
public DataSet GetEmailDetails(EmailSchema ObjEmailSchema) { try { ds = ObjEmailDAL.GetEmailDetails(ObjEmailSchema); return(ds); } catch (Exception e) { return(null); } finally { ds = null; } }