access a session variable created from another class in vb .net

Question

I need to access a session variable called "usuario" created from another class.

First, I have the following class called Default.aspx.vb

Protected Sub btnvalidar_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnvalidar.Click
    Dim fila As DataRow
    Dim nombre As String = ""

            For Each fila In tabla.Rows
                nombre = fila("referencia")
            Next
            Session.Add("usuario", nombre)

I need to access this variable from the following class called CConexion.vb

        _adaptador.SelectCommand = New MySqlCommand("select * from empresas where usuario=Session("usuario")", _conexion)

TG01 · Accepted Answer · 2016-04-05 17:50:25Z

1

Your entire sql statement is enclosed in quotes. You want to add the session variable to the string instead:

"select * from empresas where usuario= '" + Session("usuario") +"'"

(You really should be using parameterized stored procedures)

answered Apr 5, 2016 at 17:50

TG01

1952 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

DavidM Over a year ago

I did it but there is still an error in the variable, which is not declared, and I can't figure out how

TG01 Over a year ago

Session state may not be available in your CConexion.vb class. I can't tell for sure based on your code snippets. You may have to find another way to pass the variable over. Maybe add a property named usario in that class and pass the value in.

TG01 Over a year ago

Take a look at this answer: stackoverflow.com/questions/621549/…

Collectives™ on Stack Overflow

access a session variable created from another class in vb .net

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related