private void searchCustomer(string q) { DataTable data = getService.searchDataWithFilter(app.objects["customers"], q, "CONVERT(VARCHAR(10), created_date, 111) BETWEEN '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'"); if (data.Rows.Count > 0) { customerGridView.DataSource = data; } }
private void searchVouchers(string q) { DataTable data = getService.searchDataWithFilter(app.objects["vouchers"], q, "CONVERT(VARCHAR(10), transaction_date , 111) BETWEEN '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'"); if (data.Rows.Count > 0) { vouchersGridView.DataSource = data; } else { vouchersGridView.DataSource = null; } }