C# – Oracle数据库连接方法-.NET教程,C#语言

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

}

}