1.SqlDataAdapter
SqlDataAdapter 是 DataSet 和 SQL Server 之间的桥接器,用于检索和保存数据。
命名空间: System.Data.SqlClient
程序集: System.Data(在 System.Data.dll 中)
example:
private static DataSet SelectRows(DataSet dataset,
string connectionString,string queryString)
{
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(
queryString, connection);
adapter.Fill(dataset);
return dataset;
}
}
详见MSDN文档:
SqlDataAdapter
2.SqlDataReader
SqlDataReader提供一种从 SQL Server 数据库读取行的只进流的方式。无法继承此类。
命名空间:System.Data.SqlClient
程序集:System.Data(在 system.data.dll 中)
example:
private static void ReadOrderData(string connectionString)
{
string queryString =
"SELECT OrderID, CustomerID FROM dbo.Orders;";
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlCommand command =
new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
// Call Read before accessing data.
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",
reader[0], reader[1]));
}
// Call Close when done reading.
reader.Close();
}
}
详见MSDN文档:
SqlDataReader