Results page not filtering in dreamweaver ASP.NET

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 423,566 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,649 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 198 | Replies: 0

•

Join Date: May 2008

Posts: 2

Reputation: nortcoll is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

nortcoll

Offline

Newbie Poster

Results page not filtering in dreamweaver ASP.NET

May 15th, 2008

I have created a search/results page in Dreamweaver 8 using ASP.NET that references a SQL database. Searches are done using HTML form.

The dataset that I have created in dreamweaver quite happily filters the results but the page is pulling back all entries in the database. Has anyone seen this before .. the code is as follows:

/* FORM CODE */

 Help with Code Tags 
 html Syntax (Toggle Plain Text) 
<form action="course_search_results.aspx" method="GET" id="Course Search" name="searchform">
<label> Course search</label>
<input name="searchbox" type="text" size="10" />
<input type="submit" value="go" />
</form>
<form action="course_search_results.aspx" method="GET" id="Course Search" name="searchform">
<label> Course search</label>
<input name="searchbox" type="text" size="10" />
<input type="submit" value="go" />
</form>

/* asp.code /*

 Help with Code Tags 
 asp Syntax (Toggle Plain Text) 
<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet 
id="rsresults"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_main") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_main") %>'
CommandText='<%# "SELECT * FROM dbo.cur_tblSessions WHERE sesTitle LIKE ?AND sesYear=" + Chr(39) + "08/09" + Chr(39) + " ORDER BY crsCode ASC" %>'
Debug="true"
>
<Parameters>
<Parameter Name="@sesTitle" Value='<%# "%" + (IIf((Request.Form("searchform") <> Nothing), Request.Form("searchform"), "")) + "%" %>' Type="WChar" /></Parameters></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet 
id="rsresults"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_main") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_main") %>'
CommandText='<%# "SELECT * FROM dbo.cur_tblSessions WHERE sesTitle LIKE ?AND sesYear=" + Chr(39) + "08/09" + Chr(39) + " ORDER BY crsCode ASC" %>'
Debug="true"
>
<Parameters>
<Parameter Name="@sesTitle" Value='<%# "%" + (IIf((Request.Form("searchform") <> Nothing), Request.Form("searchform"), "")) + "%" %>' Type="WChar" /></Parameters></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />

/*display code */

 Help with Code Tags 
 asp Syntax (Toggle Plain Text) 
<ul>
     <li><a href="course_search_results2.aspx?=<%# DataSet1.FieldValue("crsCode", Container) %>" title="Information on course: <%# DataSet1.FieldValue("sesTitle", Container) %>"><%# DataSet1.FieldValue("sesTitle", Container) %></a></li>
</ul>
<ul>
     <li><a href="course_search_results2.aspx?=<%# DataSet1.FieldValue("crsCode", Container) %>" title="Information on course: <%# DataSet1.FieldValue("sesTitle", Container) %>"><%# DataSet1.FieldValue("sesTitle", Container) %></a></li>
</ul>