public static System.Data.DataTable RetDT(String pQry)
{
using (SqlConnection vConnection = ATCommon.GetConnection())
{
SqlDataAdapter vDataAdapter = new SqlDataAdapter(pQry, vConnection);
DataSet vDataSet = new DataSet();
vDataAdapter.Fill(vDataSet);
return(vDataSet.Tables[0].Copy());
}
}