title: Create new SQLDataAdapter for each iterate
body: <p>I'm having problem with create SqlDataAdapter for each iterate in for loop.
  Here is what im trying to do :</p>
  
  <p>I have tabControl and I'm create dataGridView on each of them, for every dataGridView I'm creating dataTable and I want to fill dataTable when the SqlDataAdapter.Name.Contains(dataTable.TableName).</p>
  
  <p>I'm not sure if it's correct way to do this.</p>
  
  <p>I'm creating DataGridView this way :</p>
  
  <pre><code>        for (int i = 0; i &lt; lista.Count; i++)
          {
              tabControl_Roz.TabPages.Add("Print " + lista[i]);
              var dataGridView = new DataGridView()
              {
                  Name = "dataGridView_" + lista[i],
                  Dock = DockStyle.Fill
              };
           }
  </code></pre>
  
  <p>DataTable : </p>
  
  <pre><code>        for (int i = 0; i &lt; lista.Count; i++)
          {
              var dataTable = new DataTable()
              {
                  TableName = "" + lista[i]
              };
              dtList.Add(dataTable);
          }
  </code></pre>
  
  <p>And it works correct but the problem with SqlDataAdapter is that I can't to do it this same way and then manipulate the SQL Query depends of SqlDataAdapterName, it should be like this :</p>
  
  <pre><code>        for (int i = 0; i &lt; lista.Count; i++)
          {
              var dataAdapter = new SqlDataAdapter()
              {
                  Name = "sda" + lista[i]
              };
              sda.List.Add(dataAdapter);
          }
  </code></pre>
  
  <p>But it doesn't work cause method "Name" don't exist.
  Can some one help me doing this ? Or show me any other way how can I accomplish this?</p>