ACCESS数据库访问组件(四)-asp.net教程
转载自:互联网 作者:cd3c.com
您正在看的asp.net教程是:ACCESS数据库访问组件(四)。
using System;
using System.Data;
using System.Data.OleDb;
using System.Collections;
namespace XLang.VideoOnline.Framework.Database.Access
{
///
/// Summary description for ACCESS_DataViewsCollection.
///
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].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; } }}
<
