using (SqlCommand cmd = new SqlCommand("select distinct Class from Tbl_ClassSectionMain", con))
{
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
try
{
sda.Fill(dt);
gridviewfeeStructure.DataSource = null;
gridviewfeeStructure.Columns.Clear();
gridviewfeeStructure.Rows.Clear();
//gridviewfeeStructure.AllowUserToAddRows = false;// gridviewfeeStructure.ColumnCount = 12;
gridviewfeeStructure.AutoGenerateColumns = false;
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
DataGridViewCell Edit = gridviewfeeStructure.Rows[0].Cells[0];
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = " Edit OR Delete ";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = " Edit OR Delete";
gridviewfeeStructure.Columns.Insert(0, Editlink);
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
gridviewfeeStructure.Columns.Insert(1, chk);
chk.HeaderText = "Click To Add Class ";
chk.Name = "chk";
gridviewfeeStructure.Columns[2].DataPropertyName = dt.Columns["Class"].ToString();
gridviewfeeStructure.Columns[2].HeaderText = "Class";
gridviewfeeStructure.DataSource = dt;
gridviewfeeStructure.Refresh();