how to use sql sever 2005

Question

how to use sql sever 2005

umbelgul

SSC Rookie

Points: 25
More actions
March 22, 2010 at 1:11 am

#212854

hi!!
connectivity of sql server 2005 with c#.net/vb.net,i need its code.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398881 More actions · Answer 1

That's a pretty big topic for a web post. You might want to try tracking down a few books. Here's some information to get you started from MSDN.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

tyson.price SSCrazy Points: 2093 More actions · Answer 2

umbelgul (3/22/2010)
hi!!
i am new to sql server 2005 ,but dnt know how to use,any one can guide me from scratch. i want to use sql server 2005 with visual studio using c#.plz guide me.

There is a “SQL with SQL Server” section here:

http://www.functionx.com/vbnet/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

I would start by finding some books. Narrow down the topic by picking a few specific things you want to learn - and then find the answers.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Uripedes Pants Hall of Fame Points: 3701 More actions · Answer 4

installation of the software is just like any other - if autorun doesn't start it, find the setup.exe and double-click. Follow the prompts. This will give a default setup and allow you to start playing.. er.. learning... After that, a beginning book on C# DB apps and hang out in the forum for SQL tips, Google "sql server 2005 best practices", etc. As someone else said, HUGE topic for a simple answer.

good luck!

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 5

hmmm check it out.

http://sql-articles.com/articles/dba/installing-sql-server-2005

Regards..Vidhya Sagar
SQL-Articles

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 6

Search for Installation Guide lines for SQL Server 2005. U may get the links & PDFs or Word Docs from which you can get how to install step by step pictorial view.

OTF SSCertifiable Points: 6104 More actions · Answer 7

If you just need a Sql Express backend for some C# development then there isn't a great deal to it. Infact, I think the Express Version of Sql Server is installed as an option with Visual Studio (well, at least for C#/VB Express).

On the other hand, if you are planning to install to Production Servers etc. then you will certainly want to look at some of the material suggested above.