Create Database Table In Visual Studio

> Here we consider how to create a database and table in visual studio.
> Lets start with one example here.
> Suppose we have a web application in visual studio.
> FIrst of all, right click on the project icon and select Add --> New Item
> A new window will appear. From Data section select SQL Server Database.
> Give a suitable name for this mdf file.
> When you click on the Add button, a warning message will come as shown below.



> It says, the database file will be placed under App_Data Folder.
> Now click on Yes Button inside this warning window.
> On Solution explorer, under App_Data Folder, you can see both database files are placed.
> For managing database, double click on .mdf file.
> This will connect Server Explorer to the current database.
> Now right click on Table icon inside Server Explorer.
> And select Add New table.



> Here specify your new table requirement and more columns.
> On each row if you right click, you can select properties window for that column.
> After appending colmns, its time to update to database.
> For that click on update button as shown here.



> Now a window will appear, click on Update database.
> After Successful execution, you can see a message saying Update Completed Successfully.

Watch Video of this Content on Video Steaming