C# (CSharp) exaCore clsSQL.GetDataSet Examples

Example #1

        public static DataTable GetAllLabTestPrice()
        {
            clsSQL sql = new clsSQL();

            return(sql.GetDataSet("Select labtest.labTestPK,labTest.labTestCode,labTest.labTestName, tbllabtestprice.* from tblLabTest labtest left join tblLabTestPrice  on labtest.labTestPK=tblLabTestPrice.labTestPK").Tables[0]);
        }

Example #2

File: LabTest.cs Project: abdojobs/medipro

 public static DataTable GetAllLabTest()
 { 
     clsSQL sql = new clsSQL();
     return sql.GetDataSet("select * from tblLabTest").Tables[0];
 }