DataSource Controls :: Item To Be Moved To A 'recycle Bin'?

Jun 25, 2010

I'm building a Content Management website which will also include other features. When an admin member deletes an item through the admin panel, I would like this item to be moved to a 'recycle bin' for 30 days (then automatically deleted).What is the best way of implementing this feature? One idea I had was to have a 'Deleted' bit column in my table, then only show records [Code].... However this would mean having to remember to put this condition in place everytime I [Code].... from the table.

Another Idea I had was to have a second table where the records would be moved to when deleted. However I have many tables being used in my website, so this would mean doubling the amount of tables, and having duplicate table structures (which could cause consistency issues in the future).Ideally I would like to have a 'RecycleBin' table which all the records are moved to, but this could contain 100s of columns to be able to store data from all the different tables.

View 2 Replies


Similar Messages:

How To Change The Text Of Last Moved Item From One Listbox To Another

Jan 7, 2011

how can i change the text of last moved item from one listbox to another

View 2 Replies

Data Controls :: Edit A GridView Row When Mouse Is Moved Over It?

Apr 23, 2014

Column1        Column2     Edit

1               A                edit

2               B                edit 

Now mouse hover on  2 or B then how it would selected or get editable.

View 1 Replies

DataSource Controls :: Getting The ID Of The Inserted Item Using ObjectDataSource?

Aug 4, 2010

Im using Objectivation as a DAL with GridView !

I would like to link item when i create it with the InsertMethode :

I have this 2 table :

Item ( id, name )

ItemRelation( idrelation, idParentItem, idSonItem)

I have a page with a gridview with the liste of item in relation with another item (Same table) : Select * From Item where id IN ( Select idSonItem where idParentItem = @TheItem )

When i add an item from this grid i would like to link it with the current Item : So I insert the Item with the GridView InsertMethod then I do another Query an the ItemRelation with idParentItem as the courant Item and the Inserted Item as the idSonsItem !

so the question is : How to get the id of an inserted Item after i get executed the InsertMethod ?

View 4 Replies

DataSource Controls :: Add A New Item To A LINQ Query?

May 13, 2010

So I'm trying to add a single item to a query I wrote. The query is then pass to the e.Result of a LinqDataSource_Selecting event. This datasource is being used by a dropdown list and label in a listview.

I am trying to add a "New" field to the end of the list.

Currently I have this working, but it seems like a really messy solution. First I make a class with the fields I need:

[Code]....

Then I build the query:

[Code]....

Then a second list and query with the new value:

[Code]....

Finally, I union the two and set the e.Result:

[Code]....

View 5 Replies

Forms Data Controls :: Foreign Key Fields Are Moved To The Bottom Of Detailsview?

Sep 15, 2010

I'm not sure if you would consider it a foreign key field or not, but I have an agency table with an association to my Project table. It exists primarily to limit the input values of agency in the Project table to those listed in the Agency table. Anyway, everything works fine, except that when you insert/add a project, the Agency field is moved to the end of the list. I'd like to move it back where it belongs (further up the list).

View 3 Replies

DataSource Controls :: Delete Selected Item From DB On Button Click

Dec 24, 2010

I have dropdownlist which items are generated using SQLDataSource. And there is a "Delete Button" next to it. When user selects item from dropdownlist and presses that button I want the item to be removed from DB. Here is the question "How can I achieve this using sqldatasource Delete Command?" I do can remove Item From Code Behind. But i believe it's more efficient to use sqldatasource delete command.

View 2 Replies

DataSource Controls :: Adding List Item Collection To Datatable?

Jul 7, 2010

I have a list item collection. How to add this list item collection to a datatable.

The list item collection has the following fields:

Student Name, Maths Mark
John 20
Mac 30
John 35

I want to create a html table from the data table, which is grouped on the Student Name field.

View 2 Replies

DataSource Controls :: Preventing SqlCacheDependency From Invalidating A Cache Item While It Is Being Set?

Feb 9, 2010

I think it is a problem that SqlCacheDependency may invalidate a cache item while it is being set:

function getCacheItem()
if cacheitem is empty
cacheitem = something
AND AT THIS POINT SqlCacheDependency INVALIDATES THE cacheitem
end if
return cacheitem
end function

