Retriving the values from Sql to datagridview C#

See more:

C#3.0

C#

Hi,
I'm working in C# windows application.I have upload a file from Excel (which has 8 rows) to C# and from C# to Sql server.Now i need to retrieve the datas from Sqlserver to C#.I'm working on Generalization,Bucketization and Slicing Process.For Generalization process First Four rows should retrive in Datagridview1 and Last 4 rows in Datagridview2.When retriving the datas one column fully should view in * method.For bucketization process column name should change which i have created like Name,Age,Sex,Education,Marital status.But in this process it should retrive like Name,Maritalstatus,Sex,Age like this the table should view.In Slicing process both datagridview1 and datagridview2 view like one columns like Name,Age and in another column Sex,MaritalStatus all the datas t should display all the names nd age.

If u r not getting understand my concept means pl pl see dis video like dis only i should implement:www.youtube.com/watch?v=C885Iw4QKzU


Regards
Balamurugan