none
Creating a database management software using VISUAL BASIC IN VISUAL STUDIO 2008 as front end and ORACLE 10g as backend.

    Question

  • I am an absolute newbie in both oracle and visual basic. I have covered some basics as tutorials and want to develop a database using Visual basic as front end and Oracle as back end. I have Visual Studio 2008 installed and I will use Visual Basic from that. I also have Oracle 10g express edition installed on my system.

    -->How do I connect both?

    -->I have created a table with 3 columns in oracle10g express edition and I want to see the table from Visual Basic.

    -->I have 3 text boxes in Visual Basic and a 'BUTTON' named 'Insert'. I want to insert the values in the text boxes into the database at the back when the Insert Butoon is pressed.

     

    Please help me.

    Tuesday, July 06, 2010 9:07 AM

Answers

  • On 7/6/2010 6:53 AM, batsachinofindia wrote:
    > Thanks for he reply.
    >
    > But, I dont think I need to know '.net' .
     
    Oh, yes you do. You may not need all of it, but you have to know some of
    it to use VB.NET programming wise against the database.
     
    >
    > I just want to no how to connect Oracle 10g express edition and Visual
    > Basic 2008 in Visual Studio 2008.
     
    You use ADO.NET which provides the means to connect to a database by a
    VB.NET program.
     
    >
    > Please provide the steps for that. I know about database , RDBMS and
    > also know to formulate SQL queries.
     
    You do know that an ORM solution would do that for you, right?
     
    >
    > I specifically want to know how to connect Oracle 10g express edition
    > and Visual Basic 2008 in Visual Studio 2008.
     
    You use ADO.NET to do it. There are plenty examples of how to use
    ADO.NET out there on Bing and Google for various database providers,
    like Oracle with using VB.NET
     
    >
    > Next step would be to write SQL queries through Visual Basic to make
    > changes[insert, delete etc] to the database at the back end. eg:I have 3
    > text boxes[ named NUMIN,NAMEIN,AGEIN] in Visual Basic Form and a
    > 'BUTTON' named 'Insert'. I want to insert the values in the text boxes
    > into the database at the back when the Insert Button is pressed.
     
    All of that can be easily accomplished with the ORM solution (ADO.NET
    Entity Framework) using Oracle. It makes the TSQL and executes the TSQL
    for CURD operations against the database/model.
     
    Other than that, then you're going to have to learn how to use VB.NET,
    with ADO.NET and ADO.NET using (TSQL) with Oracle -- the hard way.
     
    There are examples out on Bing and Google on the howto(s).
     
    HTH
    good luck
     
     
    Tuesday, July 06, 2010 11:32 AM
  • See the following:

    http://www.oracle.com/technology/obe/hol08/dotnet/getstarted-vb/getstarted_vb_otn.htm

    The assumption here is that you have the Oracle Client software and Oracle Express installed and configured. If you are having issues with the Oracle installation and configuration try posting to the Oracle forums:

    http://forums.oracle.com/forums/forum.jspa?forumID=251&start=0

     


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, July 06, 2010 12:31 PM

