The error occurs because you don't have corresponding columns in the two queries.
The type of one is integer and the type of the other is a character.
Look at the query having 3 column. In first it is first_name and in second it is id. Which causes the error.
sushil can't be converted to int value.
string qry= "select top 6 * from ( "
+ " select a.to_id, a.from_id, b.first_name, b.last_name, b.id as 'bid',c.imagedata, c.id as 'cid' from tblfrequst a "
+ " join tbluserinfo b on a.to_id=b.id"
+ " join tbluserprofilepicture c on c.id=b.id"
+ " where a.from_id="+ID + " and a.request_status='AC'"
+ " UNION"
+ " select a.to_id, a.from_id, b.first_name, b.last_name, b.id, c.imagedata, c.id from tblfrequst a "
+ " join tbluserinfo b on a.from_id=b.id "
+ "join tbluserprofilepicture c on c.id=b.id"
+ " where a.to_id="+ID+ " and a.request_status='AC'"
+ ") tblfrequst";
Change with this.