|
 using System;
namespace FenceKing.DataProviders
 
3、OracleDataProvider.cs 訪問Oracle的類
using System;
using System.Data;
using System.Data.OracleClient;
namespace FenceKing.DataProviders
App.config 應(yīng)用程序配置文件。
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<!-- 此處顯示用戶應(yīng)用程序和配置的屬性設(shè)置。-->
<!-- 示例：<add key="settingName" value="settingValue"/> -->
<!-- 連接數(shù)據(jù)庫的字符串 -->
<add key="oracleConnectionString" value="User Id=southfence;Data Source=FENCEORA;Password=southfence;Persist Security Info=true;" />
<add key="sqlConnectionString" value="workstation id=FENCEKING;packet size=4096;integrated security=SSPI;data source="FENCEKING\FENCESQL";persist security info=True;initial catalog=Northwind" />
<add key="oleDbConnectionString" value="" />
<add key="odbcConnectionString" value="" />
</appSettings>
</configuration>
FenceKingTest 客戶測(cè)試
public FenceKingTest()
{
//
// Windows 窗體設(shè)計(jì)器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調(diào)用后添加任何構(gòu)造函數(shù)代碼
//
// 聲明一個(gè)接口，返回一個(gè)訪問SQL Server的數(shù)據(jù)庫實(shí)例
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);
}
|
