Oracle C# DataSet, DataGridView Windows Forms. 1. Oracle ODAC, .
- , . . 2. "" System.Data.OracleClient. 3. using System.Data.OracleClient; : DataSet ds = new DataSet();
DataTable dt = newDataTable("QueryTable"); DataGridView DGW_QueryResult = new DataGridVIew(); using (OracleConnection connection = new OracleConnection(Static.Connection))
{
OracleCommand command = newOracleCommand(query);
command.Connection = connection;
try
{
connection.Open();
OracleDataReader reader = command.ExecuteReader();
ds.Tables.Add(dt);
ds.Load(reader, LoadOption.PreserveChanges, ds.Tables[0]);
DGW_QueryResult.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
//
}
} Oracle DataSet . , reader . reader ( DBNames . while (reader.Read())
{
DBNames CurDB = new DBNames();
CurDB.DisplayName= reader.GetString(1);
CurDB.RealName = string.Format("{0}.{1}", reader.GetString(0), reader.GetString(1) );
db_names.Add(CurDB);
} .NET Framework 3.5 SP1. , System.Data.OracleClient Oracle C# .NET 4.0 . Oracle 9i . ODAC Oracle 9- , , EntityFramework . Oracle ODAC 11- EntityFramework .NET . | 