Access database Accessibility Component (IV)

access| Access | data | database 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;
}



}
}