Loading a table from database to DataGrid
Posted: Tue 05 Oct 2010 08:14
Hello,
I'm a newbie in this area of ADO.NET but I have a problem, I want to load from a mysql database table all the data and for this i'm using dotconnect. For loading the data from the database in my program interface i'm using a DataGrid. The Datagrid is updated periodicaly(at 10 seconds, or 600 seconds, depends), after some updates of the datagrid I receive an exception that I can't solve it :
system.indexoutofrangeexception: index 0 does not have a value.
My problem is, if is somewhere have a sample of code that can help me to build my method to load the data from the mysql table it will me enough for. I've tried many methods but I couldn't make it work.
I'm a newbie in this area of ADO.NET but I have a problem, I want to load from a mysql database table all the data and for this i'm using dotconnect. For loading the data from the database in my program interface i'm using a DataGrid. The Datagrid is updated periodicaly(at 10 seconds, or 600 seconds, depends), after some updates of the datagrid I receive an exception that I can't solve it :
system.indexoutofrangeexception: index 0 does not have a value.
My problem is, if is somewhere have a sample of code that can help me to build my method to load the data from the mysql table it will me enough for. I've tried many methods but I couldn't make it work.