ASP.net Databinding

[saffyre]

Im making an order/dispatch system for the company I work for and as they will be getting a new server with windows 2003 i though i may as well develop for IIS6. Ive got most of it working but i'm not happy with the Gridview object i'm using to display the data from the database.

I need to implement various queries on the same database tables and display them in a Gridview on the respective page. So i can for example search my orders list by date/customer/order number etc. I can achieve this using a BLL made with c# classes and then calling the methods to retrieve a datatable which i can then bind to the gridview. This is ok except that I cannot sort or page the gridview which i would also like to do. I then tried to call a single method from my BLL using an objectdatasource which the gridview was bound too. I could then call methods to mutate the BLL object to change the datatable it retured to the objectdatasource. Therefore mantaining the database search functions and gaining the sort/page features of the objectdatasource. I cannot however access the instance of the BLL class the objectdatasource is using to mutate it. Therefore it is useless.

This must be something that is commonly done in websites. Is there an easier way to do this?

 

[Buttons]

Damn right, what is your underlying datasource? SQL Server is the easiest but others aren't too difficult.

Objectdatasource is the first step and sounds like you're there already. For the rest look at this article.

http://aspnet.4guysfromrolla.com/articles/031506-1.aspx

It also links to loads of other articles which help greatly. Google for Matt Berserth or something like that, now he's the king of gridview. I now have a nice inherited gridview with things like row hover, row select, frozen headers and other such stuff.

I'm now a Prince of Gridviews progressing to King but bypassing being a Queen of Gridview cos that would be rubbish!

 

[saffyre]

Cheers for the info dude that helped a lot.