DW8/ASP.Net and MS Access problem

Wurnman · 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.

Quote:

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

Quote:

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode