PDA

View Full Version : DW8/ASP.Net and MS Access problem


Wurnman
10-04-2010, 11:03 AM
Good day all. I need some help with some coding and I think it will be easy for a professional coder. Which I am definately not.

In DW8 I can connect to my MS Access db using the Dataset field and I can do a search by user name. It displays all the info for that user(s) which is perfect. Problem is I cannot get the results to display on the results_search.aspx page. Below is the code for the results page...

I have my IIS server setup and works well, except for this issue.

I am at witts end here.


id="DataSet1"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_phone") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETYPE_phone") %>'
CommandText='<%# "SELECT tblName, tblSurname, tblMobile, tblExt FROM contact WHERE tblName LIKE ?" %>'
Debug="true"
>
<Parameters>
<Parameter Name="@contact" Value='<%# IIf((Request.QueryString("contact") <> Nothing), Request.QueryString("contact"), "1") %>' Type="WChar" /></Parameters></MMDataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<html>
<head>
<title>Intranet</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script type="text/JavaScript">


and

<td width="47%" height="76" class="p"><MM:If runat="server" Expression='<%# (DataSet1.RecordCount > 0) %>'>
<ContentsTemplate><%# DataSet1.FieldValue("tblName", Container) %> </ContentsTemplate>
</MM:If></td>
<td width="53%" class="p"><MM:If runat="server" Expression='<%# (DataSet1.RecordCount > 0) %>'>
<ContentsTemplate><%# DataSet1.FieldValue("tblSurname", Container) %> </ContentsTemplate>
</MM:If></td>
</tr>