<div>
How do I test if &quot;All&quot; was selected in lstDomainName ? &nbsp; It is the first item in the list, and is also the assigned default value when the form is loaded, or is reset.
</div>


How do I test if "All" was selected in lstDomainName ?   It is the first item in the list, and is also the assigned default value when the form is loaded, or is reset.

<div>
In that case, you could simply check if selIndices(0) = 0. &nbsp;Since &quot;All&quot; is the first item, it will have index 0...and since the index collection is in order, you'll be able to look in slot 0 every time to see if it is chosen.
</div>


In that case, you could simply check if selIndices(0) = 0.  Since "All" is the first item, it will have index 0...and since the index collection is in order, you'll be able to look in slot 0 every time to see if it is chosen.

<div>
<div class="content wysiwyg-content">
VB.Net 2003<br />
<br />
Multi-Selection List Box<br />
Datatype String &nbsp; &nbsp;Domain Name &nbsp;e.g. &nbsp;aol.com,hotmail.com<br />
lstDomainName &nbsp;is the name of the control<br />
<br />
I have a list box with different domain names, and also a selection of the text &quot;All&quot;<br />
I'd like to generate an email list based on the domains the user selects, or based on all domains if the user selects &quot;All&quot;<br />
<br />
The resulting SQL statment should end up something like this &nbsp;<br />
<br />
Select EmailAddress,Created &nbsp; ' If the customer selects a domain or multiple domains<br />
From tblUsers<br />
Where Domain = Whats in lstDomainName<br />
<br />
or Select EmailAddress,Created &nbsp;' If the customer selects All<br />
From tbl Users<br />
<br />
<br />
Thanks in advance
</div>
</div>


VB.Net 2003

Multi-Selection List Box
Datatype String    Domain Name  e.g.  aol.com,hotmail.com
lstDomainName  is the name of the control

I have a list box with different domain names, and also a selection of the text "All"
I'd like to generate an email list based on the domains the user selects, or based on all domains if the user selects "All"

The resulting SQL statment should end up something like this  

Select EmailAddress,Created   ' If the customer selects a domain or multiple domains
From tblUsers
Where Domain = Whats in lstDomainName

or Select EmailAddress,Created  ' If the customer selects All
From tbl Users


Thanks in advance

Build SQL String from selectedItems in ListBox in VB.net

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,