Deleting Old Applications

Feb 2, 2010

After some trial and error I'm stuck with some applications in my database. I tried to delete them, but wound up with error about referential integrity. Is there any way to delete all of this?

View 2 Replies


Similar Messages:

C# - Deleting From Repeater Item - Erroneous Deleting?

Sep 27, 2010

I have a repeater which binds a set of data. Within this repeater is a column with various controls for updating, deleting, etc. These are image buttons which fire an onclick event such as "DeleteRecord". All this does is fire a stored procedure, passing in the ID of the record to delete from the CommandArgument of the object.

This works wonderfully... except for one rather huge problem. Once you delete a record, if you refresh the page, the record where the first deleted record used to be gets deleted. For instance... if I have 4 records

1 Record1
2 Record2
3 Record3
4 Record4

and I delete record 2... The page reloads with (which is fine):

1 Record1
3 Record3
4 Record4

...if I then hit refresh...

1 Record1
4 Record4

I assume this is because the erroneously deleted object (record3) is now in the same hierarchical place as the old object used to be and .net therefore doesn't know the difference, the page refreshes and fires the onlick event, grabbing out the command argument of the new object and deletes based on the ID as obtained from the commandargument of the new object. This is obviously a huge problem, if a client did this it would destroy data erroneously and I'm at a loss here. Is there any way to stop this from happening? I'm not sure if there is a better way to go about doing things or not. If there isn't, I need some sort of way to tell the page not to execute the event or to cross reference the ID of the object that is intended for deletion against the object itself...

Code below for convenience...

EDIT Wrapped a LinkButton around it because I have some jquery code in here as well which stops the page execution to wait for user confirmation. Pressing "ok" continues page execution.

<asp:LinkButton ID="oDeleteLink" CssClass="oDeleteIcon" CommandName="Delete" CommandArgument='<%# Eval("iAccountID") %>' runat="server">
<asp:ImageButton ImageUrl="/files/system/icons/trash-steel-16.png" ToolTip="Delete This Account" AlternateText="Delete" ID="oDeleteIcon" runat="server" />
</asp:LinkButton>
protected void oAccounts_ItemCommand(Object Sender, RepeaterCommandEventArgs e) {
if (e.CommandName == "Delete") {
int ID = e.CommandArgument.ToString().Numeric();
db.SPs.SpDeleteAccount(ID).Execute();
UI.Confirm(uiBroadcast, "Account has been deleted", "300px");
BindAccounts();
}
}

View 2 Replies

WCF / ASMX :: Building Services To Work With Web Applications And Console Applications?

Jun 7, 2010

I've been worked with web services so far, and I'm interested in expanding my services to console applications as well so I started digging up with WCF but I'm conserned that I won't be able to use the HttpContext collection that I've been used to do with web services one important thing which is to generate a random value from HttpContext.Current.Request.ServerVariables["ALL_HTTP"] that I need to reckon if it's the same or at least near what machine that is calling my service. How can I overcome this problem?

I need to know what machine is calling to count the number of attempts to login into my system for example. So must do it inside of the svc code otherwise if I let the client inform what ip address or what computer he is using, anyone could forge this argument and surpass by another machine. May be I'm approaching this matter wrongly. And I should count the number of attempts per state session, but how is it done?

View 1 Replies

Configuration :: Deploying Web Applications With Sub Web Applications?

Apr 22, 2010

Our corporate intranet is designed so that each web application is a child application in the primary application.. Everything has worked fine with Visual Studio 2008 and even in 2010 running the website locally works great, the output directory for the child apps is ..in and the ProjectName.dll copies to that directory.. When I do a publish however it does not and I have to manually copy the dll from the bin folder in the project folder to the parent bin folder, this isn't hard of course but more of a pain in the butt each time I need to publish something. I made sure the output directory is correct for both debug and release yet on publish is just copies it to the child bin and not the parent bin as needed.

View 2 Replies

Deleting Row Of Gridview

May 30, 2010

how can I delete a row of a gridview that has a command field Delete? how can I update a specific cell of a gridview.

View 1 Replies

MVC :: Deleting Record

Mar 24, 2010

I've followed a blog here on removing a record. this is what I have. everything works except the page doesn't refresh after delete has been called as if it's doing it in AJAX. I only see the change when i do a manual page refresh. [URL]

