>Queue is better, anyway:
>
>public static MyConnection[100] connections;
>// init connections
>
>if (!MyConnection[nIndex].IsInUse) { OleDbConnection con = MyConnection[nIndex].Connection; ... }
>
>public class MyConnection
>{
> OleDbConnection con;
> Bool isInUse;
>
> public MyConnection(OleDbConnection con)
> {
> this.con = con;
> }
> public bool IsInUse {get {return this.isInUse;} set {this.isInUse = value;}}
> public OleDbConnection Connection { get {return this.con;} }
>}
>Thanks, I will try the Queue approach.
