void PopualteData() { int iPartyID = 0, TM02_MAIN_PRODUCTSIZEID = 0; string sPartyID = "", sTM02_MAIN_PRODUCTSIZEID = ""; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) { int.TryParse(cmbName.SelectedValue.ToString(), out iPartyID); } //if (!string.IsNullOrEmpty(cmbMainItemSize.Text.Trim())) // int.TryParse(cmbMainItemSize.SelectedValue.ToString(), out TM02_MAIN_PRODUCTSIZEID); if (iPartyID > 0) { sPartyID = iPartyID.ToString(); } if (TM02_MAIN_PRODUCTSIZEID > 0) { sTM02_MAIN_PRODUCTSIZEID = TM02_MAIN_PRODUCTSIZEID.ToString(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_PRODUCTITEMResult> lstCategory = new List <USP_VP_GET_PRODUCTITEMResult>(); lstCategory = MyDa.USP_VP_GET_PRODUCTITEM("", sPartyID, null, null, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lstCategory; dgDisplayData.Columns["TM03_PRODUCTITEMID"].Visible = false; //dgDisplayData.Columns["TM02_MAIN_PRODUCTSIZEID"].Visible = false; dgDisplayData.Columns["TM01_MAIN_PRODUCTID"].Visible = false; dgDisplayData.Columns["TM01_PRODUCTID"].Visible = false; dgDisplayData.Columns["TM01_PRODUCTID1"].Visible = false; //dgDisplayData.Columns["TM01_PRODUCTID2"].Visible = false; //dgDisplayData.Columns["TM02_PRODUCTSIZEID"].Visible = false; //dgDisplayData.Columns["TM02_PRODUCTSIZEID1"].Visible = false; dgDisplayData.Columns["TM01_ISSET"].Visible = false; //dgDisplayData.Columns["TM02_PRICE"].Visible = false; dgDisplayData.Columns["TM01_HSNCODE"].Visible = false; //dgDisplayData.Columns["TM01_TAX_RATE"].Visible = false; dgDisplayData.Columns["TM_COMPAYID"].Visible = false; dgDisplayData.Columns["TM_COMPAYID1"].Visible = false; dgDisplayData.Columns["TM01_PRICE"].Visible = false; //dgDisplayData.Columns["TM01_NO"].HeaderText = "No"; dgDisplayData.Columns["TM01_NAME"].HeaderText = "Name"; //dgDisplayData.Columns["TM02_SIZE"].HeaderText = "Size"; dgDisplayData.Columns["TM03_QTY"].HeaderText = "Qty"; //dgDisplayData.Columns["TM01_NO"].DisplayIndex = 0; dgDisplayData.Columns["TM01_NAME"].DisplayIndex = 1; //dgDisplayData.Columns["TM02_SIZE"].DisplayIndex = 2; dgDisplayData.Columns["TM03_QTY"].DisplayIndex = 3; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; // 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; }