<div>
<div class="content wysiwyg-content">
What would DAL and BAL looks like if there a subroutine that retreives data from sql, using sqldatareader, and display on textboxes and lables? <br />
<br />
using sqlconnect as new sqlconnection(&quot;mycon string&quot;)<br />
using sqlcomnd as new sqlcommand(&quot;mysp&quot;, sqconnect)<br />
sqlcomnd.commandtype = commandtype.storeprocedure<wbr /><br />
sqlcomnd .parameters.addwithvalue(&quot;<wbr />@id&quot;, ????)<br />
dim dr as sqldatareader = sqlcomnd.exedutereader<br />
dr.read<br />
<br />
txtfirstname.text = dr.item(&quot;firstname&quot;)<br />
<br />
etc...<br />
<br />
end using<br />
end using<br />
<br />
<br />
<a href="http://www.mindstick.com/Articles/d36ceb0f-018c-4979-b2f5-a4a1e616cb5b/?N-Tier%20Architecture%20in%20ASP.NET" rel="ugc">http://www.mindstick.com/Articles/d36ceb0f-018c-4979-b2f5-a4a1e616cb5b/?N-Tier%20Architecture%20in%20ASP.NET</a>
</div>
</div>


What would DAL and BAL looks like if there a subroutine that retreives data from sql, using sqldatareader, and display on textboxes and lables? 

using sqlconnect as new sqlconnection("mycon string")
using sqlcomnd as new sqlcommand("mysp", sqconnect)
sqlcomnd.commandtype = commandtype.storeprocedure
sqlcomnd .parameters.addwithvalue("@id", ????)
dim dr as sqldatareader = sqlcomnd.exedutereader
dr.read

txtfirstname.text = dr.item("firstname")

etc...

end using
end using


http://www.mindstick.com/Articles/d36ceb0f-018c-4979-b2f5-a4a1e616cb5b/?N-Tier%20Architecture%20in%20ASP.NET

N-Tier sample

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications