Folks,

I have a nested GridTableView (DataSourceId: SqlDataSource2) in my RadGrid. In GridTableView I have a RadComboBox (SqlDatasourceId: SqlDataSource3). I would like to check for Duplicates if that Location is already exists for that person (i.e. Do not allow Duplicate entries for Update/Inserts). Below is my complete code as well as SqlDataSource2_Updating event (Is there any other event that can do the same also?).

Any Help will be appreciated. Thanks

GC_0620

_________________
<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True"

        AllowAutomaticInserts="True" AllowAutomaticUpdates="True"

        AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True"

        AutoGenerateColumns="False"  DataSourceID="SqlDataSource1" GridLines="None"

                Skin="Office2007" PageSize="8" EnableLinqExpressions="False"

                 OnInsertCommand="RadGrid1_InsertCommand"  OnUpdateCommand = "RadGrid1_UpdateCommand"

                >

<MasterTableView datakeynames="UserTablePrimaryKey" datasourceid="SqlDataSource1"  AllowFilteringByColumn = "true" CommandItemDisplay="TopAndBottom">

<DetailTables>

        <telerik:GridTableView runat="server" DataSourceID="SqlDataSource2" DataKeyNames="UserLocationsPrimaryKey"

                Width="100%" Skin="WebBlue"  CommandItemDisplay="Top" Name = "JobPerson"   AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true">

                <ParentTableRelation>

                <telerik:GridRelationFields DetailKeyField="UserTableForeignKey" MasterKeyField="UserTablePrimaryKey" />

                 </ParentTableRelation>

            <RowIndicatorColumn>

                <HeaderStyle Width="20px" />

            </RowIndicatorColumn>

            <ExpandCollapseColumn>

                <HeaderStyle Width="20px" />

            </ExpandCollapseColumn>

            <CommandItemTemplate>

                   <div style="padding: 5px 5px;">

                        Custom command item template&nbsp;&nbsp;&nbsp;&nbsp;

                        <asp:LinkButton ID="btnEditSelected" runat="server" CommandName="EditSelected" Visible='<%# RadGrid1.EditIndexes.Count == 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Edit.gif" /> Edit selected</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" Visible='<%# RadGrid1.EditIndexes.Count > 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Update.gif" /> Update</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="btnCancel" runat="server" CommandName="CancelAll" Visible='<%# RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Cancel.gif" /> Cancel editing</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="LinkButton2" runat="server" CommandName="InitInsert" Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/AddRecord.gif" /> Add new</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="LinkButton3" runat="server" CommandName="PerformInsert" Visible='<%# RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Insert.gif" /> Add this Location</asp:LinkButton>&nbsp;&nbsp;

<asp:LinkButton ID="LinkButton1" OnClientClick="javascript:return confirm('Delete all selected Person?')"

runat="server" CommandName="DeleteSelected"><img style="border:0px;vertical-align:middle;" alt="" src="Images/Delete.gif" /> Delete selected Location</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="LinkButton4" runat="server" CommandName="RebindGrid"><img style="border:0px;vertical-align:middle;" alt="" src="Images/Refresh.gif" /> Refresh list</asp:LinkButton>

                    </div>

                   </CommandItemTemplate>

            <Columns>

        <telerik:GridBoundColumn DataField="UserLocationsPrimaryKey"

            DataType="System.Int32" HeaderText="UserLocationsPrimaryKey" ReadOnly="True"

            SortExpression="UserLocationsPrimaryKey" UniqueName="UserLocationsPrimaryKey"

                    Visible="False">

        </telerik:GridBoundColumn>

                <telerik:GridTemplateColumn DataField="Location" DataType="System.Double"

                    HeaderText="Location" SortExpression="Location" UniqueName="Location">

                    <ItemTemplate>

                        <asp:Label ID="LocationLabel" runat="server" Text='<%# Eval("Location") %>'></asp:Label>

                    </ItemTemplate>

                </telerik:GridTemplateColumn>

                        <telerik:GridBoundColumn DataField="Program" HeaderText="Program"

            SortExpression="Program" UniqueName="Program" >

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="UserTableForeignKey"

            DataType="System.Int32" HeaderText="UserTableForeignKey"

            SortExpression="UserTableForeignKey" UniqueName="UserTableForeignKey"

                    Display="False" ReadOnly="True" Visible="False">

        </telerik:GridBoundColumn>

    </Columns>

   <EditFormSettings EditFormType="Template">

    <FormTemplate>

    <table id="Table1a" cellspacing="2" cellpadding="1" width="100%" border="0" rules="none"

                            style="border-collapse: collapse; background: white;">

                            <tr class="EditFormHeader">

                                <td colspan="2" style="font-size:small;  z-index:0;  font-family:Bookman Old Style; color:#669999">

                                  <b>User Location</b></td>

                            </tr>

                           <tr>

                         <td></td>

                           </tr> <tr>

                                <td>

                                </td>

                                <tr>

                                    <td>

                                        Location</td>

                                    <td>

                                        <telerik:RadComboBox ID="RadComboBoxLocation" runat="server"

                                            DataSourceID="SqlDataSource3" DataTextField="Program" DataValueField="Location"

                                            DropDownWidth="369px" Height="150px" HighlightTemplatedItems="true"

                                            MarkFirstMatch="true"

                                           SelectedValue='<%#Bind("Location") %>' Skin="Office2007" Width="320px"

                                            >

                                            <HeaderTemplate>

                                                <table cellpadding="0" cellspacing="0" style="width: 345px">

                                                    <tr>

                                                        <td style="width: 245px;">

                                                            Program</td>

                                                        <td style="width: 55px;">

                                                            Location</td>

                                                    </tr>

                                                </table>

                                            </HeaderTemplate>

                                            <ItemTemplate>

                                                <table cellpadding="0" cellspacing="0" style="width: 345px">

                                                    <tr>

                                                        <td style="width: 245px;">

                                                            <%# DataBinder.Eval(Container.DataItem, "Program") %>

                                                        </td>

                                                        <td style="width: 55px;">

                                                            <%# DataBinder.Eval(Container.DataItem, "Location") %>

                                                        </td>

                                                    </tr>

                                                </table>

                                            </ItemTemplate>

                                        </telerik:RadComboBox>

                                        <asp:RequiredFieldValidator ID="RadComboBoxLocationRequiredFieldValidator"

                                            runat="server" ControlToValidate="RadComboBoxLocation"

                                            ErrorMessage="! Required">

                                </asp:RequiredFieldValidator>

                                    </td>

                                    <td>

                                        Program</td>

                                    <td>

                                        <asp:TextBox ID="TxtProgram" runat="server" TabIndex="2"  ReadOnly="true"

                                            Text='<%# Eval( "Program") %>' Width="250px">

                                                </asp:TextBox>

                                    </td>

                                                                        </tr>

                                <tr>

                                    <td>

                                    </td>

                                    <td>

                                    </td>

                                    <td>

                                    </td>

                                    <td align="right" colspan="2">

                                        <asp:Button ID="btnUpdate" runat="server"

                                            CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'

                                            Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'

                                           />

                                        &nbsp;

                                        <asp:Button ID="btnCancel" runat="server" CausesValidation="False"

                                            CommandName="Cancel" Text="Cancel" />

                                    </td>

                                </tr>

                           </tr>

                        </table>

    </FormTemplate>

    </EditFormSettings>

        </telerik:GridTableView>

    </DetailTables>       

<!-- Rest of Master Table Continues -->

<Columns>

 '

 '

    </Columns>

<EditFormSettings EditFormType="Template">

    <FormTemplate>

    '

    '

    </FormTemplate>

    </EditFormSettings>

</MasterTableView>

    <ClientSettings>

          '

          '

        </ClientSettings>

    </telerik:RadGrid>

<asp:Label ID="Msglabel" runat="server" Text="Label4"></asp:Label>

 <asp:SqlDataSource ID="SqlDataSource2" runat="server"

                 ConnectionString="<%$ ConnectionStrings:HR_Payroll_AuthorizationConnectionString %>"

                 DeleteCommand="DELETE FROM [UserLocations] WHERE [UserLocationsPrimaryKey] = @UserLocationsPrimaryKey"

                 InsertCommand="INSERT INTO [UserLocations] ([Location], [Program], [UserTableForeignKey]) VALUES (@Location, @Program, @UserTableForeignKey)"

                 SelectCommand="SELECT [UserLocationsPrimaryKey], [Location], [Program], [UserTableForeignKey] FROM [UserLocations] WHERE ([UserTableForeignKey] = @UserTableForeignKey) ORDER BY [Program]"

                 UpdateCommand="UPDATE [UserLocations] SET [Location] = @Location, [Program] = @Program, [UserTableForeignKey] = @UserTableForeignKey WHERE [UserLocationsPrimaryKey] = @UserLocationsPrimaryKey" onupdating="SqlDataSource2_Updating"

               >

                 <SelectParameters>

                <asp:Parameter Name="UserTableForeignKey" Type="Int32" />

                 </SelectParameters>

                 <DeleteParameters>

                     <asp:Parameter Name="UserLocationsPrimaryKey" Type="Int32" />

                 </DeleteParameters>

                 <UpdateParameters>

                     <asp:Parameter Name="Location" Type="Double" />

                     <asp:Parameter Name="Program" Type="String" />

                     <asp:Parameter Name="UserTableForeignKey" Type="Int32" />

                     <asp:Parameter Name="UserLocationsPrimaryKey" Type="Int32" />

                 </UpdateParameters>

                 <InsertParameters>

                     <asp:Parameter Name="Location" Type="Double" />

                     <asp:Parameter Name="Program" Type="String" />

                     <asp:Parameter Name="UserTableForeignKey" Type="Int32" />

                 </InsertParameters>

             </asp:SqlDataSource>

             <asp:SqlDataSource ID="SqlDataSource3" runat="server"

                 ConnectionString="<%$ ConnectionStrings:HR_Payroll_AuthorizationConnectionString %>"

                 SelectCommand="SELECT * FROM [CCNS_All_Location_Codes] WHERE ([Location] IS NOT NULL) ORDER BY [Program]">

             </asp:SqlDataSource>

________________________________________________________　

So Far I came up with this for Duplicate Checking but is not working. Any help will be appreciated..

 protected void SqlDataSource2_Updating(object sender, SqlDataSourceCommandEventArgs e)

    {

       RadComboBox combo = (RadComboBox)RadGrid1.MasterTableView.FindControl("RadComboBoxLocation");

       //RadComboBox combo1 = (RadComboBox)RadGrid1.MasterTableView.Items[0].FindControl("RadComboBoxLocation");

  //string strSelectedItem = combo1.SelectedItem.Text.ToString();

         SqlConnection conLocation = new SqlConnection(ConfigurationManager.

                 ConnectionStrings["HR_Payroll_AuthorizationConnectionString"].ToString());

            SqlCommand cmd = new SqlCommand("SELECT Count(*) FROM UserLocations  " +

                   "WHERE ([Location] = '" + combo.SelectedValue.ToString() + "'", conLocation);

               conLocation.Open();

             Object result = cmd.ExecuteScalar();

             if (result != null)

               {

                   Msglabel.Visible = true;

                   Msglabel.Text = "Duplicate Location for this Person - Can't proceed.."

                   e.Cancel = true;

               }

               conLocation.Close();

    }

telerik:RadSplitter ID="RadSplitter1" runat="server" Orientation="Horizontal"

Width="1000px" BorderSize="0" Skin="WebBlue">

<telerik:RadPane ID="RadPane1" Runat="server" Width="1000px" Height="37px"><asp:Table ID="Table2" runat="server" Width="995px" CellPadding="0" CellSpacing="0" Height="37px">

<asp:TableRow >

<asp:TableCell Font-Names="Freestyle Script" Font-Size="XX-Large" ForeColor="#3F3F3F" Width="3%"></asp:TableCell>

<asp:TableCell Font-Names="Freestyle Script" Font-Size="XX-Large" ForeColor="#666666" Width="72%">(Portal)</asp:TableCell>

<asp:TableCell Font-Names="Arial" Font-Overline="False" Font-Size="Small" ForeColor="#24E6D6" Font-Underline="True" Width="10%">Welcome:</asp:TableCell>

<asp:TableCell ForeColor="#2A7CC1" Font-Names="Arial" Font-Size="Small" Width="15%"></asp:TableCell>

</asp:TableRow>

</asp:Table>

</telerik:RadPane>

<telerik:RadSplitBar ID="RadSplitBar1" runat="server" CollapseMode="Forward" />

<telerik:RadPane ID="RadPane2" runat="server" Width="1000px" Height="493px">

<telerik:RadSplitter ID="RadSplitter2" runat="server" Height="100%"

Width="100%">

<telerik:RadPane ID="RadPane3" runat="server">

</telerik:RadPane>

<telerik:RadSplitBar ID="RadSplitBar2" runat="server" />

<telerik:RadPane ID="RadPane4" runat="server">

</telerik:RadPane>

</telerik:RadSplitter>

</telerik:RadPane>

</telerik:RadSplitter>

with this setup I get scrollbars on the right and botom of what I think is the bottom horizontal panel of the first splitter. I would like a clean join onto the side of the splitter border.

I hope this is a quick one, Thanks in advance for your time and help

mike

Hi.

I have a radgrid with a one detailtable, inside this detail, i have two radcombox, in the insert of the new row, i'm trying to populate the second radcombox with the value from the first radcombox using the event OnSelectedindexChanged, but i'm not getting find the control radcombobox, i'm using the code bellow , but i know that this code is wrong, because I know I need to get index of the line,  but i don't how to get. Could you help-me?

 sqlTarget.SelectCommand = "SELECT* FROM tb_tar_target where  and mov_c_divisao = '" & CType(rdgWorkFlow.MasterTableView.DetailTables(0).FindControl("rdbnil_c_divisao"), RadComboBox).SelectedItem.Text

 CType(rdgWorkFlow.MasterTableView.DetailTables(0).FindControl("rdbnil_tar_n_codigo"), RadComboBox).DataSource = sqlTarget
 CType(rdgWorkFlow.MasterTableView.DetailTables(0).FindControl("rdbnil_tar_n_codigo"), RadComboBox).DataBind()

excuse-me by my english

thanks

Fabio