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()); } }