Forms Data Controls :: GridView Sorting With AutoGeneration True?
Mar 16, 2011
I have autogeneration of fields enabled. I do all the foramatting and other things in the RowDataBound event.
I query the database and get alot of fields. From those fields i make a new datatable with only my 4-5 fields. Remaining fields are used some where else. I am generating the new table like below:
[Code]....
Now as you can see in the code. If i run the code and enter the gridSorting event then e.SortExpression = [Column Name] whereas i want the original column name like e.SortExpresson = [Column_Name]. How can i achieve this ?
Moderators Note: THIS ISSUE IS BIG FOR ME AND EVEN IF POSSIBLE, GET THE REPLY FROM THE DESIGNER OF GRIDVIEW. I have been looking for him for long. I am really fed up with reviewing a good lot of web pages on how we can possibly customize the gridview to enable sorting and paging. So many sites have listed out a lot of information and so many guidances. But the problem is that one works out fine and the other is a burden. I really feel bad about being given the job of customizing this kind of a gridview which has no user friendly approach to it. Also, this control is rendered without the pager links inside the <tfoot> tag. I have tried the Pear Pager in php. It is that good and easy to use and compared to that, the gridview in asp.net is the worst ever control i have ever tried so far.
1. i can use the images to indicate the sorting direction 2. I can have the custom pager like
[code]
<<Previous 1 2 3 .. 7 Next >>.
[/code]
When i click the next when i am viewing the page at 3 , the pager links should change as
[code]
<<Previous 2 3 4 .. 7 Next >>
[/code]
Kindly look into this type of requirement and firstly tell me whether this is possible with the gridview control. I would like this request even to be escalated to the designers of the gridview control also, so that Microsoft comes out with a reply THAT WORKS and not the kind of stuff like surfing through a lot of links and pages and finally wasting a lot of days precious time and still breaking the head with this useless control. I have spent a lot of time in searching for a perfect way. Not writing a code that is non-standard. I am really serious b'cos I have spent weeks in customizing this control. If I dont get a solid reply atleast now, I am going to generate all the output by HTML content by custom coding.
It took me a little while to figure this out, but the AllowPaging="true" on the FormView seems to be the culprit. I don't have much experience paging from a FormView, but for this requirement the customers wants this kind of UI.I have a FormView with DefaultMode="Edit", which is bound to an EntityDataSource. One of the entity's properties, "ExternalID", determines whether some of the other properties in the entity are read-only. For example, if IsExternal==null, the FirstName, LastName, and Email fields should be rendered as TextBoxes. If IsExternal!=null, the 3 properties should be rendered in Label controls.
I got a web page, it has a tabcontainer, within each tab, there will be a gridview, all the tabs and gridview are created at run-time, i have only one code, that I will loop through to create all those tabs and gridview. When I apply the sorting, and I click on the column name on any grid, it returned an error saying index was out of bound. BUT, when there is only ONE grid view created, it is working fine, I suspect it mixed up all the grid view's id and so on. But I have assigned different ID to gridview
I have the gridview inside another gridview, i want to sort that both gridviews, I don't know how to achieve using asp.net 3.5 visual studio 2008 c# code behind. Following are my aspx page,
that aspx page contains gridview that contain one more gridview inside in it.Now i want to sort out both the grid i.e)claimgrid and Gdclmline1 i want code in c#.
I'm trying to extend the GridView control to enable sorting and paging for any situation.
When using my control I am fetching data from a database and filling a DataSet with it, then binding the GridView upon every page load. My first question would be, is this the correct approach?
To sort the GridView I am overriding the OnSorting method which stores the sort expression and direction in the ViewState, then creates a DataView and utalises the Sort method to sort the underlying data. It then sets the Data Source to this DataView and rebinds the GridView.
Paging is handled by OnPageIndexChanging which simply sets the PageIndex property and again rebinds the GridView.
My problem is; when any control causes a postback my GridView is no longer sorted, presumably because it is persistently rebound. If I don't rebind it then the GridView is empty on postback since the data isn't automatically stored in the ViewState. I have considered saving the data source in the ViewState but I would assume that this is bad practice for large amounts of data? - also DataViews are not seralisable.
The only solution I can think of currently is to override OnDataBound and sort the data every time. This results in a double sort when paging triggers a postback which seems inefficient. Code illustration of this below,
[Code]....
I'm looking for the cleanest 'best practice' solution as this is a learning exercise more than anything else.
I am using a gridview with EnableSortingAndPagingCallbacks set to true and need to run some javascript after a Paging / Sorting callback.Normally this does work with ScriptManager.RegisterStartupScript, but not when EnableSortingAndPagingCallbacks is set to true.
I'm trying to sort GridView but I have problem with converting DataSource to DataTable. Object of DataTable is empty. I don't know how to convert it.Do you have any ideas? Here is my code:
private void SortGridView(string sortExpression, string direction) { DataTable dt = GridViewDzialania.DataSource as DataTable; DataView dv = new DataView(dt); dv.Sort = sortExpression + direction; GridViewDzialania.DataSource = dv; GridViewDzialania.DataBind(); }
I have a single gridview and multple objectDataSources. Based on the user's input I bind the correct objectDataSource to the gridview in the OnClick handler when they click 'search'. ThegridView/ObjectDataSource have customPaging enabled and all that works, but I can't get the sorting to work. The sorting works when I have 1 ODS dedicated to 1 GV, but since it is set on the fly, no dice. It complains that I need to have a 'GridView1_Sorting' event. I think the answer lies in some how sorting the data inside of the ODS programmatically, but I don't know.
There are few columns in Gridview control , i want them to be sorted according to the column which i have specified . .how to specify that . .code is shown below . .By default i want them to be sorted according to "ENTRYDATE" . .
I have a gridview that can be sorted by a few of the columns.
How do I tell the gridview to go back to the unsorted mode. That is, go back to listing rows in the order they appear in the datasource.
It's ok if this will only work the next time a rebind is done on the grid. Currently it's maintaining the sort mode after a rebind. I don't want it to do that.
if it's possible to use the Gridview (SQLDatasource) UpdateCommand to actually perform an INSERT and not a true update.Here's the dealUsing a Select statement in my SQLDatasource,I'm retrieving records for which there are no History records for a specified period.(Essentially, I'm asking "Show me all records for which there are no historical records within a specified range").I'm using that result set to feed my GridView. Basically, I'm displaying all I need to know about the insert records sans one piece of info.When the user choose the "Edit" button, the row goes into edit mode.Using a template field, I've created a drop down box to allow the user to input the status of the data for that particular time period.When they click the save button,the idea is that the UpdateCommand will fire.However, when I click the save button (in edit mode),I get a postback error that tells me System.Data.SqlClient.SqlException: Must declare the scalar variable "@EQP_PK".
How to edit gridview row when not using sqldatasource and autogeneratecolumn property is set to true.I have a dropdownlist where table is selected on which gridview is populated (through sp from oracle) which is working but edit command is not working.Do i have to generate template myself or what ever solution?
i want to sort a gridview column which is a template field with a repeater control in it. this column has multiple links and i would like to sort using the first link. how can i achieve this.
