How to separate it with comma if data is more than 1 ?

Anuradha sb

foreach (DataGridViewRow row in dataGridView1.Rows)
{currQty += row.Cells["dbbname"].Value;
}

example result:

db1,db2,db3

but if only one it will show

result:

db1

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar4y ago
Accepted answer
1. currQty += (IsNullOrEmpty(currQty) ? row.Cells["dbbname"].Value : ", "+row.Cells["dbbname"].Value;
or test below code
1. var currQty = String.Join(",", dataGridView1.Rows.Select(row => row.Cells["dbbname"].Value.ToString()).Where(s => !string.IsNullOrEmpty(s));

Nitin Sontakke4y ago

currQty += (currQty.Length == 0 ? "" : ", " ) + row.Cells["dbbname"].Value;

Uday Dodiya4y ago

String currQty = "";
foreach (DataGridViewRow row in dataGridView1.Rows)
{
currQty = currQty + ',' + row.Cells["dbbname"].Value;
}
currQty = currQty.Substring(1,currQty.Length-2);
MessageBox.Show(currQty);

try this code you get excat output

i add following line because remove first and last ,

currQty = currQty.Substring(1,currQty.Length-2);