Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server
How to Change Gridview Headers using Code
hi frnds,
I want to change gridview header names using sql query
for example in database i have a field called Username, FirstName, LastName
but i want to display it as UserName , First Name , Last Name.

I want to use it as FirstName as First Name this should be in Query
I want to use AS Operator
This is my this i want to use AS
private void LoadGridview()
 SqlConnection con = new SqlConnection(_connString);

 SqlCommand cmd = new SqlCommand("Select UserName,Firstname,LastName from UserInfo",con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        GVUserInfo.DataSource = ds;

Please help, thanks
Posted 29-Jan-13 19:38pm
Edited 30-Jan-13 2:18am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I think you want to do
Select FirstName as [First Name]

The square brackets should allow you to have spaces in the column name.
Software Engineer 892 at 30-Jan-13 0:45am
Thank you sir for ur help, its working.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Mika Wendelius 161
1 Abhinav S 115
2 Peter Leow 110
3 Suvendu Shekhar Giri 100
4 Dave Kreskowiak 85
0 Sergey Alexandrovich Kryukov 8,513
1 OriginalGriff 6,526
2 Peter Leow 3,657
3 Zoltán Zörgő 3,426
4 Richard MacCutchan 2,417

Advertise | Privacy | Mobile
Web02 | 2.8.150123.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100