c# - selectionchange with concatenated columns in data grid -

hey guys need help

textbox values

brand | model | description

a | b | c

brand , model concatenated equipment

equipment | description

a b   |       c 

with selectionchange, need in order separate brand , model display values in different textboxes

select concat(equipment.eqname , ' ', equipment.eqbrand , ' ', equipment.eqmodel) items ,equipment.eqdesc ,qty, unitprice
poitems inner join equipment on poitems .eqid = equipment.eqid poitems.poid null group poitems.poitemsid, qty, equipment.eqname , equipment.eqbrand , equipment.eqmodel ,equipment.eqdesc , unitprice

what need in order separate brand , model display values in different textboxes

select concat(equipment.eqname , ' ', equipment.eqbrand , ' ', equipment.eqmodel) items ,equipment.eqdesc ,qty, unitprice poitems inner join equipment on poitems .eqid = equipment.eqid poitems.poid null group poitems.poitemsid, qty, equipment.eqname , equipment.eqbrand , equipment.eqmodel ,equipment.eqdesc , unitprice 

in above sql concatenating eqname, eqbrand , eqmodel together. need specifically include individual columns want (i.e. brand , model). sql should work:

select equipment.eqbrand, equipment.eqmodel, concat(equipment.eqname , ' ', equipment.eqbrand , ' ', equipment.eqmodel) items , equipment.eqdesc ,qty, unitprice poitems inner join equipment on poitems .eqid = equipment.eqid poitems.poid null group poitems.poitemsid, qty, equipment.eqname , equipment.eqbrand , equipment.eqmodel ,equipment.eqdesc , unitprice 

once done, can bind data existing datagrid , hide columns user can't see them.