本文介绍如何通过Oracle连接字符串连接数据库，并使用ADO.NET获取数据填充数据表，最后将数据展示在dataGridView中。
string connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)));User ID=zjm1031;password=zjm1031;Max Pool Size=512;Connection lifetime=12";
DataTable dt = new DataTable();
using (OracleConnection con = new OracleConnection(connectionString))
{
string sql = "select * from sys_ddl";
OracleDataAdapter adapter = new OracleDataAdapter(sql, con);
con.Open();
adapter.Fill(dt);
this.dataGridView1.DataSource = dt;
DataTable dt = new DataTable();
using (OracleConnection con = new OracleConnection(connectionString))
{
string sql = "select * from sys_ddl";
OracleDataAdapter adapter = new OracleDataAdapter(sql, con);
con.Open();
adapter.Fill(dt);
this.dataGridView1.DataSource = dt;
}
扫一扫
670
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
