.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How can i know a row is deleted successfully

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server


I want to delete a row from my Table. How can i know a row is deleted successfully

delete mytable where (id = 8) and (active=0) 

Best Regards. Morteza

View Complete Post

More Related Resource Links

JQGrid Loading deleted values



This is quite strange. here is the issue:

Some Info:

1. I'm using a multi-select jqgrid.

2. I have my own delete button to delete multiple orders

The problem:

When i press the delete button on the pager of my jqgrid, the records are deleted from the database but JqGrid shows some records (4-5). On refreshing the grid, correct numbers of records are shown.

Here is the code:

function delorder() {
        var amg = $("#horder").getGridParam('selarrrow');
        var cont = amg.length;
        if (amg.length > 0) {

ASP.Net account deleted. How to create it again?


 Hi I have created an intranet application using ASP.Net/IIS.

I normally need to web share the folder and allow full permission to ASP.Net user account.

However, I carelessly deleted this account. How to create it again ?

Pls help.... thanks.


how to know when a user finish his file download successfully ?


hi all

i am doing a page to sell files online

 the paying method is by a card or bank account and the customer is not registered to the site so i want to make sure that the customer has downloaded the file successfully after that the system completes the payment operation

so if there is any way to know do that tell me please

i use c# thanx all



Can not perform this operation.The file is no longer checked out or has been deleted?

In my sharepoint designer 2007, when I try to check in a file, it give me the following errors:

Can not perform this operation.The file is no longer checked out or has been deleted.

Please advise me how to fix this problem?


javascript automatically deleted



I m starting to work with Sharepoint 2010 but i have a problem.

I m trying to create a custom home page with animations.

For the moment i m just trying to change my image on my link using javascript (onmouseover="document.getElementById('MD').src='../)

But i don t understand why Sharepoint delete my function when i m saving my page.

What is the way to do it, and why SP2010 doesn't save my page (I had not this problem with SP2007)?



Deleted All the user by mistake



I deleted all the user from the Access list including myself and not able to login....How do i recover those user?

Please answer as quickly as possible.



Sharepoint Site Web Config elements Gets Deleted automatically


see i used to have a security filter settings in web config
security><requestFiltering><requestLimits maxAllowedContentLength="104857600"/></requestFiltering></security>
 but it gets deleted automatically after  i dont know why 
we tried to install something in our server yesterday it didn't worked and reverted it back to yesterdays stage( But i had updated the config files 3 weeks ago) 
but today i check the config files  these elements are  not there.

My system is 64 bit windows server 2008 with IIS 7 and MOSS 2007 SP2

How to Set a list item's createdby or modifiedby field as a User(deleted from AD)



I have to migrate data from SQL DB to SP list. But its old data and some users who created/modified the record has been deleted from the AD. Now I need to set the CreatedBy / ModifiedBy Field of the item accordingly. How to achieve this?

And when I tried to modify the "Editor" and "Author" field through Object Model, it works. But its not working through Webservice. What is the reason behind this?

Please help me find an optimal solution for this...


Thanks and Regards,

/* John JB */

Problem with connection to sql server : A connection was successfully established with the server, b

Hi all, I am trying to connect sql server using windows authentication . I am getting the fallowing when I try to establish a connection to sql server A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) Can any one tell me how to resolve this problem..

Installed .NET Framework 3.5 SP1 and 4.0 successfully but not detected

Good day, I am trying to install a SPSS Analysis of Moment Structures (AMOS) software v18 on my machine. During setup, the installation failed. An error message popped up "The Microsoft.Net Framework Version 3.5 SP1 or later was not found on your machine. This is required for the Amos installation to continue". Please install the Microsoft.NET Framework 1st. I googled and found the link on Microsoft's website, and installed 3.5 SP1 but the same error message appeared. I then tried with .NET Framework 4.0 and  still getting the same error message. I am a Windows XP User. What can I do now? Regards, Chris

A connection was successfully established with the server, but then an error occurred during the pre

One of our IIS App pools serving a SharePoint site on one of the  Web Front End  went down suddenly at around 1pm today. Not entirely sure if  it's related yet or how, but we see a bunch of SQL errors from the Web server around that time as follows..    Event Type:         Error Event Source:     Windows SharePoint Services 3 Event Category:                Database Event ID:              5586 Date:                     8/24/2010 Time:                     12:57:21 AM User:                     N/A Computer:          xxxxx Description: Unknown SQL Exception -2146893056 occured. Additional error information from SQL Server is included below.   A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error

How to Recover accedently Deleted data without restoreing the backup ??

Hi I want to restore data which has been deleted accedently by user without restoring backup of T-Log.  

The multi-part identifier "deleted.DataEncryptionKeyID" could not be bound : trigger

Hello there, I created a trigger and I am trying to only do stuff if my inserted.column_name1 is different from my deleted.column_name1. Here is my code : alter trigger EncryptionKeyUpdate on [BackupJobDefinition] after update AS if deleted.DataEncryptionKeyID != inserted.DataEncryptionKeyID begin     INSERT BackupJobDefinitionLifeTime         select             'Old',             GETDATE(),             system_user,             JobDefinitionID,             DataEncryptionKeyID,             1        from deleted     INSERT BackupJobDefinitionLifeTime         select             'New',             GETDATE(),             system_user,             JobDefinitionID,             DataEncryptionKeyID,             1    

User keeps getting deleted from MOSS site

Hello All, There is one user with contribute rights who keeps getting deleted from a team sub site that is on MOSS 2007. She has weekly reports that she works on and i was told that she doesnt really get on to the site very often except once or twice a week to update the reports. There is only one business owner of the site apart from me and who can modify permissions. So i cannot think of anybody else who has access to mess with user permissions. Has anybody had this issue before ?

Deleted row need to recver

hi in sql server 2005, i have deleted row by mistake and now want to roolback them can one there to help me, i wrote a query is "delete tblmetric" nd pressed F5 now wanna to recover the rows

Cookie is not deleted if another browser remained opened

Cookie is not deleted if another browser remained opened even the current one is closed. I also include the code to get the cookie expired . But it only works properly when user closes all browsers.  How can I resolve it ? Tks.

Cannot successfully install on Win 7 client. SQL errors.

 The installation process failed at the end of a SP2010 Windows 7 single server  install. I  followed all prerequisite steps, including the native sql download. Logs indicated the process could not find SQL or the content database. I cannot verify the sql service is running. I've repeated the sql download and reinstalled Sharepoint, but still get the same problem. I tried to manually run the SP configuration, but same problem.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend