troubleshooting Question

How to pass mutiple string value from list box to SQL 2005

Avatar of thomasm1948
thomasm1948Flag for United States of America asked on
.NET ProgrammingMicrosoft SQL Server 2005
5 Comments1 Solution325 ViewsLast Modified:

I have question in concerns with passing multiple string value to a SQL stored procedure variable

So far my code will only allow me to delete one entry from a VB.NET listbox and I need it to be able to delete multiple items fromt he list box.  Attached is my current stored procedure.  Also I need just simple help in gathering my list values and put them into a string sperated by a comma.  I figure I should be able to parse that in SQL and then delete the items; I just do not know how
Alter procedure [dbo].[Remove_AllUsersFromGroup]
@gname varchar(32)
delete from dbo.GroupNotification
where GroupName = @gname
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros