}
  //返回DataSet
  public DataSet DataSetQuery(string Sql,string TableName,int StarIndex,int Count)
  {
   DataConnection=DataConn();
   DataConnection.Open();
   DataAdapter=new SqlDataAdapter(Sql,DataConnection);
   DataSet=new DataSet();
   DataAdapter.Fill(DataSet,StarIndex,Count,TableName);
   DataConnection.Close();
   DataConnection.Dispose();
   return DataSet;
  }
  public void DataDo(string sqlstr)
  {  
   DataConnection=DataConn();
   SqlCommand mycom=DataConnection.CreateCommand();
   mycom.CommandText=sqlstr;
   DataConnection.Open();
   mycom.ExecuteNonQuery();
   DataConnection.Close();
  }
  //返回DataSet 開始行到結束行
  public bool EditData(string Sql)
  {
   DataConnection=DataConn();
   DataConnection.Open();
   DataCommand=new SqlCommand(Sql,DataConnection);
   try
   {
    DataCommand.ExecuteNonQuery();
    DataConnection.Close();
    return true;
   }
   catch(Exception ex)
   { 
    System.Console.Write(ex.Message.ToString());
    DataConnection.Close();
    return false;
   }
  }
  //執行成功返回真,否則返回假．
  public object ExecuteScalar(string Sql)
  {
   DataConnection=DataConn();
   DataConnection.Open();
   DataCommand=new SqlCommand(Sql,DataConnection);
   try
   {
    object back = DataCommand.ExecuteScalar();
    DataConnection.Close();
    return back;
   }
   catch(Exception ex)
   { 
    System.Console.Write(ex.Message.ToString());
    DataConnection.Close();
    return null;
   }
  }
  //返回一個值的查詢語句
  public DataSet EditData(DataSet DataSet,SqlDataAdapter myda,string TableName)
  {
    
   
   DataComBuilder=new SqlCommandBuilder(myda);
   myda.UpdateCommand=DataComBuilder.GetUpdateCommand();
   myda.DeleteCommand=DataComBuilder.GetDeleteCommand();
   myda.InsertCommand=DataComBuilder.GetInsertCommand();
   myda.Update(DataSet,TableName);
   DataSet.AcceptChanges();
   this.CloseConnection();
   return DataSet;
  }
  //修改DataSet 并且修改數據庫值存儲過程
  public bool DataProcedure(string ProcedureName)
  {
   DataConnection=DataConn();
   DataConnection.Open();
   DataCommand=new SqlCommand();
   DataCommand.CommandText=ProcedureName;
   DataCommand.Connection=DataConnection;
   
     
   DataCommand.CommandType=System.Data.CommandType.StoredProcedure;
   try
   {
    DataCommand.ExecuteNonQuery();
    return true;
   }
   catch(Exception ex)
   { 
    System.Console.Write(ex.Message.ToString());
    return false;
   }
  }
  
  //無參數存儲過程的執行　返回執行真假
  public void CloseConnection()
  {
   if(DataReader!=null)
   {
    DataReader.Close();
    DataReader=null;

   }
   DataConnection.Close();
   DataConnection.Dispose();
  }
  //關閉連接
 

 }
}