[darek9576]

I have VS Express and Visual Web Developer Express.

Now, when i want to add a database to my project in VS i have following options in the data source drop down list:

Microsoft SQL Server Database File (SqlClient)
Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5)

When, i want to add a database to project in Web Developer i have following options as the data source:

Microsoft SQL Server (SqlClient)
Microsoft Access Database File (OLE DB)
Microsoft SQL Server Database File (SqlClient)
Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5)

Now, the thing is: that i have my database created in sql mangement studio and i have no problem in adding it in the Web Developer by choosing Microsoft SQL Server as Data source and then i pick the server name and its done!

However, in Visual Studio, i do NOT have the Microsoft SQL Server as the data source in the drop down list so i cant add the database.

Now my question: can anyone tell me how i can add the Microsoft SQL Server as the data source to the Visual Studio???
I have been trying to solve it for the last 2 hours and im struggling big time.
Thanks for any suggestions.

[eclipsed4utoo]

Personally, I never explicitly add my SQL Server databases to my projects in Visual Studio. If you are using SQL Server that is running as a service, you can simply use a connection string to connect to it.

[darek9576]

And how could i achieve that?

[eclipsed4utoo]

There are a number of tutorials on this site that deal with databases. You should really check out our Tutorial section.