when i run a query like this:
SqlDataAdapter dap = new SqlDataAdapter("select * from some table", myConnection);
before doing the select, should i be doing "use somedatabase; go" ??
-
5That is specified in your connection string.dotariel– dotariel2010-11-04 18:17:14 +00:00Commented Nov 4, 2010 at 18:17
-
You can see what connection string is appropriate for your scenario by going to connectionstrings.comJude Cooray– Jude Cooray2010-11-04 18:18:55 +00:00Commented Nov 4, 2010 at 18:18
Add a comment
|
6 Answers
No, your database and schema should be set in the connection string for myConnection.
Comments
No you should specify the database name in myConnection
InitialCatalog = [databaseName]
Your connection string should something look like this
data source=[ServerName];Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=[DatabaseName];
Comments
No; the myConnection object's connection string should define which database needs to be used, along with the server and login information.
Comments
That should all be in the myConnection variable, since I presume that contains the connection string.
Although you might want to call using on the DataAdapter
using(SqlDataAdapter dap = new SqlDataAdapter("select * from some table", myConnection)
{
//do stuff with dap here
}//dispose of dap
Since it does inherit from something that implements IDisposable.
Comments
Your connection string tells it what database to connect to.
connectionString = "Data Source=SERVERNAME; Initial Catalog=DATABASENAME; Integrated Security=SSPI;";
That would create a connection to a server and database using windows authentication.
