本文整理汇总了C#中System.Data.DataTableReader类的典型用法代码示例。如果您正苦于以下问题：C# DataTableReader类的具体用法？C# DataTableReader怎么用？C# DataTableReader使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DataTableReader类属于System.Data命名空间，在下文中一共展示了DataTableReader类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: Fact
public void Fact()
{
var connection = default (DbConnection);
var reader = default(DbDataReader);
try
{
connection = KandaXunitProviderFactory.Instance.CreateConnection();
connection.Open();
var schema = connection.GetTablesSchema();
reader = new DataTableReader(schema);
while (reader.Read())
{
var name = reader.GetString(reader.GetOrdinal(@"TABLE_NAME"));
var type = reader.GetString(reader.GetOrdinal(@"TABLE_TYPE"));
//this.transformEntity(name, type);
this.transformInsertTable(name, type);
}
}
finally
{
if (reader != null) { reader.Close(); }
if (connection != null) { connection.Close(); }
}
}
开发者ID:kkkkkkaaaaaa，项目名称:kkkkkkaaaaaa，代码行数:28，代码来源:TextTransformFacts.cs
示例2: TransformTextFact
public void TransformTextFact()
{
var connection = default(DbConnection);
var reader = default(DbDataReader);
try
{
connection = this._factory.CreateConnection();
connection.Open();
var schema = connection.GetTablesSchema();
reader = new DataTableReader(schema);
while (reader.Read())
{
var name = TextTemplateFact.GetTableName(reader);
var type = TextTemplateFact.GetTableType(reader);
var context = new InsertTableContext(name, type)
{
ProcedureNamePrefix = @"usp_",
ProcedureNameSuffix = @"",
};
var template = new InsertTableTemplate(context);
template.Initialize();
var text = template.TransformText();
// TODO :
}
}
finally
{
if (reader != null) { reader.Close(); }
if (connection != null) { connection.Close(); }
}
}
开发者ID:kkkkkkaaaaaa，项目名称:kkkkkkaaaaaa，代码行数:35，代码来源:InsertTableTemplateFacts.cs
示例3: FillPartyName
private void FillPartyName()
{
DataTableReader read = new DataTableReader(this.maindataset.Pending);
while (read.Read())
{
txtPartyName.Items.Add(read.GetString(3));
}
}
开发者ID:EdiCarlos，项目名称:MyPractices，代码行数:8，代码来源:Supreme_Pend.cs
示例4: GetColumnAsArrayOf_Int_ReturnsIntArray
public void GetColumnAsArrayOf_Int_ReturnsIntArray()
{
var expected = new[] {1, 2};
using (var dr = new DataTableReader(_dt1)) {
var values = dr.GetColumnAsArrayOf<int>("id");
Assert.AreEqual(expected, values);
}
}
开发者ID:veracross，项目名称:ncontrib，代码行数:9，代码来源:IDataReaderExtensionsTests.cs
示例5: GetColumnNames_Dt1_GetsColumnNames
public void GetColumnNames_Dt1_GetsColumnNames()
{
var expected = new[] {"id", "time", "amount", "description"};
using (var dr = new DataTableReader(_dt1)) {
var names = dr.GetColumnNames();
Assert.AreEqual(expected, names);
}
}
开发者ID:veracross，项目名称:ncontrib，代码行数:9，代码来源:IDataReaderExtensionsTests.cs
示例6: Setup
public void Setup()
{
var schemaTable = new DataTable();
schemaTable.Locale = CultureInfo.InvariantCulture;
mockDataReader = new Mock<IDataReader>();
mockDataReader.Setup(r => r.GetSchemaTable()).Returns(schemaTable);
actualDataReader = new DataTableReader(BuildDataTable());
}
开发者ID:simonwendel，项目名称:poc-db-cache-interceptor，代码行数:10，代码来源:CacheableDataReaderTests.cs
示例7: DataTableReaderEx
public DataTableReaderEx(DataTable pTable)
{
this.isDisposed = false;
// Thank you MicroSoft, for making it a sealed class...
this.reader = new DataTableReader(pTable);
for (int i = 0; i < pTable.Columns.Count; ++i)
{
this.columns.Add(pTable.Columns[i].Caption.ToLower(), i);
}
}
开发者ID:Temperament，项目名称:FiestaShark，代码行数:10，代码来源:DataTableReaderEx.cs
示例8: Databse_ReadLikeQuery_Accept
public void Databse_ReadLikeQuery_Accept()
{
// execute the readLike query on the data
DataTable testTable = new DataTable();
testTable = Database.ReadLikeQuery("files", "id", "2", Database.LikeLocation.Before);
//check if it worked
DataTableReader reader = new DataTableReader(testTable);
Assert.True((reader[0] + " ").Equals(@"1 C:\Users\hdizzle\Desktop\Zoodevio Library\attack on titan\Attack on Titan (Shingeki no Kyojin) S01E16 What Should Be Done.mp4 11/13/2015 1:22:25 AM 11/13/2015 1:22:25 AM"));
}
开发者ID:Kaan0200，项目名称:Zoodevio_VideoLibrary，代码行数:10，代码来源:Database_Test.cs
示例9: GetTablesSchema
/// <summary>
/// 現在のカタログのテーブル定義を取得して返します。
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
public IEnumerable<TableSchemaEntity> GetTablesSchema(DbConnection connection)
{
var schema = connection.GetTablesSchema();
var reader = new DataTableReader(schema);
// TODO: KandaDbDataMapper.MapToEnumerableAsync<T>()
var tables = KandaDbDataMapper.MapToEnumerable<TableSchemaEntity>(reader);
return tables;
}
开发者ID:kkkkkkaaaaaa，项目名称:kkkkkkaaaaaa.VisualStudio.TextTemplating，代码行数:15，代码来源:SchemaRepository.cs
示例10: SupBillReceived_Load
private void SupBillReceived_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'maindataset.mainbill' table. You can move, or remove it, as needed.
this.mainbillTableAdapter.Fill(this.maindataset.mainbill);
DataTable table = this.maindataset.Tables["mainbill"];
DataTableReader read = new DataTableReader(table);
while (read.Read())
{
comboDebitBillNumber.Properties.Items.Add(read.GetInt32(3).ToString());
}
}
开发者ID:EdiCarlos，项目名称:MyPractices，代码行数:11，代码来源:SupBillReceived.cs
示例11: FillComDebitBillIdIsFalse
private void FillComDebitBillIdIsFalse()
{
this.selectlocalbillTableAdapter.Fill(this.lclsupset.selectlocalbill);
DataTable table = this.lclsupset.Tables["selectlocalbill"];
DataTableReader read = new DataTableReader(table);
comboDebitBillNumber.Properties.Items.Clear();
while (read.Read())
{
comboDebitBillNumber.Properties.Items.Add(read.GetInt32(1).ToString());
}
}
开发者ID:EdiCarlos，项目名称:MyPractices，代码行数:11，代码来源:SupLocalBillRecieved.cs
示例12: DataTableReaderListener
internal DataTableReaderListener(DataTableReader reader) {
if (reader == null)
throw ExceptionBuilder.ArgumentNull("DataTableReader");
if (currentDataTable != null) {
UnSubscribeEvents();
}
this.readerWeak = new WeakReference(reader);
currentDataTable = reader.CurrentDataTable;
if (currentDataTable != null)
SubscribeEvents();
}
开发者ID:iskiselev，项目名称:JSIL.NetFramework，代码行数:11，代码来源:DataTableReaderListener.cs
示例13: GetValue_ValidColumnIdentifiers_ReturnsCorrectType
public void GetValue_ValidColumnIdentifiers_ReturnsCorrectType()
{
using (var dr = new DataTableReader(_dt1)) {
dr.Read();
Assert.AreEqual(1, dr.GetValue<int>("id"), "ID");
Assert.AreEqual(1L, dr.GetValue<long>("id"), "ID as long");
Assert.AreEqual(1, dr.GetValue<ushort>("id"), "ID as short");
Assert.AreEqual(1, dr.GetValue<byte>("id"), "ID as byte");
Assert.AreEqual(new DateTime(2011, 03, 31, 18, 22, 13), dr.GetValue<DateTime>("time"), "Time");
Assert.AreEqual(70.41f, dr.GetValue<decimal>("amount"), "Amount");
Assert.AreEqual("Kaffe", dr.GetValue<string>("description"), "Description");
}
}
开发者ID:veracross，项目名称:ncontrib，代码行数:14，代码来源:IDataReaderExtensionsTests.cs
示例14: GetFromDataBase
private static string[] GetFromDataBase()
{
CheckLane.lanesetTableAdapters.tariff_oceanTableAdapter tableAdapter = new CheckLane.lanesetTableAdapters.tariff_oceanTableAdapter();
laneset.tariff_oceanDataTable table = new laneset.tariff_oceanDataTable();
tableAdapter.Fill(table);
DataTableReader reader = new DataTableReader(table);
string[] laneid = new string[table.Rows.Count];
int counter = 0;
while (reader.Read())
{
laneid[counter++] = reader[0].ToString();
}
return laneid;
}
开发者ID:EdiCarlos，项目名称:MyPractices，代码行数:14，代码来源:Program.cs
示例15: should_map_ids
public void should_map_ids()
{
var value = 1;
using (var table = CreateTable("Id", value))
{
var mapper = CreateMapper(table, x => x.Id(y => y.Id));
using (var reader = new DataTableReader(table))
{
reader.Read();
var person = (Foobar)mapper.Map(reader, typeof(Foobar));
Assert.That(person.Id, Is.EqualTo(value));
}
}
}
开发者ID:JonasSamuelsson，项目名称:TinyORM，代码行数:15，代码来源:ObjectMapper_mapping_a_record.cs
示例16: Database_SimpleReadQuery_Accept
public void Database_SimpleReadQuery_Accept()
{
//give the database some data
//var rows = new String[] { "id", "path", "date_added", "date_edited" };
//var data = new String[] { "1", "path", "now", "now" };
//Database.SimpleInsertQuery("files", rows, data);
// execute the read query on the data
DataTable testTable = new DataTable();
testTable = Database.SimpleReadQuery("files", "id", "1");
//check if it worked
DataTableReader reader = new DataTableReader(testTable);
Assert.True((reader[0] + " ").Equals(@"1 C:\Users\hdizzle\Desktop\Zoodevio Library\attack on titan\Attack on Titan (Shingeki no Kyojin) S01E16 What Should Be Done.mp4 11/13/2015 1:22:25 AM 11/13/2015 1:22:25 AM"));
}
开发者ID:Kaan0200，项目名称:Zoodevio_VideoLibrary，代码行数:15，代码来源:Database_Test.cs
示例17: should_map_nullable_type_with_value
public void should_map_nullable_type_with_value()
{
var value = 1;
using (var table = CreateTable("NullableValueDefaultsToZero", value))
{
var mapper = CreateMapper(table, x => x.Value(y => y.NullableValueDefaultsToZero));
using (var reader = new DataTableReader(table))
{
reader.Read();
var person = (Foobar)mapper.Map(reader, typeof(Foobar));
Assert.That(person.NullableValueDefaultsToZero, Is.EqualTo(value));
}
}
}
开发者ID:JonasSamuelsson，项目名称:TinyORM，代码行数:15，代码来源:ObjectMapper_mapping_a_record.cs
示例18: should_map_enums
public void should_map_enums()
{
var value = FoobarEnum.Bar;
using (var table = CreateTable("Enum", value, typeof(int)))
{
var mapper = CreateMapper(table, x => x.Value(y => y.Enum));
using (var reader = new DataTableReader(table))
{
reader.Read();
var person = (Foobar)mapper.Map(reader, typeof(Foobar));
Assert.That(person.Enum, Is.EqualTo(value));
}
}
}
开发者ID:JonasSamuelsson，项目名称:TinyORM，代码行数:15，代码来源:ObjectMapper_mapping_a_record.cs
示例19: Database_SimpleStarQuery_Accept
public void Database_SimpleStarQuery_Accept()
{
//give the database some data
var rows = new String[] { "id", "path", "date_added", "date_edited" };
var data = new String[] { "1", "path", "now", "now" };
Database.SimpleInsertQuery("files", rows, data);
// execute the satr query on the data
DataTable testTable = new DataTable();
testTable = Database.SimpleStarQuery("files");
//check if it worked
DataTableReader reader = new DataTableReader(testTable);
Assert.True((reader[0] + " ").Equals("1 path now now"));
}
开发者ID:Kaan0200，项目名称:Zoodevio_VideoLibrary，代码行数:15，代码来源:Database_Test.cs
示例20: MapUnexistPropertyException_Test
public void MapUnexistPropertyException_Test()
{
ObjectConverter objectConverter = new ObjectConverter();
DataTable dt = new DataTable();
dt.Columns.Add("Name", typeof(string));
dt.Rows.Add("QQ");
var reader = new DataTableReader(dt);
reader.Read();
MapWithoutPropertyTestObject1 obj = new MapWithoutPropertyTestObject1();
objectConverter.MapObject(reader, obj);
Assert.AreEqual("QQ", obj.Name);
Assert.AreEqual(100, obj.Age);
}
开发者ID:yangwen27，项目名称:moonlit，代码行数:16，代码来源:ReaderTranslatorTests.cs
注：本文中的System.Data.DataTableReader类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论