using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace MPNumberProject
{
	/// <summary>
	/// DataAccess 的摘要說明。
	/// </summary>
	public class DataAccess
	{
		private string connectionString="server=127.0.0.1;database=Mobilephone;uid=tangrong;pwd=716";
		private SqlConnection conn=null;
		private SqlCommand command=null;
		private SqlDataAdapter adapter=null;

		private void ConnectionDB()
		{
			if(conn==null)
			{
				conn=new SqlConnection(connectionString); 
				
			}
			if(conn.State!=ConnectionState.Open)
			{
				conn.Open();
			}
		}
		public DataTable Query(string tableName,string SqlString)
		{
			DataSet dataset=new DataSet();
			try
			{
				ConnectionDB();
				adapter=new SqlDataAdapter(SqlString,conn);
				adapter.Fill(dataset,tableName);
				conn.Close();
			}
			catch(Exception ee)
			{
				MessageBox.Show(ee.Message);
			}
			return dataset.Tables[0];
		}
		public void ExcuteNonQuery(string sqlString,SqlParameter[] parms)
		{
			try
			{
				ConnectionDB();
				command=new SqlCommand(sqlString,conn);
				for(int i=0;i<parms.Length;i++)
				{
					command.Parameters.Add(parms[i]);
				}
				command.ExecuteNonQuery();
				

			}
			catch(Exception ee)
			{
				MessageBox.Show(ee.Message);
			}
		
		}
	}
	


}