VB.NET developed ASP.NET, CheckBox in DataGrid selected and deleted

jin1120

I did it. But how to delete it? Who can teach the younger brother. . Anxious to do course design!
The selected code is as follows
            Dim i As Integer
            Dim ChBox As CheckBox
            For i = 0 To DataGrid1.Items.Count-1
                ChBox = CType (DataGrid1.Items (i) .Cells (0) .FindControl ("CheckBox1"), CheckBox)
                ChBox.Checked = True
            Next

13816305157

delete from [table] where id = ChBox

jin1120

Still not working ... I'm depressed

saintfrosty

If you want to delete, what else is it selected for?

Don't you know how to operate the database or what? What is the problem?

jin1120

I want to select all items. . Then there is a delete button to delete all selected items

codealxe

if you retrive your data from database and store it in dataset

---- get the selectedID, note that the following code only change the data
     in your dataset rather than database
form each row in dataset.table ( "table"). rows
  if row.item ( "id") = selectedID
  row.delete
end if
next

--------- when you click the "submit" botton

dim rowafftected as integer

rowaffected = dataadapter.update (dataset ', "yourTable")

awrtyy

public void DelBalanceWayItem (DataGrid dg, string ControlID)
{
foreach (DataGridItem item in dg.Items)
{
CheckBox cb = (CheckBox) item.FindControl (ControlID);
if (cb.Checked)
{
string str = "Update Base_BalanceWay set Status = '1' where ID = '" + dg.DataKeys [item.ItemIndex] .ToString () + "'";
Common.DataBase.DB db = new Common.DataBase.DB ();
db.Execute (str, null, false);
}
}
}
This code may help you

ybbyd1018

For i = 0 To Me.DataGrid1.Items.Count-1
            Dim ck As CheckBox

            ck = CType (DataGrid1.Items (i) .Cells (0) .FindControl ("CheckBox_delete"), CheckBox)
            If ck.Checked = True Then


                Dim cmd As SqlCommand
                Dim p1 As SqlParameter



                cmd = New SqlCommand ("Article_Delete", conn)
                cmd.CommandType = CommandType.StoredProcedure

                p1 = cmd.Parameters.Add ("@ ArticleId", SqlDbType.Int)
                p1.Value = DataGrid1.Items (i) .Cells (6) .Text

                cmd.ExecuteNonQuery ()

 
   



            End If
        Next