using surrogate list c#

i review an comparison square datagrid.from there , i have managed review grid's rows datatable object.the datatable vigilant information since i equal grid's datasource list vigilant , grid populated.

my problem : i wish list vigilant manipulate the values controlling sql server,(i.e. i wish store surrogate list manipulate controlling sql queries within c# formula , i wish relapse opposite outcome inte grid.(i don't know work surrogate tables c#)

here's formula govern clicking button....

 sqlconnection conn = new sqlconnection("server = localhost;integrated confidence = sspi");
//is tie twine incorrect?

sqlcommand cmd = new sqlcommand();

//!!the slight convertfpsheetdatatable advantage datatable object//
cmd.parameters.addwithvalue("#table",convertfpsheetdatatable(12,false,fpspread2_sheet1));
//i am perplexing emanate surrogate list     

//here , i query               
cmd.commandtext = "select col1,col2,sum(col7) #table organisation col1,col2 dump #table";

sqldataadapter da = new sqldataadapter(cmd.commandtext,conn);
 datatable dt = new datatable();
da.fill(dt); ***// i an blunder here 'invalid vigilant name '#table'.'***

fpdataset_sheet1.datasource = dt;

//**note:** fpdataset_sheet1 grid control