Hi

Can I have an array of type OleDb.OleDbConnection that has strings as
subscription values? The reason I need this is my app reads a configuration
file with db names and their locations and it then creates all connections
and if subscript is the db name as string then it is easy for the app to
figure out which db is which and to link it with other db settings in the
configuration file.

Thanks

Regards

"John" <(E-Mail Removed)> wrote in
news:#(E-Mail Removed):

> Can I have an array of type OleDb.OleDbConnection that has strings as
> subscription values? The reason I need this is my app reads a
> configuration file with db names and their locations and it then
> creates all connections and if subscript is the db name as string then
> it is easy for the app to figure out which db is which and to link it
> with other db settings in the configuration file.

You can store several connections in a hashtable. However, it is best to
open/close connections as you need them and not keep several connections
open.

--
(E-Mail Removed) (Do not e-mail)

Can hashtable be of type OleDb.OleDbConnection?

Thanks

Regards

"Spam Catcher" <(E-Mail Removed)> wrote in message
news:Xns9A1F19E07CD1Busenethoneypotrogers@127.0.0.1...
> "John" <(E-Mail Removed)> wrote in
> news:#(E-Mail Removed):
>
>> Can I have an array of type OleDb.OleDbConnection that has strings as
>> subscription values? The reason I need this is my app reads a
>> configuration file with db names and their locations and it then
>> creates all connections and if subscript is the db name as string then
>> it is easy for the app to figure out which db is which and to link it
>> with other db settings in the configuration file.
>
> You can store several connections in a hashtable. However, it is best to
> open/close connections as you need them and not keep several connections
> open.
>
> --
> (E-Mail Removed) (Do not e-mail)

You mean the value part? Sure, why not.
However, I would recommend, as stated in previous post, to avoid retaining
connections - that's the connection pool's job.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Can hashtable be of type OleDb.OleDbConnection?

Thank. Could you tell ma how to declare a hashtable of type
OleDb.OleDbConnection with a string type subscript?

Thanks

regards


"Miha Markic" <miha at rthand com> wrote in message
news:(E-Mail Removed)...
> You mean the value part? Sure, why not.
> However, I would recommend, as stated in previous post, to avoid retaining
> connections - that's the connection pool's job.
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "John" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Can hashtable be of type OleDb.OleDbConnection?
>

What .net version are you using?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"John" <(E-Mail Removed)> wrote in message
news:%23$k%(E-Mail Removed)...
> Thank. Could you tell ma how to declare a hashtable of type
> OleDb.OleDbConnection with a string type subscript?
>
> Thanks
>
> regards
>
>
> "Miha Markic" <miha at rthand com> wrote in message
> news:(E-Mail Removed)...
>> You mean the value part? Sure, why not.
>> However, I would recommend, as stated in previous post, to avoid
>> retaining connections - that's the connection pool's job.
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "John" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Can hashtable be of type OleDb.OleDbConnection?
>>
>
>

I am on vs2008, can use any.

Regards

"Miha Markic" <miha at rthand com> wrote in message
news:(E-Mail Removed)...
> What .net version are you using?
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "John" <(E-Mail Removed)> wrote in message
> news:%23$k%(E-Mail Removed)...
>> Thank. Could you tell ma how to declare a hashtable of type
>> OleDb.OleDbConnection with a string type subscript?
>>
>> Thanks
>>
>> regards
>>
>>
>> "Miha Markic" <miha at rthand com> wrote in message
>> news:(E-Mail Removed)...
>>> You mean the value part? Sure, why not.
>>> However, I would recommend, as stated in previous post, to avoid
>>> retaining connections - that's the connection pool's job.
>>>
>>> --
>>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>>> RightHand .NET consulting & development www.rthand.com
>>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>>
>>> "John" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Can hashtable be of type OleDb.OleDbConnection?
>>>
>>
>>
>

You can use Dictionary<K,V> then, i.e.
Dictionary<string, OleDbConnection> dict = new Dictionary<string,
OleDbConnection>();
dict.Add("...", conn);

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"John" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I am on vs2008, can use any.
>
> Regards
>
> "Miha Markic" <miha at rthand com> wrote in message
> news:(E-Mail Removed)...
>> What .net version are you using?
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "John" <(E-Mail Removed)> wrote in message
>> news:%23$k%(E-Mail Removed)...
>>> Thank. Could you tell ma how to declare a hashtable of type
>>> OleDb.OleDbConnection with a string type subscript?
>>>
>>> Thanks
>>>
>>> regards
>>>
>>>
>>> "Miha Markic" <miha at rthand com> wrote in message
>>> news:(E-Mail Removed)...
>>>> You mean the value part? Sure, why not.
>>>> However, I would recommend, as stated in previous post, to avoid
>>>> retaining connections - that's the connection pool's job.
>>>>
>>>> --
>>>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>>>> RightHand .NET consulting & development www.rthand.com
>>>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>>>
>>>> "John" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> Can hashtable be of type OleDb.OleDbConnection?
>>>>
>>>
>>>
>>
>
>