I found only one possible record, one for a C.Rowland in the US MO 47th Infantry, Company A. A First Sergeant. No other information.
You state he had two sons who served the US; names? I did not find a David or D.Rowland serving the US from Missouri; what unit did his pension state he served?