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;
}
