Forms Data Controls :: Webpage Not Found When Clicking Sort Or Pagination Links On Gridview Control
Feb 3, 2011
I have created a website that has some gridview controls that call stored procedures in a SQL db and display the results of the procedures. Two of the gridview controls have sorting enabled, and one has pagination enabled.
The site loads for all users who have tried it so far.
However, one user gets a "webpage not found" (HTTP 400 Bad request) error whenever they click on the pagination links or sorting links on the gridview control. It seems like it's not a security issue because the website runs as a user with permission to the database.
Let's say I passed a couple of querystring to populate my datalist on another page. Then I want to filter/refine that datalist further by clicking on links( which are dynamically created depending on the data on the datalist) and when clicked will pass another querystring to create a new refined datalist.
Example: I clicked on a link that redirects to [URL], a datalist will be produced on another page. Then there is are link on the same page that go to [URL], [URL], then another datalist will be produced. how to code these links, what I have in mind is link (4), link (10). The numbers represent how many records it will display if that link is clicked.
Just spent about 8 hours googling and looking through this forum for a solution on how to make sure that I can dynamically sort. Here is the situation.
I have 1 Gridview that displays 10 different scenarios based on what button is clicked.
I am also returning only top 10 records. I am doing all of the data binding pragmatically. So I have BoundFields, HyperLinkFields etc.
I also want to sort some records. When I change DataSource SQL statement the gridview somehow remembers what the last sort value was and it errors out saying that value "x" cannot be sorted because it does not exists.
Here I get an error that says that the data source does not support sorting? Doesnt it say gridview1.allowsorting = false;
I also tried gridview1.sort("", SortDirection.Ascending); This does nothin... except query my database one more time because i have a onSorting event that looks like this:
[Code]....
Here is an example of just one of those SLQ statements inside GetSQLQuery:
I want to sort a GridView by clicking on the header. I guess all i need is the header name and then pass it into sql to get the data back sorted. How is it possible to get the header name?
I have a gridview which I am trying to be able to sort by clicking the column header. Currently, I have the column header underlined by turning the 'allow sorting' function to TRUE, but when I click the column header, it does nothing.
I am trying to hook up custom pagination with an ObjectDataSource to my GridView. However, this thing renders no data, but does render the column headers. The debugger clearly indicates a populated DataTable being returned.
my gridview shows multiple repeated pages for one page and I dont know from where come the problemand im treating the event of the paging well
Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs) GridView1.PageIndex = e.NewPageIndex If lstCustomer.Visible = True Then
In my solution, I added the following class in the Helper folder
[Code]....
Now, In my HomeController, I used following Index function
[Code]....
And in Global.asax.cs, routing as
[Code]....
In my View of Index funtion, I have following code
[Code]....
Now the problem is on opening sitename/Home, I am getting 2 post as required but when I click on next then I am getting HTTP 404 Error. The url formed is like sitename//Home/Page/1. (Edited later- Typo. Single / not //)
I have a gridview with data. I want a button which is not part of the gridview. Then if I press a button the gridview is sorted by two colums. i.e column1 ascending column2 descending.
I am not looking to work with a Sqldatasource as I use a data access layer. So the sort would have to be from a datatable and databind or directly with the gridview.
I have a Bar Chart being driven by the user search criteria. Is it possible to make it so they can click on the bars, or label of bar, and have it taken them to another page to see more details?
I am trying to implement pagination in my gridview control. Here is the code for databind and pageindexchanged
Private Sub BindGrid() Dim dataTable as DataTable = CType(Session.Item(APPLICATION_DATA), DataTable) Grid.DataSource = dataTable.DefaultView Grid.DataBind() End Sub
Protected Sub OnChangePageSize(ByVal send As Object, ByVal e As GridViewPageEventArgs) Handles Grid.PageIndexChanging Grid.PageIndex = e.NewPageIndex _BindGrid() End Sub
But I get error after Grid.DataBind() as "Unable to cast object of type 'System.EventArgs' to type 'System.Web.UI.WebControls.GridViewPageEventArgs'"
I have been asked to replace DATAGRID with GRIDVIEW on WEBFORM1.ASPX. For Pagination, I am having problem due to lack of knowledge to replace page 1,2,3,4,5,6,7 8, 0 with NEXT , PREV like I did it for DATAGRID. Have to use NEXT and PREV because the GRIDVIEW Pagesize = 20 while the rows from the TBLSALESTRANSACTION exceeded 350rows
Using a GridView to display unique website department names from a database table, is it possible to create a hyperlink in the GridView to that specific departments page? I'm a beginner and haven't found any examples so unsure as to how this would be accomplished.
I need to disable the edit command link if a record has links to other records within the tables.
I have a table that has worktype and that is captured when certain records are entered. So if a record exists with that value, then i want to disable the "Edit" link for that record within my gridview.
I want to provide them access to add more worktypes, but if they want to edit a worktype, i need to make sure its not used anywhere in the other tables, before they can edit it. For now atleast, because i will need to allow full editing and deletion functions for this table. how to do this or maybe suggestions on other things i can do to give them full functionality?
I want to create simple rating page where player's place,name and rating is displayed. I've created database with ID,Name and Rating Columns, binded Gridview to this database and created TemplateField "Place". With following code I've created numbered list for Place:
protected void Page_Load(object sender, EventArgs e){ for (int i = 0; i < GridView1.Rows.Count; i++)
I'm a newbie to .NET, so the solution might be really trivial. I have a database, I have an Entity Data Model, I add in my Index.aspx page an EntitryDataSource and a GridView. I connect them and everything works fine (the data is displayed as expected). The problem is that clicking on the coulmn name or on the pagination lists doesnt do a thing... Although I did set the properties AllowSorting="True" and AllowPaging="True". I also tried with another datasource type (SqlDataSource) and the same problem.
