Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

webgrid.NET grouped columns

Status
Not open for further replies.
cathiec

cathiec

Programmer
Oct 21, 2003
139
IE
I am using the webgrid.NET to display data on a webpage.
I want to use the grouping functionality. The grouped columns is fine with grouping using one particular field from the database but i want to group by two fields in the database and only display one grouping level e.g. to group by first and last name - related fields that will show the same data regarless if one or the other is used.

Here is my HTML:

<GroupedColumns>
<iswebgrid:WebGridGroup SortOrder=&quot;Ascending&quot; ColumnMember=&quot;ACCNT_CODE&quot;></iswebgrid:WebGridGroup>
</GroupedColumns>
<Columns>
<iswebgrid:WebGridColumn DataMember=&quot;ACCNT_CODE&quot; Caption=&quot;ACCOUNT CODE&quot; Name=&quot;ACCNT_CODE&quot; Width=&quot;150px&quot; Visible=&quot;False&quot;></iswebgrid:WebGridColumn>
<iswebgrid:WebGridColumn DataMember=&quot;ACCNT_NAME&quot; Caption=&quot;ACCOUNT NAME&quot; Name=&quot;ACCNT_NAME&quot; Width=&quot;200px&quot;></iswebgrid:WebGridColumn>
<iswebgrid:WebGridColumn DataFormatString=&quot;€###,###,###.00&quot; DataType=&quot;System.Decimal&quot; DataMember=&quot;AMOUNT&quot; Caption=&quot;AMOUNT&quot; Name=&quot;AMOUNT&quot; Width=&quot;100px&quot;></iswebgrid:WebGridColumn>
<iswebgrid:WebGridColumn DataFormatString=&quot;€###,###,###.00&quot; DataType=&quot;System.Double&quot; Caption=&quot;TOTAL&quot; AggregateFunction=&quot;Sum&quot; AllowSorting=&quot;No&quot; Name=&quot;Total&quot; Width=&quot;100px&quot; Bound=&quot;False&quot;></iswebgrid:WebGridColumn>
<iswebgrid:WebGridColumn DataType=&quot;System.DateTime&quot; DataMember=&quot;TRANS_DATE&quot; Caption=&quot;TRANS DATE&quot; Name=&quot;TRANS_DATE&quot; Width=&quot;100px&quot;></iswebgrid:WebGridColumn>
<iswebgrid:WebGridColumn DataMember=&quot;DESCRIPTN&quot; Caption=&quot;DESCRIPTION&quot; Name=&quot;DESCRIPTN&quot; Width=&quot;175px&quot;></iswebgrid:WebGridColumn>
<iswebgrid:WebGridColumn DataMember=&quot;JRNAL_TYPE&quot; Caption=&quot;JOURNAL TYPE&quot; Name=&quot;JRNAL_TYPE&quot; Width=&quot;100px&quot;></iswebgrid:WebGridColumn>
<iswebgrid:WebGridColumn DataMember=&quot;TREFERENCE&quot; Caption=&quot;T REFERENCE&quot; Name=&quot;TREFERENCE&quot; Width=&quot;100px&quot;></iswebgrid:WebGridColumn>
</Columns>
</RootTable>
 
Status
Not open for further replies.

Similar threads

DougP
  • Locked
  • Question
need help with code behind and making a table to format data in straight rows and columns
Replies
1
Views
126
DougP
DougP
BasicBoy
  • Locked
  • Question
Gridview columns
Replies
1
Views
64
jbenson001
jbenson001
DougP
  • Locked
  • Question
asp.net 4.0 vb gridview multi button in columnsl how to tell which button clicked
Replies
17
Views
246
DougP
DougP
taree
  • Locked
  • Question
How to convert rows to columns from the dataset 1
2
Replies
32
Views
534
taree
taree
3587ch
  • Locked
  • Question
Trying to identify money columns in gridview 1
Replies
4
Views
123
jbenson001
jbenson001

Part and Inventory Search

Sponsor

Back
Top