<div>
ds.Tables(&quot;Field_Select_Va<wbr />lues&quot;).Cle<wbr />ar()
</div>


<div>
<div class="content wysiwyg-content">
The following code is inside a loop and gets executed several times<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strSql2 = &quot;SELECT * FROM Field_Select_Values WHERE field_id = &quot;&nbsp;&amp; Row(&quot;field_id&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; da2 = New SqlDataAdapter(strSql2, conn)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; da2.Fill(ds, &quot;Field_Select_Values&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'set the size of the list to be the number of rows<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lstField.Rows = ds.Tables(&quot;Field_Select_Va<wbr />lues&quot;).Row<wbr />s.Count<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; For Each Row2 In ds.Tables(&quot;Field_Select_Va<wbr />lues&quot;).Row<wbr />s<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lstField.Items.Add(Row2(&quot;f<wbr />ield_selec<wbr />t_value&quot;))<wbr /><br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Next<br />
<br />
The data for the outter loop is contained in ds as well. &nbsp;How can I clear the data from ds.Tables(&quot;Field_Select_Va<wbr />lues&quot;)?
</div>
</div>


The following code is inside a loop and gets executed several times

                strSql2 = "SELECT * FROM Field_Select_Values WHERE field_id = " & Row("field_id")
                da2 = New SqlDataAdapter(strSql2, conn)
                da2.Fill(ds, "Field_Select_Values")
                'set the size of the list to be the number of rows
                lstField.Rows = ds.Tables("Field_Select_Values").Rows.Count
                For Each Row2 In ds.Tables("Field_Select_Values").Rows
                    lstField.Items.Add(Row2("field_select_value"))
                Next

The data for the outter loop is contained in ds as well.  How can I clear the data from ds.Tables("Field_Select_Values")?

Clearing a dataset before looping

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,