public void loadData(int p) { try { Common.NhaCungCapTableAdapter.Connection = Common.CTDatHangTableAdapter.Connection = Common.NhanVienTableAdapter.Connection = Common.MatHangTableAdapter.Connection = Common.connection; Common.NhaCungCapTableAdapter.Fill(Common.NhaCungCapDataTable); Common.NhanVienTableAdapter.Fill(Common.NhanVienDataTable); Common.MatHangTableAdapter.Fill(Common.MatHangDataTable); Common.CTDatHangTableAdapter.Fill(Common.CTDatHangDataTable); page = new Paging(Common.connection, "DatHang", "DatHangId desc"); QLVTDataSet.DatHangDataTable khos = new QLVTDataSet.DatHangDataTable(); DataTable dataTable = page.getPage(p); if (dataTable != null) { khos.Merge(dataTable); } dgContent.ItemsSource = khos; tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSearch_Click(object sender, RoutedEventArgs e) { page = new Paging(Common.connection, "DatHang where DatHangId = '" + txbSearch.Text + "'", "DatHangId desc"); QLVTDataSet.DatHangDataTable khos = new QLVTDataSet.DatHangDataTable(); DataTable dataTable = page.getPage(0); if (dataTable != null) { khos.Merge(dataTable); } dgContent.ItemsSource = khos; tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1); }