?
Solved

Returning Ref_cursor to dataview

Posted on 2009-05-20
6
Medium Priority
?
592 Views
Last Modified: 2013-11-07
I am trying to get the data grid (MyDataGrid) to populate.  I run the page with no errors.  Just for grins, I sent an invalid Oracle command, and sure enough, I got an oracle error returned - So I know the code is passing through to the Oracle DB.

I can't get the datagrid to populate/draw though.  I've tested my Stored Procedure otherwise (via SQL/Plus and Excel VBA) and it works fine.

Can somebody help me understand why MyDataGrid isn't showing up on my aspx page?

<%@ Page Language="c#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="Oracle.DataAccess.Client" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ Assembly Name="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" %>
<script runat="server">
 
    protected void Page_Load(Object sender, EventArgs e)
    
    {
    
      OracleConnection con = new OracleConnection("data source=myDatabase;user id=MyuserID;password=myPass;");
    
      con.Open();
    
      OracleCommand cmd = new OracleCommand("Pkg_CPU_Reports.Report_CPU_Histogram",con);
    
      OracleParameter oparam = cmd.Parameters.Add("ResultCursor", OracleDbType.RefCursor);
    
      oparam.Direction = ParameterDirection.Output;
    
       cmd.CommandType = CommandType.StoredProcedure;
    
      OracleDataAdapter adapter = new OracleDataAdapter(cmd);
    
      DataSet myset = new DataSet("ResultCursor");
    
      adapter.Fill(myset);
	  
	  DataGrid MyDataGrid = new DataGrid();
    
      MyDataGrid.DataSource=myset;
    
       MyDataGrid.DataBind();	
 
    }
</script>
<html>
 
 
 
<body>
 
<H1>Result Set</H1>
 
<form runat="server">
 
<asp:datagrid id="MyDataGrid" runat="Server"/>
 
</form>
 
</body>
 
</html>

Open in new window

0
Comment
Question by:tscottt
  • 3
  • 3
6 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24441290
How many DataTable and rows does the DataSet have?
0
 
LVL 1

Author Comment

by:tscottt
ID: 24442762
About 10.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24446378
You didn't define any columns for the DataGrid.  If you are using ASP.NET 2.0, then I would suggest using the GridView, which can auto-generate columns from the data source.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 1

Author Comment

by:tscottt
ID: 24446981
You're a champ for helping me!  I changed it to a GridView, but it still doesn't show a control (much less populate it with data).

As an experiment I changed : asp:GridView id="MyDataGrid"

to

asp: GridView id="nothing really"

And it behaved the same.  It's as if the MyDataGrid binding in the C## inline script isn't being recognized by the ASP:GridView.

 I also tried explicitly setting DataSourceID="myset" (the variable from the script) and DataSourceID="MyDataGrid", and neither of those worked.  At least they threw errors, though.

I'm probably missing something simple about how to bind my asp control to the control of the same name in the script.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24450411
Set the GridView's AutoGenerateColumns property to True.  DataSourceID is used with an SqlDataSource, ObjectDataSource, XmlDataSource, etc.
0
 
LVL 1

Accepted Solution

by:
tscottt earned 0 total points
ID: 24456557
I found the problem.  I was declaring the datagrid (or, in more recent code, the dataview) in the inline C# script - Line 30 in the code above. That's a no-no, as it goes out of scope.

Thanks for keeping me plugging away. :)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question