logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > ASP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 10-04-2010, 10:03 AM   #1
Wurnman
 
Join Date: Oct 2010
Posts: 1
Default 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.


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:
<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>

Last edited by Wurnman; 10-04-2010 at 10:08 AM.. Reason: coding issue
Wurnman is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:28 AM.


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