how can we prevent this? Is it somehow possible to specify a ReaderWriterLockSlim for the SqlCacheDependecy to use?

View 1 Replies

DataSource Controls :: Check Datatable Rows For Existing Item?

Jun 12, 2010

I have one problem with my shopping cart that I really can't figure out all by myself.I want, if a item already exist in the datatable, the quantity to be updated for that item with the new number instead of creating the same item again.I have done a foreach loop because I think that is where I should start.Notes: MyRow[3] is the column holding the quantity.Code:

[Code]....

//Bengt

View 8 Replies

DataSource Controls :: Way To Update Part Inventory With An Updated Count Of Item

Jan 27, 2010

I'm trying (poorly I might add) to set up a select statement and due to my noobishness I simply have not found a way to do it RIGHT. Then again - I'm probably starting entirely wrong - but I've gotta' learn somewhere.I'm attempting to track product usage (think mild inventory tracking). In the system, I have independent parts and builds (combination of independent parts) - each has its own SQL table. Each time a "build" is completed, I want to update my part inventory with an updated count of that item.

Build_tbl
Build_ID (int/spec)B_nameB_desc
Part_tbl
Part_id (int/spec)P_nameP_cost
Build_asmb_tbl
[code]...

View 6 Replies

DataSource Controls :: Populate Label / Textbox From Dropdownlist In Insert Item Template

Nov 19, 2010

I've been trying to find a solution to my problem for about 2 days now, and have found nothing. I am new to .net and not really sure how to accomplish this. I have 4 tables in a database, Vendors, RepairCos, Cons, ConRepairHistory. What I'm trying to do is make a page called SendOutForRepair.aspx that has a insert item template where the first control is a dropdownlist that is attached to the Cons table (got this figured out) and is populated with the Serial Number field. I would like the selection from the dropdownlist to populate the 2nd control (VendorID) that is also from the Cons table....

View 1 Replies

Forms Data Controls :: FormView Edit And Item Template With Manual Datasource Not Returning?

Jan 12, 2011

I have a formview with both edititem template and item template as following:

<asp:FormView ID="PFTFormView" runat="server"
DataKeyNames="PFTId"
EnableModelValidation="True" Width="90%"
OnItemUpdating="PFTFormView_ItemUpdating"
onmodechanging="PFTFormView_ModeChanging" >
<EditItemTemplate>
<table>
<tr><td class="style1">PFTId</td><td class="style3"><asp:Label ID="lblPFTId" runat="server" Text='<%# Eval("PFTId") %>' /></td></tr>
<tr><td class="style1">Last Name</td><td><asp:TextBox ID="txtPFTLastName" runat="server" Text='<%# Bind("PFTLastName") %>' Width="200px" /></td></tr>
<tr><td class="style1">First Name</td><td><asp:TextBox ID="txtPFTFirstName" runat="server" Text='<%# Bind("PFTFirstName") %>' Width="200px" /></td></tr>
<tr><td class="style1">Home</td><td><asp:TextBox ID="txtPFTHome" runat="server" Text='<%# Bind("PFTHome") %>' Width="200px" /></td></tr>
</table><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
<ItemTemplate>
<table>
<tr><td>PFTId</td><td><asp:Label ID="lblPFTId" runat="server" Text='<%# Eval("PFTId") %>' /></td></tr>
<tr><td>Last Name</td><td> <asp:Label ID="lblPFTLastName" runat="server" Text='<%# Bind("PFTLastName") %>' /></td></tr>
<tr><td>First Name</td><td><asp:Label ID="lblPFTFirstName" runat="server" Text='<%# Bind("PFTFirstName") %>' /></td></tr>
<tr><td>Home</td><td> <asp:Label ID="lblPFTHome" runat="server" Text='<%# Bind("PFTHome") %>' /></td></tr>
</table><br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False"
CommandName="Edit" Text="Edit" />
</ItemTemplate>
</asp:FormView>

on my code behind, I have:

