lớp làm việc với database

code:

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.SqlClient;

/// 

/// Summary description for DataAccess
/// 
public class DataAccess
{
public DataAccess()
{
//
// TODO: Add constructor logic here
//
}
public static string getConnectionString()
{
return ConfigurationManager.ConnectionStrings["ForumConnectionString"].ConnectionString;
}
public static DataSet ExecMyQuery(SqlCommand cmd, DataAccess.TypeQuery tp)
{
using (SqlConnection con = new SqlConnection(getConnectionString()))
{
try
{
DataSet dt = new DataSet();
cmd.Connection = con;
con.Open();
if (tp == TypeQuery._SELECT)
{
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return dt;
}
else
{
cmd.ExecuteNonQuery();
return null;
}
}
catch (Exception ex)
{

}
finally
{
con.Close();
}
return null;
}
}
public enum TypeQuery
{
_SELECT = 0, 
_UPDATE = 1,
_INSERT = 2
}
} 
0