添加Oracle.DataAccess.dll引用,然后在按钮事件下写入如下代码
string connectionString; string queryString;
// 连接字符串1 connectionString = "Data Source=192.168.1.111/ORCLDBTEST;User ID=SYSTEM;PassWord=sa"; // 连接字符串2 //connectionString = "Data Source=(DESCRIPTION="+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.111)(PORT=1521))" + //"(CONNECT_DATA=(SERVICE_NAME=ORCLDBTEST)));"+ "User Id=SYSTEM;Password=sa;"; queryString = "SELECT * FROM TESTTB";
OracleConnection myConnection = new OracleConnection(connectionString); OracleCommand myORACCommand = myConnection.CreateCommand(); myORACCommand.CommandText = queryString; myConnection.Open(); OracleDataAdapter oraDA = new OracleDataAdapter(myORACCommand); DataSet ds = new DataSet(); oraDA.Fill(ds); myConnection.Close(); DataTable dtbl = ds.Tables[0]; this.dataGridView1.DataSource = dtbl;