how to delete selected items from datalist using stored procedure?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

ASP.NET

, +

hi how to delete selected items from datalist using stored procedure...???
can any one help???

Posted 26-Dec-11 18:35pm

ythisbug

Add a Solution

4 solutions

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)

Varun Sareen · Answer 1 · 2011-12-26T18:38:00

Solution 1

Dear Fahad,

Once you have selected all the Items from the datalist then try to apply a for loop OR foreach loop on it fetch all the Id's of the item being selected from the list and write a stored procedure for deleting the particular record by sending the id of the item selected into the SQL Proc as Parameter.

hope you understood.

thanks

Posted 26-Dec-11 18:38pm

Varun Sareen

Comments

ythisbug 27-Dec-11 0:42am

thanks buddy...can u give me the code or website address..??

Varun Sareen 27-Dec-11 1:12am

Dear fahad,

Please refer to the answer given by Manish.

thanks

Sarvesh Kumar Gupta · Answer 2 · 2011-12-26T19:06:00

Use same as below code

C#

foreach (RepeaterItem rept in rptbom.Items)
    {
      CheckBox chkSelect = (CheckBox)rept.FindControl("chkSelect");
      Int64 fg_id = Convert.ToInt64(((HiddenField)rept.FindControl("hdnfg_id")).Value);
      if (chkSelect.Checked == true)
      {
        //Delete Procedure working here
      }
    }

It is for repeater same is for gridview
foreach (GridviewRow grd in grdDetail.Rows)
{
CheckBox chkSelect = (CheckBox)grd.FindControl("chkSelect");

Now Change your code same as above.

if you have any problem then you can contact with me.

Manish.Insan · Answer 3 · 2011-12-26T19:07:00

use check box to select multiple rows and after that when you will click on delete button. check using condition which rows are selected and write this in loop for check multiple rows.

C#

protected void DeleteAll_Click(object sender, System.EventArgs e)
{
   bool isDeleted;

   // Check each box and see if the item should be deleted.
   foreach (DataListItem anItem in DataList1.Items)
   {
      isDeleted =
         ((CheckBox)anItem.FindControl("Delete")).Checked;
      if (isDeleted)
      {
         // Add code here to delete the item, using anItem.ItemIndex.
      }
   }
   DataList1.DataBind();
}

for more in detail :
http://msdn.microsoft.com/en-us/library/b7y72882%28v=vs.71%29.aspx[^]
Hope this will help you.
And don't forget to mark as answer if it helps. :)

chetan virkar · Answer 4 · 2011-12-26T19:10:00

Solution 4

Check This Link

http://www.expertrating.com/courseware/DotNetCourse/DotNet-ASP.Net-6-1.asp

hope this will help u.

Posted 26-Dec-11 19:10pm

chetan virkar

how to delete selected items from datalist using stored procedure?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0