These columns don't currently have unique values

export-spweb : these columns don t currently have unique values
exception setting primarykey these columns don t currently have unique values

I face the following problem : when i try to bind Telerik Treeview

These columns don't currently have unique values.


My code :

protected void BindRTV()
{
    rtv_acd.DataTextField = "name";
    rtv_acd.DataValueField = "main_id";
    rtv_acd.DataFieldID = "main_code";
    rtv_acd.DataFieldParentID = "father_code";
    rtv_acd.DataSource = dt;
    rtv_acd.DataBind();
}

Data snapshot :

How to fix this problem, i know that the main_code is repetitive but i want that .

There is a parent-child relationship between nodes, and the relation works with values specified in DataFieldID and DataFieldParentID members. So you have to specify a field with unique values for DataFieldID member.

Suppose you have two nodes with ID (main_code) of 1 (you already have), and there is another node with parent ID (father_code) of 1. So which of the two nodes are the parent of this node?

DataRelations, One datarelation definition worked, but the second DataRelation is throwing an error 'These columns don't currently have unique values' . Belo. Hi JuneT. Thank you so much for your help over the last couple of days, you are a legend ;-) Everything is working fine, batching with a different Collation ' Latin1_General_CS_AS' on a Primary Key on a single table (other tables all use Latin1_General_CI_AS the Db default).

As Mohammad said you should have at least one unique key column (without repetition). If don't this error will happens when you try to set primary key.

Also take into consideration that you don't have blank rows in that table, that indeed consider as unique column and I had this error.

The best way is to get distinct rows with certain number of column of consideration.

Check with telerik developer forum [1] http://www.telerik.com/forums/fetching-distinct-rows-from-datatable-using-linq [2] http://www.telerik.com/forums/display-distinct-values [3] http://www.telerik.com/forums/adding-5000-distinct-record-for-a-column-based-on-which-grouping-is-done-causing-ie-crash

In this Telerik also replied that you should use a unique column key.

Another tweak may be selecting datatable as distinct values [4]http://www.telerik.com/forums/radtreeview-selectednode-value

Contact them if you havent resolved this at developer forum

These columns don't currently have unique values in UI for ASP.NET , Join a community of over 2.6m developers to have your questions answered on These columns don't currently have unique values of UI for  Check for the casesentivie property in the datatable.if parent table having duplicate values then it will throw the exception 'These columns don't currently have unique values'. BY default datatable will ignore the casesensitivity and read as 'A' and 'a' are same.

this is about sql table and primary key for your table and you have duplicate data in your table feld

These columns don't currently have unique values.?, Check if any value for btNodeID is present more than once in the datatable dt . Your nodeId's should be unique and it sounds like that your  System.Data.DataRelation: These columns don’t currently have unique values. December 10, 2018 | Posted in: .Net So, this is a very short article about creating a relationship between two data tables in a dataset.

HELP: How to fix These columns don't currently have unique values , Guys, Can you help me how to fix it : These columns don't currently have unique values. What should i do with my database. I'm using VB.net  Join a community of over 2.6m developers to have your questions answered on These columns don't currently have unique values of UI for ASP.NET AJAX TreeView. New here?

Error : These columns don't currently have unique values. For , Error : These columns don't currently have unique values. For Employee ID#10. RC posted over 6 years ago. Hi , we have a Ultragrid , that lists the documents  Find answers to Error: ArgumentException These columns don't currently have unique values. from the expert community at Experts Exchange

"These columns don't currently have unique, These columns don't currently have unique values. OR While attempting to open the Programs tab in an Asset record, this error may appear: Now, drag down the formulated cell E2 below from E2 to E6 to find out the result for the entire column. Matching Two Columns with Same Values to Return a Third Column (MATCH & INDEX) The previous problem can be solved with a different formula. In this formula, we will be using the INDEX and MATCH function together.

Comments
  • I've not really used the telerik controls but with most controls the DataValueField is usually a unique identifier.
  • What if they're duplicate string values (and you're not using IDs)? Could it not treat any string value with the same value as the same parent?
  • @PeterX Do you mean it should make a single node for two items with the same string value?