RadGrid to not insert a duplicate record

[Terje Sondresen]

Basically need a way to check that the newly inserted record does not already exist in the rad grid.

my insert command code looks like below. and it works fine for checking that not a blank record is inserted, I just need to add a check that a name does not already exist. Any help would be appreciated.

Protected

Sub cEventTypesGrid_InsertCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles cEventTypesGrid.InsertCommand

 

 

Dim editedItem As GridEditableItem = TryCast(e.Item, GridEditableItem)

 

Dim vLogin As TableCell = editedItem("Name")

Dim vTxtLogin As String = (CType(vLogin.Controls(0), RadComboBox)).SelectedValue

If vTxtLogin = "" Then

 

Throw New Exception("Name cannot be blank.") 

End If

[Jayesh Goyani]

Hello,

protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
       {
           GridEditableItem item = (GridEditableItem)e.Item;
           TableCell vLogin = item["Name"];
           string vTxtLogin = (vLogin.Controls[0] as RadComboBox).SelectedValue;

           bool IsvTxtLoginIsAvialable = true; // do your logic here and set flag here
           if (IsvTxtLoginIsAvialable)
           {
               // Insert functionality should come here
           }
           else
           {
               //Label errorMessage = new Label(); // take one label for show the error message
               errorMessage.Text = "this user is alraedy available.";
               e.Canceled = true;
           }

       }

let me know if any concern.

Thanks,
Jayesh Goyani

[Terje Sondresen]

Hi thanks,

But Im not sure I understood  the answer,

Im basically looking for the logic to compare that the newly enterered name does not match one already in the list

[Radoslav]

Hello Terje,

You could try querying the database into the InsertCommand and check if the value into the vTxtLogin variable already exists into some record. If it exists you could cancel the InsertCommand. Please give it try and let me know if you experience any problems.

Greetings,
Radoslav
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Jayesh Goyani]

Hello,

List<GridDataItem> Items = (from item in RadGrid1.MasterTableView.Items.Cast<GridDataItem>()
                                    where item["Name"].Text!= "Your New Name"
                                    //&& ((CheckBox)item.FindControl("chkSelect")).Checked
                                    select item).ToList();

if you get Items.count > 0 then name exists.

let me know if any concern.

Thanks,
Jayesh Goyani