I have a gridview and I used sqldatasource to bind data with gridview
Sorting is working correctly
But on first button click event If i sort column Name by desc
and on second button click event the sort order for column name id desc only
How to reset column sort as per sql query on every button click event ?
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.
I tried this:
Tried setting gridview1.sqldatasourceid = null; gridview1.allowsorting = false; gridview1.databind();
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:
[Code]....
<asp:GridViewid="gridview"
runat="server" DataSourceID = "SqlDataSource1"
PageSize="30" EmptyDataText = "No Records Found" EmptyDataRowStyle-HorizontalAlign ="Center"
AllowPaging="true"
HorizontalAlign="Center" BorderColor ="Black" Width = "762" Font-Names="Calibri"
[Code] ....
First time on page load
Sorting works fine
But if I done sorting on gridview column then its always the same , How to assign result of SQL query to my result
so that my sort will show result from sql query order not the order of grisview sort ...
I want to reset all the fields and values in codebehind on buttonclick.
View 5 RepliesHow can I enter data from textbox to gridview on the buttonclick event
View 1 RepliesI am trying to add an instance of UserControl each time on button_click event, it works for the first time only. I am adding IDs to user control by appending integers from ViewState. Why does it not add work for subssequent clicks. Here is the simplified version with the same behavoir.
protected void Button1_Click(object sender, EventArgs e)
{
HtmlButton btnClick = new HtmlButton();
btnClick.ID = "bt" + Append.ToString();
btnClick.InnerText = "Button 1";
MainArea.Controls.Add(btnClick);
}
If the grid column is clicked to sort i dont want to retireve data agian, i can get it from viewstate, but i dont know if that triggered the post back or if the ImageButton on the page triggered it
View 5 RepliesI have created gridview with list daatsource. I want apply sorting event for gridview to sort all columns.Here is my code:
protected void grduAdminSerservice_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable tbl = grduAdminSerservice.DataSource as DataTable;
[code]...
I have a <hr/> on the page and I want to hide it on buttonclick ?
How to do it ?
I tried to capture it within div and give ID to div but in buttonclick event code the intelligsense does not give me the id name for me to use.
What should I do?
I have a page displays CRM data (with CrmService) in GridView. Everything run ok until I tried to sort out one field by default and I received the following exception: The GridView 'GridView1' fired event Sorting which wasn't handled. The reason I am using GridView to do the sorting because:
1) Cannot do it with SQL "ORDER BY" since date retrieval from CRM Web Service
2) Cannot use OrderExpression for QueryExpression from CRM because the column I want to sort is generated by my algorithm
GridView1.Sort("ColumnName" SortDirection.Descending);
in Page_Load, or Button1_Sort(object sender, GridViewSortEventArgs e), they all trigger the above execption!
I also added the method to the following method to handle exception, but didn't work:
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
GridView1.Sort("ColumnName" SortDirection.Descending);
}
how reset the value of asp testbox and dropdown list on button click event by using j query.
The button code is
[code]...
I have a simple dynamic gridview with following code -
GV = new GridView();
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 an application where the user scrolls down through a grid and clicks a SELECT button to populate some textboxes based on the content of the grid. On the return from the postback the selected row is out of sight because the grid comes back reset to the top within the scroll window.
Is it possible to have the postback return with the highlighted selected row visible rather than forcing the user to scroll back down to find the selection?
I want to know is there any other way to reset the sessions in page load?after delete the controls
i tried with Session.Abandon() -it kills all the session in page
this my code
[code]....
I have a web form with some labels, textboxes, buttons and a gridview. The gridview has AllowPaging ="true". Girdview displays record numbers (hyperlinked), When I click on a record number in the grid view it populates textbox1. Then I hit the 'Search button to auto populate the form the that record data from the database.
My problem is when I am on say 5th page on my grid view and click a record number to go in textbox1, and then click on the search button to auto populate the form, the gridview goes back to page 1.
How do I make the search button not reset/refresh the gridview?
I have webform that is used to search for records and displays them...the form contains a dropdownlist, a textbox, a button, and a gridview...user select an entry from the dropdown, type in a matching value and then click on the button to add the entry into the gridview. All of these seem to be working just fine...however, the issue am having is this...after working with the first entry and users search for the second record, the gridview still maintains the entries from the first search. How do i go about resetting the gridview each time there is a new search? Here is what my code looks like.
[Code]....
[Code]....
[Code]....
How do I get the gridview to reset the next time the btnSearch button is clicked?
Actually i want to ask which is the best for sorting in Asp.Net is it DataView.Sort Method or List<Object>.Sort() method.
View 1 RepliesI'm looking for a way to sort the rows of a datatable without setting the DefaultView.Sort to a specific column. I have a datatable in session that users can add records to. I want them to be able to sort the data by clicking on a button. But new records added after that need to show up at the bottom of the list until the sort button is clicked again.
View 2 Repliesif i click a button and i have a string(2010/08/12,2010/08/13,2010/08/14,) in the textbox it divides to 2010/08/14 in the textbox wich i dont want here is my code
[Code]....
I have a form for registering customers, with RequiredFieldValidations that each are bound to a specific textbox. My problem is that I would also like to bind them to one specific buttonclick, since I have other buttons which I don't want to trigger the validations. Is that possible?
View 6 RepliesI have trouble with the sequence of events on my page. I have a button, which on its onClick event calls a method, which posts data to a database, and causes a postback. But on the same page I have a repeater which uses the data that is being modified by the button. I would need somehow the buttonclick event occur "earlier" than the databinding in the repeater to show the correct data.
View 3 RepliesRight now I have a gridview with databind. My menu item consist of the 7 days of the week. Everything works fine except for one thing, the page index. Right now by default it loads the results for Monday. If I click on Pg 2 for Monday, and then I click on Tuesday, the page number stays at page 2 and the data remains the same. I have to click on Pg 1 or Pg 3 before the data would refresh and change the result to Tuesday's data.
I've tried adding databind() to the MenuClick event but if Monday has 3 pages, and they click on Tuesday which only has 2 pages, it would give me an error. Also the adding of the Databind() still doesn't fix the page index when I click on a different day.
How do I reset the page index when the user clicks on the day.
[Code]....
I need to open a new window or page keeping the existing page open. I plan to put a Button on the existing page and when a user click the button, a new page or window pops up with what I have coded for that page. My preference would be that the user don't have to tweek any browser options or configure anhing else to open the new window with the click.
View 1 RepliesI have a DropDownList when selected, brings up Detail Info in GridView1. That GridView has a LinkButton when selected brings up the final Detail Info, in GridView2. need to have the GridView2 clear out and display as when it is "EmptyDataText", when the DropDownList is changed.
View 5 Replies