Loading

How to create a SQL Server database in Visual Studio.NET ?

Tommy

14y1.8k.NET

Guys:

I've had difficulties creating a SQL Server database in Visual Studio.

Under "Server Explorer", I right-clicked on "Data Connections" and chose "Add Connection".

In the wizard that appeared, I selected Microsoft SQL Server and clicked continue.

In the Add Connection wizard that follows, should I enter "localhost" for Server name because I'm connecting to my local machine and IIS is already part of my Visual Studio.NET ?

Any idea ?

Thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs14y ago
Is it SQL Server Expresss? If so then the server name is not obvious. I think you can use ".\sqlexpress" for the server name for a SQL Server Express server. The "." indicates the local system. For the Provider property tab, try "SQL Server Native Client".

There are many articles in this web site that can help. Look at my Database Table Update in a DataGridView without Writing Code; it shows one way to easily work with a table.
Senthilkumar14y ago
Hi,

Click on Server explorer
Right click on the Data Connections
Click on Create new sql server database
The server name may not display in the drop down list, enter manually (Try to get the sql server name from the origianl sql server connection window)
Select authentication
Enter the database name
Click on Ok