Help with Delete in DataTable and DataGrid

[J]

Hi,

Can someone please help with a problem I have. The BOL I think are useless
in explaining what I want to do.

I have a datagrid, that is bound to a dataview. I have a checkbox as a
template column and a button marked 'delete'.

What I want to do, is be able to select a series of rows from the datagrid,
using the checkboxes, and delete them from the table when I click the delete
button.

I 'think' I'm right in my understanding that I have to create a primary key
on the datatable, and search using this key, then mark the row that is found
for deletion.

Trouble is, the BOL point to examples of if I was to use the default
'Select' command that is bound to the datagrid, and not using template
controls. So I can't see what datakey(s) are selected when I select them
using the checkboxes.

At present, my code is...

(To bind the data to the grid)

SqlConnection1. Open()

sqlRetrieveDist ributionListMem bers.Parameters ("@distID").Val ue = distID

sqlRetrieveDist ributionListMem bers.Parameters ("@distListID") .Value =
distListID

daDistList.Sele ctCommand = sqlRetrieveDist ributionListMem bers

daDistList.Fill (dsDistList, "Members")

dvMembers = New DataView(dsDist List.Tables("Me mbers"), "", "",
DataViewRowStat e.CurrentRows)

Datagrid2.DataS ource = dvMembers

Datagrid2.DataK eyField = "distID"

Datagrid2.DataB ind()

SqlConnection1. Close()

To delete the data from the grid....

Dim dgi As DataGridItem

Dim cb As CheckBox

Dim i As Integer = 0

Dim rowID As Integer

Dim dr As DataRow

For Each dgi In Datagrid2.Items

cb = CType(dgi.Cells (0).Controls(1) , CheckBox)

If cb.Checked = True Then

Response.Write( Datagrid2.DataK eys(0)

End If

Next

Any help would be really appreciated.

TIA

[Prasad]

Use

For Each dgi In Datagrid2.Items

cb = CType(dgi.Cells (0).Controls(1) , CheckBox)

If cb.Checked = True Then

Respones.Write( DataGrid2.DataK eys(dgi.ItemInd ex) '
Response.Write( Datagrid2.DataK eys(0) See dgiItemIndex instead of 0 you used.

End If
HTH
Prasad

"J" <nospam> wrote in message news:#D******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

Can someone please help with a problem I have. The BOL I think are useless in explaining what I want to do.

I have a datagrid, that is bound to a dataview. I have a checkbox as a
template column and a button marked 'delete'.

What I want to do, is be able to select a series of rows from the datagrid, using the checkboxes, and delete them from the table when I click the delete button.

I 'think' I'm right in my understanding that I have to create a primary key on the datatable, and search using this key, then mark the row that is found for deletion.

Trouble is, the BOL point to examples of if I was to use the default
'Select' command that is bound to the datagrid, and not using template
controls. So I can't see what datakey(s) are selected when I select them
using the checkboxes.

At present, my code is...

(To bind the data to the grid)

SqlConnection1. Open()

sqlRetrieveDist ributionListMem bers.Parameters ("@distID").Val ue = distID

sqlRetrieveDist ributionListMem bers.Parameters ("@distListID") .Value =
distListID

daDistList.Sele ctCommand = sqlRetrieveDist ributionListMem bers

daDistList.Fill (dsDistList, "Members")

dvMembers = New DataView(dsDist List.Tables("Me mbers"), "", "",
DataViewRowStat e.CurrentRows)

Datagrid2.DataS ource = dvMembers

Datagrid2.DataK eyField = "distID"

Datagrid2.DataB ind()

SqlConnection1. Close()

To delete the data from the grid....

Dim dgi As DataGridItem

Dim cb As CheckBox

Dim i As Integer = 0

Dim rowID As Integer

Dim dr As DataRow

For Each dgi In Datagrid2.Items

cb = CType(dgi.Cells (0).Controls(1) , CheckBox)

If cb.Checked = True Then

Response.Write( Datagrid2.DataK eys(0)

End If

Next

Any help would be really appreciated.

TIA