private void Usp_BindMedicalShopGrid() { try { DataTable dt = new DataTable(); BLMedicalShop objBL = new BLMedicalShop(); dt = objBL.BindFullGrid(); if (dt.Rows.Count > 0) { dgvMedicalShop.DataSource = dt; } else { dgvMedicalShop.DataSource = null; } dgvMedicalShop.Refresh(); dgvMedicalShop.Show(); { dgvMedicalShop.DataSource = dt; dgvMedicalShop.Columns[0].HeaderCell.Value = "Medical Name"; //dgvMedicalShop.Columns[1].HeaderCell.Value = "Contact Number"; dgvMedicalShop.Columns[1].HeaderCell.Value = "Country Name"; dgvMedicalShop.Columns[2].HeaderCell.Value = "State Name"; dgvMedicalShop.Columns[3].HeaderCell.Value = "City Name"; dgvMedicalShop.Columns[4].HeaderCell.Value = "Area"; dgvMedicalShop.Columns[5].HeaderCell.Value = "Address"; dgvMedicalShop.Columns[6].HeaderCell.Value = "Owner Name"; dgvMedicalShop.Columns[7].HeaderCell.Value = "Contact Number"; dgvMedicalShop.Columns[8].HeaderCell.Value = "Shop Type"; dgvMedicalShop.Columns[9].HeaderCell.Value = "IsActive"; dgvMedicalShop.Columns[9].Visible = false; dgvMedicalShop.Columns[10].HeaderCell.Value = "IsDelete"; dgvMedicalShop.Columns[10].Visible = false; dgvMedicalShop.AllowUserToAddRows = false; dgvMedicalShop.AllowUserToDeleteRows = false; dgvMedicalShop.Refresh(); dgvMedicalShop.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }