hi, i have this SQL command, i would like to know, if i can get the result in a textbox? or label? or send it directly to mail? how?

Code:
SELECT [InputID], [ResID], [DriverID], [Datee], [Timee], [Pax], [Fromm], [Too], [Orig], [Transfer], [ac], [Company], [Charges], [Hrs], [Pt], [Fees], [Stopp], [Grat], [Other], [Total], [Comments], [SentTo], [Email], [Saveas], [Month], [Aff], [Name] FROM [inputt] WHERE ([ResID] = @ResID)
thx