CODEWITHSUNDEEP
c#methodsexpandoobjectoledbdatareader
Mohammad Esmaeili
Mohammad Esmaeili

Reputation: 155

How can get result from OleDbDataReader with C# method

How can return this from method ????

this is important for me

thank

this is my method :

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

and this is my 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;
         }

and this is read from method source :

        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;

Upvotes: 0

Views: 581

Answers (1)

Uriil
Uriil

Reputation: 12628

Method should look like this:

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 accepts number of column, from which you want to get value

Upvotes: 1

Related Questions