Using Datasets and Data Adapters - Beginning C# 2008 Databases: From Novice to Professional - page 301

{
// connection string
string connString = @"
server = .\sqlexpress;
integrated security = true;
database = northwind
";
// query
string qry = @"
select
*
from
employees
where
country = 'UK'
";
// SQL to delete employees
string del = @"
delete from employees
where
employeeid = @employeeid
";
// create connection
SqlConnection conn = new SqlConnection(connString);
try
{
// create data adapter
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(qry, conn);
// create and fill dataset
DataSet ds = new DataSet();
da.Fill(ds, "employees");
// get data table reference
DataTable dt = ds.Tables["employees"];