public void Dispose()
{
try
{
if (Trans != null)
{
Trans.Dispose();
}
if (Conn != null)
{
if (Conn.State == System.Data.ConnectionState.Open)
{
Conn.Close();
}
Conn.Dispose();
}
}
catch (Exception)
{
throw;
}
}