Connect to MS SQL 2000

[daimous]

hi! can anybody please help me on how to connect to MS SQL 2000 DB? can you please give me an example..or just give me a link for a tutorials? thanks in advanace!

[jmcilhinney]

There are numerous tutorials in my signature. The ADO.NET tutes use VB code examples but you can use one of the code converters in my sig if you like. All the principles are exactly the same in C#. You may also like to visit www.connectionstrings.com to get the appropriate format for the connection string.

[daimous]

ah ok...thanks for that..but can i have more inputs..thanks!

[jmcilhinney]

You mean can someone give you the code to do it? Connecting to a database is simple:

System.Data.SqlClient.SqlConnection myConnection = new System.Data.SqlClient.SqlConnection("connection string here");

myConnection.Open();

To do anything useful with that connection you need to understand at least the basics of ADO.NET and SQL. There are tutorials in my signature on those topics.

[daimous]

not actually the code...something that my mind, my mouth and my fingers can work with

[Hack]

not actually the code...something that my mind, my mouth and my fingers can work with

Beyond what jmcilhinney has already provided, plus the links in his signature, I'm not sure what else you might be after.

[daimous]

ok thanks!!