Search results for query: *

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...

I use Google a ton but in this case I am not sure what to even look for. So I have this now and it gives me an error, 'Keyword not supported: unicode.' on the third line. It has something to do with the ConnectionString value. The connection string in the web.config file is where the value...

I've written this so far. Dim strConnection As String = "Data Source=D77ADEV;User ID=TDAT;Password=TDAT" Dim objConnection As New SqlConnection(strConnection) Dim strSQL As String = "SELECT * " & _ "FROM STATE;" Dim objCommand As New...

I also have the <connectionStrings> stored in the web.config file. I should be able to use this in my code instead of creating one. <connectionStrings> <add name="OracleConnectionString" connectionString="Data Source=D77ADEV;User ID=TDAT;Password=TDAT;Unicode=True"...

I'm using SqlDataSource for a drop down and a list box on a couple of my pages and it does connect to oracle just fine. I'm using a control value to pull in part of the where clause. I definitely would like to write custom queries since it would give me better control and also make it...

I am using a SqlDataSource control to pull data for a GridView control. I would like to use a value that is stored in a Hidden Field as part of the where clause. I get an Oracle invalid number error. The value of the Hidden Field is set on Page_Load and looks something like this: 2335 OR...