General Class C# (SQL Client)

General Class

using System.Data.SqlClient;

public class Cls_ADO

{

    SqlConnection con;

     

public Cls_ADO()

      {

            con=new SqlConnection("Data Source=win2006\\sqlexpress;Initial Catalog=db_sample;Integrated Security=True");

        con.Open();

      }

    public void execute_Query(string str)

    {

        SqlCommand cmd = new SqlCommand(str, con);

        cmd.ExecuteNonQuery();

    }

    public DataTable select_Query(string str)

    {

        SqlDataAdapter adp = new SqlDataAdapter(str, con);

        DataTable dt = new DataTable();

        adp.Fill(dt);

        return dt;

    }

    public void fillGrid(GridView grd,string strQry)

    {

        DataTable dt = select_Query(strQry);

        if (dt != null)

        {

            grd.DataSource = dt;

            grd.DataBind();

        }

    }

    public void fillDropDown(DropDownList ddl,string valueField,string textField,string table)

    {

        string strQry = "select " + valueField + "," + textField + " from " + table + "";

        DataTable dt = select_Query(strQry);

        if (dt != null)

        {

            ddl.DataSource = dt;

            ddl.DataValueField = valueField;

            ddl.DataTextField = textField;

            ddl.DataBind();

            ddl.Items.Insert(0, "--select--");

            //ListItem li = new ListItem("-Select-", "0");

            //ddl.Items.Insert(0, li);

        }

    }

    public void fillRepetear(Repeater rptr, string strQry)

    {

        DataTable dt = select_Query(strQry);

        if (dt != null)

        {

            rptr.DataSource = dt;

            rptr.DataBind();

        }

    }

    public void fillDataList(DataList dtl, string strQry)

    {

        DataTable dt = select_Query(strQry);

        if (dt != null)

        {

            dtl.DataSource = dt;

            dtl.DataBind();

        }

    }