Mehmet Fatih

Mehmet Fatih

  • 746
  • 905
  • 30.9k

Problem converting last column name to uppercase

Feb 21 2024 7:48 PM

I want to change the headertext of the data I pulled into the datagridview . However, the headertext in the last column interestingly does not change. I couldn't figure out why. What do you think the reason is?

  cmd1 = new OleDbCommand("SELECT okulno,tcno,adisoyadi,dtarihi,cinsiyeti,sinif,velicep,veliev,adres FROM ogrencibilgi order by sinif asc,okulno asc", conn);
  adp1 = new OleDbDataAdapter(cmd1);
  ds = new DataSet();
  adp1.Fill(ds, "ogrencibilgi");
  dataGridView1.DataSource = ds;

   ds.Tables[0].Columns["okulno"].ColumnName = "Okul No";
  ds.Tables[0].Columns["tcno"].ColumnName = "T.C. NO";
  ds.Tables[0].Columns["adisoyadi"].ColumnName = "ADI-SOYADI";
  ds.Tables[0].Columns["dtarihi"].ColumnName = "D. TARIHI";
  ds.Tables[0].Columns["cinsiyeti"].ColumnName = "CINSIYETI";
  ds.Tables[0].Columns["sinif"].ColumnName = "SINIFI";
  ds.Tables[0].Columns["velicep"].ColumnName = "VELI CEP";
  ds.Tables[0].Columns["veliev"].ColumnName = "EV TEL";
  ds.Tables[0].Columns["adres"].ColumnName = "ADRES";
  dataGridView1.DataMember = "ogrencibilgi";    

 


Answers (7)