Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: runmd
  • Order by date
  1. runmd

    Determine Precision and Scale from a Numeric Column

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

    Determine Precision and Scale from a Numeric Column

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

    ASP.NET runtime error: Cannot find table 0.

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

    ASP.NET runtime error: Cannot find table 0.

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

    Sorting/Paging a GridView

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

    Creating a Stored Procedure

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

    Creating a Stored Procedure

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

    Creating a Stored Procedure

    ...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 ='...
  9. runmd

    Sorting/Paging a GridView

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

    Sorting/Paging a GridView

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

    Sorting/Paging a GridView

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

    Sorting/Paging a GridView

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

    Sorting/Paging a GridView

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

    SqlDataSource Control and Hidded Field

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

    SqlDataSource Control and Hidded Field

    ...= 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...
  16. runmd

    SqlDataSource Control and Hidded Field

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

    SqlDataSource Control and Hidded Field

    ...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()...
  18. runmd

    SqlDataSource Control and Hidded Field

    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"...
  19. runmd

    SqlDataSource Control and Hidded Field

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

    SqlDataSource Control and Hidded Field

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

Part and Inventory Search

Back
Top