Hi akshay806,
I have created sample that full-full your requirement.
C#
protected void Page_Load(object sender, EventArgs e)
{
string monthValue = "August 200,August 300,August 800,September 500,September 600,September 900";
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] { new DataColumn("Month"), new DataColumn("Value", typeof(int)) });
for (int i = 0; i < monthValue.Split(',').Length; i++)
{
dt.Rows.Add(monthValue.Split(',')[i].Split(' ')[0], monthValue.Split(',')[i].Split(' ')[1]);
}
object[] result = (from row in dt.AsEnumerable()
group row by new
{
Month = row.Field<string>("Month")
}
into g
select new
{
g.Key.Month,
Sum = g.Sum(x => x.Field<int>("Value"))
}).ToArray();
string sumOfMonthValue = "";
foreach (object item in result)
{
sumOfMonthValue += item.ToString().Replace("{ Month = ", "").Replace(", Sum = ", " ").Replace(" }", "") + ",";
}
sumOfMonthValue = sumOfMonthValue.Substring(0, sumOfMonthValue.Length - 1);
Response.Write(sumOfMonthValue);
}
Output
August 1300,September 2000