I have a store procedure that expects a parameter "@Abnormality bit". Based on the value true, false or null, the query returns all rows with true , false or all values respectively.
I am using the isnull function to check the value, however I get the following 3 faulty condition.
if i use...
Hi Thanks for the help and I almost got it done. My last question is when I get the list of database from a server, how can I filter out the system database such as master, model, msdb, and tempdb.
myconn.ConnectionString = stringBuilder.ConnectionString
The classes you mentioned gave me pretty good idea, but the structure of your code seems to have problems. What are all the "Me" referencing? May be I just don't understand it enough. Thanks though.
Private Sub GetServerNames()
Dim dbProviderFactory As DbProviderFactory =...
I imported System, System.collections.generic, and System.Collections.ObjectModel
For the getServerName() the following are not recognized.
For the getDatabaseNames()
I am trying to build a user control that will do exactly what the SQL 2005 Connect to Server interface do, eventually create a connection string and store in a app.config file.
It should allow user to select server type, server name, authentication, user name and password.