本文整理汇总了C#中System.Data.DataTableReader.Read方法的典型用法代码示例。如果您正苦于以下问题:C# DataTableReader.Read方法的具体用法?C# DataTableReader.Read怎么用?C# DataTableReader.Read使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataTableReader
的用法示例。
在下文中一共展示了DataTableReader.Read方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: 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(); }
}
}
示例2: 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(); }
}
}
示例3: FillPartyName
private void FillPartyName()
{
DataTableReader read = new DataTableReader(this.maindataset.Pending);
while (read.Read())
{
txtPartyName.Items.Add(read.GetString(3));
}
}
示例4: ImportArticleFromCsv
/// <summary>
/// Imports article from csv file to db. If article with same number exists, it will be replaced.
/// </summary>
/// <param name="db"></param>
/// <param name="file"></param>
/// <returns></returns>
public static bool ImportArticleFromCsv(ISposDb db, string file)
{
// read csv file
DataTable data = ParseCSV(file);
if (data == null)
{
return false;
}
// convert data
DataTableReader reader = new DataTableReader(data);
if (reader.FieldCount != 5 && !reader.HasRows)
{
return false;
}
List<SimplePOS.Article.RegularArticle> articleList = new List<SimplePOS.Article.RegularArticle>();
reader.Read(); // read the header
while (reader.Read())
{
object[] values = new object[5];
int result = reader.GetValues(values);
if (result > 0)
{
try
{
// Text may be empty wich results in a strange object
string text;
try { text = (string)values[2]; }
catch { text = ""; }
articleList.Add(new SimplePOS.Article.RegularArticle((string)values[0],
(string)values[1], text,
Double.Parse((string)values[3]),
Double.Parse((string)values[4])));
}
catch { return false; }
}
}
// import to db
db.SaveArticleList(articleList);
return true;
}
示例5: 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());
}
}
示例6: 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());
}
}
示例7: 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;
}
示例8: 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");
}
}
示例9: 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));
}
}
}
示例10: 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));
}
}
}
示例11: 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));
}
}
}
示例12: 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);
}
示例13: CBoxBind
//对下拉列表进行数据绑定
private void CBoxBind()
{
cbox_SheetName.Items.Clear();//清空下拉列表项
//连接Excel数据库
OleDbConnection olecon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txt_Path.Text + ";Extended Properties=Excel 8.0");
olecon.Open();//打开数据库连接
System.Data.DataTable DTable = olecon.GetSchema("Tables");//实例化表对象
DataTableReader DTReader = new DataTableReader(DTable);//实例化表读取对象
while (DTReader.Read())//循环读取
{
cbox_SheetName.Items.Add(DTReader["Table_Name"].ToString().Replace('$',' ').Trim());//将工作表名添加到下拉列表中
}
DTable = null;//清空表对象
DTReader = null;//清空表读取对象
olecon.Close();//关闭数据库连接
cbox_SheetName.SelectedIndex = 0;//设置下拉列表默认选项为第一项
}
示例14: CtorTest
public void CtorTest ()
{
dt.Rows [1].Delete ();
DataTableReader reader = new DataTableReader (dt);
try {
int i = 0;
while (reader.Read ())
i++;
reader.Close ();
Assert.AreEqual (2, i, "no. of rows iterated is wrong");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
示例15: GetSheetName
//获取所有工作表名称
private List<string> GetSheetName(string P_str_Excel)
{
List<string> P_list_SheetName = new List<string>();//实例化泛型集合对象
//连接Excel数据库
OleDbConnection olecon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + P_str_Excel + ";Extended Properties=Excel 8.0");
olecon.Open();//打开数据库连接
System.Data.DataTable DTable = olecon.GetSchema("Tables");//实例化表对象
DataTableReader DTReader = new DataTableReader(DTable);//实例化表读取对象
while (DTReader.Read())//循环读取
{
string P_str_Name = DTReader["Table_Name"].ToString().Replace('$', ' ').Trim();//记录工作表名称
if (!P_list_SheetName.Contains(P_str_Name))//判断泛型集合中是否已经存在该工作表名称
P_list_SheetName.Add(P_str_Name);//将工作表名添加到泛型集合中
}
DTable = null;//清空表对象
DTReader = null;//清空表读取对象
olecon.Close();//关闭数据库连接
return P_list_SheetName;//返回得到的泛型集合
}