http://forums.asp.net/122.aspxDiscuss the various Patterns & Practices Application Blocks for ASP.NET 1.x.enCommunityServer 2007 SP1 (Build: 20510.895)http://forums.asp.net/thread/3182586.aspxSat, 23 May 2009 10:33:34 GMT4c671506-2930-414c-a40b-8bf57ded5924:3182586azharrahi0http://forums.asp.net/thread/3182586.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=122&PostID=3182586I have got the idea. It can be done by creating Views and then creating the DAL and BLL classes of that view.http://forums.asp.net/thread/3180817.aspxFri, 22 May 2009 12:13:08 GMT4c671506-2930-414c-a40b-8bf57ded5924:3180817azharrahi0http://forums.asp.net/thread/3180817.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=122&PostID=3180817<p>I am working in ASP.Net web application with doodads.</p> <p>I have some DAL classes and stored procedures based on database tables, which were generated by doodads. some of them are _Users, _UsersCV, </p> <p>Now my requirement is .. to write a custom stored procedure involving more than two tables using inner join with parameters.</p> <p>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,&nbsp;using LoadFromSQl(&quot;..&quot;), 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.</p> <p>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.</p> <p>Thanks</p>