C# 读取sqlite数据库image类型数据解决方法

C# 读取sqlite数据库image类型数据
给代码`

[解决办法]
/// <summary>
/// 执行一句SQL 将结果集DataTable添加到DataSet
/// </summary>
/// <param name="CommandText">需要执行的SQL语句</param>
/// <returns></returns>
public static System.Data.DataTable GetData(string CommandText)
{
try
{
if (CommandText != "")
{
System.Data.SQLite.SQLiteConnection SQLiteConnection = SQLite.SQLiteConnectionOpen();

if (SQLiteConnection == null) ///检查连接打开
{
return null;
}
System.Data.SQLite.SQLiteCommand SQLiteCommand = new System.Data.SQLite.SQLiteCommand(CommandText, SQLiteConnection);

SQLite.SQLiteDataAdapter = new System.Data.SQLite.SQLiteDataAdapter(SQLiteCommand);

System.Data.SQLite.SQLiteCommandBuilder SQLiteCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(SQLite.SQLiteDataAdapter);

DataSet.Locale = System.Globalization.CultureInfo.InvariantCulture; ///放到DataSet内存表

foreach (DataTable DataTable in SQLite.DataSet.Tables)//删除 Table 
{
SQLite.DataSet.Tables.Remove(DataTable);
break;
}

SQLite.SQLiteDataAdapter.Fill(DataSet);//把结果集添加到DataSet

if (SQLite.SQLiteConnectionClose())//关闭连接
{
if (DataSet.Tables.Count != 0)
{
return DataSet.Tables[0];
}
}
}
return null;
}
catch (System.Data.SQLite.SQLiteException ex)
{
throw new System.Data.SQLite.SQLiteException("", ex);
}
}