8,735
社区成员
发帖
与我相关
我的任务
分享
List<datatabl> returnlist = new List<datatabl>();
//创建连接
String oracleConnString = "Data Source=orcl;User Id=test;Password=test;";
OracleConnection oracleCon = new OracleConnection(oracleConnString);
oracleCon.Open();
string orclSql = "select * from data_table ";
OracleCommand cmm = new OracleCommand(orclSql, oracleCon);
OracleDataAdapter oda = new OracleDataAdapter(cmm);
DataSet ds = new DataSet();
oda.Fill(ds, "data_table");
foreach (DataRow dr in ds.Tables["data_table"].Rows)
{
returnlist.Add(new datatabl
{
Speed = Convert.ToDouble(dr["speed"]),
Speed2 = Convert.ToDouble(dr["speed2"]),
Rate = Convert.ToDouble(dr["rate"])
});
}
return returnlist;