ASP.NET SQL查询所有结果打印标签

本文介绍了ASP.NET SQL查询所有结果打印标签的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我将查询结果打印到网格视图中，但是我想打印成一个带有名字的标签，如名字++姓氏，请帮忙。 DataTable dt = new DataTable（）; SqlDataAdapter sda = new SqlDataAdapter（选择名字，来自FriendsAccount的姓氏，con）; sda.Fill（ dt）; GridView1.DataSource = dt; GridView1.DataBind（）; GridView1.Visible = true;

I print query result into the Grid View, but I want to print into a label with a loop like First Name + " " + Last Name, please help. DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter("select First Name, Last Name from FriendsAccount", con); sda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); GridView1.Visible = true;

推荐答案

如下所示进行连接 Do Concatenation like below select First Name + ' ' + Last Name AS Full_Name from FriendsAccount

始终将列（名称中有空格）放在方括号内。最好避免列名中的空格。

Always put the columns(which has space in name) inside square brackets. Better avoid spaces in column names.

select [First Name] + ' ' + [Last Name] AS Full_Name from FriendsAccount