using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;


public class dbhelper
{
    public SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["DbCnn"].ToString());
    public void ConnectinOpen()
    {
        if (con.State != ConnectionState.Open)
            con.Open();
    }
    public DataTable getdata(string qry)
    {
        SqlDataAdapter sd = new SqlDataAdapter(qry, con);
        DataTable dt = new DataTable();
        sd.Fill(dt);
        return dt;
    }

    public int execqry(string qry)
    {
        //sqlcommand cmd = new SqlCommand(qry, con);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = qry;
        return cmd.ExecuteNonQuery();
       // cmd.ExecuteNonQuery();
    }
    public object  execscalar(string qry)
    {
        if (con.State != ConnectionState.Open)
            con.Open();
        SqlCommand cmd = new SqlCommand(qry, con);
        return cmd.ExecuteScalar();
    }
    
   

    }