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(); }}
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18