My Oracle Support Banner

RDBPROD: ASP.NET GridView Does Not Display the Correct Data Using ORDT (Doc ID 1323078.1)

Last updated on JANUARY 08, 2020

Applies to:

Oracle Rdb Developer Tools for Visual Studio - Version 7.3 to [Release 7.3]
Oracle Rdb Server on OpenVMS - Version 7.3 to [Release 7.3]
Information in this document applies to any platform.


When using an RdbDataReader as the data source for an ASP.NET GridView, it displays the GridView properties repeated for the number of rows the query returns rather than the actual data returned by the query.

NOTE: The data used below are not actual PRODUCTION or Customer Data.  They are being used ONLY to demonstrate the problem/solution discussed in this note.

C# code example:

using Oracle.DataAccess.RdbClient;
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
      RdbConnection conn = new RdbConnection();
      conn.ConnectionString = "User Id=username;Password=topsecret;" +   
      RdbCommand cmd = new RdbCommand(" select * from test ", conn);
      RdbDataReader reader = cmd.ExecuteReader();
      GridView1.DataSource = reader;
   catch (RdbException ex)




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.