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

...of a heirarchical datagrid (custom control called HierarGrid, http://aspalliance.com/articleViewer.aspx?aId=21&pId=). There is a template file (*.ascx) that is used as the expand/contract portion of each record in the datagrid control and contains Labels where the data will be binded to...

...stateName OUT STATE.STATE_NAME%TYPE) IS --DECLARE variables here curCounties sys_refcursor; /* cursor variable declaration */ --curTribes sys_refcursor; query varchar2(2000); BEGIN query := 'SELECT TRIBAL_ID, TRIBAL_NAME, COUNTY_NAME, STATE_NAME...

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

...the first query. So, far this will not compile. CREATE OR REPLACE PROCEDURE GetTribeInfo (qryParam STRING) AS strSQL VARCHAR2(100); BEGIN /* Get Tribes by Selected Counties */ strSQL := 'SELECT TRIBAL_ID, TRIBAL_NAME, COUNTY_NAME, STATE_NAME FROM TRIBE_COUNTY_VW WHERE (COUNTY_ID ='...

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

...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 * FROM TRIBE_COUNTY_VW " & _ " WHERE (COUNTY_ID = " & qryParam & _ " ORDER BY...

...= GetConnectionString() Dim objConn As New System.Data.OracleClient.OracleConnection(strConnString) Dim strSQL As String = "SELECT * FROM TRIBE_COUNTY_VW " & _ " WHERE (COUNTY_ID = " & strParam objConn.Open() Dim adapter As...

...SQL Server speak instead of Oraclease. :-) Dim ConnectionString As String = GetConnectionString() Dim selectCommand As String = "SELECT * " & _ "FROM STATE;" Dim adaptor As SqlDataAdapter = New SqlDataAdapter(selectCommand...

...Source=D77ADEV;User ID=TDAT;Password=TDAT" Dim objConnection As New SqlConnection(strConnection) Dim strSQL As String = "SELECT * " & _ "FROM STATE;" Dim objCommand As New SqlCommand(strSQL, objConnection) objConnection.Open()...

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