how to sum the amount of unique codes and show it as one record in datagridview using sql procedure

//Let us say the Data is read into a DataTable from the SQL DB
//The following code is given here only to run the sample
DataTable ttest = new DataTable();
ttest.Columns.Add("Code",typeof(long),null);
ttest.Columns.Add("Name",typeof(string),null);
ttest.Columns.Add("Amt",typeof(decimal),null);
ttest.Columns.Add("Per",typeof(double),null);
ttest.Rows.Add(480530,"TESTASSET1",100.00,2.00);
ttest.Rows.Add(480530,"TESTASSET2",200.00,2.00);
ttest.Rows.Add(480535,"TESTASSET3",300.00,5.00);
ttest.Rows.Add(480535,"TESTASSET4",400.00,5.00);
//The code upto here is given only to run sample

DataTable uniqueCodes = ttest.Clone();

ttest.AsEnumerable().GroupBy (t => t.Field<long>("Code")).Select (row => 
{DataRow uRow = uniqueCodes.NewRow();
 		uRow[0]=row.Key;
		DataRow gRow = row.FirstOrDefault ();
		uRow[1]=gRow[1];
		uRow[3]=gRow[3];
		uRow[2]=row.Sum (r => r.Field<decimal>("Amt"));
		return uRow;
}
).CopyToDataTable(uniqueCodes,LoadOption.OverwriteChanges);
//The uniqueCodes can be assigned to the DataGridView
dataGridView1.DataSource = uniqueCodes;
//The contents of uniqueCodes will be
//Code  Name        Amt Per 
//480530 TESTASSET1 300 2 
//480535 TESTASSET3 700 5 

SELECT CODE, NAME, SUM(AMT) AS AMT, PER
FROM T_TEST
GROUP BY CODE