首页 > 解决方案 > 在同一项目上将会话从 c# 传递到 vb

问题描述

嗨,我有这个 c# Webform 项目,我在 vb 中添加了这个现有的 webform,但我需要一个会话来将会话从 c# 传递到 vb 似乎 vb 无法获取会话,即使具有相同的会话名称,这甚至可以不使用数据库?

C#部分:

 protected void Page_Load(object sender, EventArgs e)
        {
            personnelData();
            ITSystems();
            QRSystems();
            Session.Add("UserName", "040079");

        }

VB部分:

<body>
<%
    Set MyConn = server.createobject("ADODB.Connection")
    MyConn.connectionstring = "Provider=MSDAORA.1;User ID=****; Password=****;Data Source=*****"
    MyConn.Open

    Dim strSQL, strSessID, strURL

    strSQL = "DELETE FROM TBLUSERSESSION WHERE EMPID = '" & Session("UserName") & "'"
    MyConn.Execute strSQL

    strSQL = "INSERT INTO TBLUSERSESSION VALUES ('" & Session("UserName") & "', SYS_GUID(), SYSTIMESTAMP)"
    MyConn.Execute strSQL

    Set mySession = MyConn.Execute("SELECT SESSIONID FROM TBLUSERSESSION WHERE EMPID = '" & Session("UserName") & "'")
    If mySession.EOF = False Then
        strSessID = mySession.Fields("SESSIONID")
    End If

    strURL = "http://sample/rewards/rewards/default.aspx?id=" & strSessID
    Response.Write "<script>"
    Response.Write "window.open('" & strURL & "', '_blank');"
    Response.Write "</script>"

    MyConn.Close
    Set MyConn = Nothing
%>
</body>

对不起,我的英语不好

标签: c#asp.net.netvb.netsession

解决方案


推荐阅读