Data Grids
-
I would like to have a datagrid that automatically 'Refreshes' the dataset every time a new record is entered into the sql database. When I run the update on the dataset, fill the datagrid and use the expand statement, it does not fill out the rows. Any help / suggestions to achieving this is appreciated. Thanks! Bob Gronenthal
-
I would like to have a datagrid that automatically 'Refreshes' the dataset every time a new record is entered into the sql database. When I run the update on the dataset, fill the datagrid and use the expand statement, it does not fill out the rows. Any help / suggestions to achieving this is appreciated. Thanks! Bob Gronenthal
Can you show us your code piece ? ----------------------------------------------------------- "I think there is a world market for maybe 5 computers" Thomas Watson, chairman of IBM, 1943 "There is no reason anyone would want a computer in their home" Ken Olson, chairman & founder of Digital equipment, 1977 "This 'telephone' has too many shortcomings to be seriously considered as a means of communication. The device is ingerently of no value to us." Western Union internal memo, 1876 "640 K ought to be enough for anybody." Bill Gates, 1981 "Computers in the future may
-
Can you show us your code piece ? ----------------------------------------------------------- "I think there is a world market for maybe 5 computers" Thomas Watson, chairman of IBM, 1943 "There is no reason anyone would want a computer in their home" Ken Olson, chairman & founder of Digital equipment, 1977 "This 'telephone' has too many shortcomings to be seriously considered as a means of communication. The device is ingerently of no value to us." Western Union internal memo, 1876 "640 K ought to be enough for anybody." Bill Gates, 1981 "Computers in the future may
This is the code as it stands right now... 'Updates the current dataset the datagrid is using Me.SqlDAFire_Cur.Update(Me.DsFire_Cur1) Me.SqlDAFire_Cur.Fill(Me.DsFire_Cur1) 'Rebind the datasource to the datagrid Me.DataGridFire.DataSource = Nothing Me.DataGridFire.DataSource = Me.DsFire_Cur1 Me.DataGridFire.Expand(-1) It does not expand the entire datagrid with the records though and since I would like this automated I was thinking of putting this into a timer event. Thanks, Bob