Replace comma separated ids with values in ASP.Net MVC

Hi mahesh213,

Refer below sample code.

Namespaces

using System.Data;

Controller

public class HomeController : Controller
{
    // GET: /Home/
    public ActionResult Index()
    {
        DataTable dt2 = GetTable2();
        foreach (DataRow dr in dt2.Rows)
        {
            List<string> codes = new List<string>();
            foreach (string code in dr["ItemCode"].ToString().Split(','))
            {
                if (!string.IsNullOrEmpty(code))
                {
                    codes.Add(GetTable1().Select("Id=" + code)[0]["Item"].ToString());
                }
            }

            dr["ItemCode"] = string.Join(",", codes);
        }
        TempData["Data"] = dt2;

        return View();
    }

    private DataTable GetTable1()
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[] { new DataColumn("Id"), new DataColumn("Item") });
        dt.Rows.Add(1, "Mango");
        dt.Rows.Add(2, "Apple");
        dt.Rows.Add(3, "Banana");

        return dt;
    }

    private DataTable GetTable2()
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[] { new DataColumn("Id"), new DataColumn("ItemCode") });
        dt.Rows.Add(1, "1,2,3");
        dt.Rows.Add(2, "1,3");
        dt.Rows.Add(3, "2,3");

        return dt;
    }
}

View

<table>
    <tr>
        <th>Id</th>
        <th>Item Name</th>
    </tr>
    <%foreach (System.Data.DataRow row in ((System.Data.DataTable)TempData["Data"]).Rows)
        { %>
    <tr>
        <td><%= row["Id"]%></td>
        <td><%= row["ItemCode"]%></td>
    </tr>
    <% } %>
</table>

Screenshot