Hi droiddeve,
Here your code working fine.So please refer the below code.
C#
private void GetData()
{
SqlConnection con = new SqlConnection(conString);
using (SqlCommand cmd = new SqlCommand("SELECT * FROM Customers", 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.ColumnCount = 13;
gridviewfeeStructure.AllowUserToAddRows = false;
gridviewfeeStructure.AutoGenerateColumns = false;
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
// DataGridViewCell Edit = gridviewfeeStructure.Rows[0].Cells[0];
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "DELETE";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "DELETE";
gridviewfeeStructure.Columns.Insert(0, Editlink);
gridviewfeeStructure.Columns[0].Width = 80;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
gridviewfeeStructure.Columns.Insert(1, chk);
chk.HeaderText = "Select ";
chk.Name = "chk";
gridviewfeeStructure.Columns[1].Width = 80;
gridviewfeeStructure.Columns[2].DataPropertyName = dt.Columns["Name"].ToString();
gridviewfeeStructure.Columns[2].HeaderText = "Name";
gridviewfeeStructure.Columns[2].ReadOnly = true;
gridviewfeeStructure.Columns[3].HeaderText = "JANUARY";
gridviewfeeStructure.Columns[4].HeaderText = "FEBRUARY";
gridviewfeeStructure.Columns[5].HeaderText = "MARCH";
gridviewfeeStructure.Columns[6].HeaderText = "APRIL";
gridviewfeeStructure.Columns[7].HeaderText = "MAY";
gridviewfeeStructure.Columns[8].HeaderText = "JUNE";
gridviewfeeStructure.Columns[9].HeaderText = "JULY";
gridviewfeeStructure.Columns[10].HeaderText = "AUGUST";
gridviewfeeStructure.Columns[11].HeaderText = "SEPTEMBER";
gridviewfeeStructure.Columns[12].HeaderText = "OCTOBER";
gridviewfeeStructure.Columns[13].HeaderText = "NOVEMBER";
gridviewfeeStructure.Columns[14].HeaderText = "DECEMBER";
gridviewfeeStructure.DataSource = dt;
gridviewfeeStructure.Refresh();
gridviewfeeStructure.Parent.Refresh();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
}
}
Screenshot