C# DataTableReader.Read方法代码示例

        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(); }
            }
        }

        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(); }
            }
        }

 private void FillPartyName()
 {
     DataTableReader read = new DataTableReader(this.maindataset.Pending);
     while (read.Read())
     {
         txtPartyName.Items.Add(read.GetString(3));
     }
 }

        /// <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;
        }

 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());
     }
 }

 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());
     }
 }

 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;
 }

        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");
            }
        }

        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));
                }
            }
        }

        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));
                }
            }
        }

        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));
                }
            }
        }

        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);
        }

 //对下拉列表进行数据绑定
 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;//设置下拉列表默认选项为第一项
 }

                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 ();
                        }
                }

 //获取所有工作表名称
 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;//返回得到的泛型集合
 }