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 Repliesi have a table as child_id,parent_id,child_name,level i want to select all child(leaf nodes) with no further child for a particular parent in table.
[Code]....
I want to remove parent control (which is span in this case) without deleting its children controls from container. how can I accomplish this in asp.net c#?
you can see the code here: http://pastebin.com/9NiriWXN
Note: I can easily find the "newsright" control and return its parent (which is span in this case)
I have a MVC project wich uses LINQ to SQL as a data layer.
For example, I have a tables ProductGroups and Products. Product is a child of ProductGroup, so to get name of ProductGroup, in aspx-page I use constuction like Model.ProductGroup.Name.
But when I delete a ProductGroup there is appear a NullReference Exception in presentation page.
While I was using just DataSet and manual SQL-queries, the rows, there was not every joined-element present, simple were not put in query result.
I know that before delete Parent row I have to delete all children rows, it's correct way.
1. Is there a way to ignore rows which has null-elements without manual checking through "IF"?
2. Is there simple way to delete all dependencies without manual enumerating every related tables?
I have the next aspx page.
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true"
CodeBehind="newsEditor.aspx.cs" Inherits="ExpertSiteV2.newsEditor" %>[code]....
In some situation i want to delete all the contents of Panel1. I write in the code:
Panel1.Controls.Clear();
But it doesn't work and i get message: Page cannot be null. Please ensure that this operation is being performed in the context of an ASP.NET request.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Page cannot be null. Please ensure that this operation is being performed in
the context of an ASP.NET request.
Source Error:An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: [InvalidOperationException: Page cannot be null. Please ensure that this operation is being performed in the context of an ASP.NET request.]
System.Web.UI.ScriptManager.get_IPage()
+373832 System.Web.UI.ScriptManager.OnPagePreRenderComplete(Object
sender, EventArgs e) +54
System.Web.UI.Page.OnPreRenderComplete(EventArgs
e) +8698462
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint) +1029
Blockquote
What's wrong? Or how should i do this properly?
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();
}
}
I am working on my first project with Linq to Sql entities/winforms, and I have little problems updating the entities childs in the main form, when I come back from the entity editor....
I have a list of people, and I can edit them or add new. The edited or new person opens in a new form and can have many addresses that can be added modified from the person editor and it opens a third form...
when I have finished edit the new address, so i return to the person editor and add the address, within the person entity context... so person.address.add(newAddress)...
Then I update the list of addresses, referencing: Datasource= foreach(address adr in person.addresses).And when I have finished editing the person i return to the mainform and save the changes from that entity.
_datacontext.save()
The problems I have are that if there is a new person, and I don't add addresses, the person saves without problem. But It doesn't do it if I add any address. With the updates I haven't any problem, they updates all, adds new addresses, but I can't remove anything with the person.addresses.remove(address)...
Using asp.net C#. I have BulletList, and I would like to add ListItem that will render with childs.
That is, inside every <li> I can add more controls to be rendered.
how to maintain background color when mouse click any one of th child in asp.net treeview
View 1 RepliesI have a table of products on my page, each product has zero or more colors, the colors are shown as a list beneath the product. After the colors I have a button to add a color. The button will do an ajax call with the parent product id to a controller which will return a JSON object with color information. My problem is where to store the product id in the DOM, should I put it in a hidden field and use jquery in the click event of the "add color" to get to it? What is the best way to do this?
EDIT: The page is initially rendered on the server so I don't want to use jquery to add the id's to the page.
i have the following code:
[Code]....
3 nested dropdownlists SELECTing from DB. So i select the brand, then i select the model and then i select the product and click on SEARCH button.
But when i select thebrand, and then the model, and if i want to change the brand, it does not reset the second and third dropdownlists.
I want to sum my nested gridview column totals in parent grid's footer.
View 4 RepliesIn my website I have two forms: parent form and child form(dialog box). Their expected behaviour is like this: if clicked on 'show' button on parent form, a dialog form opens that displays a gridview. In dialog form, if clicked on 'select' button it closes
itself and returns value in selected row back to parent form.
To achieve this I write following code (.cs) : in parent form:
void ShowBtn_Click(object sender, EventArgs e)
{
StringBuilder jScript = new StringBuilder(); [code]....
Now problem is: the code in parent .cs works fine, it opens the dialog properly. But when clicked on 'select', instead of returning back to parent, it opens the same dialog again in new window. This newly open window says "Done but error on page" at left bottom.
Simple and blunt: my cascading dropdownlists clear when a postback occurs. Does anyone know a quick way around that?For more information, read on...
I have 5 dropdown lists that define a training class location and line of business: Site, Parent Client, Client, Program, Project I'm trying to build cascading dropdownlists that can work from any direction (i.e. select a site and all other lists are filtered by site...select a project and all other dropdown lists are filtered by project). I've built the SQL Select statement behind the lists that filters (accurately).
i have opend a popup window using C#.And in pop up window i have a button,clicking that button it should redirect to another page.Here i need to close the popup window and redirect to a page..Right now redirected page is opened in popup window..but it should be opened in parent window .
View 3 Replieshow 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 RepliesAfter 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 RepliesI'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();
}
}
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 RepliesI 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.
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]....
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.
How Can I appear Confirmation Message Before Deleting in ASP .NET MVC Page
View 3 RepliesHow 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 RepliesI 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]....