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 - 11 Jul 2006 16:18 GMT
There isn't enough details to give you a solid answer but I would
suggest looking into tablestyles and columnstyles
> Hi
> I am trying to change the way the datagrid looks like
[quoted text clipped - 12 lines]
> Thanks
> Shreelu
shreelu - 12 Jul 2006 05:31 GMT
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
> There isn't enough details to give you a solid answer but I would
> suggest looking into tablestyles and columnstyles
[quoted text clipped - 15 lines]
> > Thanks
> > Shreelu
Joris Zwaenepoel - 12 Jul 2006 07:20 GMT
Maybe the "PropertyGrid" control can be useful for you?
Joris
> Hi
> I am trying to change the way the datagrid looks like
[quoted text clipped - 12 lines]
> Thanks
> Shreelu
barranr - 12 Jul 2006 12:43 GMT
If you are using sqlserver look at creating a pivot table
> Maybe the "PropertyGrid" control can be useful for you?
>
[quoted text clipped - 16 lines]
> > Thanks
> > Shreelu
shreelu - 12 Jul 2006 13:11 GMT
hi
No i am using MySQL ,VB.NET
shreelu
> If you are using sqlserver look at creating a pivot table
>
[quoted text clipped - 18 lines]
> > > Thanks
> > > Shreelu
barranr - 12 Jul 2006 15:14 GMT
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
> hi
> No i am using MySQL ,VB.NET
[quoted text clipped - 22 lines]
> > > > Thanks
> > > > Shreelu