public void FillGrid(string sortExpression = null) { try { DataTable Dt = new DataTable(); Dt = STATE_MASLogicLayer.GetAllSTATE_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); if (sortExpression != null) { DataView dv = Dt.AsDataView(); this.SortDirection = this.SortDirection == "ASC" ? "DESC" : "ASC"; dv.Sort = sortExpression + " " + this.SortDirection; GvStateMaster.DataSource = dv; GvStateMaster.DataBind(); } else { GvStateMaster.DataSource = Dt; GvStateMaster.DataBind(); } // GvStateMaster.DataSource = Dt; // GvStateMaster.DataBind(); } catch (Exception) { throw; } }
protected void TxtBranchState_TextChanged(object sender, EventArgs e) { try { DataTable DtSTATEName = STATE_MASLogicLayer.GetAllSTATE_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); if (TxtBranchState.Text != string.Empty) { DataView Dv = new DataView(DtSTATEName); Dv.RowFilter = "STATE_NAME='" + TxtBranchState.Text.Trim() + "'"; DataTable DtView = Dv.ToTable(); if (DtView.Rows.Count > 0) { TxtBranchStateNo.Text = DtView.Rows[0]["STATE_NO"].ToString(); } } } catch (Exception) { throw; } }