System.Data.SqlClient Namespace   SqlDataAdapter Class

Initializes a new instance of the SqlDataAdapter class with the specified Transact-SQL SELECT statement and a connection string.

[ VB ]
Overloads Public Sub New ( _
   ByVal commandText As String, _
   ByVal connectString As String _
)

[ C# ]
public SqlDataAdapter (
   string commandText,
   string connectString
);

[ C++ ]
public: SqlDataAdapter (
   String* commandText,
   String* connectString
);

[ JScript ]
public function SqlDataAdapter (
   commandText : String,
   connectString : String
);

commandText

String specifying a Transact-SQL SELECT statement or stored procedure.

connectString

The connection string.

When an instance of SqlDataAdapter is created, the following read/write properties are set to initial values.

You can change the value of any of these properties through a separate call to the property.

The following example initializes an SqlDataAdapter using this constructor, then fills a DataSet.

// set up the connection
string connString = "server=localhost; trusted_connection=yes; database=pubs";
// set up the query
string query = "SELECT * FROM authors";

// set up the adapter
SqlDataAdapter myAdapter = new SqlDataAdapter ( query, connString );

// instantiate dataset object
DataSet myData = new DataSet ( );
// fill with query results
myAdapter.Fill ( myData, "authors" );

' set up the connection
dim connString as string = "server=localhost; trusted_connection=yes; database=pubs";
' set up the query
dim query as string = "SELECT * FROM authors";

' set up the adapter
dim myAdapter as new SqlDataAdapter ( query, connString )

' instantiate dataset object
dim myData as new DataSet ( )
' fill with query results
myAdapter.Fill ( myData, "authors" )

SqlDataAdapter Members   SqlDataAdapter Constructor Overload List   MissingMappingAction   MissingSchemaAction