LINQ - Comma Separated - Asked By Barbara M on 08-Dec-11 12:46 PM

hi,

I have one data list contain Grid view. where i have to display the product in COMMA SEPARATED  format in LinQ like: -

laptop, keyboard, mouse, webcam, speaker, headphone

which is store in DB table like;

P_Id   P_Name
-------   ----------
1     laptop
2     keyboard
3     mouse
4     webcam
5     speaker
6     headphone

here i my code:


Please provide the solution and LinQ query to display the products in comma separated....

See the Below example :
 
var dCounts = 
    (from i in dic 
      group i by i.Value into g 
      select new { g.Key, count = g.Count(), Items = string.Join(",", g.Select(kvp => kvp.Key)) });

The main thing you can achive by :

Use string.Join(",", {array}), passing in your array of keys.

or you may try this option also

string returnVal = (from a in b
select a.StringValue).Aggregate(new StringBuilder(),
(c, d) => c.Append(",").Append(@"""" + d + @""""),
(c) => c.ToString().TrimStart(new char[] { ',' })
.TrimEnd(new char[] { ',' }))

Here "b" is the list and StringValue will be the value which want to get converted to comma separated values.

You need not go form that many queries , a simple lambda expression will do,

Assuming your results are of type list


Now query on the list using Lambda expression



Regards

Use this code-

private DataTable GetSampleData() {

            //NOTE: THIS IS JUST FOR DEMO
            //If you are working with database
            //You can query your actual data and fill it to the DataTable


            DataTable dt = new DataTable();
            DataRow dr = null;

            //Create DataTable columns
            dt.Columns.Add(new DataColumn("ID", typeof(string)));
            dt.Columns.Add(new DataColumn("ProductName", typeof(string)));
            dt.Columns.Add(new DataColumn("Price", typeof(string)));
            dt.Columns.Add(new DataColumn("Amount", typeof(string)));


            //Create Row for each columns
            dr = dt.NewRow();
            dr["ID"] = 1;
            dr["ProductName"] = "Product 1";
            dr["Price"] = "100";
            dr["Amount"] = "10";

            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["ID"] = 2;
            dr["ProductName"] = "Product 2";
            dr["Price"] = "200";
            dr["Amount"] = "2";

            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["ID"] = 3;
            dr["ProductName"] = "Product 3";
            dr["Price"] = "50";
            dr["Amount"] = "10";

            dt.Rows.Add(dr);

            return dt;
        }

        private DataTable CustomTable(DataTable dtSource) {
            DataTable dt = new DataTable();
            DataRow dr;
            string delCol = string.Empty;

            if (dtSource.Rows.Count > 0) {
                dt.Columns.Add(new DataColumn("CommaSeparatedColumn", typeof(string)));

                foreach (DataRow row in dtSource.Rows) {
                    delCol += string.Format("{0},", row["ProductName"]);
                }

  
                dr = dt.NewRow();
                dr["CommaSeparatedColumn"] = delCol.Remove(delCol.Length -1);
                dt.Rows.Add(dr);

            }
            return dt;
        }


        protected void Page_Load(object sender, EventArgs e) {
            if (!IsPostBack) {
                DataTable source = CustomTable(GetSampleData());
                GridView1.DataSource = source;
                GridView1.DataBind();
            }
        }

TRy this and let me know.