Input array is longer than the number of columns in this table

I've recently started to use SQLite and began to integrate it into a C# project I'm working on.

However, randomly my project will throw the exception:

Input array is longer than the numbe开发者_如何学Gor of columns in this table

I'm having a hard time trying the trace the problem because it seems to be thrown on a random basis.

DataTable table = new DataTable();

//exception is thrown here
table = Global.db.ExecuteQuery("SELECT * FROM vm_manager"); 

Some of the data that gets returned from this query is as follows:

http://i.stack.imgur.com/9rlLN.png

If anyone has any advice, I'd be grateful.

EDIT: I'm unable to show the execute query function as it resides inside a dll from the following sql lite wrapper http://www.codeproject.com/KB/database/cs_sqlitewrapper.aspx

EDIT 2 Problem stems from the new record array function inside this particular sql lite wrapper.

---

Based on your SQLite wrapper's implementation, it is adding columns to its own internal DataTable before returning to yours. I suspect your defect is in the wrapper, and not in your code. I dug into the source of your SQLiteWrapper from CodeProject; here it is at PasteBin: http://pastebin.com/AjGaX0kL

I suspect the error is occurring in that helper method ExecuteQuery(), or its helpers: ReadFirstRow() or ReadFirstRow(), and not your code. Wrap your code in a try catch. Inspect the Exception, and the properties will tell you which method this exception is actually being created in.

Likely you're encountering a defect in this wrapper class.

try
{
    DataTable table = Global.db.ExecuteQuery("SELECT * FROM vm_manager");
}
catch (Exception ex){
//who threw this from which method and line?
} 

If this SQLite provider isn't working, suggest evaluating:

• System.Data.SQLite - An open source ADO.NET provider for the SQLite database engine
• ADO.NET 2.0 Provider for SQLite at SourceForge -- and here's a nice tutorial by Mike Duncan on this SQLite provider.