DataGridView, threat as array


i have small problem.
tht generates data very fast and fills a DataGridView.
to prevent double data, can i check a value without knowing on witch row 'X' it is in  the column.

something like

i'm try to find out if out's possible to use a DataGridView as a type of Multi array.
something simular to sql, insert, update and select wihtout looping.

public void Fill_Grid(string data)
if(this.DataGridView1.Rows['X'].Column[0].Value == data)
// omit
// add some more

Open in new window

Who is Participating?
Jaime OlivaresConnect With a Mentor Software ArchitectCommented:
datagridview does not have a facility for this, but you can keep a dictionary in parallel to store the keys.

Dictionary<string, bool> yourKeys = new Dictionary<string, bool>();

indeed the bool value doesnt matters, but you can use it for something.
To add a key to the dictionary:


to previously check if key exists:

if (yourKeys.ContainsKey(somekeyhere)) ...
Natural_DemonAuthor Commented:
yes, i know
but i use 5 dictionary's
i'm trying to visualize the data.
and the code below only works on 1 dictionary.
kind regards

            foreach (KeyValuePair<uint, int> Pair in local_steal_data)
                Grid.Rows.Add(Pair.Key, Pair.Value, "0");

Open in new window

Anurag ThakurTechnical ManagerCommented:
what you intend to do can be best done if you are binding your datagridveiw to a datatable as you can fire sql to your datatable and then rebind the datagridview

i really dont know what kind of data you are dealing with currently and what is the complexity of data but your life will become a lot simpler if you can have a datatable.
Natural_DemonAuthor Commented:
the programma is connected via dll to a popular vistual world "second life", once you connect to a simulator, a burst of data comes in.
lots of data, segarding the simulator your connected to, a normal simulator has 15.000+ objects capacity, called primatives.
so i get al this data, (if my program had a visual interface, to build a view of the simulator.), but i have no visual interface.
but i'm intrested in certained objects.

i tried with sqlite, but the harddisc get to do overtime and eventualy will produce 'database locked' message.
i'll post a thread on this soon.
thanx for pointing that out, i think there might be a work around, but having a dictionary walking paralel to the datagrid.
dictionary<uint localid, int rownumber>
once u know the line number of the grid, it's easy to get the relational data corresponding to 'localid'.
i haven't test it, but i think in theory it's possible.
and possible faster than a real big burst of data.
Natural_DemonAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.