Select INSERT in c#

[[gja]]

Hello There,

I just wanna ask how will i implement Select Insert query in C#.

Example

"INSERT INTO DB1.TABLE1 (lastname,firstname,middlename) SELECT lastname,firstname,middlename FROM DB2.TABLE2"

can i use this query like this?or do i need to separate the two statements.
cmd.commandtext = "INSERT INTO DB1.TABLE1 (lastname,firstname,middlename) SELECT lastname,firstname,middlename FROM DB2.TABLE2";

Thanks in advance!
glen