Hi there
How to get user data after login with session
I did resolve my issue now it works but you can give a look and see for yourself
Please could you check if the code is well done
Private Sub Session_Load()
Dim ConnStr As String = ConfigurationManager.ConnectionStrings("MySQLConnect").ConnectionString
Using Conn As MySqlConnection = New MySqlConnection(ConnStr)
Conn.Open()
Dim Query As String = "select * from tbl_users where User_Name='" & Session("User_Name") & "'"
Dim Cmd As MySqlCommand = New MySqlCommand(Query, Conn)
Dim Da As MySqlDataAdapter = New MySqlDataAdapter(Cmd)
Dim Ds As DataSet = New DataSet()
Da.Fill(Ds)
Dashboard_LinkBtn_User_Name.Text = Ds.Tables(0).Rows(0)("User_Name").ToString()
Dashboard_Lbl_DB_First_Name.Text = Ds.Tables(0).Rows(0)("First_Name").ToString()
Dashboard_Lbl_DB_Last_Name.Text = Ds.Tables(0).Rows(0)("Last_Name").ToString()
Dashboard_Lbl_DB_User_Name.Text = Ds.Tables(0).Rows(0)("User_Name").ToString()
Dashboard_Lbl_DB_Email.Text = Ds.Tables(0).Rows(0)("Email").ToString()
Conn.Close()
End Using
End Sub