Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Linux
how to connect to database in c# and sql server
Posted 6-Nov-10 0:32am
Comments
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
good
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[^]
  Permalink  
Rate this: bad
good
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);
 
conn.Open();
 
SqlDataReader dr = cmd.ExecuteReader();
 
while(dr.Read())
{
     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"]);
}
 
conn.Close();
 
  Permalink  
Comments
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 OriginalGriff 200
1 Kamal Rocks 184
2 PIEBALDconsult 150
3 BillWoodruff 148
4 Jochen Arndt 135
0 OriginalGriff 5,695
1 DamithSL 4,506
2 Maciej Los 4,007
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,190


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 15 Mar 2013
Copyright © CodeProject, 1999-2014
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