Sub PFTFormView_ItemUpdating(ByVal sender As Object, ByVal e As FormViewUpdateEventArgs)
Dim PFTObj As New PFT
Dim PFTDST As New Data.DataSet
Dim newPFTLastName As String = DirectCast(PFTFormView.FindControl("txtPFTLastName"), TextBox).Text
Dim newPFTFirstName As String = DirectCast(PFTFormView.FindControl("txtPFTFirstName"), TextBox).Text
PFTObj.PFTLastName = newPFTLastName
PFTObj.PFTFirstName = newPFTFirstName
PFTObj.PFTHome = DirectCast(PFTFormView.FindControl("txtPFTHome"), TextBox).Text
If PFTObj.UpdatePFT(Session("PFTId")) Then
Me.lblErrorMessage.Text = "PFT Update Successfully"
Else
'
Me.lblErrorMessage.Text = "PFT Update UnSuccessfully"
End If
PFTDST = Nothing
PFTObj = Nothing
end sub

The problem is:

PFTObj.PFTLastName = newPFTLastName
PFTObj.PFTFirstName = newPFTFirstName
PFTObj.PFTHome = DirectCast(PFTFormView.FindControl("txtPFTHome"), TextBox).Text

are not returning the updated value from the form.

View 4 Replies

IIS Recycle Vs ASP Cache

Nov 15, 2010

does scheduled recycling an application pool affects HttpContext.Application / Cache? I can't find reference for that.I guess yes, as it causes worker process to restart, I want to make sure. I'm talking about iis 6.0 (w3wp.exe).

View 3 Replies

Data Controls :: Display Image In Another Image Control When Mouse Is Moved In Nested Repeater

Jul 17, 2015

I have one repeater that has one image(image1) bound from data base .also i have one pop up div that  has another image(image2) without any image url.i wanna when click on image1 thats url put in image2's url and my pop up div show

View 1 Replies

Recycle Web Application In Production Server?

Sep 1, 2010

I have made changes to my global.asax file so i want to recycle my web application to make the changes work. How to safely recycle my asp.net web application in production server?

View 3 Replies

Log IIS Application Pool Startup / Shutdown And Recycle?

Dec 9, 2010

My application is running in a shared hosting environment. I do have a dedicated App Pool for my app. I've been doing some testing with 1st visits and precompile performance and have been tracking when my application starts up and shuts down.

In my Global.asax I have some logging code in Application_Start and Application_End. I can see from my logs generally when the application is idle and shuts down, then someone visits and it starts back up.

But, I also see cases where a shutdown is logged and then followed by another shutdown about 13 minutes later; without a startup in the middle.

I also see instances where there are two Startups in a row. I'm guessing these might be a recycle, but why wouldn't there be a shutdown log entry?

What I'd really like to know if there is a better way to track when my application starts, when it shuts down and if it is shutdown due to an idle pool, or from a recycle. I don't have access to the Windows Event Log so I need to do this from my app if possible.

View 1 Replies

Session - Why Does Application Recycle When Delete A Folder

Sep 27, 2010

I have a Silverlight application using a WCF service hosted in IIS. I make use of some aspects of ASP.NET. I have the following folder structure for my application:

inetput
wwwroot
myapp
reports
{user-guid-folders}
report1.pdf
report2.pdf
App_Data (folder)
bin (folder)
Client_Bin (folder)
(various .aspx files, plus web.config, etc.)

The application dynamically generates reports and puts them in a folder with a GUID for the name which is unique to the user. This all works fine. However, when the user logs out I was cleaning up and deleting the PDF files in their folder, then deleting their GUID folder.

