如何从 SQL 查询中创建超链接字段 [英] How to create a HyperLink field out of SQL query

问题描述

关于我的这个问题，

问题:

如何创建带有 FruitTitle 的 HyperLinkField 并链接到水果网站?

这是我目前用于显示 Types_of_Fruits_in_Crate 的代码，并且运行良好，

 BoundField theField = new BoundField();theField.DataField = "Types_of_Fruits_in_Crate";gv.Columns.Add(theField);

放什么

 HyperLinkField theField = new HyperLinkField();theField.DataTextField = 'Types_of_Fruits_in_Crate';theField.DataNavigateUrlFields =//不确定 ....

解决方案

使用文字控件代替超链接，然后尝试使用以下查询:

SELECT CrateTitle,CrateDescription,CrateID,东西((SELECT '<a href=''' + [FruitWebsite] + ''' target=''_blank''>'+ [FruitTitle] +'</a>'从水果 WHERE CrateID = t.CrateID FOR XML path('')),1,1,' ') Types_of_Fruits_in_CrateFROM (SELECT DISTINCT CrateTitle,CrateDescription,CrateID FROMfruits)t

In reference to this question of mine,

GridView Table 1 related to Table 2

I got a gridview which looks like this at the moment,

Here is the SQL fiddle

Question:

How Can I create a HyperLinkField with FruitTitle and link to fruit website ?

This is the code I am using for displaying Types_of_Fruits_in_Crate at the moment and works perfectly,

            BoundField theField = new BoundField();
            theField.DataField = "Types_of_Fruits_in_Crate";
            gv.Columns.Add(theField);

what to put in

            HyperLinkField theField = new HyperLinkField();
            theField.DataTextField = 'Types_of_Fruits_in_Crate';
            theField.DataNavigateUrlFields = // not sure ....

解决方案

Use Literal control instead of Hyperlink and then try using below Query:

SELECT CrateTitle,CrateDescription,CrateID,
stuff(
(
  SELECT '<a href=''' + [FruitWebsite] + ''' target=''_blank''>'+ [FruitTitle] +'</a>'
  FROM fruits WHERE CrateID = t.CrateID FOR XML path('')
),1,1,' ') Types_of_Fruits_in_Crate
FROM (SELECT DISTINCT CrateTitle,CrateDescription,CrateID FROM fruits )t

这篇关于如何从 SQL 查询中创建超链接字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！