C#

public static DataTable GetTable()
{
  SqlCommand cmd = myConnection.CreateCommand();
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.CommandText = "StoredProcedure";
  DataTable dt = new DataTable("Table");
  SqlDataAdapter sda = new SqlDataAdapter(cmd);
  using (sda) // Or using (SqlDataAdapter dsa = new SqlDataAdapter(cmd);
  {
    sda.Fill(dt);
    return dt;
  }
}

<br />
public static DataTable getTable()<br />
{<br />
    DataTable dt = new DataTable("table");<br />
    using (Config config = new Config()) //custom configuration class.<br />
    {<br />
        using (SqlConnection conn = new SqlConnection(config.SqlConnectionString))<br />
        {<br />
            using (SqlDataAdapter sda = new SqlDataAdatper("Select * from table", conn))<br />
            {<br />
                sda.Fill(dt);<br />
            }<br />
        }<br />
    }<br />
    return dt;<br />
}<br />
return dt;<br />

<br />
public static DataTable getTable()<br />
{<br />
    DataTable dt = new DataTable("table");<br />
    Config config = new Config();<br />
    try {<br />
        SqlConnection conn = new SqlConnection(config.SqlConnectionString);<br />
        try {<br />
            SqlDataAdapter sda = new SqlDataAdapter(SqlDataAdatper("Select * from table", conn));<br />
            try {<br />
                sda.Fill(dt);<br />
            }<br />
            finally {<br />
                if (sda!= null) ((IDisposable)sda).Dispose();<br />
            }<br />
        }<br />
        finally {<br />
            if (conn!= null) ((IDisposable)conn).Dispose();<br />
        }<br />
    }<br />
    finally {<br />
       if (config != null) ((IDisposable)config).Dispose();<br />
    }<br />
    return dt;<br />
}<br />
Believe it or not, when I run that code above, as is, it works fine. My table is populated and everyone is happy. Sorry to carry on, I am just trying to figure out the scope usage that MS wrote into the using statement.<br />
<br />
Any ideas? <br />
<br />
TIA,<br />
Bill P.<br />
Oakland, CA<br />
<hr size="2" noshade="" style="color: rgba(70, 130, 180, 1)">-----BEGIN GEEK CODE BLOCK-----<br />
Version: 3.21<br />
GCM/MU/B dpu s--:-- a32 C++++$ ULH+++ P+++ L++ E+ W+++$ N++ o K? w++++$ O-- M V-- PS+ PE+ Y++ PGP++ t++@ 5++@ X++ R+@ tv b++ DI++ D+++>++++ G++ e++ h---- r+++ y++++<br />
-----END GEEK CODE BLOCK-----<br />
<hr size="2" noshade="" style="color: rgba(70, 130, 180, 1)">