classinfos.cs

《C#和.NET第一步》中的财务系统 利用三层结构做的

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace DataAccess
{
	public class ClassInfos
	{
		private readonly string connection = "server=.;database=homemoney;uid=sa;pwd=";
		private readonly string tablename = "T_ClassInfo";
		private SqlDataAdapter dataAdapter = null;
		public DataSet GetClassInfos()
		{
			//要返回的数据集
			DataSet ds = new DataSet();
			//构造插入数据的SQL语句
			string sql = "SELECT * FROM T_ClassInfo";
			if (dataAdapter == null) dataAdapter = new SqlDataAdapter(sql, connection);
			try
			{
				dataAdapter.Fill(ds, this.tablename);
			}
			catch (SqlException e)
			{
				Console.WriteLine(e.Message);
			}
			return ds;
		}
	}
}