protected void bindANTH() { string yrmo = ddlYrmo.SelectedItem.Text; DataSet ds1 = new DataSet(); ds1 = ReconDAL.getUnmatch(yrmo); if (ds1.Tables["ANTHDATA"].Rows.Count > 0) { anthdiv.Visible = true; detailDiv.Visible = true; grdvAnth.DataSource = ds1.Tables["ANTHDATA"]; grdvAnth.DataBind(); } }
protected void bindHTH() { string yrmo = ddlYrmo.SelectedItem.Text; DataSet ds1 = null; ds1 = ReconDAL.getUnmatch(yrmo); if (ds1.Tables["HTHDATA"].Rows.Count > 0) { hthDiv.Visible = true; detailDiv.Visible = true; grdvHTH.DataSource = ds1.Tables["HTHDATA"]; grdvHTH.DataBind(); } }
private void SortGridView(string sortExpression, string direction, string source) { // You can cache the DataTable for improving performance string yrmo = ddlYrmo.SelectedItem.Text; switch (source) { case "INTL": DataTable dt = ReconDAL.GetIntlReconData(yrmo).Tables[0]; DataView dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvResult.DataSource = dv; grdvResult.DataBind(); break; case "INTL_HTH": DataSet ds1 = new DataSet(); ds1 = ReconDAL.getUnmatch(yrmo); if (ds1.Tables["HTHDATA"].Rows.Count > 0) { DataTable dt1 = ds1.Tables["HTHDATA"]; DataView dv1 = new DataView(dt1); dv1.Sort = sortExpression + direction; grdvHTH.DataSource = dv1; grdvHTH.DataBind(); } break; case "INTL_ANTH": DataSet ds2 = new DataSet(); ds2 = ReconDAL.getUnmatch(yrmo); if (ds2.Tables["ANTHDATA"].Rows.Count > 0) { DataTable dt2 = ds2.Tables["ANTHDATA"]; DataView dv2 = new DataView(dt2); dv2.Sort = sortExpression + direction; grdvAnth.DataSource = dv2; grdvAnth.DataBind(); } break; } }