我已经解决了我的问题在SQLite sqlite3_column_origin_name函数与一个简单的解决方案,但现在我有另一个大问题。
我有一个sqlwrapper与这些导入:
[DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_int")]
static extern int sqlite3_column_int(IntPtr stmHandle, int iCol);
[DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_text")]
static extern string sqlite3_column_text(IntPtr stmHandle, int iCol);
[DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_double")]
static extern double sqlite3_column_double(IntPtr stmHandle, int iCol);
这是我的ExecuteQuery函数:
public DataTable ExecuteQuery(String query)
{
SQLiteWrapper.query = query;
if (!_open)
throw new SQLiteException("SQLite database is not open.");
//prepare the statement
IntPtr stmHandle = IntPtr.Zero;
try
{
stmHandle = Prepare(query);
}
catch(Exception e)
{
Log.e(e.Message);
return null;
}
// Prevensione sul out of memory
if(stmHandle == IntPtr.Zero)
{
return null;
}
//get the number of returned columns
int columnCount = sqlite3_column_count(stmHandle);
DataTable dTable = null;
try
{
//create datatable and columns
dTable = new DataTable();
for (int i = 0; i < columnCount; i++)
{
try
{
ArrayList selections = Utils.getQuerySelection(query);
foreach(String s in selections)
{
dTable.Columns.Add(s);
}
//Workaround for sqlite3_column_origin_name
//dTable.Columns.Add("_id");
//dTable.Columns.Add(sqlite3_column_origin_name(stmHandle, i));
}
catch(Exception e)
{
}
}
//populate datatable
while (sqlite3_step(stmHandle) == SQLITE_ROW)
{
object[] row = new object[columnCount];
for (int i = 0; i < columnCount; i++)
{
switch (sqlite3_column_type(stmHandle, i))
{
case SQLITE_INTEGER:
// WORKS CORRECTLY!!!!
row[i] = sqlite3_column_int(stmHandle, i);
break;
case SQLITE_TEXT:
// ERROR!!!!!!!!!!!!!!!!!!!!!!
row[i] = sqlite3_column_text(stmHandle, i);
break;
case SQLITE_FLOAT:
row[i] = sqlite3_column_double(stmHandle, i);
break;
}
}
dTable.Rows.Add(row);
}
}
catch(AccessViolationException ave)
{
Log.e("SqliteWrapper - AccessViolationException - " + ave.Message + ":" + query);
return null;
}
// Se ci sono stati errori allora torna null e ritenta la query
Boolean finalized = Finalize(stmHandle);
if(!finalized)
{
return null;
}
return dTable;
}
当我调用sqlite3_column_text(…)我的应用程序崩溃。我已经探索了dll文件中的函数,这个入口点"sqlite3_column_text"存在。
我能解决我的问题吗?
编辑:我从http://sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/1.0.66.0/下载我的sqlite3.dll文件
文件在/bin/x64内,我已将其重命名为sqlite3.dll
编辑2:点击我有更多的信息:File che contribuiscono all description del problema:
C:UsersUtenteAppDataLocalTemp WERB927.tmp.WERInternalMetadata.xmlC:UsersUtenteAppDataLocalTemp WERD59D.tmp.appcompat.txt
C:UsersUtenteAppDataLocalTemp WERD5BD.tmp.mdmpLeggere l'informativa sulla privacy online:
http://go.microsoft.com/fwlink/?linkid=104288& clcid = 0 x0410Se l'informativa sulla隐私在线非è一次性,leggere windows system32it- it erofflps.txt
试试下面的代码
[DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_text")]
static extern string sqlite3_column_text(IntPtr stmHandle, int iCol);
string
[DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_text")]
static extern IntPtr sqlite3_column_origin_name(IntPtr stmHandle, int iCol);
row[i] = Marshal.PtrToStringAnsi(sqlite3_column_text(stmHandle, i));