public static AdoToFormats.Lib.AdoNetSql OpenAdoNetSql()
{
AdoToFormats.Lib.AdoNetSql ado = new AdoToFormats.Lib.AdoNetSql();
ado.Open(Config.GetConnectionString());
return(ado);
}
public DataSet ExecuteDataSet(SqlCommand cmd)
{
DataSet ds = null;
try
{
using (AdoToFormats.Lib.AdoNetSql ado = AdoToFormats.Lib.DBUtil.OpenAdoNetSql())
{
ds = ado.ExecuteDataSet(cmd);
ado.Dispose();
}
}
catch (Exception ex)
{
try
{
AdoToFormats.Lib.FileLog log = new AdoToFormats.Lib.FileLog(AdoToFormats.Lib.Config.GetLogFilePath());
log.WriteLine(ex.ToString());
}
catch (Exception) { }
}
return(ds);
}
public int Execute(SqlCommand cmd)
{
int nRows = 0;
try
{
using (AdoToFormats.Lib.AdoNetSql ado = AdoToFormats.Lib.DBUtil.OpenAdoNetSql())
{
nRows = ado.Execute(cmd);
ado.Dispose();
}
}
catch (Exception ex)
{
try
{
AdoToFormats.Lib.FileLog log = new AdoToFormats.Lib.FileLog(AdoToFormats.Lib.Config.GetLogFilePath());
log.WriteLine(ex.ToString());
}
catch (Exception) { }
}
return(nRows);
}
