private void BindCity(Int64 UserIdno)
        {
            BindDropdownDAL obj    = new BindDropdownDAL();
            var             ToCity = obj.BindCityUserWise(UserIdno);

            DdlfromcityHead.DataSource     = ToCity;
            DdlfromcityHead.DataTextField  = "CityName";
            DdlfromcityHead.DataValueField = "CityIdno";
            DdlfromcityHead.DataBind();
            obj = null;
            DdlfromcityHead.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
        }
        private void BindCity()
        {
            BindDropdownDAL obj    = new BindDropdownDAL();
            var             ToFrom = obj.BindLocFrom();

            DdlfromcityHead.DataSource     = ToFrom;
            DdlfromcityHead.DataTextField  = "City_Name";
            DdlfromcityHead.DataValueField = "City_Idno";
            DdlfromcityHead.DataBind();
            obj = null;
            DdlfromcityHead.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
        }
        protected void DdlfromcityHead_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                ChlnBookingCrsngDAL objGR = new ChlnBookingCrsngDAL();
                Int64 MaxCRNo             = 0;
                MaxCRNo           = objGR.MaxNo(Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToInt32(Convert.ToString(DdlfromcityHead.SelectedValue) == "" ? 0 : Convert.ToInt32(DdlfromcityHead.SelectedValue)), ApplicationFunction.ConnectionString());
                txtchallanNo.Text = Convert.ToString(MaxCRNo);
                DdlfromcityHead.Focus(); txtchallanNo.SelectText();

                return;
            }
            catch (Exception Ex)
            {
            }
        }