|
I am working on a project to design database system of a library using oracle as backhand and c# as forehand but i don't know commands to connect
c# form with oracle database.
kindly send me command lines.
|
|
|
|
|
Read this[^]
Be careful, there is no Undo Button(Ctrl+Z) in life.
|
|
|
|
|
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 - I guess thats why they always turn to CP lol
|
|
|
|
|
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. 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.
|
|
|
|
|
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
|
|
|
|
|
|
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;"
|
|
|
|
|
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.....
|
|
|
|
|
|
Find somebody who has them, bop him on the head, take the papers.
|
|
|
|
|
(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
|
|
|
|
|
Yeah, yours worked and mine does some times.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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 ?
|
|
|
|
|
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.
|
|
|
|
|
Thanks. It works.
|
|
|
|
|
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!!!
|
|
|
|
|
|
1. Learn how to write.
2. Read the documentation.
3. Ask for a hint, not for source code.
|
|
|
|
|
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!!!
|
|
|
|
|
|
Believe me, some of us hate txtspk more!
|
|
|
|