/// <summary> /// 綁定GirdView /// </summary> /// <param name="pageIndex"></param> private void BindGridView(int pageIndex) { Js.BLL.Sys.SysLabelNoDb dal = new Js.BLL.Sys.SysLabelNoDb(); int RecordCount, PageCount; dtData = dal.SelectTable(FormID, pageIndex, strWhere, PageSize, "", out PageCount, out RecordCount).Tables[0]; if (CurrentPage == 0) CurrentPage = PageCount; if (RecordCount != 0) { this.btnLast.Enabled = true; this.btnFirst.Enabled = true; this.btnToPage.Enabled = true; if (CurrentPage > 1) this.btnPre.Enabled = true; else this.btnPre.Enabled = false; if (CurrentPage < PageCount) this.btnNext.Enabled = true; else this.btnNext.Enabled = false; lblCurrentPage.Visible = true; lblCurrentPage.Text = "共 [" + RecordCount.ToString() + "] 筆記錄 第 [" + CurrentPage.ToString() + "] 頁 共 [" + PageCount.ToString() + "] 頁"; } else { this.btnFirst.Enabled = false; this.btnPre.Enabled = false; this.btnNext.Enabled = false; this.btnLast.Enabled = false; this.btnToPage.Enabled = false; lblCurrentPage.Visible = false; } this.dataGridView1.DataSource = dtData.DefaultView; }
/// <summary> /// 綁定查詢 /// </summary> private void dataSearch() { Js.BLL.Sys.SysLabelNoDb dal = new Js.BLL.Sys.SysLabelNoDb(); DataTable dt = dal.SearchTable(FormID, false).Tables[0]; this.cmbField.DataSource = dt; this.cmbField.DisplayMember = "FieldCName"; this.cmbField.ValueMember = "FieldName"; }