system error?

[Techno]

at the executenonreader statement, i always get a system error. what am i doing wrong?

            string SQLConnString = myConnection;
            SqlConnection myConn = new SqlConnection(SQLConnString);
            
            myConn.Open();

            SqlCommand myCommand = new SqlCommand("USE " + TxtDBName.Text + " " + storeProcString);
            SqlDataAdapter da1 = new SqlDataAdapter(myCommand);
            myCommand.Connection = myConn;
            myCommand.ExecuteNonQuery();
            myConn.Close();

[dj4uk]

Try:

string SQLConnString = myConnection;
            SqlConnection myConn = new SqlConnection(SQLConnString);

            SqlCommand myCommand = new SqlCommand("USE " + TxtDBName.Text + " " + storeProcString, myConn);
            SqlDataAdapter da1 = new SqlDataAdapter(myCommand);
            myCommand.ExecuteNonQuery();

DJ

[Mike Hildner]

If you put your code in a try...catch block, and catch the SqlExcpetion, you'll get better details of the exact problem.