如何使用C#方法从OleDbDataReader中获取结果

Question

如何从方法返回这个

这对我来说很重要

感谢

这是我的方法：

public static dynamic GetFactorProperties(int factornumber)
        {
            using (var db = new OleDbConnection(cs))
            {
                db.Open();
                var cmd = new OleDbCommand("SELECT * FROM FactorList WHERE FactorNumber = @0", db);
                cmd.Parameters.AddWithValue("@0", factornumber);
                var result = cmd.ExecuteReader();
                if(result.Read())
                {
                    return result ;
                }
                else
                {
                    return ProperiesObject();
                }
            }
        }

这是我的ExpandoObject（）

         public static dynamic ProperiesObject()
         {
             dynamic obj = new ExpandoObject();
            obj.FactorDate = string.Empty;
             obj.FactorNumber = string.Empty;
             obj.CustomerName = string.Empty;
             obj.FactorPrice = string.Empty;
             obj.Discount = string.Empty;
             return obj;
         }

这是从方法源读取的：

        var result = Program.GetFactorProperties(factornumber);
        TXTDate.Text = result.FactorDate;
        TXTFactorNumber.Text = result.FactorNumber;
        TXTCustomerName.Text = result.CustomerName;
        TXTFactorParice.Text = result.FactorPrice;
        TXTDiscount.Text = result.Discount;

Answer 1

方法应该如下所示：

public static dynamic GetFactorProperties(int factornumber)
{
    using (var db = new OleDbConnection(cs))
    {
         db.Open();
         var cmd = new OleDbCommand("SELECT * FROM FactorList WHERE FactorNumber = @0", db);
         cmd.Parameters.AddWithValue("@0", factornumber);
         var result = cmd.ExecuteReader();
         if(result.Read())
         {
              dynamic obj = new ExpandoObject();
              obj.FactorDate = result.GetString(0);
              obj.FactorNumber = result.GetString(1);
              // ...
              return obj;
         }
         else
         {
              return ProperiesObject();
         }
    }
}

GetString接受列的数目，您希望从中获得值