This is a migrated thread and some comments may be shown as answers.

problems with sorting a grid

0 Answers 75 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Henk Jelt
Top achievements
Rank 1
Henk Jelt asked on 06 Jun 2012, 01:57 PM
Hi

I am trying to get all the functions of a Grid operational.
I have two html tables on one page, which have different id's ("resulttable" and "invoicedetails").
Their set-up is the same: a header with <thead> etc </thead> and a bunch of rows populated by looping through a dataset.
Their visibility is exclusive: when resulttable is visible, invoicedetails is not, and vice versa.
For both tables I instantiatie KendoGrid in the same manner:
			$(document).ready(function () {
				$("#resulttable").kendoGrid({
					width: 860,
					groupable: false,
					sortable: false,
					scrollable: false
				});
			});
and
			$(document).ready(function () {
			    $("#invoicedetails").kendoGrid({
					width: 860,
					groupable: false,
					sortable: false,
					scrollable: false
				});
			});


 Now my questions:
I would like to get the grouping operational.
If I set groupable to true for the first table, everything is ok.
However, if I set groupable to true in the second table, two grouping bars appear above my second table, irrespective of the fact that the first table is not visible at all, and that the groupable-attribute of the first table is set to false.
It looks like the second snippet is controlling the first as well.

Has anyone had this issue before, and is there a solution to this?
Probably I am doing something wrong; question is: what?

I would like to get sorting operational.
Both tables are filled by looping through a dataset created by calling a webservice.
I would like to sort the second table, but it looks like it does not do this correctly.
I sort for example a column of prices (formatted as decimal or double or string makes no difference), but it only switches three or four rows out of 20.
What could be a solution to this issue?

The code for "invoicedetails" is:
<table id="invoicedetails">
	<thead>
        <tr>
			<th ><%=Session("formfields")(453) %></th>
			<th ><%= Session("formfields")(958) %></th>
			<th ><%=Session("formfields")(323)%></th>
			<th ><%=Session("formfields")(961) %></th>
			<th ><%=Session("formfields")(348) %></th>
			<th ><%=Session("formfields")(963) %></th>
        </tr>
	</thead>
	<tbody>
	<% iCnt = 0
		Dim strClass As String = ""
		For Each order In getorders.Rows
			Dim totalex As Decimal = order("nrprod") * order("unitprice")
			totalex = thisorder.round(totalex, 2)
			Dim totalin As Decimal = thisorder.round(totalex * (100 + order("vatperc")) / 100, 2)
			Dim nrunit As String = ""
			If CInt(order("nrprod")) <> 1 Then
				nrunit = order("nrprod").ToString
			End If%>
			<tr >
				<td ><a href="<%: Url.Action(targetaction, targetcontroller, New With {.id = ViewData("functionid"), .roleid = Session("roleid"), .invoicenr=session("invoicenr")}, Nothing) %>"><%=order("invnr"%></a></td>
				<td ><%=order("invline"%></td>
				<td  ><%= order("invdate")%></td>
				<td><%=totalex  %></td>
				<td ><%=order("vatperc")  %>%</td>
				<td ><%=totalin %></td>
			</tr>
			<%iCnt = iCnt + 1
		Next %>   
	</tbody>
</table>


Any help is appreciated!

KR

Henk Jelt



No answers yet. Maybe you can help?

Tags
Grid
Asked by
Henk Jelt
Top achievements
Rank 1
Share this question
or