Share this page

# Example: DoDataRead

This example executes a data read from an SQL connection.

    Dim connectionString_1 As [String]
    connectionString_1 = "Data Source=myDbServer;User ID=myuser;Password=mypwd;Connect Timeout=26"
    SqlConnection_1 = New SqlConnection(connectionString_1)
    SqlConnection_1.Open
    SqlCommand_1 = New SqlCommand("SELECT * FROM Northwind.dbo.Orders", SqlConnection_1)
    SqlDataReader_1 = SqlCommand_1.ExecuteReader
    LrReplayUtils.DoDataRead(SqlDataReader_1, valueTable_2, false, 11)
    DATASET_XML(2)
    SqlConnection_1.Close

Example of a data reader

    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.SqlClient;
    using System.Configuration;
    using System.Text;

    namespace DataReader {
      class Program  {
          static void Main(string[] args)  {
             using ( SqlConnection connection = new SqlConnection(
             ConfigurationManager.AppSettings["ConnectionString"])) {
             connection.Open();
             SqlCommand command = new SqlCommand(ConfigurationManager.AppSettings["Query"], connection);
             SqlDataReader reader = command.ExecuteReader();
             while (reader.Read())
             {
                object o;
                Console.WriteLine("---");
                object o1 = reader.GetValue(4);
                Console.WriteLine(o1);
             }
     // Call Close when done reading.
            reader.Close();
          }
        }
      }
    }

Tips to improve your search results... VuGen Function Reference Version 25.1-25.3 Function Reference 25.1-25.3 All View Local Help Center View Online Help Center Version: