本文整理汇总了C#中System.Data.DataTableReader类的典型用法代码示例。如果您正苦于以下问题:C# DataTableReader类的具体用法?C# DataTableReader怎么用?C# DataTableReader使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DataTableReader类属于System.Data命名空间,在下文中一共展示了DataTableReader类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的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(); }
}
}
示例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(); }
}
}
示例3: FillPartyName
private void FillPartyName()
{
DataTableReader read = new DataTableReader(this.maindataset.Pending);
while (read.Read())
{
txtPartyName.Items.Add(read.GetString(3));
}
}
示例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);
}
}
示例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);
}
}
示例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());
}
示例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);
}
}
示例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"));
}
示例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;
}
示例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());
}
}
示例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());
}
}
示例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();
}
示例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");
}
}
示例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;
}
示例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));
}
}
}