Click here to Skip to main content
15,919,245 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: How to resize an image file ??? Pin
Britney S. Morales18-Sep-06 6:27
Britney S. Morales18-Sep-06 6:27 
Questionwebcustomcontrol of wizard in asp .net 2.0 Pin
shadesRulz17-Sep-06 23:53
shadesRulz17-Sep-06 23:53 
QuestionEncrypting known set of values Pin
cloudking1196617-Sep-06 23:16
cloudking1196617-Sep-06 23:16 
QuestionDatabase Syncronization HOW? Pin
shafqaat17-Sep-06 23:08
shafqaat17-Sep-06 23:08 
QuestionHow to Reduce the Database Trips. Urgent **** Pin
VenkataRamana.Gali17-Sep-06 23:06
VenkataRamana.Gali17-Sep-06 23:06 
AnswerRe: How to Reduce the Database Trips. Urgent **** Pin
_AK_17-Sep-06 23:10
_AK_17-Sep-06 23:10 
AnswerRe: How to Reduce the Database Trips. Urgent **** Pin
Paddy Boyd17-Sep-06 23:29
Paddy Boyd17-Sep-06 23:29 
AnswerRe: How to Reduce the Database Trips. Urgent **** Pin
Jim Conigliaro18-Sep-06 2:48
Jim Conigliaro18-Sep-06 2:48 
There are a number of ways that you can attack this problem. The correct solution depends entirely on the nature of your application. Our developers usually create some sort of "Cached Items" class that manages data within a cache. If your data set isn't too large, you may want to store all of the unfiltered data in a single data set and use the DataRelation to define the relationship among the tables in the DataSet used to populate your ListBoxes. Whenever a list box is changed, use the relationships defined in your filter the data as needed and rebind the filtered data to the list boxes.

For example, you could so something like this:

intenal static DataSet Categroies<br />
{<br />
    get<br />
    { <br />
       DataSet data = HttpContext.Current.Session["CategoryData"] As DataSet;<br />
       if(data == null)<br />
       {<br />
          data = /* Select Data from Data Source */<br />
          HttpContext.Current.Session["CategoryData"] = data;<br />
       }<br />
       return data;<br />
    }<br />
}<br />
<br />
internal static GetCategory2Data(string category1)<br />
{<br />
   DataView category2 = Categories.Tables["Category2"].DefaultView;<br />
   category2.RowFilter = string.Format("Category1 = {0}",category1);<br />
   return category2;<br />
} <br />


Here data is being stored in the session. You could also use the Application or Cache object to store the data globally so long as you account for multi-threaded/multi-user access into account.


Jim Conigliaro
jconigliaro@ieee.org

AnswerRe: How to Reduce the Database Trips. Urgent **** Pin
wEb GuRu...18-Sep-06 8:05
wEb GuRu...18-Sep-06 8:05 
QuestionApp_Offline.htm gets automatically created. Pin
Nitin198117-Sep-06 22:40
Nitin198117-Sep-06 22:40 
JokeRe: App_Offline.htm gets automatically created. Pin
M LN Rao18-Sep-06 0:10
M LN Rao18-Sep-06 0:10 
Questionhow to get page has expired Message Asp.net Pin
Rahul_h17-Sep-06 22:38
Rahul_h17-Sep-06 22:38 
AnswerRe: how to get page has expired Message Asp.net Pin
Nitin198117-Sep-06 23:27
Nitin198117-Sep-06 23:27 
GeneralRe: how to get page has expired Message Asp.net Pin
Rahul_h20-Sep-06 20:54
Rahul_h20-Sep-06 20:54 
Questionhow to get date difference in asp.net using c# Pin
VishalSharmaDev17-Sep-06 22:33
VishalSharmaDev17-Sep-06 22:33 
AnswerRe: how to get date difference in asp.net using c# Pin
_AK_17-Sep-06 22:40
_AK_17-Sep-06 22:40 
AnswerRe: how to get date difference in asp.net using c# Pin
Guffa17-Sep-06 22:44
Guffa17-Sep-06 22:44 
QuestionTransparent Windows Pin
muthukannanb17-Sep-06 22:23
muthukannanb17-Sep-06 22:23 
AnswerRe: Transparent Windows Pin
M LN Rao18-Sep-06 0:12
M LN Rao18-Sep-06 0:12 
QuestionRe: Transparent Windows Pin
Madhu G Umapathy18-Sep-06 0:59
Madhu G Umapathy18-Sep-06 0:59 
AnswerRe: Transparent Windows Pin
M LN Rao18-Sep-06 1:19
M LN Rao18-Sep-06 1:19 
QuestionHow to make a Imagebutton handle button click ? [modified] Pin
cheeken2u17-Sep-06 21:45
cheeken2u17-Sep-06 21:45 
QuestionHelp me in my Case study Pin
shafqaat17-Sep-06 21:08
shafqaat17-Sep-06 21:08 
QuestionCalender display problem Pin
dany.s17-Sep-06 20:43
dany.s17-Sep-06 20:43 
Answercan anyone help me regarding calender Pin
dany.s17-Sep-06 23:58
dany.s17-Sep-06 23:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.