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
– Dave, Commented Nov 19, 2014 at 13:20

J. Steen · Accepted Answer · 2014-11-19 13:39:06Z

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, 2014 at 13:39

J. Steen

15.6k15 gold badges59 silver badges64 bronze badges

answered Nov 19, 2014 at 13:33

Dave

4345 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fuzzy Analysis Over a year ago

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.

TomTom · Accepted Answer · 2014-11-19 13:20:21Z

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, 2014 at 13:20

TomTom

62.4k11 gold badges95 silver badges152 bronze badges

Collectives™ on Stack Overflow

using data connection from server explorer in c#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related