| Groups | Blog | Home |
asp.net : 'Gridview1' fired event Sorting which wasn't handled
"Vincent" <vi,@sd.cv> wrote in message news:%23XMLcYmdIHA.3940@TK2MSFTNGP05.phx.gbl... > When clicking on the bar containing the pagenumber of the gridview in > order to go the next page, i get: > "The GridView 'Gridview1' fired event PageIndexChanging which wasn't > handled." > > When i click on the field for sorting, i get the error: > "The GridView 'Gridview1' fired event Sorting which wasn't handled" That's because you haven't wired up the paging and sorting events... <asp:GridView runat="server" id="Gridview1" AllowPaging="True" AllowSorting="true" pagesize="3" OnPageIndexChanging="Gridview1_PageIndexChanging" OnSorting="Gridview1_Sorting" /> protected void Gridview1_PageIndexChanging(object sender, GridViewPageEventArgs e) { // do something } protected void Gridview1_Sorting(object sender, GridViewSortEventArgs e) { // do something } -- Mark Rae ASP.NET MVP http://www.markrae.net
Hi,
I created a gridview bound to the roles tables with this code: rolesArray = Roles.GetAllRoles() Gridview1.DataSource = rolesArray Gridview1.DataBind() The gridview has following classic properties: <asp:GridView runat="server" id="Gridview1" AllowPaging="True" AllowSorting="true" pagesize="3" /> When clicking on the bar containing the pagenumber of the gridview in order to go the next page, i get: "The GridView 'Gridview1' fired event PageIndexChanging which wasn't handled." When i click on the field for sorting, i get the error: "The GridView 'Gridview1' fired event Sorting which wasn't handled" Thanks for help Vincent
[quoted text, click to view]
"Vincent" <vi,@sd.cv> wrote in message news:embJoXtdIHA.4396@TK2MSFTNGP02.phx.gbl... > Normally, when creating a gridview bound to a sqldatasource, the sorting / > paging occur automatically. Yes, but you're not using the SqlDataSource directly i.e. you're not setting the GridView's DataSourceID property - instead, you're using a custom object as the GridView's datasource e.g. rolesArray = Roles.GetAllRoles() Gridview1.DataSource = rolesArray Gridview1.DataBind() That's why you need to add event handlers for the sorting and paging functionality manually: http://forums.asp.net/p/956540/1177923.aspx -- Mark Rae ASP.NET MVP http://www.markrae.net
Thanks for your reply.
Normally, when creating a gridview bound to a sqldatasource, the sorting / paging occur automatically. This is new to me so what code do you mean with // do something Does it exist something like 'sort' or 'paging' ...? Mark Rae [MVP]" <mark@markNOSPAMrae.net> schreef in bericht news:%23NyphgmdIHA.4476@TK2MSFTNGP06.phx.gbl... [quoted text, click to view] > "Vincent" <vi,@sd.cv> wrote in message > news:%23XMLcYmdIHA.3940@TK2MSFTNGP05.phx.gbl... > >> When clicking on the bar containing the pagenumber of the gridview in >> order to go the next page, i get: >> "The GridView 'Gridview1' fired event PageIndexChanging which wasn't >> handled." >> >> When i click on the field for sorting, i get the error: >> "The GridView 'Gridview1' fired event Sorting which wasn't handled" > > That's because you haven't wired up the paging and sorting events... > > <asp:GridView runat="server" id="Gridview1" > AllowPaging="True" AllowSorting="true" pagesize="3" > OnPageIndexChanging="Gridview1_PageIndexChanging" > OnSorting="Gridview1_Sorting" > /> > > protected void Gridview1_PageIndexChanging(object sender, > GridViewPageEventArgs e) > { > // do something > } > > protected void Gridview1_Sorting(object sender, GridViewSortEventArgs e) > { > // do something > } > > > -- > Mark Rae > ASP.NET MVP > http://www.markrae.net
Thanks, i'll read it
"Mark Rae [MVP]" <mark@markNOSPAMrae.net> schreef in bericht news:OwjVKmtdIHA.4684@TK2MSFTNGP06.phx.gbl... [quoted text, click to view] > "Vincent" <vi,@sd.cv> wrote in message > news:embJoXtdIHA.4396@TK2MSFTNGP02.phx.gbl... > >> Normally, when creating a gridview bound to a sqldatasource, the sorting >> / paging occur automatically. > > Yes, but you're not using the SqlDataSource directly i.e. you're not > setting the GridView's DataSourceID property - instead, you're using a > custom object as the GridView's datasource e.g. > rolesArray = Roles.GetAllRoles() > Gridview1.DataSource = rolesArray > Gridview1.DataBind() > > That's why you need to add event handlers for the sorting and paging > functionality manually: > http://forums.asp.net/p/956540/1177923.aspx > > > -- > Mark Rae > ASP.NET MVP > http://www.markrae.net
[quoted text, click to view]
"Vincent" <vi,@sd.cv> wrote in message news:eFuzOWydIHA.4728@TK2MSFTNGP03.phx.gbl... > "Mark Rae [MVP]" <mark@markNOSPAMrae.net> schreef in bericht > news:OwjVKmtdIHA.4684@TK2MSFTNGP06.phx.gbl... >> "Vincent" <vi,@sd.cv> wrote in message >> news:embJoXtdIHA.4396@TK2MSFTNGP02.phx.gbl... >> >>> Normally, when creating a gridview bound to a sqldatasource, the sorting >>> / paging occur automatically. >> >> Yes, but you're not using the SqlDataSource directly i.e. you're not >> setting the GridView's DataSourceID property - instead, you're using a >> custom object as the GridView's datasource e.g. >> rolesArray = Roles.GetAllRoles() >> Gridview1.DataSource = rolesArray >> Gridview1.DataBind() >> >> That's why you need to add event handlers for the sorting and paging >> functionality manually: >> http://forums.asp.net/p/956540/1177923.aspx > > i used the code you gave me but there is an error when sorting only: > "Unable to cast object of type 'System.String[]' to type > 'System.Data.DataTable' " > at line: Dim dt As DataTable = Gridview1.DataSource Well, there would be... A DataTable is a DataTable datatype (obviously!), but a GridView's DataSource is an object datatype so that various datatypes can be used as datasources for databound controls - you can't dimension a DataTable as an object directly... I can only imagine that you're not using Option Strict, otherwise I'm pretty sure your code wouldn't have compiled - it certainly wouldn't have compiled in C#... [quoted text, click to view] > i tried several things (using string() instead of Datatable ...) but could > not find the solution. Try this: Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) -- Mark Rae ASP.NET MVP http://www.markrae.net
Hi Mark,
i used the code you gave me but there is an error when sorting only: "Unable to cast object of type 'System.String[]' to type 'System.Data.DataTable' " at line: Dim dt As DataTable = Gridview1.DataSource i tried several things (using string() instead of Datatable ...) but could not find the solution. the whole code: Protected Sub Gridview1_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles Gridview1.Sorting Dim dt As DataTable = Gridview1.DataSource If Not IsDBNull(dt) Then Dim dv As DataView = New DataView(dt) dv.Sort = e.SortExpression Gridview1.DataSource = dv Gridview1.DataBind() End If End Sub "Mark Rae [MVP]" <mark@markNOSPAMrae.net> schreef in bericht news:OwjVKmtdIHA.4684@TK2MSFTNGP06.phx.gbl... [quoted text, click to view] > "Vincent" <vi,@sd.cv> wrote in message > news:embJoXtdIHA.4396@TK2MSFTNGP02.phx.gbl... > >> Normally, when creating a gridview bound to a sqldatasource, the sorting >> / paging occur automatically. > > Yes, but you're not using the SqlDataSource directly i.e. you're not > setting the GridView's DataSourceID property - instead, you're using a > custom object as the GridView's datasource e.g. > rolesArray = Roles.GetAllRoles() > Gridview1.DataSource = rolesArray > Gridview1.DataBind() > > That's why you need to add event handlers for the sorting and paging > functionality manually: > http://forums.asp.net/p/956540/1177923.aspx > > > -- > Mark Rae > ASP.NET MVP > http://www.markrae.net
Thanks again, but i still get the same error at line:
Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) "Mark Rae [MVP]" <mark@markNOSPAMrae.net> schreef in bericht news:OKVNxnydIHA.748@TK2MSFTNGP04.phx.gbl... [quoted text, click to view] > "Vincent" <vi,@sd.cv> wrote in message > news:eFuzOWydIHA.4728@TK2MSFTNGP03.phx.gbl... > >> "Mark Rae [MVP]" <mark@markNOSPAMrae.net> schreef in bericht >> news:OwjVKmtdIHA.4684@TK2MSFTNGP06.phx.gbl... >>> "Vincent" <vi,@sd.cv> wrote in message >>> news:embJoXtdIHA.4396@TK2MSFTNGP02.phx.gbl... >>> >>>> Normally, when creating a gridview bound to a sqldatasource, the >>>> sorting / paging occur automatically. >>> >>> Yes, but you're not using the SqlDataSource directly i.e. you're not >>> setting the GridView's DataSourceID property - instead, you're using a >>> custom object as the GridView's datasource e.g. >>> rolesArray = Roles.GetAllRoles() >>> Gridview1.DataSource = rolesArray >>> Gridview1.DataBind() >>> >>> That's why you need to add event handlers for the sorting and paging >>> functionality manually: >>> http://forums.asp.net/p/956540/1177923.aspx >> >> i used the code you gave me but there is an error when sorting only: >> "Unable to cast object of type 'System.String[]' to type >> 'System.Data.DataTable' " >> at line: Dim dt As DataTable = Gridview1.DataSource > > Well, there would be... A DataTable is a DataTable datatype (obviously!), > but a GridView's DataSource is an object datatype so that various > datatypes can be used as datasources for databound controls - you can't > dimension a DataTable as an object directly... I can only imagine that > you're not using Option Strict, otherwise I'm pretty sure your code > wouldn't have compiled - it certainly wouldn't have compiled in C#... > >> i tried several things (using string() instead of Datatable ...) but >> could not find the solution. > > Try this: > Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) > > > -- > Mark Rae > ASP.NET MVP > http://www.markrae.net
[quoted text, click to view]
"Vincent" <vi,@sd.cv> wrote in message news:%23%23BGGKzdIHA.5164@TK2MSFTNGP03.phx.gbl... [top-posting corrected] [quoted text, click to view] >>> i used the code you gave me but there is an error when sorting only: >>> "Unable to cast object of type 'System.String[]' to type >>> 'System.Data.DataTable' " >>> at line: Dim dt As DataTable = Gridview1.DataSource >> >> Well, there would be... A DataTable is a DataTable datatype (obviously!), >> but a GridView's DataSource is an object datatype so that various >> datatypes can be used as datasources for databound controls - you can't >> dimension a DataTable as an object directly... I can only imagine that >> you're not using Option Strict, otherwise I'm pretty sure your code >> wouldn't have compiled - it certainly wouldn't have compiled in C#... >> >>> i tried several things (using string() instead of Datatable ...) but >>> could not find the solution. >> >> Try this: >> Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) > > Thanks again, but i still get the same error at line: > Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) Hmm - OK... What datatype is GridView1.DataSource? Can it even be cast to a DataTable type...? -- Mark Rae ASP.NET MVP http://www.markrae.net
The datasource are the roles from the table 'aspnet_roles' created when
creating membership users: so the datasource is of type array string. dim rolesArray() As String rolesArray = Roles.GetAllRoles() Gridview1.DataSource = rolesArray Gridview1.DataBind() Thanks "Mark Rae [MVP]" <mark@markNOSPAMrae.net> schreef in bericht news:eF1wvzzdIHA.4488@TK2MSFTNGP04.phx.gbl... [quoted text, click to view] > "Vincent" <vi,@sd.cv> wrote in message > news:%23%23BGGKzdIHA.5164@TK2MSFTNGP03.phx.gbl... > > [top-posting corrected] > >>>> i used the code you gave me but there is an error when sorting only: >>>> "Unable to cast object of type 'System.String[]' to type >>>> 'System.Data.DataTable' " >>>> at line: Dim dt As DataTable = Gridview1.DataSource >>> >>> Well, there would be... A DataTable is a DataTable datatype >>> (obviously!), but a GridView's DataSource is an object datatype so that >>> various datatypes can be used as datasources for databound controls - >>> you can't dimension a DataTable as an object directly... I can only >>> imagine that you're not using Option Strict, otherwise I'm pretty sure >>> your code wouldn't have compiled - it certainly wouldn't have compiled >>> in C#... >>> >>>> i tried several things (using string() instead of Datatable ...) but >>>> could not find the solution. >>> >>> Try this: >>> Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) >> >> Thanks again, but i still get the same error at line: >> Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) > > Hmm - OK... What datatype is GridView1.DataSource? Can it even be cast to > a DataTable type...? > > > -- > Mark Rae > ASP.NET MVP > http://www.markrae.net
[quoted text, click to view]
"Vincent" <vi,@sd.cv> wrote in message news:%2302siI4dIHA.5900@TK2MSFTNGP02.phx.gbl... [top-posting corrected again] [quoted text, click to view] >>>>> i tried several things (using string() instead of Datatable ...) but >>>>> could not find the solution. >>>> >>>> Try this: >>>> Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) >>> >>> Thanks again, but i still get the same error at line: >>> Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) >> >> Hmm - OK... What datatype is GridView1.DataSource? Can it even be cast to >> a DataTable type...? > > The datasource are the roles from the table 'aspnet_roles' created when > creating membership users: > so the datasource is of type array string. > > dim rolesArray() As String > rolesArray = Roles.GetAllRoles() > Gridview1.DataSource = rolesArray > Gridview1.DataBind() OK, so the datasource for the GridView *isn't* a DataTable - it's a string array... That's fine, of course, except that you're trying to dimension a DataTable variable and populate it with a string array - that's never going to work without an explicit conversion... In the link I suggested, the sorting method relies on the fact that the datasource of the GridView is a DataTable, from which a DataView object can be created. This isn't the case with string arrays, so you'll have to write your own sorting routine - something like this: http://www.thescripts.com/forum/thread384129.html -- Mark Rae ASP.NET MVP http://www.markrae.net
ok, thanks
"Mark Rae [MVP]" <mark@markNOSPAMrae.net> schreef in bericht news:%235YU2w5dIHA.536@TK2MSFTNGP06.phx.gbl... [quoted text, click to view] > "Vincent" <vi,@sd.cv> wrote in message > news:%2302siI4dIHA.5900@TK2MSFTNGP02.phx.gbl... > > [top-posting corrected again] > >>>>>> i tried several things (using string() instead of Datatable ...) but >>>>>> could not find the solution. >>>>> >>>>> Try this: >>>>> Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) >>>> >>>> Thanks again, but i still get the same error at line: >>>> Dim dt As DataTable = DirectCast(Gridview1.DataSource, DataTable) >>> >>> Hmm - OK... What datatype is GridView1.DataSource? Can it even be cast >>> to a DataTable type...? >> >> The datasource are the roles from the table 'aspnet_roles' created when >> creating membership users: >> so the datasource is of type array string. >> >> dim rolesArray() As String >> rolesArray = Roles.GetAllRoles() >> Gridview1.DataSource = rolesArray >> Gridview1.DataBind() > > OK, so the datasource for the GridView *isn't* a DataTable - it's a string > array... That's fine, of course, except that you're trying to dimension a > DataTable variable and populate it with a string array - that's never > going to work without an explicit conversion... > > In the link I suggested, the sorting method relies on the fact that the > datasource of the GridView is a DataTable, from which a DataView object > can be created. This isn't the case with string arrays, so you'll have to > write your own sorting routine - something like this: > http://www.thescripts.com/forum/thread384129.html > > > -- > Mark Rae > ASP.NET MVP > http://www.markrae.net
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |