' Declare variable named theConnectionString of type String;

       '  Assign a connection string to theConnectionString variable.

       ' NOTE: To run this yourself replace the connection string with a connection string to a

       '  SQL Server with the Northwind database installed that you have permission to access.

       Dim theConnectionString As String = "Data Source=az-4ffd1ee68bce;Initial Catalog=Northwind;Integrated Security=True"

 

       ' Declare a variable named theQueryString of type String;

       '  Assign a string containing a SQL SELECT command to theQueryString

       Dim theQueryString As String = "SELECT CategoryID, CategoryName FROM dbo.Categories;"

 

       ' The Visual Basic 2005 'Using' keyword simplifies the use of Dispose methods by

       '  automatically calling dispose for an object.

       ' The keyword is used here to create a SqlConnection object.

       Using theSqlConnection As New SqlConnection(theConnectionString)

 

           ' Declare variable named theSqlCommand of type SqlCommand

           '  calling theSqlConnection object's CreateCommand method

           '  and assigning the resulting SqlCommand object to theSqlCommand variable.

           Dim theSqlCommand As SqlCommand = theSqlConnection.CreateCommand()

           ' Assign theQueryString to theSqlCommand's CommandText property.

           theSqlCommand.CommandText = theQueryString

           Try

               ' Open theSqlConnection.

               theSqlConnection.Open()

 

               ' Declare variable named theSqlDataReader of type SqlDataReader

               '  calling theSqlCommand object's ExecuteReader method

               '  and assigning the resulting cursor to theSqlDataReader varaiable.

               Dim theSqlDataReader As SqlDataReader = theSqlCommand.ExecuteReader()

 

               ' Call theSqlDataReader object's Read method until then end

               '  of the cursor is reached.

               Do While theSqlDataReader.Read()

                   ' Append a formatted string containing column 0 and column 1 of the row read

                   '  to the ResultsRichTextBox.

                   Me.ResultsRichTextBox.AppendText(String.Format("{0}" & vbTab & "{1}", _

                   theSqlDataReader(0), theSqlDataReader(1)) & vbCrLf)

               Loop

               ' Close theSqlDataReader

               theSqlDataReader.Close()

           Catch ex As Exception

               Console.WriteLine(ex.Message)

           End Try

       End Using

 

 // Declare variable named theConnectionString of type String;

 //  Assign a connection string to theConnectionString variable.

 // NOTE: To run this yourself replace the connection string with a connection string to a

 //  SQL Server with the Northwind database installed that you have permission to access.

 string theConnectionString = "Data Source=az-4ffd1ee68bce;Initial Catalog=Northwind;Integrated Security=True";

 

 // Declare a variable named theQueryString of type String;

 //  Assign a string containing a SQL SELECT command to theQueryString variable.

 string theQueryString = "SELECT CategoryID, CategoryName FROM dbo.Categories;";

 

 // The C# 'Using' keyword simplifies the use of Dispose methods by

 //  automatically calling dispose for an object.

 // The keyword is used here to create a SqlConnection object.

 using (SqlConnection theSqlConnection = new SqlConnection(theConnectionString))

 {

    // Declare variable named theSqlCommand of type SqlCommand

    //  calling theSqlConnection object's CreateCommand method

    //  and assigning the resulting SqlCommand object to theSqlCommand variable.

    SqlCommand theSqlCommand = theSqlConnection.CreateCommand();

    // Assign theQueryString to theSqlCommand's CommandText property.

    theSqlCommand.CommandText = theQueryString;

    try

    {

        // Open theSqlConnection.

        theSqlConnection.Open();

 

        // Declare variable named theSqlDataReader of type SqlDataReader

        //  calling theSqlCommand object's ExecuteReader method

        //  and assigning the resulting cursor to theSqlDataReader varaiable.

        SqlDataReader theSqlDataReader = theSqlCommand.ExecuteReader();

 

        // Call theSqlDataReader object's Read method until then end

        //  of the cursor is reached.

        while (theSqlDataReader.Read())

        {

            // Append a formatted string containing column 0 and column 1 of the row read

            //  to the ResultsRichTextBox.

            this.resultsRichTextBox.AppendText(string.Format("{0}" + "\t" + "{1}", theSqlDataReader[0], theSqlDataReader[1]) + "\r");

        }

 

        // Close theSqlDataReader

        theSqlDataReader.Close();

    }

    catch (Exception ex)

    {

        Console.WriteLine(ex.Message);

    }

 }