How can we connect SQL server with visual studio

How can we connect SQL server with visual studio

Make connection from SQL server to the visual studio in this article we will make connection with visual studio from SQL server so one thing in this all course we will use SQL server 2012 and visual studio 2012.
And in this article we connect SQL server with visual studio through design and on after this article in another step we will connect SQL server with visual studio through code and we will use GridView formview listview.

To complete this we will use step for example in step one we open visual studio
1. Step one go to start menu>all program>visual studio and open it.
2. Step two create new website from left top corner in file menu new website.
3. Step three in solution explorer right click on website add new item and add new webform.
4. Step four Open toolbox in this expand data and drag and drop gridview in to design or in html.
5. Step five click on the right top corner of Gridview a little expand arrow chose new datasource from there and follow the instruction to make a connetion.
6. Step six click on next some times when connection come then select new connection.
7. Step seven give your server name its mean your computer name/SQL username for example <jhon-pc\cina> and then select the SQL authentication give your username and password and chose a database from SQL server and then press connect button and then next it some more time from there and finsh.
8. And in the last step go to standard toolbar and press the run and your data will be list on gridview.
For more information watch the video Bellow: