How do I change the Data source into Microsoft SQL Server in Visual C#?

Question

I was using this tutorial and I'm stuck in this part. The guide tells me to choose 'Microsoft SQL Server', however this is not included in the options of my computer. I only have 'Microsoft Database File', 'Microsoft Server Compact', and 'Microsoft Database Server File'.

How could I add the option 'Microsoft SQL Server'?

I'm using Microsoft Visual C# 2010 Express – Afungus Nov 08 '12 at 14:33 — Afungus, Nov 08 '12 at 14:33

score 1 · Answer 1 · edited May 23 '17 at 11:43

1

I don't think the express version can natively connect to SQL server. I can't seem to find any documentation on this, but if I recall correctly it was one of the reasons we switched to pro way back when. Anyways, perhaps this post will help: How to connect Visual Studio 2010 Express C# to SQL Server Express

edited May 23 '17 at 11:43

Community

1
1

answered Nov 08 '12 at 14:52

Robert H

11,520
18
68
110

score 1 · Answer 2 · answered Nov 09 '12 at 04:47

If yours is a web application, then you can do it the way its shown in your tutorial,

but if yours is a Winforms of WPF application you can't do it with Visual Studio Express..

There are other ways to connect using SqlConnection, SqlCommand objects etc, which are not design time..you can use them however..

Thangamani Palanisamy · Answer 3 · 2012-11-09T04:18:03.040

0

please select option other from that part and then select ".NET Framework Data Provider for SQL Server" from that list. please try let me know

edited Nov 09 '12 at 04:18

answered Nov 08 '12 at 14:36

Thangamani Palanisamy

5,152
4
32
39

I don't have the 'other' option too. – Afungus Nov 08 '12 at 14:39
Since you are visual studio express 2010, you might not have that option. Please install the VS2010 professional after downloading from the internet – Thangamani Palanisamy Nov 09 '12 at 04:14

score 0 · Answer 4 · answered Nov 08 '12 at 18:28

0

maybe you are missing some component try to download http://www.microsoft.com/web/downloads/platform.aspx

answered Nov 08 '12 at 18:28

How do I change the Data source into Microsoft SQL Server in Visual C#?

4 Answers4