empdataaccess.cs

来自「《圣殿祭司的ASP.NET 2.0开发详解——使用C#》光盘内容.包含了书籍所含」· CS 代码 · 共 53 行

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// Summary description for EmpDataAccess
/// </summary>
public class EmpDataAccess
{
	public SqlConnection sqlConn;

	public EmpDataAccess()
	{
		sqlConn = new SqlConnection("Data Source=.;Initial Catalog=Northwind;uid=sa;pwd=test");
		sqlConn.Open();
	}

	public DataSet GetCust(string strCountry)
	{
		DataSet dsData = new DataSet();

		string strCmd = String.Format("SELECT * FROM Customers WHERE Country = '{0}'", strCountry);
		SqlDataAdapter sqlDA = new SqlDataAdapter(strCmd, sqlConn);
		sqlDA.Fill(dsData);

		sqlConn.Close();
		sqlDA.Dispose();

		return dsData;
	}

	public DataSet GetCustAll()
	{
		DataSet dsData = new DataSet();

		string strCmd = String.Format("SELECT * FROM Customers");
		SqlDataAdapter sqlDA = new SqlDataAdapter(strCmd, sqlConn);
		sqlDA.Fill(dsData);

		sqlConn.Close();
		sqlDA.Dispose();

		return dsData;
	}
}