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.