How to store Form values in Oracle 10g with VB.NET

Shaz

255 pts.

Tags:

Database programming

Oracle 10g

VB.NET

VB.NET 2005

How do I store form values in Oracle 10g database storage in VB.NET 2005?

Asked: March 11, 2009 10:24 AM Last updated: September 30, 2014 5:59 PM

Answer Wiki

Last updated: September 30, 2014 5:59 PM GMT

Michael Tidmarsh63,305 pts.
History
Contributors
- Ordered by most recent
- Michael Tidmarsh63,305 pts.
- carlosdl84,505 pts.

Thanks. We'll let you know when a new response is added.

Have a look at the following Oracle article for the basics on connecting to the database from .NET

It shows how to connect to the database and retrieve records using SELECT statements. To perform inserts and updates you just need to change de command text with the appropriate SQL command, and execute it as non reader (i.e. replacing cmd.ExecuteReader with cmd.ExecuteNonReader).

Discuss This Question: 5 Replies

Shaz Mar 13, 2009 6:14 AM GMT

Thanks Carlosdl for giving me the answer ,i will work out with this

255 pointsBadges:

report
Shaz Mar 13, 2009 7:19 AM GMT

Imports Oracle.DataAccess.Client Dim oradb As String = "Data Source=localhost;User Id=shazia;Password=shazia;" Dim oradb As String = "Data Source=(DESCRIPTION=" _ + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))" _ + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));" _ + "User Id=shazia;Password=shazia;" Dim conn As New OracleConnection(oradb) Dim conn As New OracleConnection() ' Visual Basic conn.ConnectionString = oradb conn.Open() MsgBox("connected successfully") iam getting errors such as Error 1 Statement is not valid in a namespace. C:Documents and SettingsShazia (Delonti)My DocumentsVisual Studio 2005ProjectsschoolschoolAdd Admission.vb 4 1 school plz give me a solution for this .iam new vb.net Thanks once again

255 pointsBadges:

report
carlosdl Mar 13, 2009 2:26 PM GMT

In .NET, everything have to be inside a class or module (excluding the imports). Also, there are some unnecessary lines in your code, for example the lines where you set the connection string. If you want to avoid the use of the TNSNAMES.ORA file then use your second option: Dim oradb As String = “Data Source=(DESCRIPTION=" _ + “(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))” _ + “(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));” _ + “User Id=shazia;Password=shazia;” Otherwise, use this (but replace 'localhost' with the database alias defined in your tnsnames.ora file): Dim oradb As String = “Data Source=your_database_alias;User Id=shazia;Password=shazia;” Your code should look similar to this: Imports Oracle.DataAccess.Client Public Class MainClass Shared Sub Main() Dim oradb As String = “Data Source=(DESCRIPTION=" _ + “(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))” _ + “(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));” _ + “User Id=shazia;Password=shazia;” Dim conn As New OracleConnection(oradb) conn.Open() End Sub End Class

84,505 pointsBadges:

report
Shaz Mar 18, 2009 5:44 AM GMT

Hi Carlosdl, Thank u for helping me out .I have implemented the code which u have given .Now it is giving as error connection not open ora 6413.Plz give solution for that Thanks & Regards, shazia.

255 pointsBadges:

report
carlosdl Mar 18, 2009 3:29 PM GMT

I posted an answer here: Solution for ORA-6413 error showing connection not open See if it helps.

84,505 pointsBadges:

report