Dreamweaver Club Forums

Dreamweaver Club Forums (http://www.dreamweaverclub.com/forum//index.php)
-   ASP (http://www.dreamweaverclub.com/forum//forumdisplay.php?f=187)
-   -   DW8/ASP.Net and MS Access problem (http://www.dreamweaverclub.com/forum//showthread.php?t=37583)

Wurnman 10-04-2010 10:03 AM

DW8/ASP.Net and MS Access problem
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>

All times are GMT. The time now is 11:41 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com