changing datagridview header text

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

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

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

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?

        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++;
            }