473,412 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,412 software developers and data experts.

Searching for a simple (!) sample for accessing an Oracle database and read some data from it

WhenI search Internet there thousands of comments and samples for database conenction and tuning.
They are all advanced and comprehesive.

I didn't found a simple "Hello World" for accessing an Oracle database.

This sample should contain just
- connecting to database,
- pass an SELECT FROM WHERE statement and
- read the result into a CSharp internal table/records.

Does someone know such sample ?

Ken

May 24 '07 #1
2 1287
Did you try Oracle website? They have a walkthrough.

--
cheers,
RL
"Ken Williams" <ke*****@mercedes.comwrote in message
news:46***********************@newsspool3.arcor-online.net...
WhenI search Internet there thousands of comments and samples for database
conenction and tuning.
They are all advanced and comprehesive.

I didn't found a simple "Hello World" for accessing an Oracle database.

This sample should contain just
- connecting to database,
- pass an SELECT FROM WHERE statement and
- read the result into a CSharp internal table/records.

Does someone know such sample ?

Ken

May 24 '07 #2

"Ken Williams" <ke*****@mercedes.comwrote in message
news:46***********************@newsspool3.arcor-online.net...
WhenI search Internet there thousands of comments and samples for database
conenction and tuning.
They are all advanced and comprehesive.

I didn't found a simple "Hello World" for accessing an Oracle database.

This sample should contain just
- connecting to database,
- pass an SELECT FROM WHERE statement and
- read the result into a CSharp internal table/records.

Does someone know such sample ?
Well, here's a nice example of INSERT INTO

http://msdn2.microsoft.com/en-us/lib...onnection.aspx

Here are some SELECT examples, some more complex than others

http://msdn2.microsoft.com/en-us/lib...atareader.aspx
>
Ken

May 24 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Markus Breuer | last post by:
I have a question about oracle commit and transactions. Following scenario: Process A performs a single sql-INSERT into a table and commits the transaction. Then he informs process B (ipc) to...
1
by: majk | last post by:
hey! Im looking for a db tutoral which covers accessing a Microsoft SQL database on windows. I will be using VC++ if it matters. NO details just a basic introduction! Oracle DB access using...
10
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access...
1
by: Andrew Arace | last post by:
I scoured the groups for some hands on code to perform the menial task of exporting table data from an Access 2000 database to Oracle database (in this case, it was oracle 8i but i'm assuming this...
3
by: Katrina | last post by:
I am trying to write a piece of code that will search through a number of different tables (current one being tableNm) to look for a specific street name that has been entered by the user and saved...
13
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem....
2
by: Mark Brown | last post by:
I'm trying to access an Oracle database vb.net. I found several examples. I tried following each one, but I get the same error no matter what I try. I don't really understand what the error means...
8
by: =?Utf-8?B?RGF2aWQrKw==?= | last post by:
Hi, I have been developing Web Services in VS2005. Usually I use the built in server in VS2005 to test and develop the Web Service. However I now want to make this Web Service available to...
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.