dataGridView - Windows Forms

[DaveRook]

Hi

I have an empty windowsForm in Visual C# 2008 Express.

I drop a dataGridView and expand the otpions (the little play button which opens the dataGridView tasks) so I can choose a datasource. I click Choose Data Source -> Add project Data Source

I then click Database.

I click New Connection.

Under the Data Source options (click Change to show list), SQL server is not listed! Although I have SQL installed on the machine.

I repeat this process on another machine and I do have the SQL server option.

What have I done wrong?

Dave

[Aimee Bailey]

May I ask what version of SQL Server your using?

[Christian Binder]

Maybe you haven't started your sql server?
You can start it via command-line

net start mssql$sqlexpress

where sqlexpress qould be the instance name of your sql-server.

Alternatively you can start your sql server by right-clicking on Computer - Manage - Services (or sth like this)

Another thing is, that you haven't Shared Memory Protocol enabled.
This could be found at services-management within the SQL Server Configuration-node - Protocols

[Christian Binder]

Sorry, I think I've got it wrong!
I skipped, that you're not even having the SQL Server option.

But I've found this, which states that Visual Studio 2008 Express Editions doesn't support SQL Server Data Designer.
But you should be able to create a Data-Connection without a designer.

[DaveRook]

Thank you so much ChBinder. Guess I need to buy the full version! I had searched for the answer in Google so I wasn't being lazy by posting.

Thank you for your help

Dave