asp.net avoid duplicates in string builder

Question

hello everbody, i have a some problem on my code, i want get data from mssql, after get data put my table inside but i have a some problem,same data getting two times
StringBuilder sb = new StringBuilder(); foreach (Coffee coffee in coffeeList) { sb.Append(string.Format(@" Name : {0} Name : {0} Type: {1} Type: {1} Price: {2} Price: {2} Roast: {3} Roast: {3} Origin: {4} Origin: {4} Description: {5} Description: {5} ", products.Name, products.Type, products.Price, products.Roast, products.Country, products.Review, products.Image)); }

Nanhe Siddique · Accepted Answer

hi tapan   You can check whether the value you have added is exists before appending or not like   foreach(...........) {  if ( sb . ToString (). Trim (). Length == 0 || ! sb . ToString (). Contains (" addedvalue" )) { sb1 . Append ( "New value" ); } }  it think it may help you

Ekrem Tapan · Answer

hi  Nanhe Siddique ,    so, how to costumize "addedvalue" & "newValue" part ~ ?

Name :	{0}	Name :	{0}
Type:	{1}	Type:	{1}
Price:	{2}	Price:	{2}
Roast:	{3}	Roast:	{3}
Origin:	{4}	Origin:	{4}
Description:	{5}	Description:	{5}