查询结果未显示在标签中，但出现在gridview中 [英] Query result does not appear in label but appear in gridview

问题描述

大家好..我面临着将查询结果传递给标签的问题.
当我尝试使用下面的代码的gridview时，它可以工作(在gridview中显示"SEP3FM").但是，当我将代码替换为;
Dim loc1 As String = OracleDbLib.OracleDbBase.ExcuteScalar(sqlDATE)
Me.lblLoc.Text = loc1
它没有显示任何错误，但是没有任何显示.当我调试时，"loc1"值包含"Nothing".结果是varchar数据类型.如何在标签中显示值?感谢您的帮助. :)

Hye all..I am facing a problem to pass the result from query to a label.
When I try with a gridview like code below, it works (displaying ''SEP3FM'' in the gridview). However when I replace the code to ;
Dim loc1 As String = OracleDbLib.OracleDbBase.ExcuteScalar(sqlDATE)
Me.lblLoc.Text = loc1
it shows no error but nothing appear. When I debug, the ''loc1'' value contains "Nothing". The result is in varchar datatype.How to display the value in label? Thanks for your help guys. :)

Dim sqlDATE As String = " Select DVLPER.MANUFACTURERESULTS.WORKWARD" & _
                                " From (Select Max(DVLPER.MANUFACTURERESULTS.RESULTINPUTNO) As MAX1" & _
                                " From(DVLPER.MANUFACTURERESULTS)" & _
                                " Where DVLPER.MANUFACTURERESULTS.JOBNO = ''404001039232'') DB1 Inner Join" & _
                                " DVLPER.MANUFACTURERESULTS On DB1.MAX1 =" & _
                                " DVLPER.MANUFACTURERESULTS.RESULTINPUTNO"

Dim loc1 As DataTable = OracleDbLib.OracleDbBase.BuildDataTable(sqlDATE)
GridView2.DataSource = loc1
GridView2.DataBind()

推荐答案

OracleDbLib.OracleDbBase.ExcuteScalar(sqlDATE)的返回类型是什么?我认为您需要将其强制转换为字符串.

问候
塞巴斯蒂安(Sebastian)

Whats the return type of OracleDbLib.OracleDbBase.ExcuteScalar(sqlDATE) I think you need to cast it to string.

Regards
Sebastian

您可以尝试

Hi,

you may try

Me.lblLoc.Text = loc1.Rows[0][0].toString();

希望对你有帮助

祝你好运

Hope its help u

Best Luck

这篇关于查询结果未显示在标签中，但出现在gridview中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！