1) I am using click once deployment, and I do not want the user to see the database setup wizard.

2) because of #1, I have to use DataLayer.DataSources.Add to add my database connection

3) The main application (Program.cs) runs many other SF forms.

4) Some of these SF forms read data directly (do not use BO's)

so far so good?

Question: How can I create s SQLConnection and pass it the ConnectString without using ConnectionManager to get it?

i.e.how can I get the connection string from the datalayer? I really don't want to code the connectstring in all of my forms that need it when not using the BO to get the data.

I know this is probably so obvious it's stupid, but....

Thanks in advance.

Doug

That's exactly what I was looking for.  Worked perfectly. 

Trent,

I'll look forward to seeing your example on using the BBS in reporting.  Maybe I'm just too used to doing things the old fashioned way

Thanks for all the help!

Doug