Hi Try this....
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.GetData();
}
}
private void GetData()
{
DataTable categoryTable = new DataTable();
categoryTable.Columns.Add(new DataColumn("Id", typeof(int)));
categoryTable.Columns.Add(new DataColumn("Category", typeof(string)));
categoryTable.Columns.Add(new DataColumn("BranchId", typeof(string)));
categoryTable.Rows.Add(1, "cat1", "1,2");
string concatenatedValue = this.GetConcatenatedValue(categoryTable.Rows[0].Field<string>("BranchId").ToString());
categoryTable.Rows.Clear();
categoryTable.Rows.Add(1, "Cat1", concatenatedValue);
this.gvCategories.DataSource = categoryTable;
this.gvCategories.DataBind();
}
private string GetConcatenatedValue(string id)
{
string concatenatedValue = string.Empty;
DataTable branchTable = new DataTable();
branchTable.Columns.Add(new DataColumn("Id", typeof(int)));
branchTable.PrimaryKey = new DataColumn[1] { branchTable.Columns["Id"] };
branchTable.Columns.Add(new DataColumn("BranchName", typeof(string)));
branchTable.Rows.Add(1, "a");
branchTable.Rows.Add(2, "b");
branchTable.Rows.Add(3, "c");
branchTable.Rows.Add(4, "d");
string[] splittedValue = id.Split(',');
foreach (string item in splittedValue)
{
DataRow row = branchTable.Rows.Find(item);
concatenatedValue += row[1] + ",";
}
return concatenatedValue;
}
Html
<div>
<asp:GridView ID="gvCategories" runat="server" />
</div>