void PopualteData()
        {
            string TM02_PARTYID  = "";
            int    iTM02_PARTYID = 0;

            if (!string.IsNullOrEmpty(cmbName.Text.Trim()))
            {
                int.TryParse(cmbName.SelectedValue.ToString(), out iTM02_PARTYID);
            }

            if (iTM02_PARTYID > 0)
            {
                TM02_PARTYID = iTM02_PARTYID.ToString();
            }

            decimal dTotal = 0;

            MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
            List <USP_VP_GETCHALLENLISTResult> lst = new List <USP_VP_GETCHALLENLISTResult>();

            lst = MyDa.USP_VP_GETCHALLENLIST(null, TM02_PARTYID, null, dtpFromDate.Value, dtpTodate.Value, Datalayer.iT001_COMPANYID.ToString()).ToList();
            dgDisplayData.DataSource = lst;

            for (int i = 0; i < lst.Count; i++)
            {
                dTotal = dTotal + lst[i].T012_NETAMOUNT.Value;
            }

            lblNetTotal.Text = dTotal.ToString();
            dgDisplayData.Columns["T012_CHALLENID"].Visible      = false;
            dgDisplayData.Columns["T001_ACCOUNTID"].Visible      = false;
            dgDisplayData.Columns["T012_DETAILS"].Visible        = false;
            dgDisplayData.Columns["T012_TOTAL_AMT"].Visible      = false;
            dgDisplayData.Columns["T012_DISCOUNT"].Visible       = false;
            dgDisplayData.Columns["T012_TAX"].Visible            = false;
            dgDisplayData.Columns["T001_CONTACT_PERSON"].Visible = false;
            dgDisplayData.Columns["T001_MOBILE1"].Visible        = false;



            dgDisplayData.Columns["T001_NAME"].HeaderText       = "Name";
            dgDisplayData.Columns["T012_TRANSPORT1"].HeaderText = "Transport";
            dgDisplayData.Columns["T012_LR1"].HeaderText        = "L.R.No";
            dgDisplayData.Columns["T012_TRANSPORT2"].HeaderText = "Parcel";

            dgDisplayData.Columns["T012_DATE"].HeaderText = "Date";
            dgDisplayData.Columns["T012_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy";
            dgDisplayData.Columns["T012_NO"].HeaderText        = "Invoice No";
            dgDisplayData.Columns["T012_NETAMOUNT"].HeaderText = "Net Amount";

            dgDisplayData.Columns["T001_NAME"].DisplayIndex       = 0;
            dgDisplayData.Columns["T012_DATE"].DisplayIndex       = 1;
            dgDisplayData.Columns["T012_NO"].DisplayIndex         = 2;
            dgDisplayData.Columns["T012_NETAMOUNT"].DisplayIndex  = 3;
            dgDisplayData.Columns["T012_TRANSPORT1"].DisplayIndex = 4;
            dgDisplayData.Columns["T012_LR1"].DisplayIndex        = 5;
            dgDisplayData.Columns["T012_TRANSPORT2"].DisplayIndex = 6;


            this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3);
            dgDisplayData.EnableHeadersVisualStyles = false;
            this.dgDisplayData.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;

            // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White;
            dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            dgDisplayData.ColumnHeadersHeight         = 30;

            dgDisplayData.ColumnHeadersDefaultCellStyle.Font      = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
            dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
        }