Search results

  1. A

    SQL Parameter isNull() Boolean/Bit True False Null Problem

    what is the benefit of isnull() vs is null ?
  2. A

    SQL Parameter isNull() Boolean/Bit True False Null Problem

    thanks and I appreciate the correct answer. Can you help me understand why did isnull() not work in this case?
  3. A

    SQL Parameter isNull() Boolean/Bit True False Null Problem

    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...
  4. A

    Create Database Connection String Builder like SQL Connect to Server interface

    Hey thanks again, Is the Datatable returned by GetSchema the same as the following SQL ? select * from sys.sysdatabases
  5. A

    Create Database Connection String Builder like SQL Connect to Server interface

    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 myconn.Open()...
  6. A

    Create Database Connection String Builder like SQL Connect to Server interface

    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 =...
  7. A

    Create Database Connection String Builder like SQL Connect to Server interface

    I imported System, System.collections.generic, and System.Collections.ObjectModel For the getServerName() the following are not recognized. Me.CanEnumerateDataSources Me.Factory Me.ServerSchemaCOlumnName Me.InstanceschemaColumnName Me.GetServerName For the getDatabaseNames() Me.Connection...
  8. A

    Create Database Connection String Builder like SQL Connect to Server interface

    Thanks Hey thanks. Where can I learn about specific classes like this, do you have any good reference site or book that I should look into?
  9. A

    Create Database Connection String Builder like SQL Connect to Server interface

    Hi All, 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. It...
Top Bottom