C # Changing column headers in a DataGridView

Question

I have a datagridview in my project that populates from an SQL database with the following code:

public cToDoList(string paramUser, DateTime paramDueDate) { string sqlStat = "SELECT * FROM tblDiary " + "WHERE DiaryUserFor = @User " + "AND DiaryDueDate <= @DueDate;"; SqlCommand sqlCom = new SqlCommand(sqlStat); sqlCom.Parameters.Add("@User", SqlDbType.VarChar); sqlCom.Parameters.Add("@DueDate", SqlDbType.Date); sqlCom.Parameters["@User"].Value = paramUser; sqlCom.Parameters["@DueDate"].Value = paramDueDate.Date; cSqlQuery sqlQ = new cSqlQuery(sqlCom, "table"); this.cTable = sqlQ.cQueryResults; } 

The above code works fine and the datagridview fills up, however the column headers are field names from the SQL database which are not very user friendly.

I tried a couple of things to try changing the default column names, but nothing works. While I tried -

 dataToDoList.Columns[0].Name = "TEST1"; dataToDoList.Columns["DiaryCompletedDate"].Name = "TEST2"; 

But do nothing.

Can someone tell me how to change column header names in datagridview please?

Answer 1

What are the exact columns you need?

Replace the SELECT * with

  SELECT ColumnName AS 'TEST1', ColumnName2 AS 'TEST2' FROM ...etc 

Answer 2

Try DataGridViewColumn.HeaderText and AutoGenerateColumns (MSDN)

Hope this works for you.

Answer 3

You want Column.HeaderText , not Column.Name .

---

Alternatively, set the column properties using the visual constructor, and in the set of form designers

 dataToDoList.AutoGenerateColumns = false; 

Answer 4

A simple way would be to explicitly specify the columns you want in SQL.

Those. replace select * (which you probably shouldn't use anyway) with select DiaryCompletedDate [TEST1], OtherColumn [TEST2], .. etc.

Answer 5

while data binding to the grid you can change the HeaderText as follows

 this.dataGridView1.Columns["ResourceValue"].HeaderText = Helper.getlocalStringResource("Xinga.LocalStrings.ColumnHeader.ResourceValue");