how can i save a single record from a mysql recordset ? like saving a job from list of jobs ?

Answer 1

database type is not matter, if you mean your SQL statement return one row of database, do it(an example):
ds => data reader object
"Select [FullName] As [tempFN] From [Members] Where [ID]='2'"
ds("tempFN") contains that record!