Budget amount total in Footer

private void GetData()

{

try

{

PRDataContext context = new PRDataContext();

StringBuilder htmlTable = new StringBuilder();

Int32 rownum = 0;

var Result = (from t in context.View_Entries

where t. Code == Convert.ToInt32(hdfCode.Value)

select t);

if (Result != null)

{

htmlTable.Append("

htmlTable.Append("

htmlTable.Append("

foreach (var colum in Result)

{

rownum++;

htmlTable.Append("

htmlTable.Append("

htmlTable.Append("

htmlTable.Append("

htmlTable.Append("

}

htmlTable.Append("

htmlTable.Append("").Append("").Append("");

htmlTable.Append("

PlaceHolder1.Controls.Add(new Literal { Text = htmlTable.ToString() });

}

}

catch (Exception ex)

{

SaveErrorLog(ex.Message, System.IO.Path.GetFileName(Request.Path), System.Reflection.MethodBase.GetCurrentMethod().Name);

MessageBox.Show(ex.Message);

}

}