页面数值传送问题?

[rongxh]

我以前调试的时候可行,但是现在不知道为什么SUBMIT之后,本页设置的SESSION,APPLICATION或者PUBLIC都会重置为空.

[wangdequan1024]

？？不会吧，代码贴出来看看

[Jinniu]

？！

[rongxh]

Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.DataSet



Public Class Base_ClientS
Inherits System.Web.UI.Page



#Region " Web 窗体设计器生成的代码 "

'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

End Sub
Protected WithEvents Text1 As System.Web.UI.HtmlControls.HtmlInputText
Protected WithEvents Text2 As System.Web.UI.HtmlControls.HtmlInputText
Protected WithEvents Text3 As System.Web.UI.HtmlControls.HtmlInputText
Protected WithEvents Text4 As System.Web.UI.HtmlControls.HtmlInputText
Protected WithEvents Text5 As System.Web.UI.HtmlControls.HtmlInputText
Protected WithEvents Text6 As System.Web.UI.HtmlControls.HtmlInputText
Protected WithEvents Checkbox1 As System.Web.UI.HtmlControls.HtmlInputCheckBox
Protected WithEvents Select1 As System.Web.UI.HtmlControls.HtmlSelect
Protected WithEvents Submit1 As System.Web.UI.HtmlControls.HtmlInputButton

'注意: 以下占位符声明是 Web 窗体设计器所必需的。
'不要删除或移动它。
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()



If Request.QueryString("a") = 2 Then
Text1.Value = Request.QueryString("ChinaName")
Text2.Value = Request.QueryString("EnglishName")
Text3.Value = Request.QueryString("Connecter")
Text4.Value = Request.QueryString("Fax")
Text5.Value = Request.QueryString("Phone")
Text6.Value = Request.QueryString("Address")
Select1.Value = Request.QueryString("Type")

If Request.QueryString("UserOrNO") = "YES" Then
Checkbox1.Value = 1
End If
End If
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
session("a")=Request.QueryString("a")
End Sub

Private Sub Submit1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.ServerClick
Dim SqlStr As String

Dim MyConn As SqlConnection
Dim MyComm As SqlCommand

Dim UserOrNo As Integer

'On Error GoTo MSLIST


If Checkbox1.Checked = True Then
UserOrNo = 1
Else
UserOrNo = 0
End If



If Text1.Value <> "" And Text2.Value <> "" Then

If session("a") = 2 Then

SqlStr = "Update Base_Client set ChinaName='" & Text1.Value & "',Type='" & Select1.Value _
& "',EnglishName='" & Text2.Value & "',Connecter='" & Text3.Value & "'" _
& ",Fax='" & Text4.Value & "',Phone='" & Text5.Value & "',Address='" & Text6.Value _
& "',WorkerLast='" & Application("UserName") & "',WorkLDate='" _
& Now() & "',UserOrNo=" & UserOrNo & " where ChinaName='" & Request.QueryString("ChinaName") & "' and EnglishName='" _
& Request.QueryString("EnglishName") & "'"

ElseIf session("a") = 1 Then


SqlStr = "Insert into Base_Client(ChinaName,Type,EnglishName,Connecter,Fax,Phone,Address,UserOrNo," _
& "WorkerFrist,WorkFDate) values('" _
& Text1.Value & "','" & Select1.Value & "','" & Text2.Value & "','" & Text3.Value & "'" _
& ",'" & Text4.Value & "','" & Text5.Value & "','" & Text6.Value & "'," & UserOrNo & ",'" _
& Application("username") _
& "',getdate())"

End If

Response.Write("123" & SqlStr)

If SqlStr <> "" Then
MyConn = New SqlConnection(Application("myconn"))

MyConn.Open()

MyComm = New SqlCommand(SqlStr, MyConn)

MyComm.ExecuteNonQuery()

MyConn = Nothing

MyComm = Nothing
End If
End If
Exit Sub

MSLIST:
Response.Write("<SCRIPT> ALERT('" & Err.Description & "')</SCRIPT>")
End Sub

End Class