Click here to Skip to main content
11,708,116 members (68,209 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: Linux
how to connect to database in c# and sql server
Posted 5-Nov-10 23:32pm
Rajesh Puli at 8-Nov-10 4:14am
You are asking a C#, Sql Server Question .., You tagged it as Linux., Read the Guidelines before posting Question, to get the Correct Answer..
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

As an absolute minimum, construct an SqlConnection object and Open it. You can then attach that to an SqlCommand before using the ExecuteReader method.
The exact syntax you use will depend on your database: have a look at the MSDN examples Here[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

You need an SqlConnection, SqlCommand, SqlDataReader (you can use SqlDataReader, but let's keep it simple)

Now in order to connect you have to write the following code

string connectionString = "server=.; uid=Your_SQL_Username; pwd=Your_SQL_Password; database=The_Name_Of_Your_Database";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("select * from tables", conn);
SqlDataReader dr = cmd.ExecuteReader();
     MessageBox.Show(dr[0].ToString()); // The first column of the tables Table
     MessageBox.Show(dr[1].ToString()); // If there are more columns, and so on;
     // You can also store values in a variable.
     // Example int empid = Convert.ToInt16(dr["empid"]);
ThePhantomUpvoter at 15-Mar-13 12:13pm
Do you think that it's possible that in the 3 years since he asked, that he might have already found the answer by now?
H.Brydon at 16-Mar-13 0:34am
That's pretty funny. Honorary +5 for you somewhere soon!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Maciej Los 230
1 Mika Wendelius 180
2 OriginalGriff 168
3 Sergey Alexandrovich Kryukov 145
4 Peter Leow 140
0 OriginalGriff 9,198
1 Sergey Alexandrovich Kryukov 8,562
2 CPallini 5,189
3 Maciej Los 4,921
4 Mika Wendelius 3,856

Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 15 Mar 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100