Click here to Skip to main content
15,894,720 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello friends,
I am learning how to update dataset to the database. But while executing following code I am facing following error, please help. Thanks in advance.

Code :
VB
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
        '
        ' Control Validation
        '
        changeState(True)
        inputEnabled(False)

        Dim dr As DataRow

        dr = ds.Tables(0).NewRow()
        dr(0) = txtRollNo.Text
        dr(1) = txtName.Text
        dr(2) = txtClass.Text

        ds.Tables(0).Rows.Add(dr)

        build = New SqlCommandBuilder(ada)

        ada.Update(ds) 'Error causes line'

    End Sub


Error :

Dynamic SQL generation is not supported against a SelectCommand that does not return
any base table information.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900