How to use AS Operator in Query Asp.Net Proj

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