Guys I have a peculiar problem here, I need to display data from two tables having no fields at all common and want to display them in one gridview on the click of a radio button .
If radiobuttton(1) is selected then data from table one will be displayed and if radiobuttton(2) is selected then data from table two will be displayed.
each of the table is having field name as:
fname lname mname abid
fname lname mname cdid
is there some advice you guys can help me?