我将查询结果打印到网格视图中,但是我想打印成一个带有名字的标签,如名字++姓氏,请帮忙。 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
更多推荐
ASP.NET SQL查询所有结果打印标签
发布评论