Creating DataAdapter Object
The overloaded constructor for the DataAdapter
allows four different ways to create the
data
adapter, of which two are most commonly used. The following example
creates a DataAdapter
specifying the SELECT
statement and connection string in the constructor.
String connString = "Data Source=(local);Integrated security=SSPI;" + "Initial Catalog=Northwind;"; String selectSql = "SELECT * FROM Orders"; SqlDataAdapter da = new SqlDataAdapter(selectSql, connString);
While this approach is common, it is awkward when using parameterized
queries or stored procedures. The following example creates a
DataAdapter
specifying a
Command
object for the
SelectCommand
property of the
DataAdapter
in the constructor:
// create the Connection String connString = "Data Source = (local);Integrated security = SSPI;" + "Initial Catalog = Northwind;"; SqlConnection conn = new SqlConnection(connString); // create a Command object based on a stored procedure String selectSql = "MyStoredProcedure"; SqlCommand selectCmd = new SqlCommand(selectSql, conn); selectCmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(selectCmd);
It should be noted that there is no best way to create a
DataAdapter
, and it makes no real difference how
it is created.
Get ADO.NET in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.