RadGrid Grid Column If GridColumn is empty

[Allan]

I would like to execute a stored procedure for each record where the last name column is empty but I can't seem to get this to work.

 

Grid Code

 

<telerik:RadGrid ID="rgd_OrdersNew" runat="server" CellSpacing="0" DataSourceID="sds_ETP_OrdersNew"
                                    GridLines="None" AllowSorting="True">
                                    <MasterTableView AutoGenerateColumns="False" DataSourceID="sds_ETP_OrdersNew" DataKeyNames="IDOrder, InvoiceNumber, OrderLastName"
                                        ClientDataKeyNames="IDOrder, InvoiceNumber, OrderLastName" HeaderStyle-Wrap="False" HeaderStyle-HorizontalAlign="Center">
                                        <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
                                        <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
                                        </RowIndicatorColumn>
                                        <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
                                        </ExpandCollapseColumn>
                                        <Columns>
                                            <telerik:GridTemplateColumn DefaultInsertValue="" HeaderText=" " UniqueName="TemplateColumn"
                                                ItemStyle-HorizontalAlign="Center" ItemStyle-Width="10px" ItemStyle-CssClass="radgrid_count"
                                                FooterStyle-CssClass="radgrid_count">
                                                <ItemTemplate>
                                                    <%# Container.ItemIndex+1 %>
                                                </ItemTemplate>
                                            </telerik:GridTemplateColumn>
                                            <telerik:GridBoundColumn DataField="InvoiceNumber" DataType="System.Int32" FilterControlAltText="Filter InvoiceNumber column"
                                                HeaderText="Invoice" SortExpression="InvoiceNumber" UniqueName="InvoiceNumber"
                                                ItemStyle-HorizontalAlign="Center" DataFormatString="ETP-{0}" ItemStyle-ForeColor="#597791"
                                                ItemStyle-Width="60px" ItemStyle-Wrap="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="IDOrder" DataType="System.Int32" FilterControlAltText="Filter IDOrder column"
                                                HeaderText="Order ID" SortExpression="IDOrder" UniqueName="IDOrder" ItemStyle-HorizontalAlign="Center"
                                                Visible="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="OrderStatus" FilterControlAltText="Filter OrderStatus column"
                                                HeaderText="Status" ReadOnly="True" SortExpression="OrderStatus" UniqueName="OrderStatus"
                                                Visible="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="ShippingMethod" FilterControlAltText="Filter ShippingMethod column"
                                                HeaderText="Shipping" ReadOnly="True" SortExpression="ShippingMethod" UniqueName="ShippingMethod"
                                                Visible="True" ItemStyle-Wrap="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="IDCustomer" DataType="System.Int32" FilterControlAltText="Filter IDCustomer column"
                                                HeaderText="Customer ID" SortExpression="IDCustomer" UniqueName="IDCustomer"
                                                ItemStyle-HorizontalAlign="Center" Visible="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="DateOrder" DataType="System.DateTime" FilterControlAltText="Filter DateOrder column"
                                                HeaderText="Order Date" SortExpression="DateOrder" UniqueName="DateOrder" ItemStyle-HorizontalAlign="Right"
                                                DataFormatString="<nobr>{0}</nobr>">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="OrderCompany" FilterControlAltText="Filter OrderCompany column"
                                                HeaderText="Company" SortExpression="OrderCompany" UniqueName="OrderCompany">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="OrderLastName" FilterControlAltText="Filter OrderLastName column"
                                                HeaderText="Last Name" SortExpression="OrderLastName" UniqueName="OrderLastName"
                                                ItemStyle-Width="100px">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="OrderFirstName" FilterControlAltText="Filter OrderFirstName column"
                                                HeaderText="First Name" SortExpression="OrderFirstName" UniqueName="OrderFirstName"
                                                ItemStyle-Width="100px">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="OrderStep" FilterControlAltText="Filter OrderStep column"
                                                HeaderText="Step" SortExpression="OrderStep" UniqueName="OrderStep" ItemStyle-HorizontalAlign="Center">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="OrderAmount" DataType="System.Decimal" FilterControlAltText="Filter OrderAmount column"
                                                HeaderText="Order Total" SortExpression="OrderAmount" UniqueName="OrderAmount"
                                                DataFormatString="{0:C}" ItemStyle-HorizontalAlign="Right">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="PayMethodType" FilterControlAltText="Filter PayMethod column"
                                                HeaderText="Pay Method" SortExpression="PayMethodType" UniqueName="PayMethodType"
                                                ItemStyle-HorizontalAlign="Center" ItemStyle-Wrap="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="CardType" FilterControlAltText="Filter CardType column"
                                                HeaderText="CardType" SortExpression="CardType" UniqueName="CardType" ItemStyle-HorizontalAlign="Center"
                                                Visible="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="Items" DataType="System.Int32" FilterControlAltText="Filter Items column"
                                                HeaderText="Items" SortExpression="Items" UniqueName="Items" ItemStyle-HorizontalAlign="Center">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="Sheets" DataType="System.Int32" FilterControlAltText="Filter Sheets column"
                                                HeaderText="Sheets" SortExpression="Sheets" UniqueName="Sheets" ItemStyle-HorizontalAlign="Center">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="PastOrdersCount" DataType="System.Int32" FilterControlAltText="Filter PastOrdersCount column"
                                                HeaderText="Orders" SortExpression="PastOrdersCount" UniqueName="PastOrdersCount"
                                                ItemStyle-HorizontalAlign="Center" ItemStyle-BackColor="#CCFFCC">
                                            </telerik:GridBoundColumn>
                                        </Columns>
                                        <EditFormSettings>
                                            <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                                            </EditColumn>
                                        </EditFormSettings>
                                    </MasterTableView>
                                    <ClientSettings>
                                        <Resizing AllowColumnResize="true" ResizeGridOnColumnResize="true" AllowResizeToFit="true" />
                                        <Selecting AllowRowSelect="True"></Selecting>
                                        <ClientEvents OnRowDblClick="OrderDetails_OnRowDblClick" />
                                    </ClientSettings>
                                    <HeaderStyle Font-Bold="True" HorizontalAlign="Center" />
                                    <FilterMenu EnableImageSprites="False">
                                    </FilterMenu>
                                </telerik:RadGrid>

 

 

