DB2DataAdapter Constructor(String,String)

In This Topic

Initializes a new instance of the DB2DataAdapter class with a SelectCommand and a connection string.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal selectCommandText As String, _
   ByVal selectConnectionString As String _
)

public DB2DataAdapter( 
   string selectCommandText,
   string selectConnectionString
)

Parameters

selectCommandText: A System.String that is a SELECT statement to be used as the CommandText of the SelectCommand property of the DB2DataAdapter .
selectConnectionString: The connection string.

Example

The following example creates a DB2DataAdapter, sets some of its properties, retrieves data from a table, and displays it.

csharp

public void CreateDataAdapter()
{
  DB2DataAdapter myAdapter = new DB2DataAdapter("SELECT DeptNo, DName FROM Dept", 
      "user id=db2admin;server=db2;database=SAMPLE;");
  myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
  DataSet myDataSet = new DataSet();
  myAdapter.Fill(myDataSet,"Departments");
  //Get all data from all tables within the dataset
  foreach(DataTable myTable in myDataSet.Tables)
  {
    foreach(DataRow myRow in myTable.Rows)
    {
      foreach (DataColumn myColumn in myTable.Columns)
      {
        Console.Write(myRow[myColumn]+"\t");
      }
      Console.WriteLine();
    }
    Console.WriteLine();
  }
}

Visual Basic

Public Sub CreateDataAdapter()
  Dim myAdapter As DB2DataAdapter = New DB2DataAdapter("SELECT DeptNo, DName FROM Dept", _
      "user id=db2admin;server=db2;database=SAMPLE;")
  myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
  Dim myDataSet As DataSet = New DataSet
  myAdapter.Fill(myDataSet, "Departments")
  Dim myTable As DataTable
  Dim myRow As DataRow
  Dim myColumn As DataColumn
  ' Get all data from all tables within the dataset
  For Each myTable In myDataSet.Tables
    For Each myRow In myTable.Rows
      For Each myColumn In myTable.Columns
        Console.Write(myRow(myColumn) & Chr(9))
      Next myColumn
      Console.WriteLine()
    Next myRow
    Console.WriteLine()
  Next myTable
End Sub

Reference

DB2DataAdapter Class
DB2DataAdapter Members
Overload List
DB2Connection Class
DB2Command Class

Send Feedback