Master Page Head section

<head runat="server">
<title><asp:ContentPlaceHolder ID="TitleContent" runat="server" /></title>
<link href="../../Content/Site.css" rel="stylesheet" type="text/css" />
<script src="../../Scripts/jquery-1.3.2.js" type="text/javascript"></script>
</head>

Index View:

<% foreach (var item in Model) { %>
<tr>
<d>
<%= Html.ActionLink("Edit", "Edit", new { id = item.LogId })%> |
<%= Html.ActionLink("Details", "Details", new { id=item.LogId })%> |
<a href="/Log/Delete/<%= item.LogId %>" onclick="$.post(this.href); return false;">Delete</a>
</td>
<td>
<%= Html.Encode(item.CampaignId) %>
</td>

Controller:
//DELETE
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Delete(int id)
{
try
{
_repository.Remove(id);
return RedirectToAction("Index");
}
catch
{
return View();
}
}

View 4 Replies

C# - Deleting Row Method On GridView?

May 7, 2010

I am trying to implement the deleting method and pass my parameters for the delete operation. I am using sqldatasource. Since the ID doesnt have a column in my gridview how can I get the value of the ID and set it as my delete parameter?

View 2 Replies

SqlCacheDependency Not Deleting What Is In Cache

Feb 2, 2011

I am using sqlCacheDependency, and usually upon any changes in the database cache items get deleted automatically. In my case everything works allright, but I had to buy a new laptop and I moved the same exact database and the same exact webapplication to the new laptop. Unfortunately, on my new machine the cache items remain in cache upon data updates on the database.

I have enabled servicebroker on the database, and started it in the application_start event in my webapplication. I also ran the following:

GRANT SUBSCRIBE QUERY NOTIFICATIONS
TO "Naji-pcNaji"

The differance I see on my laptop from my other machine is that the database is named (local). Naji-pc is the name of my machine.

View 1 Replies

C# - Deleting Items From Datagrid (xml)?

Dec 25, 2010

I have a datagrid buttoncolumn which acts as delete buttons for my xml nodes. The elements are simply displayed in a boundcolumn, so there names get displayed.

Each item generated gets a unique id (each time one is made id+++). My question his how can i remove a item (the entire element node with that certain id) when i click on one of the buttons in the bound column?

[Code]....

View 1 Replies

Deleting A File On The Server?

May 6, 2010

I'm trying to delete a file on the server

Try
delete("D:/xx/xx/xx.xx.uk/xxxx/documents/" & Request.QueryString("id"))
Catch ex As Exception
success.Visible = True
success.Text = "Upload Failure ERROR: " & ex.Message.ToString()
End Try

I get the error:

BC30451: Name 'delete' is not declared.

View 1 Replies

MVC :: Deleting Parent And Its Childs?

Dec 31, 2010

I have 3 Tables Order, OrderDetails, Item and Order is A parent and Oreder Details is The Child i want when I Select any Order and Delete it to Delete all Its OrderDetials Childs So Could Any One Tell Me what is The Delete Code i will Write in Delete Get and Delete Post Function and How can I Handle That

View 3 Replies

MVC :: Appear Confirmation Message Before Deleting?

Dec 27, 2010

How Can I appear Confirmation Message Before Deleting in ASP .NET MVC Page

View 3 Replies

Deleting History Pages In .net?

Oct 21, 2010

How to delete the history pages in ASP.net?In my application when the user logs out, i delete the session variables and expire the cookie(aspxauth and asp_net_sessionId) but however when user clicks on the back button of the browser, user could still see the pages with all the user information on it. However the page cannot interact the server as sessions are not available but expired pages contain demographic information which is an harmful scenario for Security issues.

View 3 Replies

Deleting Files From ArrayList In C#?

Dec 3, 2010

I have an Array List to save selected files and a ListBox to display only the name of the files..my requirement is to delete corresponding files from arraylist when its deleted from listbox...here is my code:

public ArrayList to_compress = new ArrayList();
ListBox pack_lbx=new ListBox();
private void add_btn_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();

[Code]....

View 5 Replies

Deleting Entity With Child Relationships

Apr 10, 2010

EF is so frustrating. I can't seem to be able to get my head around what I need to do so I can delete an object. I seem to be able to remove the object but not the related child objects. Can anyone tell me what is the rule of thumb when you want to delete all related child objects of a given object? I've tried loading all related objects like this:

Entry entry = ModelContext.GetObjectByKey(new EntityKey("ModelContainer.EntrySet", "Id", id)) as Entry;
entry.ChildEnteries.Load();
if (entry != null)
{
ModelContext.DeleteObject(entry);
ModelContext.SaveChanges();
}

I get errors related to the relationships: A relationship is being added or deleted from an AssociationSet 'EntryEntry'. With cardinality constraints, a corresponding 'Entry1' must also be added or deleted. Why can't I just load the object using modelcontext.GetObjectByKey and remove it along with its child objects? My other question is can I delete an object using Entity command like so? DELETE e from objectset as e where e.id = 1 I've tried few variations and all of them throw exceptions.

View 1 Replies

How To Update Entity Objects Without Deleting

Sep 20, 2010

I have an entity generated from my database that contains one table. When i make changes in the DB i obviously would like these changes to reflected in my model.

My current approach is to delete the item from the designer and then right-click - update model from database. This works for me at the moment. Is there a different approach to refreshing these entity tables ?

View 1 Replies

Web Forms :: Deleting Image From Directory?

Oct 6, 2010

Deleting image from directory?

View 3 Replies

C# - Web Application Restarts When Deleting Directory?

Jun 30, 2010

I have some code in my logout routine that deletes some temporary session files when the user logs out or when the session expires. Deleting these folders causes my web app to restart. It does not error out or throws an exception it just restarts!

View 1 Replies

C# - When Deleting The 11th Row The Grid Become Blank?

Nov 15, 2010

I have one telerik rad grid.Using a method i am filling the grid.I have enabled paging property.I have used itemtemplate-->ImageButton for delete and edit options.I have set page size as 10.Page load time it is working properly and populating the grid.After inserting 11 th row the pagination starts and it will show in next page with one record.But when i am deleting the 11th row the grid become blank.I have used dataset to bind the records.

[code].....

View 1 Replies

C# - Deleting Entire Xml Node With Datagrid?

Dec 25, 2010

I have the following xml structure:

<systemtest>
<test id="0">
<name>Test One</name>
</test>
<test id="1">
<name>Test Two</name>
</test>
</systemtest>

The name gets displayed in the 1ste colum of the datagrid, where in the 2nd colum there is a buttoncolumn with delete button.

How exactly can i use xpath and navigate to the current node lets say with test id="0" and delete it (including name)?

Its unclear how i can say to this method what row he has to delete exactly.

[Code]...

This does delete the first item, but offcourse crashes on the second. How an i make this into something variable that is bound depending on what button i press in my datagrid?

View 1 Replies

MVC3 Deleting A Record Using A Sub-form

Feb 1, 2011

I am trying to delete a record being displayed in a table on my ManageUser view using a sub-form, thus

<table cellpadding="2" cellspacing="0" border="1" summary="User Grid" style="text-align: left">
<tr style="background-color: #ABC3CB;">
<th align="center">User Name</th>
<th align="center">Approved</th>.....

but instead, it is returning directly to the Admin/ManagerUser view, thus displaying my original set of records again.

View 1 Replies

Cleanup Function Deleting Files?

Feb 10, 2011

I created a file cleanup function by using health monitoring. It is deleting file that is no access from another process. So, I want to check this. Is it stay access. If not access, I delete this file. How can I do?

View 1 Replies

Keep Visual Studio From Deleting Everything From Bin/ On Rebuild?

Feb 1, 2010

I have a web application project. I have DLLs that I reference in the project stored in my bin/ folder. Well, whenever I do a rebuild or clean from Visual Studio, it will delete everything in that folder. How do I prevent this from happening?

View 3 Replies

Web Forms :: Deleting The Files Automatically?

Jan 30, 2010

In my application i am saving the worddocuments in a folder,I should delete all the prev date files.can i do it automatically? and i am not using any database for the application

View 21 Replies

Confirm Box For Deleting Multiple Records?

Apr 18, 2010

I have a page that is used to delete multiple records....i tried attaching a confirm extender

to the delete button....but it the problem is when i click Ok on the confirm button UI...it deletes

only one record even if i have selected multiple records for deletion

View 8 Replies







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