public DataSet GetSingleProductsDataSet() { objSQLdb = new SQLDB(); SqlParameter[] param = new SqlParameter[1]; DataSet ds = new DataSet(); try { param[0] = objSQLdb.CreateParameter("@sCompCode", DbType.String, CommonData.CompanyCode, ParameterDirection.Input); ds = objSQLdb.ExecuteDataSet("SingleProductMasAll_Get", CommandType.StoredProcedure, param); } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { objSQLdb = null; } return(ds); }
public DataSet UserBranchList(string strCompanCode) { objSQLdb = new SQLDB(); SqlParameter[] param = new SqlParameter[1]; DataSet ds = new DataSet(); try { param[0] = objSQLdb.CreateParameter("@sCompCode", DbType.String, strCompanCode, ParameterDirection.Input); ds = objSQLdb.ExecuteDataSet("UserBranchMaster_Get", CommandType.StoredProcedure, param); } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { param = null; objSQLdb = null; } return(ds); }