refreshing a datagrid with new data
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
nSQL = "Insert Into OrderDetail (OrderNo, ProductCode, ProductDesc, Quantity, Price) Values ('" & strOrderNo & "', '" & strCode & "', '" & strDesc & "', " & iQuantity & ", " & iFullPrice & ")" Set RS = Conn.Execute(nSQL) DataGrid2.Refresh What the above code is trying to do is that when a command button is pressed, the values in the textboxes are saved to the OrderDetail table. However, what I also wish to happen is that the datagrid (the datagrid is bound to this OrderDetails table) is updated with this new record. This is not happening - what am i doing wrong? Thanking you in advance!