DBC

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Data;
/// <summary>
/// Summary description for DBConnection
/// </summary>
///
namespace StdMngSystem
{
    public class DBConnection
    {

        SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionStringa"].ToString());
        SqlCommand command = null;
        SqlDataAdapter adapter = null;

        public void ExecuteQuary(string quary)
        {
            try
            {
                if (connection.State == ConnectionState.Closed)
                {
                    connection.Open();
                    command = new SqlCommand();
                }
                command.CommandText = quary;
                command.Connection = connection;
                command.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception)
            {

            }
        }
        public DataSet GetData(string quary)
        {
            if (connection.State == ConnectionState.Closed)
            {
                connection.Open();
                adapter = new SqlDataAdapter(quary, connection);
            }
            DataSet getDataSet = new DataSet();
            adapter.Fill(getDataSet);
            connection.Close();
            return getDataSet;
        }
    }
}