public System.Data.DataTable GetData(PRPDCAP.CAPStatus Status) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Status", Status) }; return(Execute.RunSP_DataTable(Connection, "SPGET_PRPDCAP_By_Status", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public System.Data.DataTable GetData(PRPDCAP.CAPStatus Status1, PRPDCAP.CAPStatus Status2) { tblPRPDCAPTableAdapter da = new tblPRPDCAPTableAdapter(); da.Connection = Connection; try { return(da.GetDataByApprove(Convert.ToInt32(Status1), Convert.ToInt32(Status2))); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { da.Dispose(); } }