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

10-04-2010, 10: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.

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 ?" %>'
<Parameter Name="@contact" Value='<%# IIf((Request.QueryString("contact") <> Nothing), Request.QueryString("contact"), "1") %>' Type="WChar" /></Parameters></MMDataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script type="text/JavaScript">


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