Click here to Skip to main content
11,924,487 members (52,350 online)
Rate this:
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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web04 | 2.8.151125.3 | 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