C#

Console.WriteLine("{0}.{1}", k.GetType().Name, k.ToString());

Console.WriteLine("{0}.{1}", k.GetType().Name, k.ToString());

while (statreader.Read() && !m_bCancel)
{
   stemp = statreader["aj_vchar"].ToString();
   //do other stuff here
   this.progressBar1.Increment(1);
                            
}
this.progressBar1.Value = 0;  //breakpoint here,stops here soon as I press 'Cancel'
statreader.Close(); //this line hangs for a LONG time (~10 minutes) 

using (OdbcConnection conn = new OdbcConnection(source))
           {

               conn.Open();


               statcmd = new OdbcCommand("select * from tblPeople", conn);
                   statcmd = new OdbcCommand(sql, conn);
                   OdbcDataReader statreader = statcmd.ExecuteReader();

EricDV wrote:

Depending on the provider implementation, the Close method may wait for the data reader to finish returning all of the specified data before closing.

<br />
DataTable is loaded prior to this call<br />
<br />
public TreeNode GetFolders()<br />
{<br />
DataRow[] rows = DataTable.Select("ParentID IS NULL");<br />
<br />
// Create the root node<br />
TreeNode parent = new TreeNode();<br />
parent.Text = rows[0]["Name"].ToString();<br />
parent.Tag = rows[0]["ID"];<br />
<br />
// Add child nodes recusrsively<br />
AddChildNode(parent);<br />
<br />
return parent;<br />
}<br />
<br />
private void AddChildNode(TreeNode node)<br />
{<br />
// Get children of this node if any<br />
DataRow[] rows = DataTable.Select("ParentID=" + node.Tag);<br />
foreach(DataRow row in rows)<br />
{<br />
TreeNode child = new TreeNode();<br />
child.Text = row["Name"].ToString();<br />
child.Tag = row["ID"].ToString();<br />
node.Nodes.Add(child);<br />
<br />
// Call recursively to add children<br />
AddChildNode(child);<br />
}<br />
}<br />

foreach(DataRelation relation in table.ChildRelations)<br />
    {<br />
        foreach(DataRow row in table.Rows)<br />
        {<br />
            childRows = row.GetChildRows(relation);<br />
        }<br />
    }<br />