changing datagridview header text

Question

hey guys i have a class that i defined variables like that

public string cekilis_no{ get; set; }
public string cekilis_tarihi { get; set; }
public string sayi_bir { get; set; }
public string n_iki { get; set; }
public string n_uc { get; set; }
public string n_dort { get; set; }
public string n_bes { get; set; }
public string n_alti { get; set; }
and i give their values with the datas from my database with SqlDataReader and i show them by datagridview in my form..but my problem is that the headers shown as i wrote in my class like n_bes,n_alti, like here..how i can show it like Number 5 or Number 6 ??

Crish · Answer

Hi You can refer this code to solve the issue of changing datagridview header text. Private Sub Button9_Click( ByVal sender As Object  _ ByVal args As EventArgs) Handles Button9.Click For Each column As DataGridViewColumn _ In dataGridView.Columns column.HeaderText = String .Concat( Column   _ column.Index.ToString) Next End Sub

Madhu K · Answer

Yes the query you used should change the Column header from the backend itself.

Erdinc Kolukisa · Answer

i changed it a little bit like that cmn.HeaderText = Kolon +count.ToString(); and i tried something like that also dataGridView1.Columns[1].HeaderText = Çekilis Tarihi; it gives the result as i wish but i thought i can rename columns while i am selecting in Sql like below Select id  cekilis_no[ÇekiliS No]  cekilis_tarihi[Çekilis Tarihi]  num1[Birinci Say]  num2[kinci Say]  num3[nc Say]  num4[Drdnc Say]  num5[Beinci Say]  num6[Altnc Say] From NumaraBilgileri

Madhu K · Answer

The code in previous post has nothing to do with numbers and string. The column header text will be displayed starting from 1 to total number of columns. Are you missing anything?

Erdinc Kolukisa · Answer

thanks for the reply..yeah it works for the columns which has numbers in it but i have two more columns like Cekilme TarihiCekilis No..so how i can rename them or can i rename them while getting from database ?

Madhu K · Answer

Following code snippet gives you the column names starting from 1. You can change it according to requirement. int count = 1; foreach (DataGridViewColumn cmn in dataGridView1.Columns) { cmn.HeaderText = count.ToString(); count++; }