111,094
社区成员




begin select EMPNO from oratt.bonus; end;
void GetData()
{
string tnsName = "(DESCRIPTION =(CONNECT_DATA =(SERVICE_NAME = repdb1CS_1121)(SERVER = timesten_client)))";
Oracle.DataAccess.Client.OracleConnection con = new Oracle.DataAccess.Client.OracleConnection("User Id=oratt;Password=timesten;Data Source=" + tnsName + ";Statement Cache Size=0;");
try
{
con.Open();
Oracle.DataAccess.Client.OracleCommand cmd = new OracleCommand("select EMPNO from oratt.bonus;", con);
cmd.CommandType = CommandType.Text;
DataTable ds = new DataTable();
OracleDataAdapter da = new OracleDataAdapter(cmd);
da.Fill(ds);//报错
//OracleDataReader rdr = cmd.ExecuteReader();
//while (rdr.Read())
//{
// int f1 = int.Parse(rdr[0].ToString());
// int f2 = int.Parse(rdr[1].ToString());
// Console.WriteLine(f1 + " " + f2);
//}
con.Close();
for (int i = 0; i < ds.Rows.Count; i++)
{
DataRow dr = ds.Rows[i];
int f1 = int.Parse(dr[0].ToString());
int f2 = int.Parse(dr[1].ToString());
int f3 = int.Parse(dr[2].ToString());
MessageBox.Show(f1.ToString() + " " + f2.ToString() + " " + f3.ToString());
}
}
catch (OracleException e)
{
string ee = e.ToString();
}
}