Click here to Skip to main content
12,401,608 members (55,221 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 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
Updated 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 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
Web02 | 2.8.160721.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2016
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