SqlDataAdapter Constructor(String,String)

In This Topic

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

Example

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

csharp

public void CreateDataAdapter()
{
  SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT DeptNo, DName FROM Test.Dept", 
      "User Id=sa;Server=localhost;Initial Catalog=Test;");
  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 SqlDataAdapter = New SqlDataAdapter("SELECT DeptNo, DName FROM Test.Dept", _
      "User Id=sa;Server=localhost;Initial Catalog=Test;")
  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

SqlDataAdapter Class
SqlDataAdapter Members
Overload List
SqlConnection Class
SqlCommand Class

Send Feedback