using System;
using System.Data;
using System.Data.SqlClient;
namespace Chapter08
{
class PopDataSet
{
static void Main(string[] args)
{
// connection string
string connString = @"
server = localhost;
integrated security = true;
database = student
";
// query
string sql = @"
select
studentID,
studentName,
studentSex
from
stu
";
// create connection
SqlConnection conn = new SqlConnection(connString);
try
{
// open connection
conn.Open();
// create data adapter
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
// create dataset
DataSet ds = new DataSet();
// fill dataset
da.Fill(ds, "studentName");
// get data table
DataTable dt = ds.Tables["studentName"];
for (int i = 0; i < 5; i++)
{
Console.WriteLine(dt.Rows[i]["studentID"].ToString() +" "
+ dt.Rows[i]["studentName"].ToString() + dt.Rows[i]["studentSex"].ToString());//Datatable实验
}
// display data
foreach (DataRow row in dt.Rows)
{
foreach (DataColumn col in dt.Columns)
Console.WriteLine(row[col]);
Console.WriteLine("".PadLeft(20, '='));
}
}
catch (Exception e)
{
Console.WriteLine("Error: " + e);
}
finally
{
// close connection
conn.Close();
Console.ReadLine();
}
}
}
}