Specified cast is not valid
-
hi Code behind: Dim dgitem As DataGridItem For Each dgitem In Dgdisplay.Items If cacheRankingName = "cumulativeranking" Then 'If dgitem.ItemType.Item = ListItemType.Header Or dgitem.ItemType.Item = ListItemType.AlternatingItem Or dgitem.ItemType.Item = ListItemType.Item Then Dim dt As New DataTable qrytoExecute = "select playerid, firstname , lastname, scores.points as leaderboarddisplay from scores " & qrytoAdd qrytoExecute &= "group by scores.playerid order by leaderboarddisplay desc, playerid limit 30 " dt = DBManager.GetDataTable(qrytoExecute) For i = 0 To dt.Rows.Count - 1 Dim id As String = dt.Rows(i)("playerid").ToString() Dim Query As String = "select concat(p.firstname,p.lastname) as Name from player p join scores s on s.playerid=p.userid where s.playerid=" & id Dim retVal = DBManager.GetScalar1(Query) Dim lbl As Label Dim intCounter As New Integer Dim str As String = DirectCast(dgitem.Cells(0).Controls(0), Label).Text 'If txtHNGet.Text = retVal Then ' 'flag = True ' dgitem.Cells(1).BackColor = System.Drawing.Color.DarkRed 'End If Next End If 'End If Exit For Next End If Html: <asp:datagrid id="Dgdisplay" EnableViewState="False" Runat="server" PageSize="50" GridLines="None" AutoGenerateColumns="False" Width="65%" AllowPaging="True"> <Columns> <asp:TemplateColumn HeaderStyle-Font-Bold="True" HeaderText="Rank"> <ItemTemplate> <asp:Label ID="lblrank" Runat="server"> <%#getRank%> </asp:Label> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderStyle-Font-Bold="True" HeaderText="Playername"> <ItemTemplate> <a href='DisplayPlayerBioData.aspx?ids=<%#Container.DataItem("playerid")%>'> <%#getPlayerName(Container.DataItem("firstname"),Container.DataItem("lastname"))%> </a> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderStyle-Font-Bold="True" HeaderText="Count#"> <ItemTemplate> <asp:Label ID="lblcount" Runat="server"> <%#DataBinder.Eval(Container.DataItem,"leaderboarddisplay")%> </asp:Label> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn Visible="False"> <ItemTemplate> <asp:Label ID="lbl1" Runat="server"> <%#getPlayerName(Container.DataItem("firstname"),Container.DataItem("lastname"))%> </asp:Label> </ItemTemplate> </asp:TemplateColumn> </Columns> <PagerStyle Mode="NumericPages" ForeColor="#003300"
-
hi Code behind: Dim dgitem As DataGridItem For Each dgitem In Dgdisplay.Items If cacheRankingName = "cumulativeranking" Then 'If dgitem.ItemType.Item = ListItemType.Header Or dgitem.ItemType.Item = ListItemType.AlternatingItem Or dgitem.ItemType.Item = ListItemType.Item Then Dim dt As New DataTable qrytoExecute = "select playerid, firstname , lastname, scores.points as leaderboarddisplay from scores " & qrytoAdd qrytoExecute &= "group by scores.playerid order by leaderboarddisplay desc, playerid limit 30 " dt = DBManager.GetDataTable(qrytoExecute) For i = 0 To dt.Rows.Count - 1 Dim id As String = dt.Rows(i)("playerid").ToString() Dim Query As String = "select concat(p.firstname,p.lastname) as Name from player p join scores s on s.playerid=p.userid where s.playerid=" & id Dim retVal = DBManager.GetScalar1(Query) Dim lbl As Label Dim intCounter As New Integer Dim str As String = DirectCast(dgitem.Cells(0).Controls(0), Label).Text 'If txtHNGet.Text = retVal Then ' 'flag = True ' dgitem.Cells(1).BackColor = System.Drawing.Color.DarkRed 'End If Next End If 'End If Exit For Next End If Html: <asp:datagrid id="Dgdisplay" EnableViewState="False" Runat="server" PageSize="50" GridLines="None" AutoGenerateColumns="False" Width="65%" AllowPaging="True"> <Columns> <asp:TemplateColumn HeaderStyle-Font-Bold="True" HeaderText="Rank"> <ItemTemplate> <asp:Label ID="lblrank" Runat="server"> <%#getRank%> </asp:Label> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderStyle-Font-Bold="True" HeaderText="Playername"> <ItemTemplate> <a href='DisplayPlayerBioData.aspx?ids=<%#Container.DataItem("playerid")%>'> <%#getPlayerName(Container.DataItem("firstname"),Container.DataItem("lastname"))%> </a> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderStyle-Font-Bold="True" HeaderText="Count#"> <ItemTemplate> <asp:Label ID="lblcount" Runat="server"> <%#DataBinder.Eval(Container.DataItem,"leaderboarddisplay")%> </asp:Label> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn Visible="False"> <ItemTemplate> <asp:Label ID="lbl1" Runat="server"> <%#getPlayerName(Container.DataItem("firstname"),Container.DataItem("lastname"))%> </asp:Label> </ItemTemplate> </asp:TemplateColumn> </Columns> <PagerStyle Mode="NumericPages" ForeColor="#003300"
hi try this, Dim str As String= CType(dgi.Cells(0).Controls(0), Label).Text and be sure that control(0) of cell(0) is text field