Visual Basic&database, Data Widgets

Data Widgets

Author	Message
Jonath #1 / 4	Data Widgets Using VB6 and ADO. and I have an Infragistics OLEDB Grid mapped to an SQL command in a VB data environment. I add a record to the table but I can't get the grid to reflect the change. I've tried just about everything I can think of. I've re-queried the command, open and closed the query, open and closed the connection, refreshed the grid, changed the cursors to dynamic. Nothing works except stopping the program and starting it again. Then the new record shows up in the grid. There must be a way of doing that without stopping the program. Any ideas? Thanks in advance
Sat, 09 Apr 2005 09:52:40 GMT

Richard T. Edward #2 / 4	Data Widgets Have you called refresh on the gird itself? MoveFirst? MoveLast? If you have then close down the data connection and rest it. hth. Quote: > Using VB6 and ADO. and I have an Infragistics OLEDB Grid mapped to an > SQL command in a VB data environment. I add a record to the table but > I can't get the grid to reflect the change. I've tried just about > everything I can think of. I've re-queried the command, open and > closed the query, open and closed the connection, refreshed the grid, > changed the cursors to dynamic. Nothing works except stopping the > program and starting it again. Then the new record shows up in the > grid. There must be a way of doing that without stopping the program. > Any ideas? > Thanks in advance
Sat, 09 Apr 2005 11:08:51 GMT

Jonath #3 / 4	Data Widgets Tried both those things. I closed the connection, then opened it, then did a rebind on the OLEDB grid. The grid still does not reflect the change to the database. Quote: > Have you called refresh on the gird itself? MoveFirst? MoveLast? > If you have then close down the data connection and rest it. > hth. > > Using VB6 and ADO. and I have an Infragistics OLEDB Grid mapped to an > > SQL command in a VB data environment. I add a record to the table but > > I can't get the grid to reflect the change. I've tried just about > > everything I can think of. I've re-queried the command, open and > > closed the query, open and closed the connection, refreshed the grid, > > changed the cursors to dynamic. Nothing works except stopping the > > program and starting it again. Then the new record shows up in the > > grid. There must be a way of doing that without stopping the program. > > Any ideas? > > Thanks in advance
Sun, 10 Apr 2005 04:35:59 GMT

Axela #4 / 4	Data Widgets I am facing the same problem, too. After I alter the connection string and re-open the ADO connection, all Data Widget Controls do not work! I have check the bounded recordset of them but they just don't open though I have re-assign the data source and member and refresh them, etc -- Posted via http://dbforums.com
Tue, 12 Jul 2005 10:30:25 GMT

Page 1 of 1

[ 4 post ]