Dear Users,

i am trying to delete multiple records in a datagrid, at once. How is this done, please look at the code I have which deletes one record at a time....Only the record that is currently highlight, is deleted, can I highlight mulitple rows and delete all of them at the same time?

Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
        Dim IRow As Integer
        Dim TRow As Integer
        Dim LRow As String
        Dim MyRow As DataRow
        Dim NTID As String
        ProgressBar1.Visible = False
        NTID = txtNTID.Text


        IRow = dgdResults.Item(dgdResults.CurrentCell)
        TRow = dgdResults.CurrentCell.RowNumber

        Dim strSQL As String = "SELECT [ID],[ItemName], [StartDate], [EndDate], [StartTime], [StopTime], [NTID] From (Requests)"
        strSQL = strSQL & " Where(([NTID]='" & NTID & "'));"
        Dim adodbConnection As New ADODB.Connection()

        adodbConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\DATA\ACCESS\13FloorEquipment.mdb;"

        adodbConnection.Open()

        Dim rs As ADODB.Recordset = New ADODB.Recordset()
        Dim adoRS As Recordset = New Recordset()
        adoRS.Open(strSQL, adodbConnection, CursorTypeEnum.adOpenForwardOnly, LockTypeEnum.adLockOptimistic, 0)
        'adoRS.Open(strSQL, adodbConnection, CursorTypeEnum.adOpenKeyset, LockTypeEnum.adLockBatchOptimistic, 0)

        If adoRS.EOF Then
            MsgBox("There are no records")
        Else
            If adoRS.RecordCount <> 0 Then
                adoRS.MoveFirst()
            End If
        End If
        Do Until adoRS.EOF
            If adoRS.Fields("ID").Value = IRow Then
                adoRS.Delete()
                GoTo Quit
            Else
                adoRS.MoveNext()
                ProgressBar1.PerformStep()
            End If
        Loop
Quit:
        MsgBox("Record is Deleted")
        adoRS.Close()

Hi there,

I think the question has been asked before, but you never answered it: Why on earth are you using ADO and other Legacy code? Goto was banned 5 years ago ;) IMO, by coding this way, you're not using .NET to the fullest. In fact, you may even make it harder on your self than strictly necessary.

Anyway, there are a few ways to select rows in a grid and then check which rows are selected. One way is to use the Select method of the Grid. Pass it an index of the row you want to select, to select that row.

Then you can use IsSelected(rowIndex) to determine which rows are selected. Loop through all the rows in the Grid and see whether they are selected or not.

I am sure there are better ways (I am not really into the DataGrid for Windows forms), but this should at least work.

However, before you continue, I would strongly advice to "upgrade" your code to .NET. Programming classic VB and ADO in .NET is going to get you into real problems soon......

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Dear Programmers,

One reason for me using ADO.net, is due to the fact the Database is on my company network, and is not on an SQL server..... Should that make a difference

You're not using ADO.NET, you're using "classic" ADO. ADO.NET is completely different from ADO. Instead of creating a Recordset, you would create a DataSet or an OleDbDataReader to access your Access database in .NET.

Take a look here: http://msdn.microsoft.com/library/de...ClassTopic.asp for more info about the DataReader and here: http://msdn.microsoft.com/library/de...ClassTopic.asp for more info about the DataSet.

I suggest you Google a bit for ADO.NET, DataSet and Tutorial. There are tons of sites out on the Web that'll teach you how to code stuff like this in "proper" .NET.

And thanks for your personal message. Would you mind posting your queries here instead of directly sending them to me? Makes things a lot easier....

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

hi i want to know how i can add four records of database
table in one row of datagrid.and each record have more than one fields in database

Imar, If i select multiple row in the datagrid and then i sort the Grid,and then i wanna to delete all the selected record,But when i click on the delete button then when i loop the grid and check the IsSeleted and then delete the row then it delete only one record,
Can you suggest me this is the bug with the DataGrid.

Hi sachinmahajan,

Can you please start a new thread when you have a different topic? That makes things much easier to track.

That said, I don't believe the behavior is being caused by a bug in the datagrid. Maybe it's caused by a misunderstanding of how the DataGrid works, or maybe something else is wrong.

I don't fully understand the situation (why would you sort the data after you have checked some items and are about to delete them), so can you:

a) Start a new thread for this topic (just click the New Topic link)

and

b) describe your situation in more detail. Posting the relevant parts of your code surely helps explaining the problem.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Sour Times by Portishead (Track 2 from the album: Dummy) What's This?