Change Display pattern of Datagrid

[shreelu]

Hi
I am trying to change the way the datagrid looks like
ie, i want to have only two columns one for the column names and the
other for the values of the columns,instead of displaying in a single
row
For Example:
Suppose in Employee table , Iam displaying a single
record from the database in a datagrid , I want to display Employee
name , Employee id , Address, phone No, in a single column and
corresponding values in another column.

Is it possible to change the display pattern as i wanted ,If so pls
help me out

Thanks
Shreelu

 

[rhaazy]

There isn't enough details to give you a solid answer but I would
suggest looking into tablestyles and columnstyles

 

[shreelu]

Hi
By Default Datagrid displays a table in this manner

Employee Name EmployeeID Address phNo
Madhu 124 dsfdsf 4521255
It has 2 rows

I want to display it as

Employee Name Madhu
EmployeeID 124
Address dsfdsf
Phno 4521255

It should have Only 2 columns

Hope u can understand it now
Thanks
Shreelu

 

[Guest]

Maybe the "PropertyGrid" control can be useful for you?

Joris

 

[barranr]

If you are using sqlserver look at creating a pivot table

 

[shreelu]

hi
No i am using MySQL ,VB.NET
shreelu

If you are using sqlserver look at creating a pivot table

 

[barranr]

mysql should have something similar, create an sp, you query
information_schema for table columns, populate a temp table with col
names(as data) and data and fill your dataset and grid.
That will give you the format you need