Why the Page.DataBind() method call's result reflects later than the DataSet related works following it?
<p>I have called the Page.DataBind() method for binding data to the DataGrid controls. After that I've iterated through the DataColumns for the Column types and showed them as on the fly html.
My code is as below:</p>

<pre><code>public partial class MultipleDataSources : System.Web.UI.Page
{   

    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection sc=new SqlConnection(ConfigurationManager.ConnectionStrings["arsenicConnectionString"].ConnectionString);
        String strSQL1="select * from tubewell";
        String strSQL2="select * from tubewellOwner";
        DataSet ds=new DataSet("myDataSet");

        SqlDataAdapter dadap=new SqlDataAdapter(strSQL1,sc);
        dadap.Fill(ds,"Tubewell");
        dadap.SelectCommand.CommandText=strSQL2;
        dadap.Fill(ds,"Tubewell Owner");
        first.DataSource=ds.Tables["Tubewell"];
        second.DataSource=ds.Tables["Tubewell Owner"];
        Page.DataBind();
        String strType="&lt;/br&gt;";
        foreach (DataTable dt in ds.Tables)
        {
            strType += "Table Name: " + dt.TableName + "&lt;/br&gt;";
            foreach (DataColumn dc in dt.Columns)
            {
                strType += "Column Name: " + dc.ColumnName + " is of type " + dc.DataType.ToString() + "&lt;/br&gt;";
            }
            Response.Write(strType);
        }

    }
}
</code></pre>

<p>Now my problem is the data is shown after the types are shown which I didn't expect
my output screenshot:</p>

<p><img src="http://i.stack.imgur.com/y32i1.jpg" alt="enter image description here"></p>
