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:
I have a gridview in an update panel which is declared in an ASPX page, and bound to a SQLDataSource in code. The gridview's 'allowsorting' attribute is set to true, and because it is bound to a SQLDataSource, I expect the sorting to be automatically handled.
Yet I am getting the "Message: Sys.WebForms.PageRequestManagerServerErrorException: The GridView 'grdStatusItems' fired event Sorting which wasn't handled" error. I am using Visual Studio 2008, IE8, IIS7. What am I doing wrong? I have done anextensive search for this error, but it seems in most cases where this error occurs, the people are not using a SQLDatasource, so have to handle the sorting event themselves. Is this the case here? Here is the updatepanel and gridview declaration in the aspx file:
I've got a gridview that returns student order history which works just fine. It pulls the StudentId from a hidden field on page load. I have a link button that ADDS AN ORDER when clicked. It calls a stored procedure, inserts the record, then rebinds the gridview and displays the new record at the top of the list.
Problem is when I go to EDIT it, i get this error... "The GridView 'GridViewOrderHistory' fired event RowEditing which wasn't handled." But the interesting thing is the error doesn't occur if I close the browser and reload the page and then click on that new record that was created. Obviously I'm missing something in my code when the new order is created. Here are the 2 subs involved in the process.
i have a problem in my gridview control,actually i am having a gridview and bind the gridview with the database,in that gridview i provide a link button called delete,when i click the delete button its shows an error,after reloading the page the current record is deleted,but whenever the delete button is pressed its shows the following error..The GridView 'GridView1' fired event RowDeleting which wasn't handled.but whenever i reload the project the record will be deleted,here is my code
I am populating the gridview on the basis of listbox selection . However, I am setting the datasource in the click event after listbox entry. When i am trying to update any record in the gridview this error gets thrown because the datasourceid from the aspx page has been removed. Code for reference -
protected void btn_save_Click(object sender, EventArgs e) { ArrayList list = new ArrayList(); foreach (object o in ListBox2.Items) { list.Add(o); } string str2 = null, str, host; string str1 = "SELECT SYSTEMNAME, DATETIME, PDOWNTIME, UDOWNTIME, SYSDOWNMINS, REASON FROM PLANNED_DOWNTIME where "; host = Convert.ToString(list[0]); str2 = " ( SYSTEMNAME like '" + host + "'"; for (int i = 1; i < list.Count; i++) { host = Convert.ToString(list[i]); str2 = str2 + " or SYSTEMNAME LIKE'" + host + "'"; } str = str1 + str2 + " )"; string connectstring = "Data Source=SRCPA035\ovops;Initial Catalog=reporter;Persist Security Info=True;User ID=sa;Password=ril123"; DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(connectstring); try { connection.Open(); SqlCommand sqlCmd = new SqlCommand(str, connection); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(dt); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } GridView1.DataSource = SqlDataSource1; } catch (System.Data.SqlClient.SqlException ex) { string msg = "Fetch Error:"; msg += ex.Message; throw new Exception(msg); } finally { connection.Close(); } }
Why wasn't my GridView's RowDataBound event fired? I have a masterpage on whick i have a query button, and I have a content page on which i have a customized GridView(named cgvEmployees,derived from GridView). The logic is when user click the button, the button click event triggered that search the underlying database and populate the GridView.
Everything runs great except that RowDataBound event isn't triggered. Because I have to change some cells' representations in RowDataBound event handler. I have surfed so much pages to find the answer but failed. Below is what i have already done:
1. set the autoeventwireup to true; 2. i have a cgvEmployees.bind() sentence in the button click event handler; 3. i have OnRowDataBound="cgvEmployees_OnRowDataBound" in the content page GridView tag attribute
by the way, the database query is coded by Linq Dynamic Query (please google 'dynamic Linq').
void Master_QueryButton_Click(object sender, EventArgs e) { RetiredEmployeeDataContext db = new RetiredEmployeeDataContext(); NameValueCollection nvcQueryKeyValue = getNVCQueryKeyValue(); Expression<Func<RetiredEmployee, bool>> searchPredicate = getLambdaExpr(nvcQueryKeyValue); IQueryable<RetiredEmployee> retireds = db.RetiredEmployees; Expression expr = Expression.Call(typeof(Queryable), "Where", new Type[] { typeof(RetiredEmployee) }, Expression.Constant(retireds), searchPredicate); IQueryable<RetiredEmployee> query = db.RetiredEmployees.AsQueryable().Provider.CreateQuery<RetiredEmployee>(expr); List<RetiredEmployee> employeeList = new List<RetiredEmployee>(query); List<RetiredEmployeeEO> employees = new List<RetiredEmployeeEO>(); foreach (RetiredEmployee employee in employeeList) { RetiredEmployeeEO employeeEO = new RetiredEmployeeEO(); employeeEO.MapEntityToProperties(employee); employees.Add(employeeEO); } cgvEmployees1.ListClassName = typeof(RetiredEmployeeEOList).AssemblyQualifiedName; cgvEmployees1.LoadMethodName = "LoadFromQuery"; cgvEmployees1.LoadMethodParameters.Clear(); cgvEmployees1.LoadMethodParameters.Add(employees); cgvEmployees1.DataBind(); } protected void cgvEmployees1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //Add the edit link to the action column. HyperLink editLink = new HyperLink(); if (((BasePage)this.Page).ReadOnly) { editLink.Text = "View"; } else { editLink.Text = "Edit"; } editLink.NavigateUrl = "employee.aspx" + EncryptQueryString("id=" + ((RetiredEmployeeEO)e.Row.DataItem).ID.ToString()); if(e.Row.Cells[0].Controls.Count==0) e.Row.Cells[0].Controls.Add(editLink); //Add checkbox to display the isactive field. CheckBox chkActive = new CheckBox(); chkActive.Checked = ((RetiredEmployeeEO)e.Row.DataItem).liveOrDead; chkActive.Enabled = false; if(e.Row.Cells[24].Controls.Count==0) e.Row.Cells[24].Controls.Add(chkActive); if (((RetiredEmployeeEO)e.Row.DataItem).gender.Equals((byte)1)) e.Row.Cells[2].Text = "Male"; else e.Row.Cells[2].Text = "Female"; if (((RetiredEmployeeEO)e.Row.DataItem).retiredOr.Equals((byte)1)) e.Row.Cells[14].Text = "Retired1"; else e.Row.Cells[14].Text = "Retired2"; if (((RetiredEmployeeEO)e.Row.DataItem).birthday.Equals("1753-01-01")) e.Row.Cells[3].Text = ""; if (((RetiredEmployeeEO)e.Row.DataItem).dayToEmployed.Equals("1753-01-01")) e.Row.Cells[6].Text = ""; if (((RetiredEmployeeEO)e.Row.DataItem).dayRetired.Equals("1753-01-01")) e.Row.Cells[7].Text = ""; if (((RetiredEmployeeEO)e.Row.DataItem).dayParty.Equals("1753-01-01")) e.Row.Cells[13].Text = ""; if (((RetiredEmployeeEO)e.Row.DataItem).daytoassign.Equals("1753-01-01")) e.Row.Cells[17].Text = ""; } }
I have problem with gridview sorting. I am using online example to sort a grid view. see the link [URL] but I always got an error "The gridview fired sorting event without handle" on this statement "helper.ApplyGroupSort();"
I have 2 Gridviews of the same structure and header. I want when user click hear of Gridview 1 for sorting, the same sorting applies to Gridview2 onclick.
I have a very simple asp.net page, just some buttons and one GridView on it. The logic is a user click the QUery button,then the button click event was trigured to populate the gridview with data queried from database via LINQ. for a user friendly interface, in RowDataBound event, I visit every row, change a boolean value into checkbox represention. But it seem that the RowDataBound run twice, because the checkboxs were inserted twice for every row in one cell. so why? the source code snippet as follow:
I have a Gridview which contains templated column that has 5 checkboxes in it. When you click on one checkbox, I want to uncheck the other 4.
I am using the Item Template for this. I don't want the user to have to Select a row, before clicking on the checkboxes. Here is my non-working code to uncheck the other checkboxes. I realize it's not "SelectedRow" that I want since there's no selected row, so how do I find the row containing the checkbox that fired off CheckChanged?
since APS.Net 4.0 I have a curious problem with an event.
There is a FormView and inside of the EditItem there is a GridView. In the Footer of the GridView I put Controls for inserting records.
But when I fire a markup defined RowCommand of that GridView then the same event is getting fired for the Parent FormView. First I had 'Insert' as the CommandName and so I was getting the Error that my FormView had to be in insert mode to insert a record. Then I changed the RowCommand of the GridView to 'xxx' and I got also the RowCommand 'xxx' at the RowCommand eventhandler of the Parent FormView.
The project was migrated from .Net 3.5 a few days ago, but nothing was manually changed in the code/markup. And the problem was not there with the "old" framework.
[Code]....
Of course, I could simply change the CommanName of the LinkButton e.g. to 'InsertChild' but I would like to know:
So I have a GridView control with autogenerated column set to true, it also has autogenerated Edit and Delete buttons, sorting and paging, and also I am binding this same gridview to multiple data sources at runtime. All is working well.
Now I am adding a dynamically generated footer row at runtime. This footer row will allow users to add new record regardless which data source it binds to. So it is working as well except there's a small bug I couldn't figure out why. It's when I navigate to the last page of the gridview, if the rows on the last page is less than the page size, for example, I have page size 10 and the rows in last page is 9, then when I click the 'Add' linkbutton, the Add event does not fire, instead, it fill the last page with additional blank rows, that means if the last page has 5 rows, it will fill 5 blank rows below, if it has 9 rows, it will fill 1 blank row below. Then if you click the add again, it will work. If the last page already has 10 rows then, it works just fine.
Below is the code I used to dynamically add footer row:
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
I have a page on which everything is loaded dynamically.
There is a Gridview (AutoGenerateColumns=true) and in the RowDataBound I check every column for a boolean datatype. If found I add a checkbox (autopostback=true) to the cell and register the CheckedChanged event. The problem is, that I only get the CheckedChanged event, if I reload the grid in Page_Load:
All of my columns are bound in the Gridview. On OnRowDataBound event, I am adding some custom styles like underlines and colors to the text of the columns. Sorting of data is working fine but I am losing my custom styles when I sort. I am using the generic sorting code for the GridView.
How I can keep my custom styles on sorting that I added during OnRowDataBound event.
I'm creating a confirm delete like popup with an iframe to use along with a gridview. When you click delete on a gridview row, the iframe shows up and asks if you would like to delete the associated image as well from the server. It works perfectly the first time I delete a row. After that whenever I click select or edit on a new row, it calls the rowdeleting event from the last deleted entry every time. I'm stumped.Here's the Sub:
'// Event that Occurs when the Delete Button is Clicked //' Protected Sub Confirm_Delete(ByVal sender As Object, ByVal e As GridViewDeleteEventArgs) Handles GridView1.RowDeleting Dim file_name As Array = Split(GridView1.Rows.Item(e.rowIndex).Cells.Item(10).Text, "/") If file_name.getLength(0) = 1 Then file_name = Split(GridView1.Rows.Item(e.rowIndex).Cells.Item(10).Text, "") End If Dim fn As String = file_name(file_name.getLength(0) -1) fn = replace(fn, ",", "%2C") fn = replace(fn, " ", "%20") Dim url As String = Me.Master.get_root_url & "CrimeBulletinProject/ConfirmDelete.asp?img_list=" & fn & "~!" confirm_delete_frame.Attributes.Add("src", url) confirm_delete_frame.Attributes.Add("style", "display: block; left: 50%") End Sub
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.
I have a rowDeleting even on my gridView. When I click Delete link, the Rowdeleting is not fired. I checked my aspx...and I have it there...I dont see any problems there..bu still when I click delete, my page is refreshed without calling RowDeleing event.
I am creating a user control to serve as a multi select, multi column drop down. i.e more than one items can be selected. To achieve this, I used GridView control to dispay multiple columns when user clilck on image of drop down, first column containing CheckBox to select multiple rows. I have registered mouseout event handler for GridView control, to hide GridView when mouse leaves GridView area.
But mouseout event is going to be fired even mouse pointer moves from one row to another row. I have seen HTML in browser, mouseout is registerd in table rather than each row.
