Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL
how to delete from database using Repeater that has checkboxes when checkbox is selected and button is fired, then i want to delete from the database
 
I have tryed like this , but dont get it to work
 
protected void ButtonDeleteAttachments_Click(object sender, EventArgs e)
        {
            var db = new knowitCVdbEntities();
            SPWeb theSite = SPControl.GetContextWeb(Context);
            SPUser theUser = theSite.CurrentUser;
            string strUserName = theUser.LoginName;
 
            var theEmpDocumentRem = (
                                        from p
                                            in db.EMPLOYEES
                                        where p.username == strUserName
                                        select p).FirstOrDefault();
 
            _emp = theEmpDocumentRem;
 
            if (_emp != null)
            {
 
                int docId = Convert.ToInt32(LabelDocumentID.Text);
 
                var documentList = (from p in db.EMPLOYEE_DOCUMENT
                                    where p.employee_id == _emp.employee_id && p.document_id== docId
                                    select p).ToList();
 
                foreach (var doclist in documentList)
                {
 
                    db.DeleteObject(doclist);
                    db.SaveChanges();
 

                }
 
                foreach (var docItems in RepeaterDocument.Items)
                {
                    if(_chk.Checked)
                    {
                        db.DeleteObject(docItems);
                    }
                    
                }
 
            }
Posted 9-Apr-13 8:34am
Kurac1747
Comments
Mike Meinz at 9-Apr-13 13:43pm
   
What doesn't work? Have you stepped through the code using the Visual Studio interactive debugger? Where in the code is it failing and how is it failing? What is the error message and which line in your code threw the error?
Kurac1 at 9-Apr-13 14:23pm
   
Because i need to loop true the database first in the foreach like u se, but i dont select what i want to delete i want to delete from checkbox.Checked. That i am trying to do in the other foreach but i dont now to connect two loops.

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

  Print Answers RSS
0 OriginalGriff 350
1 Jochen Arndt 190
2 Richard MacCutchan 135
3 Sergey Alexandrovich Kryukov 130
4 DamithSL 95
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,310


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 9 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100