W
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=Northwind; integrated
security=true;");
String strSQL = "SELECT ProductName, UnitsInStock FROM Products
WHERE UnitsInStock >= 50";
SqlCommand objCommand = new SqlCommand(strSQL, objConnection);
objConnection.Open();
ArrayList strLabel = new ArrayList();
ArrayList x = new ArrayList();
SqlDataReader dr = objCommand.ExecuteReader();
while (dr.Read())
{
object[] values1 = new object[0];
dr.GetValues(values1);
strLabel.Add(values1);
object[] values2 = new object[1];
dr.GetValues(values2);
x.Add(values2);
}
dr.Close();
objConnection.Close();
How can I do that?
--Thanks
SqlConnection objConnection = new
SqlConnection("server=(local)\\SQLEXPRESS; database=Northwind; integrated
security=true;");
String strSQL = "SELECT ProductName, UnitsInStock FROM Products
WHERE UnitsInStock >= 50";
SqlCommand objCommand = new SqlCommand(strSQL, objConnection);
objConnection.Open();
ArrayList strLabel = new ArrayList();
ArrayList x = new ArrayList();
SqlDataReader dr = objCommand.ExecuteReader();
while (dr.Read())
{
object[] values1 = new object[0];
dr.GetValues(values1);
strLabel.Add(values1);
object[] values2 = new object[1];
dr.GetValues(values2);
x.Add(values2);
}
dr.Close();
objConnection.Close();