本机跑不起,哎,郁闷啊,
虚拟机里可以
主要是里面有取每个字段的数据的例子
OracleConnection conn = new OracleConnection();
try
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["sourcedb"].ConnectionString;
conn.Open();
string strSQL = "select * from TB_ZY_SFMXB where rownum<10";
OracleCommand cmd = new OracleCommand(strSQL, conn);
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string line = "";
for (int i = 0; i < reader.FieldCount; i++)
{
line += reader.GetName(i).ToString() + "=" + reader.GetValue(i).ToString() + " \n";
}
jg.AppendText(line);
}
}
catch (Exception ex)
{
jg.AppendText(ex.Message+"\n");
}
finally
{
conn.Clone();
}