Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 code....in 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();
        da.Fill(ds);
      
        GVUserInfo.DataSource = ds;
        GVUserInfo.DataBind();
    }
 

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

1 solution

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

Solution 1

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

etc.
 
The square brackets should allow you to have spaces in the column name.
  Permalink  
Comments
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
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 412
1 sanket saxena 355
2 Abhinav S 258
3 OriginalGriff 210
4 CPallini 205
0 Sergey Alexandrovich Kryukov 8,704
1 OriginalGriff 5,000
2 Peter Leow 3,839
3 Maciej Los 3,535
4 Er. Puneet Goel 3,107


Advertise | Privacy | Mobile
Web04 | 2.8.140415.2 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid