折雨的天空
c#的odp.net连接oracle的代码
2017-8-14 我好笨


本机跑不起,哎,郁闷啊,



虚拟机里可以







主要是里面有取每个字段的数据的例子



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();
}



发表评论:
昵称

邮件地址 (选填)

个人主页 (选填)

内容