如何在Query Asp.Net Proj中使用AS运算符 [英] How to use AS Operator in Query Asp.Net Proj

问题描述

如何使用代码更改Gridview标题

================================ =========



喜欢frnds，



我想更改gridview标题使用sql查询的名称



例如在数据库中我有一个名为Username，FirstName，LastName的字段



但我想将其显示为UserName，First Name，Last Name。





我想将它作为FirstName用作名字这个应该在查询中



我想使用AS运营商



这是我的代码....在这里我想使用AS

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

推荐答案

我想你想做什么



选择FirstName作为[名字]





等



方括号应该允许你在列名中有空格。

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.

这篇关于如何在Query Asp.Net Proj中使用AS运算符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！