updating DataGrid on Button Press

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: May 2007
Posts: 45
Reputation: mike.mclennan is an unknown quantity at this point 
Solved Threads: 0
mike.mclennan's Avatar
mike.mclennan mike.mclennan is offline Offline
Light Poster

updating DataGrid on Button Press

 
0
  #1
May 22nd, 2007
I am working with ASP.NET, C# and SQL Server.

What I am trying to do seems simple enough, but is causing me alot of problems. I am trying to set up my DataGrid so that is updates only when i press the Update button. It is pulling information from 5 different locations right now. 4 Combo boxes that contain a Category, Family, Sub Family and a Specific ID. It is also getting information from a text box that simple uses the word(s) typed in to search for the matching content in the items description field. I have basically created a detailed item searcher. But the problem is each combo box has to contain auto post back, because of the relationships. (each Category has specific Families that can belong to it, each Family has specific Sub Families that can belong to it, etc, etc...) so each time i select a new category, family what have you, the datagrid refreshes and this takes alittle time because the database itself contain 1500+ items.

Right now i am using paging, but i want to find a way so that the DataGrid will only refresh when the user preses the Search button.
Any help would be greatly appreciated.
Reply With Quote Quick reply to this message  
Join Date: May 2007
Posts: 20
Reputation: kokkee is an unknown quantity at this point 
Solved Threads: 2
kokkee kokkee is offline Offline
Newbie Poster

Re: updating DataGrid on Button Press

 
0
  #2
May 23rd, 2007
Originally Posted by mike.mclennan View Post
I am working with ASP.NET, C# and SQL Server.

What I am trying to do seems simple enough, but is causing me alot of problems. I am trying to set up my DataGrid so that is updates only when i press the Update button. It is pulling information from 5 different locations right now. 4 Combo boxes that contain a Category, Family, Sub Family and a Specific ID. It is also getting information from a text box that simple uses the word(s) typed in to search for the matching content in the items description field. I have basically created a detailed item searcher. But the problem is each combo box has to contain auto post back, because of the relationships. (each Category has specific Families that can belong to it, each Family has specific Sub Families that can belong to it, etc, etc...) so each time i select a new category, family what have you, the datagrid refreshes and this takes alittle time because the database itself contain 1500+ items.

Right now i am using paging, but i want to find a way so that the DataGrid will only refresh when the user preses the Search button.
Any help would be greatly appreciated.
If you dun wan to let it postback, why not u dun using ASPnet AJAX?
it quite Simple to use that.
but requirement is framework 2.0 and above
Last edited by kokkee; May 23rd, 2007 at 4:09 am.
Reply With Quote Quick reply to this message  
Join Date: May 2007
Posts: 45
Reputation: mike.mclennan is an unknown quantity at this point 
Solved Threads: 0
mike.mclennan's Avatar
mike.mclennan mike.mclennan is offline Offline
Light Poster

Re: updating DataGrid on Button Press

 
0
  #3
May 23rd, 2007
Mostly because i have to use what my company uses. They have the software for SQL 2005 and Visual Studios 2005 so that is what I am using. If i had my choice I would be using Asynchronous, but i do not... bah.

Anyways i found a work around, I am still curious about this problem, but for now I am making this one as solved.
- mike mclennan
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC