How to Create a Database/Connect to a Database in Visual Studio 2010

1.File-> New-> Website->  ASP.NET Web Site(Visual C#) -> Ok

(Now You will see a Default.aspx page. To create your own page->click on dropdown list below Edit->click Add new item->Select Web Form->click Add)

2. Click Solution Explorer(if you didn't see solution explorer click View->Solution Explorer) -> Click Connect to Database(Arrow sign on image)->


 3. Select Data Source to Microsoft SQL Server Database File->make sure Data Provider is selected to .NET Framework Data Provider for SQL Server -> Ok

4.Change Database file name to Your Desired Database name(Here i write Testdatabase)-> Ok(Your Database is created)

































5.Click Solution Explorer-> Double click on Your Database->Your window should look like this.
Here you can create Table,create Database Diagram and many more.

No comments:

Post a Comment