using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using FirebirdSql.Data.FirebirdClient;

namespace DBConn
{
    public class Connection_Query
    {

        private string strConn = @"DataSource=localhost; Database=D:\Fontes\DADOS\ROSA\DADOS.FDB; username= SYSDBA; password = masterkey";
        //string de conexao. preencher os dados minimos para conectar

        FbConnection conn;

        public void OpenConection()
        {
            conn = new FbConnection(strConn); //conecta utilizando a stri
            conn.Open();
        }


        public void CloseConnection()
        {
            conn.Close();
        }


        public void ExecuteQueries(string Query_)
        {
            FbCommand cmd = new FbCommand(Query_, conn);
            cmd.ExecuteNonQuery();
        }


        public FbDataReader DataReader(string Query_)
        {
            FbCommand cmd = new FbCommand(Query_, conn);
            FbDataReader dr = cmd.ExecuteReader();
            return dr;
        }


        public object ShowDataInGridView(string Query_)
        {
            FbDataAdapter dr = new FbDataAdapter(Query_, strConn);
            DataSet ds = new DataSet();
            dr.Fill(ds);
            object dataum = ds.Tables[0];
            return dataum;
        }
    }
}