datause.cs

勤工俭学的管理系统 记录学生资料

namespace sues_data
{
	using System;
	using System.Collections;
	using System.Diagnostics;
	using System.Configuration;
	using System.Data;
	using System.Data.OleDb;

	public class DataUse
	{
		private OleDbDataAdapter adapter;
		private OleDbConnection cnn = new OleDbConnection();
		private OleDbCommand cmd;

		public DataUse()
		{
			cnn.ConnectionString = ConfigurationManager.ConnectionStrings["myCnn"].ConnectionString;
			cmd = new OleDbCommand("sql", cnn);
		}

		public DataTable getDataTable(string select, string name)
		{
			DataTable dt = new DataTable(name);
			adapter = new OleDbDataAdapter(select, cnn);
			cnn.Open();
			adapter.Fill(dt);
			cnn.Close();
			return dt;
		}

		public DataTable getDataTable(string select,DataTable dt)
		{
			adapter = new OleDbDataAdapter(select, cnn);
			cnn.Open();
			adapter.Fill(dt);
			cnn.Close();
			return dt;
		}

		public bool commit(string sql)
		{
			cmd.CommandText = sql;
			bool temp = false;
			try
			{
				cnn.Open();
				cmd.ExecuteNonQuery();
				temp = true;
			}
			catch
			{
				temp = false;
			}
			finally
			{
				cnn.Close();
			}
			return temp;
		}

	}
}