>Hi all,
> I use vb.net , i have a special case. i want use datagridview DataSource to access right. So i want to make the Datagridview (vertical fields).
>How can i do, thank you .
>
>For example, select a,b,c,d,e,f form Atable.
>
>Atable
>-----------
>a data
>b data
>c data
>d data
>e data
>f data
What database your're using? In SQL Server take a look at PIVOT command, in Access google for 'PIVOT Access'.
If it's not broken, fix it until it is.
My Blog