asked on

DataGridView, threat as array

hi,

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
}
else
{
// add some more
}
}

Open in new window

ASKER CERTIFIED SOLUTION

Jaime Olivares

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Natural_Demon

ASKER

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");
                ++i;
            }

Open in new window

Anurag Thakur

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_Demon

ASKER

@ragi0017
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.
@jaime_olivares
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_Demon

ASKER

thanks