第一步:连接数据库
public DataSet GetData(String SqlString)
{
//连接数据库
string oraConnectionString = "User ID=账号;Password=密码;" +
"Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口号))) (CONNECT_DATA = (SERVICE_NAME = 数据库名称)))";
OracleConnection conn = new OracleConnection(oraConnectionString);
try
{
OracleDataAdapter oad = new OracleDataAdapter(SqlString, conn);
DataSet ds = new DataSet();
oad.Fill(ds);
return ds;
}
catch
{
return null;
}
finally
{
conn.Close();
}
}
第二步:查询数据 编写sql语句
public DataSet GetSet1()
{
String SqlString = "select t.*, t.rowid from 表名 t";
DataSet ds = new DataSet();
ds = this.GetData(SqlString);
return ds;
}
第三步:查询按钮 点击显示查询结果
//查询按钮
private void button1_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = this.GetSet1();
if (ds.Tables[0].Rows.Count > 0)
{
this.dataGridView1.DataSource = ds.Tables[0];
}
}