---
title: "How To Save Multiple ListBox Value in a single row and in a single column"  
description: "How To Save Multiple ListBox Value in a single row and in a single column"  
author: "Anonymous User"  
published: 2013-12-16  
updated: 2013-12-16  
canonical: https://www.mindstick.com/forum/1780/how-to-save-multiple-listbox-value-in-a-single-row-and-in-a-single-column  
category: "c#"  
tags: ["c#"]  
reading_time: 2 minutes  

---

# How To Save Multiple ListBox Value in a single row and in a single column

I want to save [multiple](https://www.mindstick.com/blog/12797/iowa-is-expected-to-see-heavy-growth-in-multiple-sectors) list box [value](https://www.mindstick.com/articles/23219/an-optimized-description-adds-value-to-experience-and-in-turn-effectively-guest-posting-packages) into a single [field](https://www.mindstick.com/forum/160867/does-mindstick-provide-training-for-field-marketing) of a [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) using [linq](https://www.mindstick.com/articles/12007/language-integrated-query-linq-queries) to entity. this is my code. any suggestion?

```
protected void Button5_Click(object sender, EventArgs e){    for(var i = 0; i < lb2.Items.Count; i++)    {        var e1 = new employee() { emp_skill = lb2.Items[i].Text };        je.employee.AddObject(e1);    }    je.SaveChanges();}
```

## Replies

### Reply by Pravesh Singh

Hi Jacob,\

I assume your data is collection of string and you want to save it as single string. The following code make those collection of string become single string separated by semicolon, then you can save it as single row single column data:

```
protected void Button5_Click(object sender, EventArgs e)    {        var semicolonSeparatedString = "";        var e1 = (from emp in je.employee where emp.emp_email == txtmail.Text select emp).FirstOrDefault();        for (int index = 0; index < lb2.Items.Count; index++)        {            //no need to add separator for the first item            if (index == 0) semicolonSeparatedString += lb2.Items[index];            else semicolonSeparatedString += ";" + lb2.Items[index];        }        //data formatted as single string and ready to be saved        e1.emp_skill = semicolonSeparatedString;        je.SaveChanges();
```

And when you want to get it back as collection of string simply use Split() extension method :

```
var semicolonSeparatedString = je.employee.FirstOrDefault(o => o.name == "employeeName").Select(o => o.emp_skill);//split to get the single string data back to array of stringvar items = semicolonSeparatedString.Split(';');foreach(var item in items){    lb2.Items.Add(item);}
```


---

Original Source: https://www.mindstick.com/forum/1780/how-to-save-multiple-listbox-value-in-a-single-row-and-in-a-single-column

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.