1static public System.Data.DataSet GetResultSet(System.Data.SqlClient.SqlTransaction Tran, string SqlStatement)
2{
3    System.Data.DataSet Elements = new System.Data.DataSet();
4
5    System.Data.SqlClient.SqlCommand sql = null;
6    System.Data.SqlClient.SqlDataAdapter ad = null;
7    try
8    {
9        sql = new System.Data.SqlClient.SqlCommand(SqlStatement, Tran.Connection, Tran);
10        sql.CommandTimeout = 0;
11        ad = new System.Data.SqlClient.SqlDataAdapter(sql);
12        ad.Fill(Elements);
13    }
14    catch (Exception ex)
15    {
16        throw ex;
17    }
18    finally
19    {                
20        sql.Dispose();
21        ad.Dispose();
22    }
23
24    return Elements;
25}