本文整理汇总了C#中System.Data.SQLite.SQLiteDataReader.NextResult方法的典型用法代码示例。如果您正苦于以下问题:C# SQLiteDataReader.NextResult方法的具体用法?C# SQLiteDataReader.NextResult怎么用?C# SQLiteDataReader.NextResult使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SQLite.SQLiteDataReader
的用法示例。
在下文中一共展示了SQLiteDataReader.NextResult方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DataReader2DataSet
public DataSet DataReader2DataSet ( SQLiteDataReader reader )
{
DataSet dataSet = new DataSet ( );
do
{
// Create new data table
DataTable schemaTable = reader.GetSchemaTable ( );
DataTable dataTable = new DataTable ( );
if ( schemaTable != null )
{
// A query returning records was executed
for ( int i = 0 ; i < schemaTable.Rows.Count ; i++ )
{
DataRow dataRow = schemaTable.Rows [ i ];
// Create a column name that is unique in the data table
string columnName = ( string ) dataRow [ "ColumnName" ];
// Add the column definition to the data table
DataColumn column = new DataColumn ( columnName , ( Type ) dataRow [ "DataType" ] );
dataTable.Columns.Add ( column );
}
dataSet.Tables.Add ( dataTable );
// Fill the data table we just created
while ( reader.Read ( ) )
{
DataRow dataRow = dataTable.NewRow ( );
for ( int i = 0 ; i < reader.FieldCount ; i++ )
dataRow [ i ] = reader.GetValue ( i );
dataTable.Rows.Add ( dataRow );
}
}
else
{
// No records were returned
DataColumn column = new DataColumn ( "RowsAffected" );
dataTable.Columns.Add ( column );
dataSet.Tables.Add ( dataTable );
DataRow dataRow = dataTable.NewRow ( );
dataRow [ 0 ] = reader.RecordsAffected;
dataTable.Rows.Add ( dataRow );
}
}
while ( reader.NextResult ( ) );
return dataSet;
}
示例2: ParseWithReferences
private static File ParseWithReferences(SQLiteDataReader dr)
{
if (!dr.Read()) return null;
File file = Parse(dr);
List<Tag> tags = new List<Tag>();
dr.NextResult();
while (dr.Read())
{
Tag tag;
tags.Add(tag = new Tag
{
Id = dr.GetInt32(0),
Description = dr.GetString(1)
});
object idTagTypeObj = dr.GetValue(2);
if (idTagTypeObj != DBNull.Value)
{
tag.TagType = new TagType
{
Id = dr.GetInt32(2),
Description = dr.GetString(3)
};
}
}
file.Tags = tags;
return file;
}