Hi.
Indresh
It was Commented By Mistake (Soory )
Here Is the Full Code
var connectionString = ConfigurationManager.ConnectionStrings["Constr"].ConnectionString;
SqlConnection con = new SqlConnection();
con = new SqlConnection(connectionString);
{
using (SqlCommand cmd = new SqlCommand("select distinct u.Class,t2.January,t2.February,t2.March,t2.April,t2.May,t2.June,t2.July,t2.August,t2.September,t2.October,t2.November,t2.December from Tbl_ClassSectionMain u left join Tbl_Finance_FeeStructure t2 on u.Class=t2.Class ", 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.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["Class"].ToString();
gridviewfeeStructure.Columns[2].HeaderText = "Class";
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 (Exception)
{
}
}
}
}
}
}
Gird Is not Showing When AllowuserToAddRow=Fasle;