Click here to Skip to main content
12,065,721 members (35,056 online)
Rate this:
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
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)

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