110,534
社区成员
发帖
与我相关
我的任务
分享
private void button1_Click(object sender, EventArgs e)
{
string connString = @"Data Source=(DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.8.99 )(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=test)));User Id=test ;Password=test";
OracleConnection conn = new OracleConnection(connString);
DataTable dt = ExecuteDataTable(connString, "select * from t1");
dataGridView1.DataSource = dt;
dataGridView1.Show();
}
DataTable ExecuteDataTable(string connstr, string cmdText, params OracleParameter[] commandParameters)
{
OracleCommand command = new OracleCommand();
OracleConnection connection = new OracleConnection(connstr);
DataTable table = null;
try
{
PrepareCommand(command, connection, null, CommandType.Text, cmdText, commandParameters);
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand = command;
table = new DataTable();
adapter.Fill(table);
int rrr = table.Rows.Count;
command.Parameters.Clear();
}
catch
{
throw;
}
finally
{
command.Dispose();
connection.Close();
connection.Dispose();
}
return table;
}