protected void ExpExcel_Click(object sender, EventArgs e)
{
foreach (GridColumn col in RadGrid1.MasterTableView.Columns)
{
if (col.UniqueName.Contains("notes") || (col.UniqueName.Contains("EditCommandColumn")) ||
(col.UniqueName.Contains("column1")))
{
col.Display = false;
}
else
{
col.Display = true;
}
}
foreach (GridFilteringItem item in RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem))
item.Visible = false;
RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.MasterTableView.ExportToExcel();
}
Hi There
I have a situation in which I have grid with numeric column on the web page and I have a numeric column on the web page as well.
I would like to compare the sum of all the grid numeric column values with the value of numeric column on the web page.
For example I have a value of 10,000 on the numeric column on the page and I have four records in the grid with the value 1000, 2000, 4000,2500 total=9500 which is less than 10,000 the value of my numeric column on the web page
And I am going to edit the fourth record (using Edit form mode) with the value say 5000 from 2500. Now the total value is greater than 10000 so I would like to warn my user using client side Java script and put the focus back again inside the grid numeric column so that he can change the value so that the value should not be greater than 10,000
So I would like to know the way how to calculate the total of particular numeric column of all rows including the edited row using Java script on focus out or on update client side event
In short I need to find a way to loop through all the rows including the one I am editing on the client side
Your help will be much appreciated
Many thanks
Syed