Foreach a listbox, Split the value and Insert splitted value in Array

Question

4.00/5 (1 vote)

See more:

I have this problem that prevents me to collect a proper set of data.
I want to Foreach the items from a listbox and split the items.
The splitted items must be store in a single Array

I have this syntax.

while (reader.Read())
   {
      var tmp = reader["Items"];
      if (tmp != DBNull.Value)
      {
        ListBox1.Items.Add(tmp.ToString()); // The data that added in the Listbox is already
                                            // 1 string ("ItemA,ItemB,ItemC,ItemD")
      }
   }
   foreach (var items in ListBox1.Items)
     {
        myDb.Add(new MyItems() { string.Join(",", items) } ); 
         //Here, I want to transfer the items from listbox. 
     }

The result I got from this process is a single data in 1 array, not multiple.
Actual Result:

{"ItemA,ItemB,ItemC,ItemD"}

Expected Result:

{ "ItemA", "ItemB", "ItemC", "ItemD" }

I found this usefull:
Here[^]

and I have this syntax now.

IEnumerable<string> row;
IEnumerable<string> permutations;
     while (reader.Read())
     {
     var tmp = reader["Items"];
     if (tmp != DBNull.Value)
         {
         ListBox1.Items.Add(tmp.ToString());   
         }
     }
     row = new string[] {ListBox1.Items.ToString()};
     permutations = GetPermutations(row, delimiter: ",");
     foreach (var permutation in permutations)
     {
         myDb.Add(new MyItems() {permutation});
     }

Error: {System.Web.UI.WebControls.ListItemCollection}

Posted 20-Jan-14 1:34am

Dev Jonie

Updated 20-Jan-14 15:17pm

v5

Add a Solution

Comments

Dev Jonie 20-Jan-14 8:12am

I've made a little change and a little bit clearer for the question

Dev Jonie 20-Jan-14 8:16am

I need a set of arrays.

ex.
myDB.Add
{ "ItemA", "ItemB", "ItemC", "ItemD" }
{ "ItemA", "ItemC", "ItemE", "ItemF" }
{ "ItemA", "ItemB", "ItemC" }
{ "ItemA", "ItemB" }

Dev Jonie 20-Jan-14 21:16pm

Guys I Updated my question and found some good hints.

4 solutions

Solution 4

Maybe try:

C#

while (reader.Read()) {
   // Here I would like to know how you assign you 'tmp' variable?
   if (tmp != DBNull.Value) {
      ListBox1.Items.Add(tmp.ToString()); // The data that added in the Listbox is already
                                          // 1 string ("ItemA,ItemB,ItemC,ItemD")
   }
}
List<string> list = new List<string>();
foreach (var items in ListBox1.Items) {
   // myDb.Add(new MyItems() { string.Join(",", items) } ); 
   //Here, I want to transfer the items from listbox.
   list.AddRange(((string)items).Split(','));
}
// Here you have a list of single string-elements { "Item1", "Item2", "Item3", "Item4" } obtained from multiple-string elements { "Item1,Item2", "Item3,Item4" }
// Do what you have to do with them in your DB

Posted 20-Jan-14 4:04am

phil.o

Updated 20-Jan-14 5:55am

v3

Comments

Dev Jonie 20-Jan-14 11:46am

object does not contain .Split()
so
list.AddRange(items.Split(',')); - encountered the error

phil.o 20-Jan-14 11:54am

Yep, sorry. We are sure items are of string type, so see my updated answer.

Dev Jonie 20-Jan-14 18:59pm

I tried but not the solution i needed.

var tmp = reader["Items"];
if (tmp != DBNull.Value) {
ListBox1.Items.Add(tmp.ToString()); // The data that added in the Listbox is already
// 1 string ("ItemA,ItemB,ItemC,ItemD")
}

There you go, its an object(tmp) to call the item from db. I hope it might help you to analyze the problem

Solution 1

hi try this

C#

List<string> list = new List<string>();
            foreach (var item in listBox1.Items)
            {
                list.Add(item.ToString());
            }

like this you can try.

Posted 20-Jan-14 1:58am

Bojjaiah

