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(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_EXPENSETRANSACTIONResult> lst = new List <USP_VP_GET_EXPENSETRANSACTIONResult>(); lst = MyDa.USP_VP_GET_EXPENSETRANSACTION(TM02_PARTYID, null, dtpFromDate.Value, dtpTodate.Value, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lst; dgDisplayData.Columns["T013_EXPENSETRANSACATIONID"].Visible = false; dgDisplayData.Columns["TM05_EXPENSEID"].Visible = false; dgDisplayData.Columns["T013_DETAILS"].Visible = false; dgDisplayData.Columns["TM_COMPAYID"].Visible = false; dgDisplayData.Columns["TM05_EXPENSE"].HeaderText = "Name"; dgDisplayData.Columns["T013_DATE"].HeaderText = "Date"; dgDisplayData.Columns["T013_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy"; dgDisplayData.Columns["T013_AMOUNT"].HeaderText = "Amount"; dgDisplayData.Columns["TM05_EXPENSE"].DisplayIndex = 0; dgDisplayData.Columns["T013_DATE"].DisplayIndex = 1; dgDisplayData.Columns["T013_AMOUNT"].DisplayIndex = 2; 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; dgDisplayData.Columns["TM05_EXPENSE"].Width = 350; }