Click here to Skip to main content
12,998,363 members (58,181 online)
Rate this:
Please Sign up or sign in to vote.
See more:
how to connect to database in c# and sql server
Posted 5-Nov-10 23:32pm
Rajesh Puli 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 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170622.1 | Last Updated 15 Mar 2013
Copyright © CodeProject, 1999-2017
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