Thanks to Pandeyism for helping me we these codes
https://www.aspforums.net/Threads/748564/Move-and-delete-multiple-rows-in-database-table-using-EntityFramework-in-ASPNet/?s=2#Replies
But i whant to a a dynamic checkbox to the view and move and delete it based on the checked rows
what am i doing wrong here
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Me.BindGrid()
End If
Dim checkBoxColumn As New DataGridViewCheckBoxColumn()
checkBoxColumn.HeaderText = ""
checkBoxColumn.Width = 30
checkBoxColumn.Name = "check"
DataGridView1.Columns.Insert(0, checkBoxColumn)
DataGridView1.AllowUserToAddRows = False
End Sub
Private Sub BindGrid()
Dim test As TestEntities = New TestEntities()
gvMembsers.DataSource = From m In test.members Select m
gvMembsers.DataBind()
End Sub
Protected Sub btnInsert_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim test As TestEntities = New TestEntities()
Dim isSelected As Boolean = Convert.ToBoolean(row.Cells("check").Value)
Dim memberOldRecord = (From o In test.members Where isSelected = True Select o).ToList()
If isSelected Then
For j As Integer = 0 To memberOldRecord.Count() - 1
Using test1 As TestEntities = New TestEntities()
Dim ol As Oldmember = New Oldmember With {
.name = memberOldRecord(j).name,
.age = memberOldRecord(j).age,
.dob = memberOldRecord(j).dob,
.location = memberOldRecord(j).location
}
test1.AddToOldmembers(ol)
test1.SaveChanges()
End Using
Next
Me.BindGrid()
End if
Using test2 As TestEntities = New TestEntities()
Dim mem = (From c In test2.members Where c.age >= 20 Select c).ToList()
For i As Integer = 0 To mem.Count() - 1
Dim member As member = mem(i)
test2.DeleteObject(member)
test2.SaveChanges()
Next
gvOldmembers.DataSource = mem
gvOldmembers.DataBind()
Me.BindGrid()
End Using
End Sub
will appriciate if the logics is explain please