Re: Intearact with DB ? - C# Discussion Boards

Hum Dum10-Feb-11 23:52

Hum Dum

10-Feb-11 23:52

I am not specific to sql only !

What i want to know without using Oledb, Odbc, Sql, SqlClient namespace
Is it possible to interact with DB ?

Now don't tell you can create your own library from scratch like fraework have D'Oh! | :doh:

May be i am asking worng ? ( As i don't exactly recall ? )

But it is something like same as my initial post Confused | :confused:

PIEBALDconsult11-Feb-11 0:15

11-Feb-11 0:15

Hum Dum wrote:
May be i am asking worng ?

Pretty much.

ADO.net relies on derived versions of Connection, Command, and other sundry classes. Each database -- Sql Server, Oracle, MySql, Ingres, Firebird, Cache, etc. -- has its particular classes in some namespace; if you want to use ADO.net, you will need to use the classes in the appropriate namespace.

Or use something (e.g. Linq) that hides the ADO.net so you don't see it even though you're using it.

Or don't use ADO.net -- you can use older database access techniques, but ADO.net is far superior to any others I have used.

PIEBALDconsult10-Feb-11 23:28

10-Feb-11 23:28

Sounds like a test question.

Certainly you can do without CommandBuilder, but ADO.net requires a Command, even if it's buried in a DataAdapter.

Hum Dum10-Feb-11 23:57

Hum Dum

10-Feb-11 23:57

PIEBALDconsult wrote:
Sounds like a test question.

Yup it is !

PIEBALDconsult wrote:
even if it's buried in a DataAdapter.

That i know (and is my intial thought) also Odbc, Oledb namespaces.

But without all these namspaces.
Is there any way ?

PIEBALDconsult11-Feb-11 0:17

11-Feb-11 0:17

Hum Dum wrote:
But without all these namspaces.
Is there any way ?

How do you think we did it before ADO.net came along (and lifted us from the dark ages)?

Pete O'Hanlon11-Feb-11 0:24

Pete O'Hanlon

11-Feb-11 0:24

I don't know about you, but I sacrificed chickens and did the hoodoo dance.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

PIEBALDconsult11-Feb-11 0:39

11-Feb-11 0:39

Ah, PRO*C, I did that too.

Pete O'Hanlon11-Feb-11 0:23

Pete O'Hanlon

11-Feb-11 0:23

Hum Dum wrote:
But without all these namspaces.
Is there any way ?

Well, you could always write your own protocol but that's time consuming, prone to errors and a bit, how shall I put it, boneheaded stupid.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Rajesh R Subramanian11-Feb-11 0:28

Rajesh R Subramanian

11-Feb-11 0:28

Hum Dum wrote:
But without all these namspaces.Is there any way ?

Those namespaces exist to serve you that very purpose. If you don't want to use any of those, AND you don't want to write your own stuff from scratch, then the only way is to p/invoke into the beast and use one of the things it has to offer.

Then it would be pointless to use .NET.

"Real men drive manual transmission" - Rajesh.

Eddy Vluggen11-Feb-11 0:28

Eddy Vluggen

11-Feb-11 0:28

Hum Dum wrote:
Without using SqlCommand or CommandBuilder object,

Is it possible to interact with database?

Yes, by capturing the output of SQLCMD/Isql.exe for example.

I are Troll Suspicious | :suss:

PIEBALDconsult11-Feb-11 0:33

11-Feb-11 0:33

I hadn't thought of that. MySql also has a command-line utility.

Pete O'Hanlon11-Feb-11 0:41

Pete O'Hanlon

11-Feb-11 0:41

So does 'orrible.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

get host name from Ip address

OriginalGriff11-Feb-11 2:47

OriginalGriff

11-Feb-11 2:47

You could use LINQ to SQL[^]

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."

Anubhava Dimri10-Feb-11 21:09

Anubhava Dimri

10-Feb-11 21:09

Hello everybody,

i have an ip address. Now how can i get it's host name.

Thanks

If you can think then I Can.

Rajesh R Subramanian10-Feb-11 21:16

Rajesh R Subramanian

10-Feb-11 21:16

DNS.GetHostByAddress[^].

FYI - C# is not my primary competency. No prizes for guessing how did I find an answer. Roll eyes | :rolleyes:

"Real men drive manual transmission" - Rajesh.

Abhinav S10-Feb-11 22:01

Abhinav S

10-Feb-11 22:01

Precise answer.
Smile | :)

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

My latest tip/trick

Nuri Ismail10-Feb-11 21:19

Nuri Ismail

10-Feb-11 21:19

You can use:

- Dns.GetHostEntry[^]
- Dns.GetHostByAddress[^]

The second method is obsolete and using the first alternative is recommended but you will see these details in documentation. Smile | :)

PIEBALDconsult11-Feb-11 0:23

Control input and output of one software?

11-Feb-11 0:23

If it's your address wouldn't it be your name? Confused | :confused:

dnqhung10-Feb-11 19:43

dnqhung

10-Feb-11 19:43

Dear all,

I'm looking for a method to control the input to one software from my code and receive the output of that software to use in my code. Some one call that is intergrating one software to another software. For example, I want to control the text input to TextAloud (using to convert text to human's voice). Anyone know about that?

Thanks in advance.
Best regards.

dnqhung

Rajesh R Subramanian10-Feb-11 21:27

Rajesh R Subramanian

10-Feb-11 21:27

dnqhung wrote:
Some one call that is intergrating one software to another software.

It's called Automation in South Asia. Smile | :)

dnqhung wrote:
For example, I want to control the text input to TextAloud (using to convert text to human's voice). Anyone know about that?

You'll have a better chance of doing this with programs that are built with automation support in mind from the beginning. In which case, you could use the interfaces for automation exposed by the program.

In other cases, you could write code that generates events like mouse click, key presses, read the values of controls, etc., by writing code. This technique may or may not work, depending on the type of the UI you're dealing with.

"Real men drive manual transmission" - Rajesh.

dnqhung11-Feb-11 15:15

dnqhung

11-Feb-11 15:15

Long time ago,i read one similar project in this forum. He intergrated one chat software (may be Window live messenger, i don't remember exactly) in to his application. However in this case, he used COM interface. In my case, how can i write the interface if the software don't support COM interface. Can you explain more about "automation". In my problem, i want to control a software run "underground" (still running when you close it's main window, such as IDM), so how can i write code that generates events like mouse click, key presses, read the values of controls, etc.

dnqhung

PIEBALDconsult11-Feb-11 0:38

11-Feb-11 0:38

Is it a command-line utility? If so, perhaps you would be interested in my ProcessCommunicator[^].