The standard MM dataset is too restricitve to allow for that
type of
operation. The following code uses the MM connector but a
hand written SQL
statement to then bind to a datagrid.
<%@ Page Language="VB" ContentType="text/html"
ResponseEncoding="iso-8859-1"
%>
<%@ Import NameSpace="System.Data.OleDB"%>
<script runat="server">
Sub Page_Load()
If Not Page.IsPostBack then
getDetails()
End if
End Sub
Sub getDetails()
Dim strSQL as String
strSQL = "SELECT * FROM dbo.NAT_SYSTEM WHERE FIELDA " &
request.Form("Parameter") & " " &
request.Form("value")
Dim objConn As New
OleDbConnection(ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_dbDebtors"))
Dim objCmd As New OleDbCommand(strSQL, objConn)
objConn.Open()
Dim objRdr As OleDbDataReader = objCmd.ExecuteReader()
DataGrid1.DataSource = objRdr
DataGrid1.DataBind()
objRdr.Close()
objConn.Close()
End Sub
</script>
--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver
Valleybiz Internet Design
www.valleybiz.net
"pwochnick" <webforumsuser@macromedia.com> wrote in
message
news:ef1omo$oql$1@forums.macromedia.com...
>I am trying to create a search from in Dreamweaver 8
using VB ASP.NET. What
>I
> would like to do is to have the user choose the
comparison operator
> (=,>,etc.).
> by choosing it in a field. Does anyone have an example
of this in a
> dataset?
>
> Here is what I have so far for the dataset:
>
> <MM:DataSet
> id="rs_SystemParts"
> runat="Server"
> IsStoredProcedure="false"
> ConnectionString='<%#
>
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_Net
> workAssets") %>'
> DatabaseType='<%#
>
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETY
> PE_NetworkAssets") %>'
> CommandText='<%# "SELECT * FROM dbo.NAT_SYSTEM WHERE
""Parameter"" =
> @Parameter AND ""Value" = @Value" %>'
> Debug="true"
> >
> <Parameters>
> <Parameter Name="@Parameter" Value='<%#
> IIf((Request.Form("ParameterList") <> Nothing),
> Request.Form("ParameterList"),
> "") %>' Type="VarChar" />
> <Parameter Name="@Value" Value='<%#
IIf((Request.Form("Value") <>
> Nothing), Request.Form("Value"), "") %>'
Type="VarChar" />
> </Parameters>
> </MM:DataSet>
>
1
Reply
AdChoices