C# - How To Store And Retrieve A Particular Segment From The Cache
Mar 8, 2011
It should store plain HTML fragments of a page like the standard Output cache in asp.net .The HTML may contain dynamic content from a database.When an object is updated in the database all the cached HTML fragment containing that particular object should be destroyed and re-cached next time it will be requested.
There is a separate admin tool to handle all data in the database so I can easy store the Id's in a cachetable when an object is invalid. I can also make a request to a page that destroy all cached HTML fragment for that object.
But when I write the markup, how could I do to store and retrieve a particular segment from the cache? Of cause I could do this in code behind and have the markup in a string but I don't want that. I want to have the markup as intact as possible.
Its related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
I've seen numerous examples of people storing DataTables into the Cache, but I am just wondering, do the same rules apply to the Cache that apply to the Session? The one rule I am most concerned with is:Do not store unserializable objects into the Session. Just because you can doesn't mean it is guaranteed to work So ultimately my question is:Can you store unserializable objects into the Cache?I reasearched this for a while, reading numerous posts and even reading the chapter about Cache in my ASP.NET 3.5 book and I cannot find it anywhere.I am going to put my DataTable into a DataSet then into the Cache,but is this necessary?
I would like to store this data once for aspx page. When the user selects different options in the page, data is further selected from the already stored DataTable.
I tried using the ViewState, but as soon as the data grows beyond 100 rows, performance degrades.
i'm developing a "small" warehouse-management WebApplication for few users(5-10 parralel) but with a complex authorization system(checking if pages,menus,TabPanels, UserControls and even single controls are visible or enabled) and permanent and frequent access. Because i've only limited experiences with the ASP.Net MembershipProvider, i'm unsure what's the best approach for following goal:
I want to hold all users, roles and frequently used masterdata in the Cache(in a Dataset). Hence every readonly access should be faster and causes less traffic than always using the database. On updates,deletes and inserts i would update the cached dataset and also the database.Can i use or extend the SqlMembershipProvider to achieve this goal and if possible how?Should i use the stored-procedures from asp.net or simply use the standard CreateUser, GetUser, DeleteUser-functionality? Does this approach makes sense at all?
I would like to know what is the best way to include Cache-Control: no-cache, no-store in authenticated pages in DotNetNuke 5.4.4. In fact, I want to prevent caching in IE6/7 and FireFox as well.
EDIT: Purpose of this Website: Its called Utopiapimp.com. It is a third party utility for a game called utopia-game.com. The site currently has over 12k users to it an I run the site. The game is fully text based and will always remain that. Users copy and paste full pages of text from the game and paste the copied information into my site. I run a series of regular expressions against the pasted data and break it down. I then insert anywhere from 5 values to over 30 values into the DB based on that one paste. I then take those values and run queries against them to display the information back in a VERY simple and easy to understand way. The game is team based and each team has 25 users to it. So each team is a group and each row is ONE users information. The users can update all 25 rows or just one row at a time. I require storing things into cache because the site is very slow doing over 1,000 queries almost every minute.
So here is the deal. Imagine I have an excel EDIT(Excel is just an example of how to imagine it, I don't actually use excel) spreadsheet with 100 columns and 5000 rows. Each row has two unique identifiers. One for the row it self and one to group together 25 rows a piece. There are about 10 columns in the row that will almost never change and the other 90 columns will always be changing. We can say some will even change in a matter of seconds depending on how fast the row is updated. Rows can also be added and deleted from the group, but not from the database. The rows are taken from about 4 queries from the database to show the most recent and updated data from the database. So every time something in the database is updated, I would also like the row to be updated. If a row or a group has not been updated in 12 or so hours, it will be taken out of Cache. Once the user calls the group again via the DB queries. They will be placed into Cache.
The above is what I would like. That is the wish.In Reality, I still have all the rows, but the way I store them in Cache is currently broken. I store each row in a class and the class is stored in the Server Cache via a HUGE list. When I go to update/Delete/Insert items in the list or rows, most the time it works, but sometimes it throws errors because the cache has changed. I want to be able to lock down the cache like the database throws a lock on a row more or less. I have DateTime stamps to remove things after 12 hours, but this almost always breaks because other users are updating the same 25 rows in the group or just the cache has changed.This is an example of how I add items to Cache, this one shows I only pull the 10 or so columns that very rarely change. This example all removes rows not updated after 12 hours:
DateTime dt = DateTime.UtcNow; if (HttpContext.Current.Cache["GetRows"] != null) {
I am writing a bit of code to store about 100 (yes/no) answers about hotels. I have about 7000 records so I need to try and get this right the first time.At the min I have 4 * int32 values stored in SQL and I use a structure containing names boolean values like swimming pool, bar etc etc. In my BLL I have a method that tests the bits in the int 32 and sets the boolean value to try or false.
I have not had any problems with this way, but was thinking about the performance as this would currently have with about 100 if statements in the BLL to set all of the boolean values.The only other ways as I see it are..
1) have 100 boolean columns in the sql table, which I feel would be messy.
2) to have all the int32 sql values populate another text field that is stored in the DB so that the int32 value creates a text string when the hotel owner populates the click boxs in the first place. - then I just display the text value which would have been created something like "pool, bar" My way of lots of ifs does work, I was just worried about the performance
Basically a listing can be more than 1 type and I want that to be able to be shown using the ListingMatrix table. However, I'm having a lot of issues populating the checkboxlist because I have it being sorted by Title to keep it user friendly. I'm using VB.Net, LINQ and MS SQL.
Dim readListingMatrix = (From ListingCategories In db.ListingTypeMatrixes _ Where ListingCategories.ListingID = ListingID) For Each row In readListingMatrix CheckBoxListListingCategories.Items(row.ListingTypeID - 1).Selected = True
I am using C#. I am consuming a webservice. The webservice has a method, which has the return type as blob. The webservice serializes the data before sending as blob.I am able to access the webservice method, but I am not sure how to store the value, as the return type is a blob.I have tried this:
Service1.TestService serv = new Service1.TestService();
? = serv.Custom_methodname(true);
How to assign the output as it is a blob variable?
I am working on a project (asp.net web application) that takes files from users, stores them and retrieves or shows them back to the user when needed. I am saving files on my file system (drive). When I save images and refer to them in iframes, images are being displayed in iframes. But when I save .html file and refer it in an iframe it is not displaying the html file. I want to store a .html file on my file system using file upload and store on my local drive, display it in an iframe.
I need a place to store images. My first thought was to use the database, but many seems to recommend using the filesystem. This seems to fit my case, but how do I implement it?
The filenames need to be unique, how to do that. Should I use a guid?
How to retrieve the files, should I go directly to the database using the filename, make a aspx page and passing either filename or primary key as a querystring and then read the file.
What about client side caching, is that enabled when using a page like image.aspx?id=123 ?
How do I delete the files, when the associated record is deleted?
i have a web page in asp.net.vb code and sql database.
the persons number is called PNUMB and i have stored all photos of persons in a folder with the persons number (PNUMB) as their file name. when i search for a PNUMB i want to display the photo of the persons whose dtata is displayed. how i sit possible
I'm trying to develop local website that records and save to sqlserver the private ip of person who will login to my website, Im using Windows Server r2 as my server, Now my problem is it only records the IP with same segment of my server which is segment zero like(192.168.0.83), if the IP of user is segment 1 or 2 the only the Default gateway of their IP are being saved, Correct me if I am wrong if it is defends on segment or gateway.
I have a public property that I use to store a GUID in the viewState:
Property myGUID() As Guid Get Return CType(Me.ViewState("myGUID"), Guid) End Get Set(ByVal value As Guid) Me.ViewState("myGUID") = value End Set End Property
I include this code on many pages in my website...is there any way to migrate this to a common code file, so I don't have to repeat it on each page? If I try to add it to a class file, the "Me" part of course is out of scope.
My problem is regarding title written above. Currently I have some functions that rely on Sessions to do the job. Everything works smoothly when it is left to default. However, I do not like the idea of losing sessions in case of crash and I have modified my web.config to use Sql Server mode instead.
I have run the necessary commands to create tables and stored procedures in my database using aspnet_sql.exe. I am able to store values into the database but have not been successful retrieving them. Since it has been working fine with InProc mode, I think I can safely assume that there's nothing wrong with my codes. Here's my web.config setting:
