Radgrid update with unique constraint validation

[Mrinalini]

Hi,
I have a radgrid with an edit form template. There are multiple entry fields in the edit form.
I have a textbox in a radgrid that must be unique. I have created a custom validator for the insert so that it checks to make sure the value does not exist in the database and this works fine. However, if I use the same custom validator in the radgrid edit template, it will not let me update a row with the original value because it sees that it is already in the database. I use  page.isvalid to check before updating the radgrid. How do I get around this issue? Any help is appreciated! Thanks!

[Jayesh Goyani]

Hello,

Also try with below code snippet.

<MasterTableView >

                <Columns>

                    <telerik:GridTemplateColumn UniqueName="FirstName">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                            <asp:Label ID="Label1" Visible="false" runat="server" Text="First name already exists"></asp:Label>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridEditCommandColumn></telerik:GridEditCommandColumn>
                </Columns>
            </MasterTableView>

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
        {
            GridEditableItem item = e.Item as GridEditableItem;
            TextBox TextBox1 = item.FindControl("TextBox1") as TextBox;


            string strName = TextBox1.Text;

            // check if firstname is exists or not

            if (true) // if firstname is exists
            {
                Label Label1 = item.FindControl("Label1") as Label;
                Label1.Visible = true;
                e.Canceled = true;
            }
            else
            {
                // Perform Update Operation
            }

        }

Thanks,
Jayesh Goyani

[Mrinalini]

Hi jayesh,

Thanks for your reply - it was very helpful.

I still have a problem with this though:

Checking if "first name" exists:
I have 2 other textboxes in the edit form for the radgrid (say last name and city). For an existing record, when user tries to update last name or city (or both), the record does not get updated because first name already exists.

How do I overcome this issue?

Thanks!

[Radoslav]

Hi Mrinalini,

I am sending you a simple example which demonstrates the desired functionality. Please check it out and let me know if it helps you. Looking forward for your reply.

All the best,
Radoslav
the Telerik team