usingSystem;
namespaceFenceKing.DataProviders
3、OracleDataProvider.cs 访问Oracle的类
usingSystem;
usingSystem.Data;
usingSystem.Data.OracleClient;
namespaceFenceKing.DataProviders
App.config 应用程序配置文件。
FenceKingTest 客户测试
public FenceKingTest()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
// 声明一个接口,返回一个访问SQL Server的数据库实例
FenceKing.DataProviders.IDataProvider sqlDataProvider = FenceKing.DataProviders.DataProvider.CreateDataProvider(DataProvider.DataProviderType.SqlDataProvider);
string[] sql = new string[2];
sql[0] = "SELECT * FROM Orders";
sql[1] = "SELECT CustomerID, CompanyName, ContactName FROM Customers";
DataSet ds;
string[] tableName = new string[]{"Orders","Customers"};
ds = sqlDataProvider.RetriveDataSet(sql, tableName);
ds.Relations.Add("CustomerOrders",ds.Tables["Customers"].Columns["CustomerID"],ds.Tables["Orders"].Columns["CustomerID"]);
this.dataGrid1.SetDataBinding(ds, ds.Tables[1].TableName);
}