예제 #1
0
        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;
            }
        }
예제 #2
0
 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;
     }
 }