how does it work when i have a data grid that i want page able and sortable, do i use view state? does the data get pulled once and then the view state keeps all the data and grid working, sortable, page able? or do i need to go to the db server each time i page and sort?
View 2 RepliesI have a datagrid and a template column which is bound. I don't understand how to set the sortExpression to make sorting on that column work.
View 2 RepliesI have 5 bound columns to be retrieved from the database but I want that on page load event the retrieval of data should be sorted according to that column only
View 1 Repliesin my page_load method I call a mthod that it create some dynamic controls. one of them is an Image control that it's ImageURL property set to an URL that is saved in data base. image shows that URL but when postback ocuurs, previous image controls doesn't their image. but other controls for example TextBoxes keep text values. what should I do for keep image url property for this dynamic Images controls?
View 3 Repliesis it possible to disable sorting on specific columns? 5 out of 7 columns have to be sortable, two not sortable. The columns are created dynamically in code behind, so I think doing this with mark up is out of the question. When I say disabled, I'm hoping that the underline wont show on the column header when you mouse over it.
View 1 RepliesI have a datagrid that is displaying data that is being returned from a stored procedure. That works fine. The problem is that I want to do sorting. I know that there is sorting functionality in the grid, however, I don't want to go back to the server and get a new set of data. What I want to do is just re-sort the data that is already being displayed.
Basically, I couldn't not find an easy solution to this issue. I tried updating my dataGrid to a gridView control and even that (for my particular issue) was difficult. I wound up un-doing all the changes and just adding another grid that had just the data I wanted for the requirement. If anyone else has an issue like this I would recommend taking it out of a datagrid and writing it in jQuery. I could of written a table that had the data I wanted (and fully sortable using a plug-in mentioned below) in 15 minutes compared to the hours I spent trying to jam a square peg into a round hole.
I have a datagrid with some data in three datacolumns. I have to apply sorting to two of the datacolumns. Is it possible without any datasource..
View 2 Replieswhat I am trying to do;I want it so that when the user clicks on the datagrid column headers to sort the records, or when they go to page the datagrid, that a confirmation pop-up appears first, confirming that their changes are going to be lost (unless they click "Cancel").I have the confirmation pop-up scripted in Javascript and is added to the controls on the page using
[Code]....
How do I attach this to a datagrid header and to the pager?Do the columns need to be Template columns and the header text being hyperlink? If so, how do I set it up so it will, if the user clicks "OK" in the confirmation pop-up, still sort?
I have my data grid and sort on a column but the row formatting stops working. I simply selected a format using the autoformat option and picked classic. Am I meant to reapply the row formatting after the sort? And if so how?
View 1 Repliescan i implement multiple column sorting in an ASP.NET DataGrid.Datagrid contains Template columns.
View 5 RepliesI have tried several different approaches .SOMEONE PLEASE sow me how to sort on template field with a calculated value.Basically i have half the data i need in the DB and the other half comes from textbox1.textI take the text in textbox1 and pass it along with a value from the DB (Orig) to a function that returns miles.
[Code]....
Whit the above method everything displays correctly but i cannot sort on that column .I also tried using the miles() function in my select statement for my datasource but that was a nightmare and couldn't get that to work i either got "undeclared function "miles()" or when i fixed that i got "orig" not declared.Sorry code is so jumbled , entire code is below:
[Code]....
Would it be possible to do Sorting and Paging in a DataGrid, My dataGrid is place inside an asp:wizard which is inside an Update Panel.
[Code]....
I have a datagrid with two columns ( File Name, and Date Created ). I want them to be sorted when clicked (ASC or DESC). I went into the design view and added the allow sorting feature and added the column names, so they are clickable in the header of the data grid. I also already added the onsortcommand as well.
My datagrid is named dgFileList and the onsortcommand method is named dgFileList_SortCommand.
The procedure that is already loading on page load is a DataSet. (where I think my problem is)I dont have anything in the back end beside the dgFileList_Sortcommand method. From what I have read, it seems like I can't use a DataSet to be sorted...I'm using visual studios 2005, C#, not VB.
I have a Gridview thats is working just fine, but when i click the sort header link, nothing happens !?? it will not sort the data by Desc or Asc
Main grid_view code
Code:
<asp:GridView ID="MySource" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataKeyNames="email_id" AllowPaging="True" emptydatatext="Ingen Data tilgngelig." allowsorting="true" EnableViewState="False" OnSorting="MySource_Sorting"
onRowDataBound="myGridView_RowDataBound">
[code]...
I am having a gridview with an object datasource binded in the markup(aspx page).When page loads it directly works fine with all sorting and paging properties.However, i need to filter display on gridview so i have to change the datasource of the gridview on the code behindIt works fine.. i mean the filtering and displaying is good but paging and sorting doesnt work.
View 1 Replies[Code]....
I have tryed this sorting code here in first post http://forums.asp.net/t/956540.aspx but it doesnt work. any tips?
I have a gridview and a drop down filter on the same page. The dropdown code :
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList2.SelectedValue == "LineManager")
{
ApproversListDB.FilterExpression = "Approver = '{0}'";
ApproversListDB.FilterParameters.Add("@Approver", strAccount);
}
else if (DropDownList2.SelectedValue == "AssignmentManager")
{
ApproversListDB.FilterExpression = "AssignmentApprover = '{0}'";
ApproversListDB.FilterParameters.Add("@AssignmentApprover", strAccount);
//ApproversListDB.FilterExpression = "AssignmentApprover=" + userid;
}
}
This filter / dropdown works fine....apart from if anyone sorts or pages the grid in which case it looses the filter expression. I have looked at a few examples on the web and cant get my head round it (ie
[URL]
PS I connect my grid to the following datasource using the GUI - ie nothing databinding in the code behind apart from page refresh
<asp:SqlDataSource ID="ApproversListDB" runat="server"
ConnectionString="<%$ ConnectionStrings:PDRConnect %>"
SelectCommand="p_PDRsForMyApprovalTable"
ProviderName="<%$ ConnectionStrings:PDRConnect.ProviderName %>"
SelectCommandType="StoredProcedure">
<SelectParameters>
<custom:UserNameParameter Name="userName" />
</SelectParameters>
</asp:SqlDataSource>
I am using a following code for paging.
[Code]....
In my controller, I have the following code
[Code]....
Now, how should I do routing. Current routing with no sorting support is
[Code]....
I am having a ASP.net application it having three pages ,page 1,page 2,page 3,when the user navigating between this pages I want to maintain the view state in page level after postbacks(i.e.) .If a user visits page 3, passing some query loads some data .then he moves to page 1 doing some entries .after that he once again moves to page 3 now I want to display the data previously available at the time he moves to page 1, same
way I want to do to my three pages up to the user logging out.
i have one method which save datatable in viewstate.i am calling this method in. page_load2. Prerenderthe page was every heavy,i did tracing of page i found due to calling of method from preprnder it doubled the viewstate sizewhat was the reseon behind this.
View 2 RepliesSplit view and design view doesn't work.I installed and uninstalled Office 2003 and 2007 once but there's no office in my computer now.-I have Microsoft Studio Web Authoring Component installed.(12.0.4518.1066)(Uninstalled and installed it twice)-My computer-properties-Advenced system settings-environment variables-system variables-path is;
[code]...
What is the problem,how can i fix it? I tried everything in other posts.
I got here a answer to sort the gridview. sorting and paging with gridview asp.net But using the above solution all the grid data sorted while clicking on the any column. I request a solution which sorts data on the particular page only. Suppose I have 10 pages with 50 records each page, now if I visit page 7 and sort then the only 50 records of the page 7 should be sorted.
View 1 RepliesHow can I accomplish gridview sorting in client browser using javascript ? without using inbuilt gridview sorting method. I really dont want the gridview to go to the DB each time while sorting.
View 1 RepliesI know the basic of view state. But I dont understand the functionality of view state at a control. For example, a texbox has a property view state. what is the purpose ? what it wiil act for true or false value.
View 3 RepliesI have two radio button list:
*1* report views -- 4 options -- NOT in updatepanel
*2* pagination views -- 2 options -- IS in updatepanel
The situation goes as follows: Refresh WORKS in default setting but when I select *2* radio button options and refresh the page renders the state that the (1) was entered in.
Example: () are the radio buttons
Report Viewing: () (x) () () Pagination View: (x) () REFRESH works!
Report Viewing: () (x) () () Pagination View: () (x) REFRESH fails to display Report Viewing: () (x) () () Pagination View: (x) ()
Report Viewing: () (x) () () Pagination View: (x) () REFRESH works!
OR: () are the radio buttons
Report Viewing: () () (x) () Pagination View: () (x) REFRESH works
Report Viewing: () () (x) () Pagination View: (x) () REFRESH fails to display Report Viewing: () (x) () () Pagination View: () (x)
Report Viewing: () () (x) () Pagination View: () (x) REFRESH works
I am using the session variable to hold the Pagination Viewing option but during page states, I've noticed that when a 2nd option is selected of *2* radio buttons (doesn't matter of 1st or 2nd option was initially selected) that during debugging mode the step over corrects the issue but not the right table viewing. Upon entering Page_Init selection selection index of radio button list returns to 1st option.