[Solved] Trouble with RadGrid1.SelectedValue

[Dan Schmecker]

It seems that no matter what i do, the RadGrid1.SelectedValue ends up as null.
If i switch out "RadGrid1.SelectedValue" and just manually put a value in.....the code works fine (but obviously, every line i select ends up becoming that same value.)
My best guess is that the "Ticket#" column isn't being correctly defined as being the DataKey.
Please Help.

Here's the vb code behind.

    Protected Sub RadGrid1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadGrid1.SelectedIndexChanged

        Dim xxx As String
        xxx = RadGrid1.SelectedValue
        GetTheData(xxx)
        Panel1.Visible = True

    End Sub

Public Function GetTheData(ByVal vary As String) As String

        Dim conn As New SqlConnection
        Dim var1 As Integer
        var1 = RadGrid1.SelectedValue
        Label_ID.Text = var1

        conn = GetConn2()

        Dim sql As String = "SELECT Ticket#, Notes, Respformissing, Analyzed, Priority, Week_Restored, Type, ClosureCodeName,Met,BusHourDur, Cost, EffortHrs FROM vwSLA WHERE ticket# = " & vary

        Dim cmd As SqlCommand

        cmd = New SqlCommand(sql, conn)

        Dim rdr As SqlDataReader

        conn.Open()

        rdr = cmd.ExecuteReader

        Dim tick As String
        Dim n As String
        Dim resp As Boolean
        Dim ana As String
        Dim pri As Integer
        Dim wr As String
        Dim type As String
        Dim cc As String
        Dim met As Boolean
        Dim bush As Long
        Dim co As Long
        Dim eh As Long

        While rdr.Read

            ana = fixNull(rdr("Analyzed"))
            n = fixNull(rdr("Notes"))
            tick = fixNull(rdr("Ticket#"))
            type = fixNull(rdr("type"))
            cc = fixNull(rdr("ClosureCodeName"))
            pri = rdr("priority")
            wr = rdr("Week_Restored")
            met = fixNullBool(rdr("met"))
            bush = rdr("BusHourDur")
            co = rdr("Cost")
            eh = rdr("EffortHrs")
            resp = fixNullBool(rdr("respformissing"))

        End While

        Label_Ana.Text = ana
        Label_ID.Text = tick
        Label_Type.Text = type
        Label_CC.Text = cc
        Label_Priority.Text = pri
        Label_WRes.Text = wr
        Label_Met.Text = met
        Label_BHD.Text = bush
        LabelEffort.Text = eh
        Label_Cost.Text = co
        CheckBox_resp.Checked = resp
        TextBox_Notes.Text = n


        conn.Close()

    End Function

here's the asp.net portion

<telerik:RadGrid ID="RadGrid1" runat="server"
                            DataSourceID="SLA_DB" AllowSorting="True" CellPadding="2" ForeColor="#993333"
                        GridLines="None" Height="300px" DataKeyNames="Ticket#" Width="925px"
                        BorderStyle="Solid" Skin="Hay"
                            GroupingEnabled="False">
                            <ItemStyle BackColor="#3366FF" />
<MasterTableView DataSourceID="SLA_DB" GroupsDefaultExpanded="False" AutoGenerateColumns="False">
    <DetailTables>
        <telerik:GridTableView runat="server" AutoGenerateColumns="False">
            <RowIndicatorColumn>
                <HeaderStyle Width="20px" />
            </RowIndicatorColumn>
            <ExpandCollapseColumn>
                <HeaderStyle Width="20px" height="30px" />
            </ExpandCollapseColumn>
            <HeaderStyle BackColor="#1D33D1" Font-Bold="False" Font-Italic="False"
                Font-Overline="False" Font-Strikeout="False" Font-Underline="False"
                Wrap="True" />
        </telerik:GridTableView>
    </DetailTables>
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" display="False">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
    <Columns>
        <telerik:GridButtonColumn CommandName="Select" Text="Select"
            UniqueName="column">
        </telerik:GridButtonColumn>
        <telerik:GridBoundColumn DataField="Ticket#"
            HeaderText="Ticket#" SortExpression="Ticket#" UniqueName="Ticket#"
            ColumnEditorID="True">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Priority"
            HeaderText="Priority" SortExpression="Priority"
            UniqueName="Priority" DataType="System.Int32">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Week_Restored"
            HeaderText="Week_Restored" SortExpression="Week_Restored"
            UniqueName="Week_Restored" ReadOnly="True">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Type" HeaderText="Type"
            SortExpression="Type" UniqueName="Type">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Analyzed" HeaderText="Analyzed"
            SortExpression="Analyzed" UniqueName="Analyzed" ReadOnly="True">
        </telerik:GridBoundColumn>
        <telerik:GridCheckBoxColumn DataField="Met" DataType="System.Boolean"
            HeaderText="Met" SortExpression="Met" UniqueName="Met">
        </telerik:GridCheckBoxColumn>
        <telerik:GridBoundColumn DataField="IssueName" HeaderText="IssueName"
            SortExpression="IssueName" UniqueName="IssueName1">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ClosureCodeName"
            HeaderText="ClosureCodeName" SortExpression="ClosureCodeName"
            UniqueName="ClosureCodeName">
        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="TeamName" HeaderText="TeamName"
            SortExpression="TeamName" UniqueName="TeamName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="IssueName" HeaderText="IssueName"
            SortExpression="IssueName" UniqueName="IssueName">
        </telerik:GridBoundColumn>

    </Columns>
    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
        Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
        VerticalAlign="Middle" Wrap="True" />
    <AlternatingItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
    <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Names="Calibri"
        Font-Overline="False" Font-Size="14pt" Font-Strikeout="False"
        Font-Underline="False" HorizontalAlign="Center" VerticalAlign="Middle"
        Wrap="True" />
</MasterTableView>

                            <HeaderStyle Font-Size="12pt" Height="30px" />

                            <ClientSettings>
                                <Selecting AllowRowSelect="True" />
                                <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                            </ClientSettings>

<FilterMenu EnableTheming="True">
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
</FilterMenu>
                        </telerik:RadGrid>

[Princy]

Hi,

Could you check if the following code snippet works for you. I have used the selecteditems collection to get the selected item and access the DataKey value.

VB:

Protected Sub RadGrid1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
     Dim str As String = DirectCast(RadGrid1.SelectedItems(0), GridDataItem).GetDataKeyValue("CustomerID").ToString()
End Sub

Thanks,
Princy