first off, i realize this is kind of an odd request, try and ignore that 
. my boss wants me to implement a copy row feature in a datagrid. essentially, i need to gather all the info from the current row and do an insert into the sql database that has all that info. i know that i can grab the values of the labels that are in each itemtemplate, but the problem is, I have two columns that display a text value where a id field is stored in that database. for instance, i have budget category description showing in the column in the datagrid, but the budget id is stored in the table (the description is being pulled from another table). is there a sql copy row function or something akin to that? thanks!
. my boss wants me to implement a copy row feature in a datagrid. essentially, i need to gather all the info from the current row and do an insert into the sql database that has all that info. i know that i can grab the values of the labels that are in each itemtemplate, but the problem is, I have two columns that display a text value where a id field is stored in that database. for instance, i have budget category description showing in the column in the datagrid, but the budget id is stored in the table (the description is being pulled from another table). is there a sql copy row function or something akin to that? thanks!