Posts

Showing posts from April, 2009

Intermediate Results-II Year

Your browser does not support iframes.

Re load page using asp.net

Instead of using Response.Redirect you could try CODE ScriptManager.RegisterClientScriptBlock(this, typeof(string), "postBack", Page.ClientScript.GetPostBackEventReference(new PostBackOptions(this)), true);I know it's a bit long but if you have any update panels or ajax stuff on the page you need to use ScriptManager. Otherwise you can just use CODE ClientScript.RegisterClientScriptBlock(typeof(string), "postBack", Page.ClientScript.GetPostBackEventReference(new PostBackOptions(this)));I hope that helps

Bulk Operations Using Oracle Data Provider for .NET (ODP.NET)

Introduction In a typical multi-tier application, one of the biggest performance bottlenecks is the overhead of making round-trips to the database . Minimizing these round-trips is often the first area you should look at during performance tuning. Fortunately, the Oracle Data Provider for .NET (ODP.NET) makes it fairly easy to do this by providing several built-in methods to write and read data in bulk. To run the code samples in this article, you will need to have: ODP.NET 2.0 A table named "BULK_TEST". Here's the script that creates the table BULK_TEST: CREATE TABLE BULK_TEST ( EMPLOYEE_ID NUMBER(10) NOT NULL, FIRST_NAME VARCHAR2(64 BYTE) NOT NULL, LAST_NAME VARCHAR2(64 BYTE) NOT NULL, DOB DATE NOT NULL ); CREATE TABLE BULK_TEST ( EMPLOYEE_ID NUMBER(10) NOT NULL, FIRST_NAME VARCHAR2(64 BYTE) NOT NULL, LAST_NAME VARCHAR2(64 BYTE) NOT NULL, DOB DATE NOT NULL ); Bulk Inserts Using Array Binding The Array Binding feature in ODP.NET allows you to insert multiple records in

Calling Oracle stored procedures from Microsoft.NET

Introduction This article is intended to illustrate how to illustrate how to call Oracle stored procedures and functions from Microsoft.NET through the Microsoft.NET Oracle provider and its object model residing in the namespace System.Data.OracleClient. I will cover several possible scenarios with advanced examples.Executing a stored procedure Let's begin with definitions. A procedure is a module that performs one or more actions. A function is a module that returns a value and unlike procedures a call to a function can exist only as part of an executable such as an element in an expression or the value assigned as default in a declaration of a variable. The first example illustrates how to call an Oracle procedure passing input parameters and retrieving value by output parameters. For all the examples, we're going to use the default database ORCL which comes with the Oracle database installation. The following code in Listing 1 shows how to create a procedure named count_emp_

Caching Oracle Data for ASP.NET Applications

Introduction For building scalable and high-performance Web based applications, ASP.NET provides a feature called data caching. Data caching enables programmatic storing of frequently accessed data objects in memory. This feature can be extended to vastly improve performance for ASP.NET applications that query data stored in an Oracle database. This article describes a strategy for caching Oracle database data in ASP.NET Web applications deployed using a Web Farm environment. This technique enables caching of frequently accessed Oracle database data in memory rather than making frequent database calls to retrieve the data. This helps to avoid unnecessary roundtrips to the Oracle database server. Further the article proposes an implementation for maintaining the cached data so it is always in sync with the corresponding data in the Oracle database. Data Caching in ASP.NET Data Caching in ASP.NET is facilitated via the Cache class and the CacheDependency class in the System.Web.Caching n