using data connection from server explorer in c#

Question

I use data connections to connect to a SQL Server 2008 Database. I search the web to know how to open, close and do queries (CRUD) but I found nothing.

enter image description here

In a first time, I would open a connection. I am stuck because I don't know how to get my connection "object" and use it in C# code.

Here is the begining of my code :

SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Connection"].ConnectionString);

Thanks in advance !

Is it me or did you forgot to add the code beneath: 'Here is the begining of my code:' — Dave, Nov 19 '14 at 13:20

score 3 · Answer 1 · answered Nov 19 '14 at 13:20

3

You do not. This explorer is a developer tool to use in visual studio. It has no resemblance at all to what you do in your C# code.

answered Nov 19 '14 at 13:20

TomTom

61,059
10
88
148

score 3 · Accepted Answer · edited Nov 19 '14 at 13:39

3

You can't use the database from the Server Manager. Instead include the database in your Solution Explorer. However you will still need the database to be in the Server Manager in order to use it in your Solution Explorer. You can add it to your Solution Explorer by right clicking on Solution Explorer and go to add -> new item.

edited Nov 19 '14 at 13:39

J. Steen

15,470
15
56
63

answered Nov 19 '14 at 13:33

Dave

434
5
22

1

You can get the full correct connection string by right-clicking your project in the Solution Explorer, the selecting add -> new item -> ADO.NET Entity Data Model -> EF Designer from data... . The next screen shows the connection string used. – Fuzzy Analysis Apr 14 '19 at 08:27

using data connection from server explorer in c#

2 Answers2