Author: akpuk | Posted on: 7/10/2009 2:18:29 AM | Views : 249

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 ...