UniDataAdapter Constructor(String,String)

On this page

Initializes a new instance of the UniDataAdapter 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 UniDataAdapter( 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 UniDataAdapter .
selectConnectionString: The connection string.

Example

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

csharp


public void CreateDataAdapter() { UniDataAdapter myAdapter = new UniDataAdapter("SELECT DeptNo, DName FROM Test.Dept", "Provider=SQL Server;Data Source=SERVER;Initial Catalog=Northwind;User ID=sa"); 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(); } }

public void CreateDataAdapter()
{
  UniDataAdapter myAdapter = new UniDataAdapter("SELECT DeptNo, DName FROM Test.Dept", "Provider=SQL Server;Data Source=SERVER;Initial Catalog=Northwind;User ID=sa");
  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 UniDataAdapter = New UniDataAdapter("SELECT DeptNo, DName FROM Test.Dept", "Provider=SQL Server;Data Source=SERVER;Initial Catalog=Northwind;User ID=sa") 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

Public Sub CreateDataAdapter()
  Dim myAdapter As UniDataAdapter = New UniDataAdapter("SELECT DeptNo, DName FROM Test.Dept", "Provider=SQL Server;Data Source=SERVER;Initial Catalog=Northwind;User ID=sa")
  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

UniDataAdapter Class
UniDataAdapter Members
Overload List
UniConnection Class
UniCommand Class

Send Feedback