Hi,
I am implemeting a 3-tier solution for my web application. Basically, I have a web form that contains a GridView. The GridView needs to be bound to data returned from a stored procedure. I have been told that the best way to implement this is to use Generic collections. I created my DAL class to return a datatable back to the BLL. The relevant method is as follows:
public virtual DataTable Load()
{
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable("DataSet");
SqlDataAdapter adp = new SqlDataAdapter();
try
{
&n ...
Go to the complete details ...