private void binddata() { string strSQL = "select * from 分组表"; DataTable dt = DBOper.execQueryBySQLText(strSQL); GVAdmin.DataSource = dt; GVAdmin.DataBind(); }
protected void FillAdmin() { using (PTCLEntities db = new PTCLEntities()) { var Admins = db.GetPtclAdmins().ToList(); GVAdmin.DataSource = Admins; GVAdmin.DataBind(); GVAdmin.UseAccessibleHeader = true; if (GVAdmin.Rows.Count > 0) { GVAdmin.HeaderRow.TableSection = TableRowSection.TableHeader; } else { lblAdminmsg.Text = "No Record to Show"; } } }
protected void GridFill() { using (PTCLEntities db = new PTCLEntities()) { var reportData = db.spReportData().ToList(); GVAdmin.DataSource = reportData; GVAdmin.UseAccessibleHeader = true; if (GVAdmin.Rows.Count > 0) { GVAdmin.HeaderRow.TableSection = TableRowSection.TableHeader; lblAdminmsg.Text = ""; } else { ; } GVAdmin.DataBind(); } }
protected void btnSearch_Click(object sender, EventArgs e) { if (ddlAdmins.SelectedValue == "0") { lblAdminmsg.Text = "Please Select Admins"; } if (ddlLocation.SelectedValue == "1") { lblAdminmsg.Text = "Please Select Location"; } using (PTCLEntities db = new PTCLEntities()) { if (ddlAdmins.SelectedItem.Text == null && ddlLocation.SelectedItem.Text == null) { lblAdminmsg.Text = "Please Select both CheckBoxes"; } else { int adminValue = Convert.ToInt32(ddlAdmins.SelectedValue); int LocationValue = Convert.ToInt32(ddlLocation.SelectedValue); var reportData = db.spFilterAdminWithLocation(adminValue, LocationValue).ToList(); GVAdmin.DataSource = reportData; } GVAdmin.DataBind(); GVAdmin.UseAccessibleHeader = true; if (GVAdmin.Rows.Count > 0) { GVAdmin.HeaderRow.TableSection = TableRowSection.TableHeader; lblAdminmsg.Text = ""; } else { lblAdminmsg.Text = "No Record to Show"; } } }