初学oracle,遇到了问题:
用sql developer 建表填表,想用c#来连接数据库读取其中数据,但运行时报错:ORA—00911:无效字符
我的代码很简单,照书上例子写的,大家帮我看看吧:using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OracleClient;
using System.Data;namespace ORACLEconnection
{
class Program
{
static void Main(string[] args)
{ string ConnectionString = "Data Source=ORCL;User ID=FIA;Password=fiafia;Unicode=True";
OracleConnection conn = new OracleConnection(ConnectionString);
try{
Console.WriteLine("START!");
conn.Open();
Console.WriteLine("OK!");
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from stu;";
OracleDataReader odr = cmd.ExecuteReader();
while (odr.Read()) { Console.WriteLine(odr.GetOracleString(1).ToString()); }
}
catch(Exception ee){Console.WriteLine(ee.Message);}
finally{conn.Close(); }
}
}
}
用sql developer 建表填表,想用c#来连接数据库读取其中数据,但运行时报错:ORA—00911:无效字符
我的代码很简单,照书上例子写的,大家帮我看看吧:using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OracleClient;
using System.Data;namespace ORACLEconnection
{
class Program
{
static void Main(string[] args)
{ string ConnectionString = "Data Source=ORCL;User ID=FIA;Password=fiafia;Unicode=True";
OracleConnection conn = new OracleConnection(ConnectionString);
try{
Console.WriteLine("START!");
conn.Open();
Console.WriteLine("OK!");
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from stu;";
OracleDataReader odr = cmd.ExecuteReader();
while (odr.Read()) { Console.WriteLine(odr.GetOracleString(1).ToString()); }
}
catch(Exception ee){Console.WriteLine(ee.Message);}
finally{conn.Close(); }
}
}
}
裡面的;分號不需要,改成
cmd.CommandText = "select * from stu";
把里面的分号去掉