public DataSet GetFreightBill(string tsReferenceNo) { IDbDataParameter param1 = this.CreateParameter("@ReferenceNo", tsReferenceNo); return this.GetDataSet("SELECT * FROM FreightBills WHERE ReferenceNo = @ReferenceNo", param1); }