I am working in ASP.Net web application with doodads.

I have some DAL classes and stored procedures based on database tables, which were generated by doodads. some of them are _Users, _UsersCV,

Now my requirement is .. to write a custom stored procedure involving more than two tables using inner join with parameters.

I have done it. But the problem is that ... I am writing the code in _Users DAL class. So when I load the custom stored procedure, using LoadFromSQl(".."), only properties of _Users are loaded (i.e. Columns of User Tables only). But I am also returning columns of other tables like UsersCV and as you can think, they cannot be loaded to properties of _Users DAL class. I need to access that columns and want to create a runtime properties (or columns) in _Users DAL class, because I have to set the Datasource of Datagrid to that class in order to display the columns and values on the web page.

I dont know how to access the columns in custom stored procedure over ASP.Net application. can anybody tell me the way to access them please.

Thanks