Please help me - newbie pulling from a DB

[Al Murphy]

Folks,


Can you help me please? I would greatly appreciate any
assistance/comments/help that you may be able to lend me on this one.
All information much
I've been given a heads up on a wee project that a person want me to
build. He needs an query support tool (written in C#) with the ability
to be able to query a SQL Server 2000 database. It doesnlt haveto be
brilliant. Problem is though I am unfamiliar with with C# but have
strong SQL.

Can you explain in generic terms how to do the following please (in
C#):


1. Open a connection to a MS SQL Server (assuming access to the DB -
name, password etc...)

2. In general how do you run a query against said DB in 1

3. How do you return said results of the DB query in 2 and output to a
basic window on the screen


While I realise that this may seem like an entire topic in itself but
all I need is starter code to point me in the right direction. It
doesn't have to be specific - generically written is just fine. Or,
failing that, can you recommend a good article that can get person
pulling from a DB quickly. I need results quick...

Thanks a million,
Al.

 

[Hayato Iriumi]

This should get you started.

http://samples.gotdotnet.com/quickstart/winforms/

============================
Hayato Iriumi ([email protected])
Blog: http://www.vbaspcoder.com

 

[Jeff Louie]

Al.. You can copy the GUI design of a working tool at

http://www.geocities.com/jeff_louie/SQLQuery.htm

Unfortunately it is written in Objective-C.

Regards,
Jeff

 

[Hayato Iriumi]

Why are you giving this guy object-c sample? This is C# news group and
shouldn't we assume that this person want to learn .NET technology? Not
that I'm against Mac or anything (I personally have Mac OS X at home)...