using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace ProjectName
{
    class DB_Helper
    {
     
        SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=DataBaseName;user id=sa");
        public DataTable GetData(string Command)//Select & Update
        {
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(Command, con);
            da.Fill(dt);
            return dt;
        }
        //
        public void SetData(string Command)//Insert
        {
            SqlCommand cmd = new SqlCommand(Command, con);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
        //
        public void ide(SqlCommand cmd)
        {
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
}