Code Behind

 

Protected Sub rgd_OrdersNew_DataBound(sender As Object, e As System.EventArgs) Handles rgd_OrdersNew.DataBound
    For Each gridDataItem As GridDataItem In rgd_OrdersNew.Items

        Dim OrderLastName As String = gridDataItem("OrderLastName").Text
        If OrderLastName Is Nothing OrElse OrderLastName = String.Empty Then

            Dim IDOrder As String = gridDataItem.GetDataKeyValue("IDOrder").ToString()

            Dim connectionString As String = DirectCast(ConfigurationManager.ConnectionStrings("ETP_OPS_ConnectionString").ConnectionString, String)
            Dim connection As New SqlConnection(connectionString)
            Dim command As New SqlCommand(connectionString, connection)

            command = New SqlCommand("sp_Fix_Order", connection)
            command.CommandType = CommandType.StoredProcedure

            command.Connection.Open()
            command.Parameters.Add("@IDOrder", SqlDbType.Int).Value = IDOrder
            command.ExecuteNonQuery()
            command.Connection.Close()



        End If
    Next
End Sub

 

 Thank you as always.

 

[Konstantin Dikov]

Hello Allan,

If the value in the underlying database is "null", the Text property for the corresponding TableCell will contain the non-breaking white space entity " ". This entity is included in the empty cells, so it could handle a IE7 bug with empty TD elements.

With the above in mind, in your condition you need to check if the Text property of the cell is equal to " ".

Hope this helps.


Best Regards,
Konstantin Dikov
Telerik