Updated 20-Jan-14 2:00am

v2

Solution 2

C#

List<string> li_str = new List<string>();

foreach (var items in ListBox1.Items)
     {
        li_str.Add(items);
     }


string[] arr_str = li_str.ToArray();

</string></string>

Now you have your array ready in "arr_str".

Posted 20-Jan-14 2:07am

Ksh_Sr

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2014-01-20T02:07:00

Solution 3

Try this

C#

foreach (var items in ListBox1.Items)
           {
               myDb.Add(new MyItems() { items });
           }
 var array = myDB.ToArray();

Posted 20-Jan-14 2:07am

Karthik_Mahalingam

Comments

Dev Jonie 20-Jan-14 8:16am

I wan't to use myDb.Add(new MyItems() { items });
as final array.

Karthik_Mahalingam 20-Jan-14 8:24am

can u pls post the code for this class MyItems

Karthik_Mahalingam 20-Jan-14 8:25am

then

myDB = myDB.ToArray();

Karthik_Mahalingam 20-Jan-14 8:39am

try this

foreach (var items in ListBox1.Items)
{
myDb.Add(items.ToString());

}

Dev Jonie 20-Jan-14 8:43am

tried that but stores "ItemA,ItemB,ItemC,ItemD" in single index.
I fetched that data from a query as a single item. what i need is to parse it and put it according to their arrangements in a new container(list/array).

Karthik_Mahalingam 20-Jan-14 9:05am

change this function as

public override string ToString()
{
return ("{\"" + string.Join("\",\"", this.ToArray()) + "\"}" + (this.Support > 0 ? " (support: " + Math.Round(this.Support, 2) + "%)" : string.Empty));
}

Dev Jonie 20-Jan-14 18:31pm

That function has a different role.
I tried a static sample db inside my syntax
{ "ItemA", "ItemB", "ItemC", "ItemD" }
and I got it running correct.

But when I fetched the item from database
originally "ItemA, ItemB, ItemC, ItemD"

and try all of your solutions, its still the same..

I believe that the answer lies in the same class(the one that i showed in question)
I just really need to change that single string to multiple index and store it in 1 array.
Doing this method repeatedly until each strings are arranged accordingly.

Karthik_Mahalingam 20-Jan-14 21:46pm

ok, is your issue got resolved ?

Karthik_Mahalingam 20-Jan-14 21:46pm

is your issue got resolved?

Dev Jonie 20-Jan-14 22:04pm

I've updated my question.
I still haven't get the desired result.

Karthik_Mahalingam 20-Jan-14 22:20pm

ListBox1.Items.Add(tmp);
remove ToString()
because you overrided the method to do some action..
you can call that method after the array is loaded to the list..

Dev Jonie 20-Jan-14 22:29pm

tmp is an object
and the value is "ItemA,ItemB,ItemC,ItemD" string

Karthik_Mahalingam 20-Jan-14 22:36pm

do u have team viewer ?

Dev Jonie 20-Jan-14 22:39pm

Yes

Karthik_Mahalingam 20-Jan-14 22:41pm

can u share yuour screen

Karthik_Mahalingam 21-Jan-14 1:25am

post this Itemset class

Karthik_Mahalingam 21-Jan-14 2:03am

ok i wil check and tell you...

Dev Jonie 21-Jan-14 2:10am

thank you sir

Karthik_Mahalingam 21-Jan-14 4:32am

try this code..

public override string ToString()
{
string dq =@"""";
string temp = "{" + dq + string.Join(dq + "," + dq, this.ToArray()) + dq+ "}";
return (temp + (this.Support > 0 ? " (support: " + Math.Round(this.Support, 2) + "%)" : string.Empty));
}

Karthik_Mahalingam 21-Jan-14 6:14am

??

Dev Jonie 21-Jan-14 6:22am

what I mean is that it resulted as 1 string

{ ""Murder", "Rape", "Carnapping"" }
its like that

Dev Jonie 21-Jan-14 8:23am

WHOOOOOOOOOOOAH!!

Ok ok.. now i know whats the problem.
and I think we already answered this question. ok thank you :]