Deleting multiple records in database at once

Question

0.00/5 (No votes)

See more:

Hello,

Please help me, How to delete multiple records in database with xml as input parameter in c#.

I just need the stored procedure in sql server 2005.

Please help me, its very urgent.

Regards
Nagaraj.J

Posted 13-Apr-14 20:12pm

Member 10454499

Add a Solution

Comments

syed shanu 14-Apr-14 2:19am

From your c# program read all xml data using loop and inside loop call the SP and pass the xml deletetion parameter to delete Delete from your table_name where conditon=@paramaeter

Member 10454499 14-Apr-14 3:05am

Hello Syed, If i call sp inside the loop it will call sp for every id, i think its a big process and takes lot of time, Instead of that i think xml parameter is best

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)

sankarsan parida · Accepted Answer · 2014-04-13T20:36:00

Solution 1

See
Collect you data in a string lit
string IDs="1,5,7"

Pass this IDs to your storeprocedure as a parameter

And write a query like

Delete from your table_name where ID in (@IDs)

See a link which is discussed on this matter

http://forums.asp.net/t/1859005.aspx?Delete+multiple+records+using+SQL+Delete+Query[^]

Posted 13-Apr-14 20:36pm

sankarsan parida

Updated 13-Apr-14 21:09pm

v3

Comments

Member 10454499 14-Apr-14 3:02am

Thank you Sankarsan, i tried with the tip you given, but am getting error converting datatype varchar to bigint, i tired convert that string in bigint in stored procedure but i takes only first value. Please help how to solve this.

[no name] 14-Apr-14 3:09am

See I have given a link in above answer see the topic which will help you

Member 10454499 14-Apr-14 3:24am

Thank you very much sir, It solved my problem.

[no name] 14-Apr-14 3:25am

welcome :)