DropDown gets refreshed from DW.DataSet. Also need alter DataSetCommandText to filter from dropdown

[jeba_2458]

<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>

--Getting rows from Dataset for Grid

<MM:DataSet id="DSGRID" runat="Server" Debug="true" ConnectionString='' DatabaseType=''

CommandText='<%# "SELECT Manager,.... from ..." %>'

></MM:DataSet>

--Getting rows from Dataset for DropDown 

<MM:DataSet id="dsDropDown" runat="Server" Debug="true" ConnectionString='' DatabaseType=''

CommandText='<%# "SELECT Manager from ..." %>'

></MM:DataSet>

--Populate DropDown from DataSet

<asp:DropDownList ID="ddlManager" DataSource='<%# dsGrid.DefaultView %>' runat="server" autopostback="true" ENABLEVIEWSTATE="TRUE" ">  

</asp:DropDownList> 

--Populate Grid from DataSet

<ASP:Repeater runat="server" DataSource='<%# dsGrid.DefaultView %>' >

INTRO

I am using Dreamweaver with tag MM to create 2 DataSet objects for a drop down & a grid. The drop down is used to filter the grid.

Currently the drop down and grid statically displays all date. The issues is:-

1) The drop down refreshes the screen and its selected value gets reset only because I think the dataset is refreshed and refreshes the drop down.

How to avoid this, If there is a way to do something like this:-

<% If !PostBack

Create DataSet

Populate the ddlManager

else 

--dont refresh the dataset or dropdown

End If

%>

2) How to dynamically filter the Grid with selection from drop down. Or how to alter the dataset to include the filter from drop down selection

If there is a way to insert a WHERE clause comparing the drop down value, like this:-

<MM:DataSet id="DSGRID" 

CommandText='<%# "SELECT Manager,.... from ...<%WHERE MANAGER='DDLMANAGER.VALUE'%>" %>'

></MM:DataSet>

[Nancy OShea]

Which version of Dreaweaver?

Dynamic Content Sources:

https://helpx.adobe.com/dreamweaver/using/dynamic-content-sources-overview.html

[jeba_2458]

Adobe dreamweaver 21.1

[BenPleysier]

In all honesty, you are using an outdated workflow for your application. A better, more secure and faster way to create a web application today is to use web API's.  This will result in the features that you are looking for.

Have a look at https://dotnet.microsoft.com/en-us/apps/aspnet/apis for what this is about.

A tool that will create the ASP.net API's automatically, without hand coding, is Wappler.

[jeba_2458]

Thanks for your response but, we do not have the time and budget for that.

There is a viewstate and the drop down gets refreshed each time there is a post back.

I kinda sorta managed question #2, but need fix on question #1.

[jeba_2458]

I meant to say... EVENTHOUGH there is a viewstate the drop down STILL gets refreshed each time....

[Nancy OShea]

I don't think anyone in this Dreamweaver community can help you.  Most DW users don't use ASP or have moved beyond it.  Perhaps the Microsoft community can better assist you.

https://learn.microsoft.com/answers/questions/1741650/classic-asp-support-clarification

[jeba_2458]

Issue is I am not initiating the code in code behind or c# but using tags <Dataset></Dataset> instead.

So the dataset gets initiated each time and resets the drop down. Is there a way to avoid databinding the dataset to the drop down at each submit/postback? Like in C#/codebehind you have this

   if (!IsPostBack)
        ddlTypeProf.DataBind();

.