asp.net用DataReader从数据库中获取数据

asp.net用DataReader从数据库中获取数据

string connStr = "user id=username; data source=xxx; password=pwd";

string selectStr = "SELECT * FROM TableName";

OracleConnection conn = new OracleConnection(connStr);

OracleCommand cmd = conn.CreateCommand();

cmd.CommandText = selectStr;

conn.Open();

OracleDataReader MyReader = cmd.ExecuteReader();

while(MyReader.Read())

{

Console.WriteLine(MyReader.GetInt32(0).ToString());

Console.WriteLine(MyReader.GetString(1).ToString());

}

上一篇：asp.net用DataSet从数据库中获取数据
下一篇：asp.net执行SQL命令