how to calculate delete records and delete after enter value in textbox

Question

0.00/5 (No votes)

See more:

i want to calculate total deleted records and delete particular record, like if user enter 'raj' in text box and after submitting a button page will transfer to another page and some information should be show on page that is total number of 'Raj' deleted and delete 'Raj' from a table. pls tell me how to do this problem with sql database...

Posted 8-Feb-13 7:15am

chander_rani

Add a Solution

Comments

Hasham Ahmad 8-Feb-13 13:27pm

nothing to be done, just select the count before deleting and display it on the other page

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jibesh · Answer 1 · 2013-02-08T07:51:00

Solution 1

If you are using SQL ExecuteNonQuery [^] command to delete, the method returns how many rows affected for the last executed command.

if its a delete statement the return value is the how many rows deleted.

Posted 8-Feb-13 7:51am

Jibesh

Comments

[no name] 8-Feb-13 14:06pm

i need it in asp.net c#, i require total deleted records which have to show on page in lable, and the raj records should be delete from table

Jibesh 8-Feb-13 14:14pm

can you explain the relation between the table. since you didnt show any code and you did not explain well I can only provide hints about your problem.

If you know how to execute the sql statement you would know how to get the record number.
as explained above, Construct a delete query using the textInput eg:

delete from table where field_name like'%inputtext'; this is pseudo code only

[no name] 8-Feb-13 14:25pm

sir i can delete the records from table but i want to know that how to show total number of record deleted from a table, and one more thing i want to know that only single query can delete and calculate total deleted records from a table but how, and which query. pls tell me.

Jibesh 8-Feb-13 14:31pm

have wrote any code for this delete operation? if yes can you paste it here. or check the sample below

string myExecuteQuery ="delete from your_tableName where yourfieldName='%inoput";

SqlCommand myCommand = new SqlCommand(myExecuteQuery, myConnection);
myCommand.Connection.Open();
int count = myCommand.ExecuteNonQuery();
myConnection.Close();

variable count holds the number of records deleted for the above delete query. give a try and tell me the answer.you can use this count to display total number records deleted