title: DataSet, SqlDataAdapter, Multiple select returns one table
body: <p>I would like to make one call (containing several SELECT statement) to the database and then databind the results to multiple components.</p>
  
  <p>I'm using a DataSet and SqlDataAdapter to fill tables that are then bound to components.</p>
  
  <p>Problem is the results of the first SELECT statement are put into both tables so I get a "'System.Data.DataRowView' does not contain a property..." error when I try to use the second lot of data on the second component.</p>
  
  <p>Have I misunderstood how this is meant to work?</p>
  
  <pre><code>DataSet ds = new DataSet();
  
  SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["myString"].ConnectionString);
  
  StringBuilder topicDropDownListSQL = new StringBuilder();
  topicDropDownListSQL.Append("SELECT topic.topic_ID, topic.topic_title FROM FPL2012_TOPIC as topic WHERE topic.topic_isEnabled = 1;");
  topicDropDownListSQL.Append("SELECT explain.itemExplanationType_ID, explain.itemExplanationType_type FROM FPL2012_ITEM_EXPLANATION_TYPE as explain;");
  
  SqlDataAdapter da = new SqlDataAdapter(topicDropDownListSQL.ToString(), connection);
  
  ds.Tables.Add("Topics");
  ds.Tables.Add("ExplainType");
  
  ds.EnforceConstraints = false;
  
  ds.Tables["Topics"].BeginLoadData();
  da.Fill(ds.Tables[0]);
  ds.Tables["Topics"].EndLoadData();
  
  ds.Tables["ExplainType"].BeginLoadData();
  da.Fill(ds.Tables[1]);
  ds.Tables["ExplainType"].EndLoadData();
  
  topicDropDownList.DataValueField = "topic_ID";
  topicDropDownList.DataTextField = "topic_title";
  topicDropDownList.DataSource = ds.Tables["Topics"];
  topicDropDownList.DataBind();
  
  explanationTypeDropDownList.DataValueField = "itemExplanationType_ID";
  explanationTypeDropDownList.DataTextField = "itemExplanationType_type";
  explanationTypeDropDownList.DataSource = ds.Tables["ExplainType"];
  explanationTypeDropDownList.DataBind();
  
  connection.Close();
  </code></pre>