Test App is a good idea. I was wondering about this yesterday when I went to look for a sample I knew I had written before and couldn't find it.

>>Thanks, Bonnie. I knew this should work, I just don't do .NET often enough to post the syntax off the top of my head.<
>
>Hah! You think I have all this syntax in my head?!?! <g>
>
>Actually, a lot of it I *do* know off the top of my head (nowhere *near* everything of course <g>), but I keep a little test app for just this purpose ... to copy/paste sample code that I *know* will work (and if I *do* post code that's just "off the top of my head", then I'll mention that it's untested and posted just to illustrate the concept).
>
>
>~~Bonnie
>
>
>
>>
>>>Actually, Ben, Fred is right ... maybe I should have replied to him yesterday to give him an "attaboy" when I saw his post. Here's how you would do this:
>>>

>>>string ConnString = "server=(local);uid=sa;pwd=";
>>>
>>>SqlConnection oConn = new SqlConnection(ConnString);
>>>SqlCommand sc = new SqlCommand("use MyDataBase", oConn);
>>>oConn.Open();
>>>sc.ExecuteNonQuery();
>>>
>>>sc.CommandText = "select * from MyTable";
>>>SqlDataAdapter da = new SqlDataAdapter(sc);
>>>
>>>DataSet ds = new DataSet();
>>>da.Fill(ds);
>>>oConn.Close();
>>>

>>>
>>>The trick is to open the connection and "use" your database, then keeping the same connection, do whatever else you need to do.
>>>
>>>~~Bonnie
>>>
>>>
>>>>>You don't need to connect to your database in your connection string, just to your server. You can then connect to the appropriate database using the "USE yourdatabase" command via a SQLEXEC. This way, you can change databases using the same connection.
>>>>
>>>>Actually, as it was stated by Borislav and Bonnie earlier in this thread...one has to use the database name in the connection string (Initial Catalog=...) otherwise it won't work. It you notice in my original posting, I mentioned that I tried using the "USE " SQL command and it came back with an error stating that CREATE PROCEDURE has to be the first executing statement in a batch.

(On an infant's shirt): Already smarter than Bush