>C# doesn't like
lnAmt = rdr["maxordamt"];.
What do you mean by "C# doesn't like"? Are you obtaining an error message? If yes, this is necessary for one to provide support. It would also help to see your SQL command. We cannot see it in here as it hasn't been provided in the code sample.
>And I can't do
lnAmt = rdr["maxordamt"].ToString();.
>How do I save maxordamt, which is a numeric (99999.99) into lnAmt variable so I can insert it into orderamt field in MyTarget table which is also numeric?
Once the first situation resolved, that command should work. Note that you do not have to convert to string.