i retrieved the column name from the data base to the DGV
i retrieved the column name from the data base to the data grid view.
design as follows at run time in data grid view ;
Date Session colname colname colname colname colname
7/1/12 1
7/1/12 2
7/1/12 3
7/1/12 4
7/1/12 5
in the run time in the column name faculty name is retrieved from the data base.that is working fine.
Here Total Column is 7.
Data base record as follows;
date session faculty name
7/1/12 1 G Sekar
7/1/12 2 R suresh
7/1/12 3 V Raju
7/1/12 4 m Murali
7/1/12 5 R Joshi
suppose when i add one record in the data base total record as follows;
date session faculty name
7/1/12 1 G Sekar
7/1/12 2 R suresh
7/1/12 3 V Raju
7/1/12 4 m Murali
7/1/12 5 R Joshi
8/1/12 1 R Ram
BUTTON CODE AS FOLLOWS;
con.Open();
SqlCommand cmd = new SqlCommand("select Faculty_Name from Tb_SCH_Faculty_Details Where Active <> 'D' ", con);
SqlDataReader dr = cmd.ExecuteReader();
int j = 2;
while (dr.Read())
{
datagridView.Columns[j].HeaderText = dr[0].ToString().Trim();
j++;
}
dr.Close();
con.Close();
that time when i click the BUTTON ERROR SHOWS AS FOLLOWS;
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name:
please help me.from the button code please correct it, i tried.