Deleting the files works fine, but if I delete the folder, the application recycles (which then removes all other users' sessions - I get a Session_OnEnd event for every user's session, and an Application_OnEnd event. The next user request causes the whole application to restart. So, while I can fix this by not deleting the GUID folder (which my application itself created), what is the reason for this? Is there any way I can prevent this from happening?

View 1 Replies

Iis7 - Should Set .NET Application Pool To Auto-recycle

Mar 3, 2011

I have a number of ASP.NET (4.0) web applications that appear to leak (a small amount) of memory during each request. It is such a small amount, that for most use-cases, it will not grow to become a problem for weeks or even months at a time. I generally try to be good with closing any connections managed by the application, avoiding state-variables (or instance variables for my singleton), etc. My question is this - is this normal behavior for ASP.NET applications? I had turned off the default (IIS 7) behavior of recycling the app pool after 20 minutes of being idle. I do this since the application takes a few minutes to build its internal cache, and I want to avoid negatively impacting the user experience (and having them wait for the application to start when they issue the request).

View 1 Replies

.net - Memory Increase On Application Pool Recycle?

Dec 14, 2010

I'd like to describe strange issue I've noticed while analyzing my asp.net application in production and ask for some advice or opinion on the following matter.Application usually runs with some 80-90 MB of memory footprint. This seems stable since no memory leaks have been detected so far - no slight increase in memory usage over time. Yet, problem occurs when application pool recycles (I'm using shared hosting and judging by logs it occurs either when app is idle for 20 mins or every ~30 hours - something like that). The issue is that used memory almost doubles for some period on recycle - it goes to some 160-170 MBs without any explanation. This is confusing, since it is common claim that recycling should purge the memory and all other resources - at least I get it that way. System holds this amount of memory for some 7-8 hours and then memory usage drops to it's usual level of 90-100 MB, again, with no apparent reason (at least not know to me).

View 1 Replies

Appdomain Recycle Settings On Mod_mono & Apache?

Apr 30, 2010

How does one control the application recycle settings for an ASP.NET application runnin on mod_mono & Apache ?

On IIS6 & 7 there was an option to specify either a time period, a number of requests, etc. when the AppDomain would be recycled and the application would basically do an Application_End() / Application_Start().

I am seeing the same behaviour on mod_mono & Apache ,but I can't find where to change the settings.

View 2 Replies

Memory Limits And Application Pool Recycle?

Jun 22, 2010

my web applications app pool configuration is
PeriodicRestartMemory : 512000
PeriodicRestartPrivateMemory : 196608

although the virtual memory limit is higher than private memory, app pool is recycled with virtual memory limits exceeded errors in the event log (instead of private memory).

what is the reason for this? how could it exceed virtual memory limits before exceeding private memory limits? it seems that systems other allocations in virtual memory cause limits exceeded before applications private allocations exceed the limits, but what are those allocations of the system? or what is the root cause of this.

View 1 Replies

IIS7 ASP.NET In-proc Session NOT Being Lost After App Recycle?

Aug 23, 2010

I've got an ASP.NET MVC app running under IIS7. It's using the default in-proc session management, which, according to all that I read, should lose the users' session after an app pool recycle.It doesn't seem to be losing it though. Even an IIS reset doesn't lose the session.Has something changed in IIS7 that keeps the session alive?

View 1 Replies

Configuration :: Worker Process Recycle, Every 60 Seconds?

Jul 13, 2010

We recently had to enable Memory Recycling on a 2.0 app pool (IIS6). We checked both boxes, leaving in the default values of 500 MB for virtual memory and 192 MB for used memory. Here's where it gets interesting. Every 60 seconds, on the dot, the worker process is forced to recycle.Our tests were spamming the site with concurrent users trying to get the virtual memory up to 500MB, but we never could (as viewed in task manager). However, that didn't matter. We tested it by simply recycling the pool and hitting one page, once, and seeing around 30MB allocated and then just waiting 60 seconds and watching the process die in task manager (and a new one start up).We've increased the value for maximum virtual memory to 768MB and the issue *appears* to have gone away, but just arbitrarily accepting a fix isn't how we like to do things. I haven't found any officially reported bugs, kb articles, or solutions on blogs that point to what is causing this. To me, this means either it's some crazy environmental issue or the answer is really obvious and we just can't see it.

View 1 Replies

Forms Data Controls :: Check If Item Exists In E.item.dataitem?

Oct 27, 2010

I use a ItemDataBound for a repeater.But i use 2 kinds of linq querys to bind it.Some of them has a MerkID, and some doesnt have this item.So its easy i need to do this:

if(e.Item.DataItem.Contains("MerkID"))

{
//Code for linq query 1

} [code]...

So of course the if selection doesnt work, but how can i do that? I already tryed this:

DataRowView drv = (DataRowView)e.Item.DataItem; if (drv.Row.Table.Columns.Contains("MerkID"))

But that doenst work because he cant convert it to a datarowview because its a linq class.So what to do? Right now i use a try and catch, but there are better solutions i guess...

View 8 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved