来自带有多列C#的SQL结果的Gridview数据绑定 [英] Gridview databinding from SQL result with multiple columns C#

问题描述

我刚刚学习了如何使用SQLDatareader在C#中绑定gridview.但这是通过在每列中放置一个结果来完成的.我想将2个SQL结果连接到一列中.我有名字和姓氏，我想将它们以串联格式放在名为名称"的一列中.我应该在ASP绑定字段上的数据字段上放什么

Hi,

I just learned how to bind gridview in C# from using SQLDatareader. But this is done by placing one result per column. I want to concatenate 2 SQL results into one column. I have firstname and lastname, I want to put them in one column named "Name" in a concatenated format. What should I put on the Datafield on the ASP Boundfield

<asp:BoundField DataField="" HeaderText="Name" />

??

谢谢，

Franco

??

Thanks,

Franco

推荐答案

尝试使用此

Try using this

<asp:boundfield datafield="field1 + ' ' + field2" headertext="Name" xmlns:asp="#unknown" />

谢谢
Ashish

如果这是您的答案，请将其标记为解决方案

Thanks
Ashish

Mark it solution if this is your answer

使用查询
添加您的列

add your column using query

select Fname+' '+Lname as Name From tablename

并绑定名称为
的datagrid列

and bind datagrid column with name

<asp:boundfield datafield="Name" headertext="Name" xmlns:asp="#unknown" />

这篇关于来自带有多列C#的SQL结果的Gridview数据绑定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！