class1.cs

学生管理系统

using System;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace chaxun
{
	/// <summary>
	/// Class1 的摘要说明。
	/// </summary>
	public class Class1
	{
		public Class1()
		{
			
		}
		private string strSQL;
		private string connectionString=@"Integrated Security=SSPI;Initial Catalog=xxgcx;Data Source=.";
		private SqlConnection myConnection;
		private SqlCommandBuilder SqlCmdBld;
		private DataSet ds =new DataSet();
		private SqlDataAdapter da;
		public DataSet SelectDataBase(string tempStrSQL,string tempTableName)
		{
			this.strSQL=tempStrSQL;
			this.myConnection = new SqlConnection(connectionString);
			this.da=new SqlDataAdapter(this.strSQL,this.myConnection);
			this.ds.Clear();
			try
			{
				this.da.Fill(ds,tempTableName);
			}
			catch(Exception ee)
			{
				MessageBox.Show(ee.Message);
			}
			return ds;
		}
		public DataSet UpdateDataBase(DataSet changedDataSet,string tableName)
		{
			this.myConnection=new SqlConnection(connectionString);
			this.da =new SqlDataAdapter(this.strSQL,this.myConnection);
			this.SqlCmdBld=new SqlCommandBuilder(da);
			this.da.Update(changedDataSet,tableName);
			return changedDataSet;
		}
		public DataTable SelectDataBase(string tempStrSQL)
		{
			this.myConnection=new SqlConnection(connectionString);
			DataSet tempDataSet=new DataSet();
			this.da =new SqlDataAdapter(tempStrSQL,this.myConnection);
			this.da.Fill(tempDataSet);
			return tempDataSet.Tables[0];
            
		}
		public int UpdateDataBase(string tempStrSQL)
		{
			this.myConnection=new SqlConnection (connectionString);
			myConnection.Open();
			SqlCommand tempSqlCommand = new SqlCommand(tempStrSQL,this.myConnection);
			int intNumber =tempSqlCommand.ExecuteNonQuery();
			myConnection.Close();
			return intNumber;
		}
	}
}