database.cs

进销存管理系统软件

using System;
using System.Data;
using System.Data.SqlClient;

namespace my进销售
{


	/// <summary>
	/// Database 的摘要说明。
	/// </summary>
	public class Database
	{
	  private string sqlconnectionString = "workstation id=server; integrated security=SSPI;database=jxcbook";
       private  DataSet ds=new DataSet();
		private SqlConnection sqlconnection;
		private SqlDataAdapter da;
		private SqlCommandBuilder sqlCmdBld;
		private string sqlsQl;

		public Database()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet selectdata(string name,string sqlname)
				{
			     this.sqlsQl=sqlname;
                  this.sqlconnection=new SqlConnection(sqlconnectionString);
				  this.da=new SqlDataAdapter(sqlname,sqlconnection);
				  this.ds.Clear();
                  this.da.Fill(ds,name);
                  return ds;
				 }

		public DataSet UpdateDataBase(DataSet changedDataSet,string tableName)
		{
			this.sqlconnection = new SqlConnection(sqlconnectionString);
			this.da = new SqlDataAdapter(this.sqlsQl,this.sqlconnection);
			this.sqlCmdBld = new SqlCommandBuilder(da);
			this.da.Update(changedDataSet,tableName);
			return changedDataSet;//返回更新了的数据库表
		}

		public DataTable selectdata(string sqlname)
		{
		
		   this.sqlconnection=new SqlConnection(sqlconnectionString);
		    DataSet tempdataset=new DataSet();
			this.da=new SqlDataAdapter(sqlname,this.sqlconnection);
            this.da.Fill(tempdataset);
			return tempdataset.Tables[0];

		}
		public int UpdateDataBase(string tablename)
		{
			this.sqlconnection=new SqlConnection(sqlconnectionString);
           sqlconnection.Open();
			SqlCommand tempsql=new SqlCommand(tablename,this.sqlconnection);
			int intnumber=tempsql.ExecuteNonQuery();
		    sqlconnection.Close();
			return intnumber;



		}

	}
}