using System.Data;
using System.Configuration;
using System.Data.SqlClient;

public class db
{
    public static string GetConnectionString()
    {
        return ConfigurationManager.ConnectionStrings["[connectionStringNameFromWebConfig]"].ConnectionString;
    }

    public static DataSet GetDataSet(string sqlCommand)
    {
        SqlConnection conn = new SqlConnection(GetConnectionString());
        SqlDataAdapter command = new SqlDataAdapter(sqlCommand, conn);
        DataSet dataset = new DataSet();
        command.Fill(dataset, "dataset");
        return dataset;
    }

    public static DataTable GetDataTable(string sqlCommand)
    {
        return (DataTable)((DataSet)GetDataSet(sqlCommand)).Tables[0];
    }

    public static void ExecuteNonQuery(string sqlStatement)
    {
        SqlConnection conn = new SqlConnection(GetConnectionString());
        SqlCommand sql = new SqlCommand(sqlStatement);
        sql.Connection = conn;
        conn.Open();
        sql.ExecuteNonQuery();
        sql.Connection.Close();
    }

    public static string CleanString(string stringParam)
    {
        return stringParam.Replace("'", "''");
    }

}