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

Listing 13-10. PopDataTable.cs
using System;
using System.Data;
using System.Data.SqlClient;
namespace Chapter13
{
class PopDataTable
{
static void Main(string[] args)
{
// connection string
string connString = @"
server = .\sqlexpress;
integrated security = true;
database = northwind
";
// query
string sql = @"
select
productname,
unitprice
from
products
where
unitprice < 20
";
// create connection
SqlConnection conn = new SqlConnection(connString);
try
{
// open connection
conn.Open();
// create data adapter
SqlDataAdapter da = new SqlDataAdapter(sql, conn);