Browse by Tags

Related Posts

  • Re: Connection with oracle9i

    Hey buddy! The above link given by praveen is indeed very informative. As an addon to the explanation you can find a crisp example here:- 1 string ConnString = "data source=dsn1;user id=user1;password=pwd1;" ; 2 OracleConnection NewConn = new OracleConnection(ConnString); 3 string sql= "SELECT * FROM...
    Posted to Oracle (Forum) by veeaar on 03-29-2007, 12:00 AM
    Filed under: Oracle, example, oracleconnection, datagrid, oraclereader, c#, .net
  • Re: Inserting dropdown list numeric value to oracle database

    Wow! Excellent Thanks pixelsyndicate. thank you! pixelsyndicate: One suggestion: generate your SQL for the insert based on the value of the dropdownlist: protected void DropDownList1_SelectedIndexChanged( object sender, EventArgs e) { if (((DropDownList)sender).SelectedIndex > 0) { string sql = "insert...
    Posted to Oracle (Forum) by sthauttam on 04-19-2007, 12:00 AM
    Filed under: Oracle, c#, .net
  • Problem with OracleConnection

    Hi I try to conenct to Oracle from aspx page I'm ussing: <% @ Import Namespace ="System.Data.OracleClient" %> and dim objConn As New OracleConnection( "Data Source=hdb;User ID=xxx;Password=xxx" ) and getting error BC30002: Type 'OracleConnection' is not defined....
    Posted to Oracle (Forum) by bij004 on 05-28-2007, 12:00 AM
    Filed under: .net, Oracle, oracleconnection
  • Re: ORA-12514

    check for this file C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora here u c # tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora # Generated by Oracle configuration tools. POWER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP...
    Posted to Oracle (Forum) by kdyande on 05-28-2007, 12:00 AM
    Filed under: .net, Oracle
  • How to write Commit trasction

    Note from moderator XIII : this message was moved from the Oracle forums : i have create Business logic layer i want to implement begin transaction commit transaction. if data is not properly updated -> Rollback trasaction thank you vijaya@jyothy.com
    Posted to Data Access and ObjectDataSource Control (Forum) by vijaya123 on 06-02-2007, 12:00 AM
    Filed under: C#, .net 2.0, Oracle, .net
  • Character mismatch exception while using "SQLDataSource" for "GridView" updating Oracle Data Base

    i creat connection easlly and fatch data from oracle and delete also easlly uisng "SQLDataSource" for "GridView" accessing Oracle Data Base but when i wish to do "UpDate" it give me the execption "System.Data.OracleClient.Oracle Exception:ORA-12704:Character Set MisMatch"...
    Posted to Oracle (Forum) by avais2006 on 06-23-2007, 12:00 AM
    Filed under: Oracle, .net 2.0, OracleCommand, OracleCommand Error, SQLDataSource, .net
  • Re: Converting Now date to Oracle's whacky date

    Date .Now.ToString( "yyyy-MMM-dd" ) doesnt make sense but works. You can also try Date .Now.ToString( "dd-MMM-yyyy" ) universal function to convert any oracle date to .net date to_char(doe,'MM-DD-YYYY HH24:MI:SS')= '" & doe.ToString( "MM-dd-yyyy HH:mm:ss"...
    Posted to Oracle (Forum) by ratnamadhuri on 12-14-2007, 12:00 AM
    Filed under: Oracle, c#, .net, function, time, date, conversion, how to convert a .net date to oracle date, vb.net, convert now date to oracle date
  • How to make a oracle package call and receive the return values as dataset

    Here is My Problem, I have a complicated login porcess, there are two seperate databases involve in it. Firstly, I will search the userid in the local sql server 2005 database, if not found I will call an oracle package which is being develop by a third party(none comercial) and that package will verify...
    Posted to Oracle (Forum) by kabir.khan.net on 02-12-2008, 12:00 AM
    Filed under: Oracle, .net 2.0, OracleCommand Error, oracleconnection, .net, asp.net 2.0, Oracle Package
  • Transfer Data from Oracle to SQL

    Hi, I am new to Oracle and SQL and I want to transfer data from Oracle to an SQL table. Would it be better to look into doing this using a DTS package or writing a c#.net program to do it? Thanks.
    Posted to Oracle (Forum) by systima on 06-07-2007, 12:00 AM
    Filed under: Oracle, .net, SQL Server
  • Help me pls. i wan't code startup and shutdown oracle database with vb.net.

    Help me pls. i wan't code startup and shutdown oracle database with vb.net.
    Posted to Oracle (Forum) by pinkbuff on 05-31-2007, 12:00 AM
    Filed under: VS.2005, .net, .net 2.0, Oracle, Oracle XMLElement, OracleCommand, OracleCommand Error, oracleconnection, oraclereader, c#
Page 1 of 2 (11 items) 1 2 Next >