我用Session("bz")进行从第一个页面到第二个页面传值,第二个页面用以下sql句子取得值题是错误,
是否是这里不能用session("bz")。产生错误提示:SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。strcj = "select dh AS 单号,kdrq as 计划日期,hh as 货号,pm as 品名,gg as 规格,left(cd,6) as 产地,dw as 单位,sl as 数量," & Session("bz") & " AS 供价 from gl_qgd order by DH"
是否是这里不能用session("bz")。产生错误提示:SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。strcj = "select dh AS 单号,kdrq as 计划日期,hh as 货号,pm as 品名,gg as 规格,left(cd,6) as 产地,dw as 单位,sl as 数量," & Session("bz") & " AS 供价 from gl_qgd order by DH"
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
TextBox1.Text = Session("bz")
End Sub
第二个页面显示时Textbox1却什么也没有内容
'" & Session("bz") & "'把单引号加上试试错误提示是什么
to NoYester 这样它是一个空项生成一列,我跟感觉是session("bz")没有传到第二个页面产生错误提示:SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确