Fetching Data from DATABASE in spread sheet form - SQL Server 2008

Steps:

1. Database Connection using DOT.NET
2. Write Query
3. Getting data in Spreadsheet form

Open you project in Visual Studio 

Click on SERVER EXPLORER and right click on DATA CONNECTION and select ADD CONNECTION in your running project

Open SQL Server 2008 and copy highlighted string

Paste COPPED string at point A, point B will become visible. 

Select Specific database from there.

I am working on gang war game so I am going to select GANG WAR GAME database

Then click OK

Select “FORM” where you want to display data in spread sheet from SQL Server 2008.

Select “DATA GRID VIEW” from ToolBox and place it on form.

Select dropdown menu where (none) has been written then select “ADD PROJECT DATA SOURCE” then click “DATABASE” and click “NEXT”

Then Select “NEXT” again

At point A there is our database which we are going to add

You can change your database using “NEW CONNECTION”

When you click on point B “+” button connection string will be shown up

Click “NEXT”

Above screen been shown up. Click “NEXT”

After that above window will be appear. Select (TICK) “TABLES” because you are going to insert TABLES. And click “FINISH”

After that all table can easily be seen. Select desired table at point B and then you can view all data at point A