Recent content by runmd

Thargy, This is perfect! I'll post my code after I get it working.

Is it possible to find out the precision and scale of a numeric column? I have a PL\SQL script that determines the max length of each column in a table. The script contains an IF block that reads the max length of columns that are of data type NUMBER, VARCHAR2, CHAR or any other data type. I...

jmeckley, I took some time to think about my problem and tackle it a slightly different way. I used two REF CURSORs in my test procedure prior to the one I posted here. I got frustrated and came up with the one above. I decided to go back to using those two REF CURSORS as output with two...

I am working on some VB code to connect to an Oracle stored procedure and retrieve data. The stored procedure takes a string as input, constructs a SQL query into a string and uses a cursor to query and pull four fields of data. I have the four fields as an OUT parameter that I would like to...

I've got the sorting and paging working ok. Now I'm taking the gridview control a few steps further by making it expandable/heirarchical. For every row, there is a row below it showing more information. I'm working on an oracle store procedure to run a query and get a result. I'm going to...

Thanks Karluk! So, now I am tying this into a oracle package for use with an ASP.NET vb application. I get an error when filling a dataset since the table or query is not returning any rows. I'm going to post it on the ASP.NET forum.

SantaMufasa, The passing of one COUNTY_ID value is not my problem, it's the passing of multiple COUNTY_ID's in a string where I need multiple records for multiple counties. The qryParam would be equal to this: 91 OR COUNTY_ID = 92 OR COUNTY_ID = 93 OR COUNTY_ID = 94) So, I've strung...

I would like to fire off an oracle stored procedure in a ASP.NET page that I will pass a query parameter (string variable) to assign to a where clause. I am concatenating the string to the rest of the SQL statement and would like to execute it. Do I use the EXEC() command? I would also like...

Thanks jbenson001! That makes perfect sense. So, I just did something crazy and instead of binding a dataset to the GridView.DataSource, I converted it to a DataTable. This was in hope to alleviate the problem and it worked. I've been working on this stuff for a couple of days and everytime...

I've tried this line of code: Dim dataTable As DataTable = TryCast(GridView1.DataSource, DataSet) I still get the same error: Value of type unable to cast object of type 'System.Data.DataSet' to type 'System.Data.DataTable'. Ugh. So, does anyone have any ideas? Do I need to use a...

I've fixed the paging issue and that was actually easy but I am still stuck on the sorting problem. After researching it, I have seen others fill the GridView by running the query a 2nd time on the post back. I'm not sure I would need to do that since I already access the db on page load...

One more thing, I just tested the paging in IE and the pages do not show up in the browser. The page numbers only show up in Firefox. Ugh....

I have a GridView control that I attach data to in the Page_Load event. I have set AllowPaging and AllowSorting to True. The data comes from an oracle database so that means that the data binding is one way. The sorting and paging of data is a two way event so I have added two events to...

I've fixed the code in the previous post to fill the GridView with data from this query. I've put it in its own procedure passing it the connection string and part of the query parameter and call it from the Page_Load procedure. It works like a charm. Dim queryString As String = "SELECT *...

Ive installed the ODAC tools for Visual Studio and added the System.Data.OracleClient to my IDE. I started to work on a query to add records to a gridview control. I think the query is working but what is bound to the gridview is a row of attributes describing the parameters of one of the...