Hi

I am trying to get information in a Database to be displayed when a user is logged in using cookies. Unfortunately have seemed to have got stuck somewhere.

Please see the below code of where I have got to so far: -

<script runat="server">

Dim DBConnection As OleDbConnection
Dim DBCommand As OleDbCommand
Dim DBReader As OleDbDataReader
Dim SQLString As String
Dim UserNameCookie As HttpCookie

Sub Page_Load()

    If (Request.IsAuthenticated = true) Then
        pnlEdit.Visible = true
        pnlView.Visible = false
        lblStatus.Text = "<br>Welcome: " & _
        Request.Cookies("UserNameCookie").Value
       End If

    If Not Page.IsPostBack Then
    DBConnection = New OleDbConnection( _
      ConfigurationSettings.AppSettings("ConnectionStrin g"))
    DBConnection.Open()
    SQLString = "SELECT * FROM Customers" & _
        "WHERE CustomerEmail = '" & UserNameCookie & "'"
    DBCommand = New OleDbCommand(SQLString, DBConnection)
    DBReader = DBCommand.ExecuteReader()
    RepeaterDisplay.DataSource = DBReader
    RepeaterDisplay.DataBind()
    DBReader.Close()
    DBConnection.Close()
  End If

End Sub

I have declared the UserNameCookie as a HttpCookie but now getting an error on the page where Operator '&' is not defined for types 'String' and 'System.Web.HttpCookie'.

Does anyone have any suggestions or pointers of where I need to go from here?

Thanks

Sharon

You need to read the value from the cookie and place that into a string and then add that string to your SQL statement.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hi

Thanks for the tip, becuase I am requesting the cookie value, I have now assigned it to the variable. For example:

Dim UserNameCookie As String
UserNameCookie = Request.Cookies("UserNameCookie").Value

Now I can use the variable UserNameCookie throughout my coding.

Thanks
Sharon

You are welcome, glad it worked out for you.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========