Re: how to connect oracle database to form in c# in visual studio - C# Discussion Boards

Re: how to connect oracle database to form in c# in visual studio

29-Jan-09 8:28

Read this[^]

Be careful, there is no Undo Button(Ctrl+Z) in life.

musefan29-Jan-09 8:30

Re: how to connect oracle database to form in c# in visual studio

29-Jan-09 8:30

LMAO, how did you ever find the same link as me, it took me so long to actual get a google result for what the OP wanted Wink | ;)

- I guess thats why they always turn to CP lol

vaghelabhavesh29-Jan-09 8:33

Re: how to connect oracle database to form in c# in visual studio

29-Jan-09 8:33

musefan wrote:
I guess thats why they always turn to CP lol

Well, The good thing is that he wasn't asking for the source codez and it wasn't urgent. Smile | :)

So I just asked him to read that article. Did I do something wrong?

Be careful, there is no Undo Button(Ctrl+Z) in life.

musefan29-Jan-09 8:35

Re: how to connect oracle database to form in c# in visual studio

29-Jan-09 8:35

No, I was just making a comment on how easy it is to find a search result that fits thier needs, yet they never seem to try for themselves

musefan29-Jan-09 8:29

Re: how to connect oracle database to form in c# in visual studio

29-Jan-09 8:29

Work through this tutorial and then you should be able to do what you require, or atleast have a basic idea of what you need to do, one would hope

http://www.oracle.com/technology/pub/articles/cook_dotnet.html[^]

Second time i have used this link today lol

Pete O'Hanlon29-Jan-09 8:33

Pete O'Hanlon

29-Jan-09 8:33

It depends on the technology you are using to connect. Are you using ODP.NET or ODBC for instance? If ODP, you'd create instances of OracleConnection and OracleCommand objects. Your connection string would be based on the entry in TNSNAMES.ORA that you are aiming to connect to. So, suppose the SID was MYORA, then your connection string might look like this "Data Source=MyOra; User ID=NamedUser; Password=Password;"

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

My blog | My articles | MoXAML PowerToys

How To get MCTS papers?

Roney29-Jan-09 7:59

Roney

29-Jan-09 7:59

Hi all,
I am looking for MCTS[70-536,70-526,70-528] papers....where should i get this content
pages...if you people have anything this info please post a link or you may post info to my mail and one more actually am a c# developer so is there any chances to get vb.net questions above mentioned papers please let me know this info very urgent ...........
thank you in advance.....

Re: How To get MCTS papers?

musefan29-Jan-09 8:12

Re: How To get MCTS papers?

29-Jan-09 8:12

LMAO,What?!?

PIEBALDconsult29-Jan-09 13:41

PIEBALDconsult

29-Jan-09 13:41

Find somebody who has them, bop him on the head, take the papers. Unsure | :~

Re: How To get MCTS papers? [modified]

Luc Pattyn29-Jan-09 14:20

Luc Pattyn

29-Jan-09 14:20

(entered using FF3)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

modified on Friday, June 10, 2011 11:55 AM

Re: How To get MCTS papers?

PIEBALDconsult29-Jan-09 16:15

PIEBALDconsult

29-Jan-09 16:15

Yeah, yours worked and mine does some times.

Seeing content of a SDF file ?

Mohammad Dayyan29-Jan-09 7:46

29-Jan-09 7:46

Hello guys.
I have a file with SDF extension ( database ).
I'm gonna see content of it ! I couldn't see it with VS2008 SP1 or SQL Express 2008 SP1.
How can I see it ?

Thanks in advance.

musefan29-Jan-09 8:10

29-Jan-09 8:10

Have you tried using the System.Data.SQLClient classes and specifying the .SDF file as the data source

Other than that dont know what to suggest

Mohammad Dayyan29-Jan-09 8:28

29-Jan-09 8:28

Hi musefan.

musefan wrote:
Have you tried using the System.Data.SQLClient classes and specifying the .SDF file as the data source

Actually I've known it and I've used it for using the database in my project.
But I'm gonna trace my program and see the content of the database after each query, so I need a program like MSSQL to see content of the database .
As I said I've used SQL Express and VS2008 , but they didn't show anything.

Thanks anyway

vaghelabhavesh29-Jan-09 8:23

29-Jan-09 8:23

Option 1:
Do you have SQL Server Management Studio? If so then open it and select the Database type as SQL Server Compact Edition and specify the path of sdf file in Database File option. Thats it!!

Option 2:
Open the Server Explorer Window in Visual Studio and right click the Data Connection and click add connection. In Data Source Click Change button and select the SQL Server Compact Edition. Then click OK. Now you will have to specify the path of sdf file.

<edit>
Try this[^]

Be careful, there is no Undo Button(Ctrl+Z) in life.

Mohammad Dayyan29-Jan-09 8:46

29-Jan-09 8:46

Thanks a lot crudeCodeYogi.

crudeCodeYogi wrote:
Do you have SQL Server Management Studio? If so then open it and select the Database type as SQL Server Compact Edition and specify the path of sdf file in Database File option. Thats it!!

I have SQL Express 2008 SP1, Is it appropriate ?

vaghelabhavesh29-Jan-09 8:52

29-Jan-09 8:52

Mohammad Dayyan wrote:
I have SQL Express 2008 SP1, Is it appropriate ?

It should work on SQL Express 2008 also.

Be careful, there is no Undo Button(Ctrl+Z) in life.

Mohammad Dayyan29-Jan-09 9:02

Help to a new user please

29-Jan-09 9:02

Thanks. It works. Thumbs Up | :thumbsup:

sridhar88729-Jan-09 5:20

sridhar887

29-Jan-09 5:20

i'm a new user of C#.. pls help me how 2 insert data into oracle 10g database???? and also how to fetch data from it???? pls help me soon.. pls provide source code r any idea for that...

thanks in advance!!!

N a v a n e e t h29-Jan-09 5:29

N a v a n e e t h

29-Jan-09 5:29

Look at the classes in System.Data.OracleClient[^] namespace. If you need more, download ODP.NET from oracle website.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Giorgi Dalakishvili29-Jan-09 5:29

Giorgi Dalakishvili

29-Jan-09 5:29

1. Learn how to write.
2. Read the documentation.
3. Ask for a hint, not for source code.

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

sridhar88729-Jan-09 18:15

sridhar887

29-Jan-09 18:15

i'm extremely sorry 4 askin de source code... i don no how to ask ma doubt so i jus typed tat... thank u very much 4 ur guidance... i want to know how to connect oracle 10g database with c#.net...

thanks in advance!!!

musefan29-Jan-09 5:31