I have multiple tables for this page I need to call from the Access db. Table Points and table Member on my members profile page.
Points table has 2 fields only (Member and Points)
Member table has: MemberName (text), MemberEmail (text), MemberPassword, MemberAvatar(image path (example: app_images/faces/"AVATAR NAME.png)) (text), MemberAbout(memo), MemberCity (text), MemberState (text), MemberCountry (text), PatientType (text), PatientIssues(memo), AgreeTerms (text), AgreeDisclaimer (text), AgreePrivacy (text) fields
Nothing is being called up and populating the page. I am only getting a syntax error message.
What I have tried:
Dim pointDs As OleDbDataAdapter
Dim con As OleDbConnection
Dim ds As New DataTable
Dim mymemDs As OleDbDataAdapter
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0 ;data source=" & Server.MapPath("app_data/SimpleQSet.mdb") & ";")
If Request.QueryString("mem","sitemem") <> "" Then
pointDs = New OleDbDataAdapter("select * from Points where Member='" & Request.QueryString("mem") & "'", con)
mymemDs = New OleDbDataAdapter("select * from Member where PatientType='" & Request.QueryString("sitemem") & "'", con)
ElseIf Session("member","sitemember") <> "" Then
pointDs = New OleDbDataAdapter("select * from Points where Member='" & Session("member") & "'", con)
mymemDs = New OleDbDataAdapter("select * from Member where PatientType='" & Session("sitemember") & "'", con)
Else
Response.Redirect("Mainforum.aspx")
Exit Sub
End If
pointDs.Fill(ds)
mname.Text = ds.Rows(0)(0)
mPoints.Text = ds.Rows(0)(1)
mymemDs.Fill(ds)
myavatar.ImageUrl.ToString()
mypatient.Text.ToString()
myissue.Text.ToString()
End Sub
Profile Page Coding
<div class="style10">
<b style="text-align: left">Member Profile :</b></div>
<table style="width:100%;">
<tr>
<td class="style9">
Name</td>
<td align="left">
<b>
<asp:Label ID="mname" runat="server"></asp:Label>
</b>
</td>
</tr>
<tr>
<td class="style9">
Points</td>
<td align="left">
<b>
<asp:Label ID="mPoints" runat="server"></asp:Label>
</b>
</td>
</tr>
<tr>
<td class="style9">
Patient Type</td>
<td align="left">
<b>
<asp:Label ID="mypatient" runat="server"></asp:Label>
</b>
</td>
</tr>
<tr>
<td class="style9">
My Avatar</td>
<td align="left">
<b>
<asp:Image ID="myavatar" runat="server" AlternateText="Avatar" />
</b>
</td>
</tr>
<tr>
<td class="style9">
My Issues</td>
<td align="left">
<b>
<asp:Label ID="myissue" runat="server"></asp:Label>
</b>
</td>
</tr>
</table>