我用的是vb写的,是这样的 Imports System.Data.OleDb Private objDbCommand As OleDbCommand Private objConn As OleDbConnection strUrl = "Provider=OraOLEDB.Oracle;Data Source=orcl;User ID=user319;Password=user319" Try objConn = New OleDbConnection(strUrl) objConn.Open() objDbCommand = New OleDbCommand objDbCommand.Connection = objConn Catch ex As Exception Exit Sub End Try 我这样做是可以的,你试试看
//一个通用的DataSet数据库连接函数-------------------------------------------------------
public DataSet connect_DataSet(string strSQL)
{
DataSet objDS = new DataSet();
try
{
objConnection.Open();
OracleDataAdapter objOraDA = new OracleDataAdapter(strSQL,objConnection);
objOraDA.Fill(objDS);
}
catch(System.Data.OracleClient.OracleException E)
{
throw new Exception(E.Message);
}
finally
{
objConnection.Close();
}
return objDS;
} //执行SQL语句的数据库通用连接--------------------------------------------------------------
public bool connect_NonQuery(string strSQL)
{
OracleCommand objCommand = new OracleCommand(strSQL,objConnection);
try
{
objCommand.Connection.Open();
objCommand.ExecuteNonQuery();
return true;
}
catch(System.Data.OracleClient.OracleException E)
{
throw new Exception(E.Message);
}
finally
{
objCommand.Dispose();
objConnection.Close();
}
}
Imports System.Data.OleDb
Private objDbCommand As OleDbCommand
Private objConn As OleDbConnection
strUrl = "Provider=OraOLEDB.Oracle;Data Source=orcl;User ID=user319;Password=user319"
Try
objConn = New OleDbConnection(strUrl)
objConn.Open()
objDbCommand = New OleDbCommand
objDbCommand.Connection = objConn
Catch ex As Exception
Exit Sub
End Try
我这样做是可以的,你试试看
string StrConn = "Data Source=mrain;user id=SYS;password=change_on_install";
OracleConnection myConn=new OracleConnection(StrConn);
myConn.Open();
string SqlStr ="select * from temp";
OracleCommand MyCommand = new OracleCommand(SqlStr,myConn);
OracleDataReader myReader = MyCommand.ExecuteReader();
int i=0;
while(myReader.Read())
{
TextBox1.Text = myReader["name"].ToString();
}
myReader.Close();
myConn.Close(); }