ACCESS資料庫訪問組件(四)

來源:互聯網
上載者:User
access|訪問|資料|資料庫 using System;
using System.Data;
using System.Data.OleDb;
using System.Collections;


namespace XLang.VideoOnline.Framework.Database.Access
{
/// <summary>
/// Summary description for ACCESS_DataViewsCollection.
/// </summary>
public class DataViewsCollection
{
private Database.Access.DataView[] _views;

private int _count;

public int Count
{
get
{
return _count;
}
}


public DataViewsCollection(OleDbConnection connection)
{
System.Data.DataTable schemaTable = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null,null, "VIEW"});

_count=schemaTable.Rows.Count;
_views=new Database.Access.DataView[_count];

for(int i=0;i<_count;i++)
{
_views[i]=new Database.Access.DataView(schemaTable.Rows[i][2].ToString());
}
}


public Database.Access.DataView this [int tableIndex]
{
get
{
return _views[tableIndex];
}
set
{
_views[tableIndex]=value;
}
}


public Database.Access.DataView this [string viewName]
{
get
{
return this [NameToIndex(viewName)];
}
set
{
this [NameToIndex(viewName)]=value;
}
}


private int NameToIndex(string viewName)
{
for(int i=0;i<_views.Length;i++)
{
if(_views[i].Name.ToUpper()==viewName.ToUpper())
return i;
}
return -1;
}



}
}





相關文章

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。