void PopualteData() { string sType = ""; if (!string.IsNullOrEmpty(Convert.ToString(cmbType.Text.Trim()))) { sType = cmbType.SelectedItem.ToString(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_ACCOUNTResult> lstCategory = new List <USP_VP_GET_ACCOUNTResult>(); //lstCategory = MyDa.USP_VP_GET_ACCOUNT("", txtName.Text.Trim(), "", sType, "", txtMobileNo.Text.Trim(), Datalayer.iT001_COMPANYID.ToString()).ToList(); lstCategory = MyDa.USP_VP_GET_ACCOUNT("", "", "", "", "", "", Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lstCategory; dgDisplayData.Columns["T001_ACCOUNTID"].Visible = false; dgDisplayData.Columns["T001_CONTACT_PERSON"].Visible = false; dgDisplayData.Columns["T001_ADDRESS1"].Visible = false; dgDisplayData.Columns["T001_ADDRESS2"].Visible = false; dgDisplayData.Columns["TM_STATEID"].Visible = false; dgDisplayData.Columns["TM_STATEID1"].Visible = false; dgDisplayData.Columns["TM_STATE_NAME"].Visible = false; dgDisplayData.Columns["TM_STATE_CODE"].Visible = false; dgDisplayData.Columns["T001_MOBILE2"].Visible = false; dgDisplayData.Columns["T001_PHONE"].Visible = false; dgDisplayData.Columns["T001_EMAIL"].Visible = false; dgDisplayData.Columns["T001_OPENINGBAL"].Visible = false; dgDisplayData.Columns["T001_GSTTIN"].Visible = false; dgDisplayData.Columns["T001_TIN"].Visible = false; dgDisplayData.Columns["T001_DISCOUNT"].Visible = false; dgDisplayData.Columns["TM_COMPAYID"].Visible = false; dgDisplayData.Columns["T001_TYPE"].Visible = false; dgDisplayData.Columns["T001_NAME"].HeaderText = "Name"; dgDisplayData.Columns["T001_MOBILE1"].HeaderText = "Mobile No"; dgDisplayData.Columns["T001_CITY"].Visible = false; dgDisplayData.Columns["T001_NAME"].DisplayIndex = 0; dgDisplayData.Columns["T001_MOBILE1"].DisplayIndex = 1; dgDisplayData.AllowUserToResizeColumns = false; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; //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; }