Hi. Friends today we will see that how to create database in visual studio 2012 or 2008 of asp.net C# and how to add table in that database
steps :-
- First one is that we have to create a new web site in the visual studio 2012 or visual studio 2008.Its easy to create just go to File --> New --> Web site OR shortcut key is that SIFT+ALT+N.
- Open Solution Explorer and right click on our website folder and select Add and in this select Add New Item or shortcut key is that CLRT+SHIFT+A.
- And now You get the pop up menu and you have to select SQL Server Database and you have to see that its extension is .mdf
- And click on the OK button and now your database is ready to us
Open Server Explorer and Refresh it. After then right click on the Tables, Select Add New Table.
- Now we see data table we have to fill field and data type and in the code view you have to change table name. And click on Update button (in Visual Studio 2012).
- After click on Update database( in Visual Studio 2012).
- And if you want to add data in data table right click on table and show user data and fill the data and don't save it just close this tab( in Visual Studio 2012).
- And in 2008.Save the data table in the database to press CTRL+S and give a table name (in Visual Studio 2008).
- And if you want to add data in data table right click on table and show user data and fill the data and save it (in Visual Studio 2008).
if You any Query in php or get Example of php click on :- PHP EXAMLE
It is very good.
ReplyDelete