0
Sub loadtodgv()
        Dim sqlquery As String = "select * from nursery"
        Dim sqlcommand As New OleDbCommand
        Dim sqladapter As New OleDbDataAdapter
        Dim table As New DataTable
        With sqlcommand
            .CommandText = sqlquery
            .Connection = conn
            .ExecuteNonQuery()

        End With
        With sqladapter
            .SelectCommand = sqlcommand
            .Fill(table)

        End With
        DataGridView1.Rows.Clear()

        For i = 0 To table.Rows.Count - 1
            With DataGridView1
                .Rows.Add(table.Rows(i)("regno"), table.Rows(i)("rollno"), table.Rows(i)("nepali(writing)"), table.Rows(i)("nepali(oral)"), table.Rows(i)("maths(writing1)"), table.Rows(i)("maths(oral)"), table.Rows(i)("maths(writing2)"), table.Rows(i)("english(writing)"), table.Rows(i)("english(oral)"), table.Rows(i)("physical_edu(oral)"), table.Rows(i)("creative(oral)"))
            End With
        Next
    End Sub

    Private Sub btndel_nursery_Click(sender As Object, e As EventArgs) Handles btndel_nursery.Click
        For i = 0 To DataGridView1.Rows.Count - 1
            Dim deleterows As String = DataGridView1.SelectedRows(i).Cells(0).Value.ToString
            Dim sqlquery As String = "delete from nursery where regno=" & deleterows & ""
            Dim sqlcommand As New OleDbCommand
            With sqlcommand
                .CommandText = sqlquery
                .Connection = conn
                .ExecuteNonQuery()

            End With
        Next
        loadtodgv()
    End Sub
End Class
3
Contributors
6
Replies
26
Views
4 Years
Discussion Span
Last Post by sushilsth
0

why these error comes to my code. plz help..
.executenonquery() ' no value given for one or more parameter

0

It didnot worked after putting .executereader... same error occurs

1

Can't you get any information in debugmode? What parameter is missing? Try to find an ADO.Net example, read some ADO.Net documentation; maybe you can find some clues for use. The way you use it, is somewhat compact. Usually it is spread over some layers of code. Good luck

0

In line 28, why use SelectedRows property? Perhaps after a time, there is no selectedrow, therefore giving no value to the regno parameter?

0

thanx scudzilla for response.. its because i want to delete selected rows from datagrid.. if its not correct plz provide me correct code..

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.