All replies

  • If possible Screenshot images would be a great help.

    Thanks in advance.

    Tuesday, July 06, 2010 9:08 AM
  •  
    "batsachinofindia" wrote in message news:12f55267-b6a6-4682-8244-0310757b2f60...

    I am an absolute newbie in both oracle and visual basic. I have covered some basics as tutorials and want to develop a database using Visual basic as front end and Oracle as back end. I have Visual Studio 2008 installed and I will use Visual Basic from that. I also have Oracle 10g express edition installed on my system.

    -->How do I connect both?

    -->I have created a table with 3 columns in oracle10g express edition and I want to see the table from Visual Basic.

    -->I have 3 text boxes in Visual Basic and a 'BUTTON' named 'Insert'. I want to insert the values in the text boxes into the database at the back when the Insert Butoon is pressed.

     

    Please help me.

     

    --------------------------------------------------------------------------------------------------------------------

     

    http://www.vbforums.com/showthread.php?t=540421

     

    What is Object Relational Mapping?

     

    (ORM) is a programming technique for converting data between incompatible type systems in relational databases and object-oriented programming languages. This creates, in effect, a "virtual object database," which can be used from within the programming language. There are both free and commercial packages available that perform object-relational mapping, although some programmers opt to create their own ORM tools.

    http://en.wikipedia.org/wiki/O-RM

    http://www.objectmatter.com/vbsf/docs/maptool/ormapping.html

     

    What is Language Integrated Query?

     LINQ is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.

    Microsoft LINQ defines a set of query operators that can be used to query, project and filter data in arrays, enumerable classes, XML, relational database, and third party data sources. While it allows any data source to be queried, it requires that the data be encapsulated as objects. So, if the data source does not natively store data as objects, the data must be mapped to the object domain. Queries written using the query operators are executed either by the LINQ query processing engine or, via an extension mechanism, handed over to LINQ providers which either implement a separate query processing engine or translate to a different format to be executed on a separate data store (such as on a database server as SQL queries). The results of a query are returned as a collection of in-memory objects that can be enumerated using a standard iterator function such as C#'s foreach.

    Many of the concepts that LINQ has introduced were originally tested in Microsoft's research project. LINQ was released as a part of .NET Framework 3.5 on November 19, 2007.

    http://en.wikipedia.org/wiki/Language_Integrated_Query

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>

    <o:p>

    What is ADO.NET Entities framework?

    ADO.NET Entity Framework is an object-relational mapping (ORM) framework for the .NET Framework. This framework is Microsoft's first ORM offering for the .NET Framework. While Microsoft provided objects to manage the Object-relational impedance mismatch (such as a DataSet).

    ADO.NET Entity Framework is included with .NET Framework 3.5 Service Pack 1 and Visual Studio 2008 Service Pack 1, released on 11 Aug 2008. It also includes the capability of executing LINQ against ADO.NET Entity Framework entities

    http://en.wikipedia.org/wiki/ADO.NET_Entity_Framework

    </o:p> 

    <http://www.google.com/#hl=en&source=hp&q=using+ado.net+entity+framework+with+oracle&btnG=Google+Search&aq=f&aqi=&aql=&oq=using+ado.net+entity+framework+with+oracle&gs_rfai=CS4vhRfMyTPnEMpXggwTsg8mDBQAAAKoEBU_QCl-y&fp=4cb5f508e49085f6>

    Tuesday, July 06, 2010 9:42 AM
  • Thanks for he reply.

    But, I dont think I need to know '.net' .

    I just want to no how to connect Oracle 10g express edition and Visual Basic 2008 in Visual Studio 2008.

    Please provide the steps for that. I know about database , RDBMS and also know to formulate SQL queries.

    I specifically want to know how to connect Oracle 10g express edition and Visual Basic 2008 in Visual Studio 2008.

    Next step would be to write SQL queries through Visual Basic to make changes[insert, delete etc] to the database at the back end. eg:I have 3 text boxes[ named NUMIN,NAMEIN,AGEIN] in Visual Basic Form and a 'BUTTON' named 'Insert'. I want to insert the values in the text boxes into the database at the back when the Insert Button is pressed.

    Thanks in advance.

    Tuesday, July 06, 2010 10:53 AM
  • On 7/6/2010 6:53 AM, batsachinofindia wrote:
    > Thanks for he reply.
    >
    > But, I dont think I need to know '.net' .
     
    Oh, yes you do. You may not need all of it, but you have to know some of
    it to use VB.NET programming wise against the database.
     
    >
    > I just want to no how to connect Oracle 10g express edition and Visual
    > Basic 2008 in Visual Studio 2008.
     
    You use ADO.NET which provides the means to connect to a database by a
    VB.NET program.
     
    >
    > Please provide the steps for that. I know about database , RDBMS and
    > also know to formulate SQL queries.
     
    You do know that an ORM solution would do that for you, right?
     
    >
    > I specifically want to know how to connect Oracle 10g express edition
    > and Visual Basic 2008 in Visual Studio 2008.
     
    You use ADO.NET to do it. There are plenty examples of how to use
    ADO.NET out there on Bing and Google for various database providers,
    like Oracle with using VB.NET
     
    >
    > Next step would be to write SQL queries through Visual Basic to make
    > changes[insert, delete etc] to the database at the back end. eg:I have 3
    > text boxes[ named NUMIN,NAMEIN,AGEIN] in Visual Basic Form and a
    > 'BUTTON' named 'Insert'. I want to insert the values in the text boxes
    > into the database at the back when the Insert Button is pressed.
     
    All of that can be easily accomplished with the ORM solution (ADO.NET
    Entity Framework) using Oracle. It makes the TSQL and executes the TSQL
    for CURD operations against the database/model.
     
    Other than that, then you're going to have to learn how to use VB.NET,
    with ADO.NET and ADO.NET using (TSQL) with Oracle -- the hard way.
     
    There are examples out on Bing and Google on the howto(s).
     
    HTH
    good luck
     
     
    Tuesday, July 06, 2010 11:32 AM
  • On 7/6/2010 6:53 AM, batsachinofindia wrote:
    > Thanks for he reply.
    >
    > But, I dont think I need to know '.net' .
    >
    > I just want to no how to connect Oracle 10g express edition and Visual
    > Basic 2008 in Visual Studio 2008.
    >
    > Please provide the steps for that. I know about database , RDBMS and
    > also know to formulate SQL queries.
    >
    > I specifically want to know how to connect Oracle 10g express edition
    > and Visual Basic 2008 in Visual Studio 2008.
    >
    > Next step would be to write SQL queries through Visual Basic to make
    > changes[insert, delete etc] to the database at the back end. eg:I have 3
    > text boxes[ named NUMIN,NAMEIN,AGEIN] in Visual Basic Form and a
    > 'BUTTON' named 'Insert'. I want to insert the values in the text boxes
    > into the database at the back when the Insert Button is pressed.
    >
    > Thanks in advance.
    >
     
    One other thing here, you do know that VS2008 is a .NET development
    environment, right?
     
     
    Tuesday, July 06, 2010 11:36 AM
  • See the following:

    http://www.oracle.com/technology/obe/hol08/dotnet/getstarted-vb/getstarted_vb_otn.htm

    The assumption here is that you have the Oracle Client software and Oracle Express installed and configured. If you are having issues with the Oracle installation and configuration try posting to the Oracle forums:

    http://forums.oracle.com/forums/forum.jspa?forumID=251&start=0

     


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, July 06, 2010 12:31 PM