public class DB
{
public DB()
{
}
public static string GetConnectString()
{
return ConfigurationManager.AppSettings.Get("conn");
}
public static DataSet GetDataTableBySql(String sSql)
{
SqlConnection conn = new SqlConnection(GetConnectString());
SqlCommand cmd = new SqlCommand(sSql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
try
{
conn.Open();
ds.Clear();
da.Fill(ds);
conn.Close();
}
catch (SqlException)
{
conn.Close();
}
return ds;
}
public static Boolean UpdateDataBySql(String sSql)
{
SqlConnection conn = new SqlConnection(GetConnectString());
SqlCommand cmd = new SqlCommand(sSql, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return true;
}
catch (SqlException)
{
conn.Close();
return false;
}
}
public static string MD5Encoding(string sSrc)
{
return FormsAuthentication.HashPasswordForStoringInConfigFile(sSrc, "MD5");
}
}