Search results matching tags 'Oracle' and 'ajax'

Oracle script returns value

n4nish — Mon, 15 Jun 2009 04:00:00 GMT

Hello,

I can successfully insert and update the oracle database by calling a
oracles script from my vb.net code on vs2003. This oracle script is returning
some value. I cannot see that value in my .net code

Re: Change ScriptResource.axd path

redrum2455 — Mon, 09 Mar 2009 04:00:00 GMT

I banged my head enough and actually came up with a solution this this. It's kind of goofy but it's the only thing that I can find that works:

1) You need to stop using the dynamically generated script files (ScriptResource.axd) and instead, reference the static .js files for both "System.Web.Extensions" and the Ajax Control Toolkit. Here's a helpful article that showed me how to do this:

http://blogs.msdn.com/jorman/archive/2007/05/18/referencing-js-files-for-the-ajax-control-toolkit.aspx

If you follow this article (remember it depends on the version of the Ajax Control Toolkit you are using, I am using version 1.0.20229.20821 which is the last version of the 2.0 Toolkit - you can get these from http://ajaxcontroltoolkit.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=11121), put the static .js files in the root of your web app in a "Scripts" folder the way the article above says, and add this "ScriptPath" attribute to the <ScriptManager> tag on the rendered page and see that the page is now referencing the static .js files.

2) If the page is gatewayed, the only other step is (and this is kind of hacky) but you must parse out the fully qualified gatewayed link to your page and use it to programatically RESET the ScriptPath attribute to your static .js files in the root of your Web App every time the page loads to the value of the fully qualified gatewayed link (put it in the Page_Load() function so it runs every time, postback or not).

I did this by parsing out the gatewayed link from the portal's "HTTP_CSP_GATEWAY_SPECIFIC_CONFIG" header variable. Inside this is a parameter of PT-Hostpage-URI which contains the address of the gatewayed page.

Parse this out, and reset it every time in the Page_Load() function. It never changes, but somehow the .NET app loses its reference to this when gatewayed - hence our error. So I re-apply it every time, and presto, I can use the Standard .NET Ajax Extensions with the Ajax Control Toolkit like I described above (using UpdatePanel to dynamically add AutoCompleteExtenders to Textboxes).

So, for example, on every Page_Load(), I am resetting the ScriptPath to:

http://PortalServerName/portal/server.pt/gateway/PTARGS_0_16064_352_210_0_43/http%3B/ExternalCodeServerName%3B80/MyAjaxWebAppName/Scripts/

Where PortalServerName is the name of my portal server, and ExternalCodeServerName is the server where the .NET code lives.

I know this may be a little confusing, but it does work for me. Hopefully it will work for you.

Database Lookups for ASP.NET and AJAX 3.5

CodeOnTime — Thu, 31 Jul 2008 04:00:00 GMT

Database Lookups is a free code generator project that allows to replace standard ASP.NET controls DropDownList and ListBox used by database web application developers to display and select lookup values.

The replacement DataViewLookup is implemented as AJAX ASP.NET 3.5 control with dynamic user interface based on abbreviated version of the Data Aquarium Framework.

Popup lookup windows with infinite scalability allow to sort data, apply adaptive filters, and page through thousands of records without effort. You can provide multiple views of the same data to make record selection even more efficient

No programming is required. The configuration is done via data controllers that are included in the source code of your application. There are no external dependencies in the code.

Review a complete feature list of this code generator project.

Download the Database Lookups for ASP.NET and AJAX 3.5 code generator project and improve usability of the user interface in your database web applications.

Try the demo of database lookups now.

Code OnTime LLC

Databound Reorder Control and Oracle 10g DB - Not Updateable

John Happy — Wed, 09 Apr 2008 04:00:00 GMT

I'm using VS 2005 to develop a web app and would like to use the Ajax Reorder control.

I want to use an Oracle db table, rather than MS SQL Server db table, as the SQLDataSource for the control.

I can get a Reorder control to work using a MS SQL Server db table hooked up to a SQLDataSource control. The select statement obviously works and the update code updates the SortOrderField as it should: http://www.lowfatcow.com/SQLServerReorder.aspx

I am unable to get my databound Reorder control to effect an update using my Oracle 10g (Express Edition) when hooked up to a SQLDataSource control: http://www.lowfatcow.com/OracleReorder.aspx

If you follow the link to my OracleReorder.aspx page, you will see the database table data within the Reorder control - the SQLDataSource SELECT statement works - but attempting to reorder the list (and UPDATE the Oracle db table) results in an error. The error message says that the data source could not be reordered and it does not implement IList.

The SQL Server 2005 and Oracle 10g database tables have the same column names, the appropriate data types and the same data.

Have you had any success getting a Reorder control to do a db table update with an Oracle database and a SQLDataSource control?

Following is the OracleReorder code:

Connection String in the Web.config file:

Reorder Control Code:

<cc1:ReorderList ID="ReorderList1" runat="server" AllowReorder="true" CssClass="ReOrderControlStyle" DataKeyField="CATEGORYID" DataSourceID="SqlDataSource1" DragHandleAlignment="left" SortOrderField="PRIORITY" >

<asp:Label id="lblCategoryName" runat="server" Text='<%# Eval("CATEGORYNAME") %>'></asp:Label>

</ItemTemplate>

</cc1:ReorderList>

SQLDataSource code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:BDLOracleConnectionString %>"

OldValuesParameterFormatString="original_{0}"

ProviderName="<%$ ConnectionStrings:BDLOracleConnectionString.ProviderName %>"

SelectCommand='SELECT * FROM "REORDER" ORDER BY "PRIORITY"'

UpdateCommand='UPDATE "REORDER" SET "PRIORITY" = :PRIORITY WHERE "CATEGORYID" = :original_CATEGORYID'>

<asp:Parameter Name="PRIORITY" Type="Decimal" />

<asp:Parameter Name="original_CATEGORYID" Type="Decimal" />

</UpdateParameters>

</asp:SqlDataSource>

***************************************************************

Following is the SQLServerReorder Code:

Connection String in the Web.Config file:

Reorder Control Code:

<cc1:ReorderList ID="ReorderList1" runat="server" AllowReorder="true" CssClass="ReOrderControlStyle" DataKeyField="CategoryID" DataSourceID="SqlDataSource1" DragHandleAlignment="left" ItemInsertLocation="beginning" SortOrderField="Priority">

<asp:Label ID="lblCategoryName" runat="server" Text='<%# Eval("CategoryName") %>' />

</ItemTemplate>

</cc1:ReorderList>

SQLDataSource Code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SQLServerBDLConnectionString %>"

SelectCommand="SELECT * FROM [Reorder] ORDER BY [Priority]"

UpdateCommand="UPDATE [Reorder] SET [Priority] = @Priority WHERE [CategoryID] = @original_CategoryID"

OldValuesParameterFormatString="original_{0}" >

<asp:Parameter Name="Priority" Type="Int32" />

<asp:Parameter Name="original_CategoryID" Type="Int32" />

</UpdateParameters>

</asp:SqlDataSource>

************************************************

On both the SQLServer and Oracle web pages the Reorder control display correctly. The select statements generate the list items within the Reorder controls.

On the OracleReorder page the list items will move, but they snap back to their original position when the mouse button is released and the error dialog appears.

Perhaps the Oracle 10g database is simply not compatable with the Reorder and SQLDataSource controls and no amount of code tweeking will work?