Showing posts with label HOW TO CREATE DATA BASE IN VISUAL STUDIO 2010. Show all posts
Showing posts with label HOW TO CREATE DATA BASE IN VISUAL STUDIO 2010. Show all posts

Sunday, 12 May 2013

HOW TO CREATE DATA BASE IN VISUAL STUDIO 2010

HOW TO CREATE DATA BASE  IN VISUAL STUDIO 2010 

STEPS TO CREATE DATABASE: 


Visual Studio 2010 :  This is the start page  for Visual Studio 2010  Professional 



CLICK ON VIEW => CLICK ON SERVER EXPLORER (IS TO MANAGE DATABASES )




RIGHT CLICK ON DATA CONNECTION  => CLICK ON CREATE NEW SQL SERVER DATABASE 





 A new window will  appear : Create New SQL Server  Database



GIVE NAME TO SERVER /GIVE INSTANCE NAME => USE SQL SERVER  AUTHENTICATION => USER NAME :SA PASSWORD : GIVE SOME PASSWORD => NEW DATABASE NAME : GIVE ANY  => OK 






IN SERVER EXPLORER  YOU WILL SEE A NEW DATABASE IS CREATED WITH TEST DATABASE NAME  WHICH INCLUDES FURTHER FILES  AS SHOWN BELOW.