22,210
社区成员
发帖
与我相关
我的任务
分享
public abstract class SQLHelper
{
public static string connectionString = Config.DecryptDES(Config.GetAppConfig("ConnectionString"), "jxx");
public static DataSet Query(string SQLString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
SqlDataAdapter command = new SqlDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception(ex.Message);
}
return ds;
}
}
}