OdbcDataReader dr=cmd.ExecuteReader();dr如何读取多条记录的值?
例如:cmd=new OdbcCommand("select ckye from chart where bm='一部'",conn);
得到如下值:
ckye
1231336.25
54465443.00
45454521.55
12154552.70
55521221.20
用什么方法读取每个值,并放入一个数组中?dr.GetValue()吗?给点具体代码啊
例如:cmd=new OdbcCommand("select ckye from chart where bm='一部'",conn);
得到如下值:
ckye
1231336.25
54465443.00
45454521.55
12154552.70
55521221.20
用什么方法读取每个值,并放入一个数组中?dr.GetValue()吗?给点具体代码啊
string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders";
OdbcConnection myConnection = new OdbcConnection(myConnString);
OdbcCommand myCommand = new OdbcCommand(mySelectQuery,myConnection);
myConnection.Open();
OdbcDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read()) {
Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
myConnection.Close();
}
{
..............
}或者你可以放到DataSet中
array()=dr.item(0)
loop
while(dr.Read())
{
if (dr["ckye"].ToString()!="")
{
yValues =(double[])dr["ckye"];
}
}
(double[])dr["ckye"];出错:指定的转换无效。
怎么转换?