Treeview error

[Reetu]

Hi All,

I need to populate the treeview dynamically from the the
tables specie,serie and product. I am not able to get rid
of the following error " System.ArgumentException: These
columns don't currently have unique values."

I am refering to one of the msdn examples and have done
the same as specified in the example.

It would be very kind if someone can tell me whats wrong
in the code below.


Thanks,
-Reetu

string query1 = "SELECT Specie_Id, Specie_Name FROM
Specie";

string query2 = "SELECT
Specie_Id ,Serie_Id,Serie_Name " +
"FROM serie where
Specie_Id in (SELECT Specie_Id FROM Specie)";

string query3= "SELECT top 10
Serie_Id,Product_Name,Product_Id " +
"FROM Product where
serie_Id in " +
"(SELECT Serie_Id " +
"FROM serie where
Specie_Id in (SELECT Specie_Id FROM Specie))";

//SqlConnection objConn = new
SqlConnection
("server=SALVIA;database=GSI_OFFLINE_ED;uid=sa;pwd=xoutsql2
");
SqlConnection objConn = new
SqlConnection
("server=Kompassom;database=GSI_OFFLINE_ED;uid=sa;pwd=xouts
ql2");
SqlDataAdapter daSpecies = new
SqlDataAdapter(query1,objConn);
DataSet objDS = new DataSet();
daSpecies.Fill(objDS,"dtSpecie");

SqlDataAdapter daSeries = new
SqlDataAdapter(query2,objConn);
daSeries.Fill(objDS,"dtSerie");

SqlDataAdapter daProducts = new
SqlDataAdapter(query3,objConn);
daProducts.Fill
(objDS, "dtProduct");

objConn.Close();

objDS.Relations.Add
("SpecieToSerie",
objDS.Tables
["dtSerie"].Columns["Specie_Id"],
objDS.Tables
["dtSpecie"].Columns["Specie_Id"],false);

objDS.Relations.Add("SerieToProd",
objDS.Tables
["dtSerie"].Columns["Serie_Id"],
objDS.Tables
["dtProduct"].Columns["Serie_Id"],false);

TreeNode
nodeSpecie,nodeSerie,nodeProd;

foreach(DataRow rowSpecie in
objDS.Tables["dtSpecie"].Rows)
{
nodeSpecie = new TreeNode
();
nodeSpecie.Text = rowSpecie
["Specie_Name"].ToString();
nodeSpecie.ID = rowSpecie
["Specie_Id"].ToString();
TreeView1.Nodes.Add
(nodeSpecie);

foreach(DataRow rowSerie
in rowSpecie.GetChildRows("SpecieToSerie"))
{
nodeSerie = new
TreeNode();
nodeSerie.Text =
rowSerie["Serie_Name"].ToString();
nodeSerie.ID =
rowSerie["Serie_Id"].ToString();

nodeSpecie.Nodes.Add(nodeSerie);

foreach(DataRow
rowProd in rowSerie.GetChildRows("SerieToProd"))
{
nodeProd =
new TreeNode();

nodeProd.Text = rowProd["Product_Name"].ToString();

nodeProd.ID = rowProd["Product_Id"].ToString();

nodeSerie.Nodes.Add(nodeProd);
}
}

}

objDS.Dispose();
daSpecies.Dispose();
daSeries.Dispose();
daProducts.Dispose();
objConn.Close();
objConn.Dispose();

 

[Patrick.O.Ige]

Hi Reetu,
Are u getting the Data from different tables?
Well i can post u a full code but all my data was from one table
Or post how ur Tables look like!

Hi All,

I need to populate the treeview dynamically from the the
tables specie,serie and product. I am not able to get rid
of the following error " System.ArgumentException: These
columns don't currently have unique values."

I am refering to one of the msdn examples and have done
the same as specified in the example.

It would be very kind if someone can tell me whats wrong
in the code below.


Thanks,
-Reetu

string query1 = "SELECT Specie_Id, Specie_Name FROM
Specie";

string query2 = "SELECT
Specie_Id ,Serie_Id,Serie_Name " +
"FROM serie where
Specie_Id in (SELECT Specie_Id FROM Specie)";

string query3= "SELECT top 10
Serie_Id,Product_Name,Product_Id " +
"FROM Product where
serie_Id in " +
"(SELECT Serie_Id " +
"FROM serie where
Specie_Id in (SELECT Specie_Id FROM Specie))";

//SqlConnection objConn = new
SqlConnection
("server=SALVIA;database=GSI_OFFLINE_ED;uid=sa;pwd=xoutsql2
");
SqlConnection objConn = new
SqlConnection
("server=Kompassom;database=GSI_OFFLINE_ED;uid=sa;pwd=xouts
ql2");
SqlDataAdapter daSpecies = new
SqlDataAdapter(query1,objConn);
DataSet objDS = new DataSet();
daSpecies.Fill(objDS,"dtSpecie");

SqlDataAdapter daSeries = new
SqlDataAdapter(query2,objConn);
daSeries.Fill(objDS,"dtSerie");

SqlDataAdapter daProducts = new
SqlDataAdapter(query3,objConn);
daProducts.Fill
(objDS, "dtProduct");

objConn.Close();

objDS.Relations.Add
("SpecieToSerie",
objDS.Tables
["dtSerie"].Columns["Specie_Id"],
objDS.Tables
["dtSpecie"].Columns["Specie_Id"],false);

objDS.Relations.Add("SerieToProd",
objDS.Tables
["dtSerie"].Columns["Serie_Id"],
objDS.Tables
["dtProduct"].Columns["Serie_Id"],false);

TreeNode
nodeSpecie,nodeSerie,nodeProd;

foreach(DataRow rowSpecie in
objDS.Tables["dtSpecie"].Rows)
{
nodeSpecie = new TreeNode
();
nodeSpecie.Text = rowSpecie
["Specie_Name"].ToString();
nodeSpecie.ID = rowSpecie
["Specie_Id"].ToString();
TreeView1.Nodes.Add
(nodeSpecie);

foreach(DataRow rowSerie
in rowSpecie.GetChildRows("SpecieToSerie"))
{
nodeSerie = new
TreeNode();
nodeSerie.Text =
rowSerie["Serie_Name"].ToString();
nodeSerie.ID =
rowSerie["Serie_Id"].ToString();

nodeSpecie.Nodes.Add(nodeSerie);

foreach(DataRow
rowProd in rowSerie.GetChildRows("SerieToProd"))
{
nodeProd =
new TreeNode();

nodeProd.Text = rowProd["Product_Name"].ToString();

nodeProd.ID = rowProd["Product_Id"].ToString();

nodeSerie.Nodes.Add(nodeProd);
}
}

}

objDS.Dispose();
daSpecies.Dispose();
daSeries.Dispose();
daProducts.Dispose();
objConn.Close();
objConn.Dispose();