本文整理匯總了C#中Mono.Data.Sqlite.SqliteDataReader.Dispose方法的典型用法代碼示例。如果您正苦於以下問題：C# SqliteDataReader.Dispose方法的具體用法？C# SqliteDataReader.Dispose怎麽用？C# SqliteDataReader.Dispose使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Mono.Data.Sqlite.SqliteDataReader的用法示例。
在下文中一共展示了SqliteDataReader.Dispose方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: HyenaSqliteArrayDataReader
internal HyenaSqliteArrayDataReader (SqliteDataReader reader)
{
rows = new List<object[]> ();
column_names = new Dictionary<string, int> ();
closed = false;
current_row = -1;
ReadAllRows (reader);
reader.Dispose ();
}示例2: GetMonsterData
static public MonsterData GetMonsterData(int id)
{
string query = "SELECT * FROM MONSTER where id = " + id;
reader = ExecuteQuery(query);
MonsterData monster = new MonsterData();
if (reader.Read())
{
monster.id = reader.GetInt32(0);
monster.name = reader.GetString(1);
monster.hp = reader.GetFloat(2);
monster.attack = reader.GetFloat(3);
monster.defence = reader.GetFloat(4);
monster.gold = reader.GetInt32(5);
}
reader.Dispose();
return monster;
}示例3: GetItemData
static public ItemData GetItemData(int id)
{
string query = "SELECT * FROM ITEM where id = " + id;
reader = ExecuteQuery(query);
ItemData item = new ItemData();
if (reader.Read())
{
item.id = reader.GetInt32(0);
item.name = reader.GetString(1);
item.addHp = reader.GetFloat(2);
item.addAttack = reader.GetFloat(3);
item.addDefence = reader.GetFloat(4);
item.addGold = reader.GetInt32(5);
}
reader.Dispose();
return item;
}示例4: ConvertDataReaderToDataSet
public DataSet ConvertDataReaderToDataSet(SqliteDataReader reader, string[] sColNames)
{
DataSet dataSet = new DataSet();
try
{
// DataTable schemaTable = reader.GetSchemaTable();
DataTable dataTable = new DataTable();
for (int i = 0; i < sColNames.Length; i++)
{
string columnName = sColNames[i];
DataColumn column = new DataColumn(columnName);
dataTable.Columns.Add(column);
}
//for (int i = 0; i <= schemaTable.Rows.Count - 1; i++)
//{
// DataRow dataRow = schemaTable.Rows[i];
// string columnName = dataRow["ColumnName"].ToString();DataColumn column = new DataColumn(columnName, dataRow["DataType"].GetType());
// dataTable.Columns.Add(column);
//}
dataSet.Tables.Add(dataTable);
int j = 0;
while (reader.Read())
{
DataRow dataRow = dataTable.NewRow();
for (int i = 0; i < sColNames.Length; i++)
{
dataRow[i] = reader.GetValue(i);
}
j++;
dataTable.Rows.Add(dataRow);
}
reader.Dispose();
}
catch (Exception ex)
{
string sMsg = ex.Message.ToString();
}
return dataSet;
}