dbupdate

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

/// <summary>
/// Summary description for DBUpdate
/// </summary>
public class DBUpdate
{
    public DBUpdate()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    public SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings.Get("connString"));
    public SqlCommand cmd = new SqlCommand();
    public SqlDataAdapter ada = new SqlDataAdapter();
    public DataTable dt = new DataTable();
    public SqlDataReader dr;

    public  SqlConnection getcon()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        return con;
    }
    public string excquery(string cmdtext)
    {
        try
        {
            cmd.Connection = getcon();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = cmdtext;
            cmd.ExecuteNonQuery();
            return "1";

        }
        catch (Exception ex)
        {
            return ex.Message;
        }
    }
    public string excproc(string procname)
    {
        try
        {
            cmd.Connection = getcon();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = procname;
            cmd.Connection = con;
            cmd.ExecuteNonQuery();
            return "1";
        }
        catch (Exception ex)
        {
            return ex.Message;
        }

    }
   
   
   
   
   
    public DataTable gettable(string fetchcmd)
    {
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = fetchcmd;
        ada.SelectCommand = cmd;
        dt = new DataTable();
        ada.Fill(dt);
        return dt;

    }
    public SqlDataReader datareader(string fetchrow)
    {
        getcon();
        cmd.Connection = con;
        cmd.CommandText = fetchrow;
        dr = cmd.ExecuteReader();
        return dr;
        closeconnection();

    }

    public void closeconnection()
    {
        if (con.State != ConnectionState.Closed)
        {
            con.Close();
        }
    }