convert ArrayList object to double

[Web learner]

In the following code, I want ArrayList object x to be of type double.

How can I do that?

--Thanks

SqlConnection objConnection = new
SqlConnection(" server=(local)\ \SQLEXPRESS; database=Northw ind; integrated
security=true;" );
String strSQL = "SELECT ProductName, UnitsInStock FROM Products
WHERE UnitsInStock >= 50";
SqlCommand objCommand = new SqlCommand(strS QL, objConnection);

objConnection.O pen();

ArrayList strLabel = new ArrayList();
ArrayList x = new ArrayList();

SqlDataReader dr = objCommand.Exec uteReader();

while (dr.Read())
{
object[] values1 = new object[0];
dr.GetValues(va lues1);
strLabel.Add(va lues1);

object[] values2 = new object[1];
dr.GetValues(va lues2);
x.Add(values2);
}

dr.Close();
objConnection.C lose();

[agapeton]

Oops sorry...

unitsInStock.Ad d(Convert.ToDou ble(dr.GetValue (1)));

For the other one, these would also work...
productName.Add (Convert.ToStri ng(dr.GetValue( 0)));
productName.Add (dr.GetValue(0) .ToString( ));

[Web learner]

Aha.... The problem is solved and I learnt too.

Thanks a lot.......

<ag******@gmail .com> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. .

Oops sorry...

unitsInStock.Ad d(Convert.ToDou ble(dr.GetValue (1)));

For the other one, these would also work...
productName.Add (Convert.ToStri ng(dr.GetValue( 0)));
productName.Add (dr.GetValue(0) .ToString( ));