private void LoadCustomerInPage(int page) { if (page < 1) { this.PageNumber = 1; } else if (page > this.TotalPageNumber) { this.PageNumber = this.TotalPageNumber; } else { this.PageNumber = page; } DataGridViewCustomerInfo.ClearSelection(); DataTable dataTable = new DataTable(); if (this.UserName.Equals(AllUsers)) { dataTable = TableCustomerManage.QueryCustomerByPage(this.PageNumber, PageSize); } else { dataTable = TableCustomerManage.QueryCustomerByUserNameAndPage(this.UserName, this.PageNumber, PageSize); } DataGridViewCustomerInfo.DataSource = dataTable; FormatDataGridView(DataGridViewCustomerInfo); LblCurPage.Text = this.PageNumber + "/" + this.TotalPageNumber; }
private void DataGridViewCustomerInfo_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { try { int rowIndex = e.RowIndex; int count = DataGridViewCustomerInfo.SelectedRows.Count; contextMenuStrip1.Items.Clear(); ToolStripMenuItem tsmiAdd = CreateAddCustomerInfoMenuItem(); contextMenuStrip1.Items.Add(tsmiAdd); if (count > 0) { bool contains = DataGridViewCustomerInfo.SelectedRows.Contains(DataGridViewCustomerInfo.Rows[rowIndex]); if (contains) { if (1 == count) { ToolStripMenuItem tsmiEdit = CreateEditCustomerInfoMenuItem(); contextMenuStrip1.Items.Add(tsmiEdit); } ToolStripMenuItem tsmiDelete = CreateDeleteCustomerInfoMenuItem(); contextMenuStrip1.Items.Add(tsmiDelete); } else { DataGridViewCustomerInfo.ClearSelection(); } } ToolStripSeparator tss = new ToolStripSeparator(); contextMenuStrip1.Items.Add(tss); ToolStripMenuItem tsmiRefresh = CreateRefreshCustomerInfoMenuItem(); contextMenuStrip1.Items.Add(tsmiRefresh); } catch (Exception ex) { MessageBox.Show(this, ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }