I'm getting the following error:
Not sure why, since I'm trying to close the connection right when I'm done, and the timeout is set to "30".
Select Case DBselected
Case "DB8"
Try
Dim sCon1 As New SqlConnection...
Step 1: In my datagrid, if I click on the only row on the second page, it takes me to the first record on the first page.
Step 2: If I add a second row to the second page, then click "Edit" on the top / first record on the second page, I can now edit that record that I couldn't edit in Step...
When I call the following:
OleDbDataAdapter1.Update(DsGridDeliverables1)
I get a Syntax error in the Update query.
Here's the update query:
"UPDATE WP WP_P_I = ?, P3 = ?, [DDesc] = ?, [Date] = ? WHERE ([DNumber] = ?) AND ([Date] = ? OR ? IS NULL AND [Date] IS NULL) AND (P3 = ? OR ? IS NULL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.