C# - Oracle数据库连接方法

2024-07-21 02:18:23

字体：大中小

来源：转载

供稿：网友

国内最大的酷站演示中心!
using system;
using system.data;
using system.data.oracleclient;

class sample
{
public static void main()
{
string myconnstring = "user id=zk;data source=zkqx;password=*****";
oracleconnection myconnection = new oracleconnection(myconnstring);

oraclecommand catcmd = myconnection.createcommand();
catcmd.commandtext = " select czydm,czymc,czymm,czyqx from zc_czy ";

myconnection.open();

oracledatareader myreader = catcmd.executereader();

while (myreader.read())
{
console.writeline("/t{0}/t{1}/t{2}/t{3}", myreader.getstring(0),myreader.getstring(1),myreader.getstring(2),myreader.getstring(3));
}

myreader.close();

myconnection.close();
}
}

上一篇：C#中使用Oracle 存储过程笔记

下一篇：C#下实现ping功能