Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Yahya
540
Dynamically created data source for UltraGrid
posted

Hi

I have a SQL string on the lines;

"SELECT a,b, c FROM MyTable WHERE MyTable.d = '" & Me.MyField.text & "'"

The value of Me.MyField is provided at runtime by user. I need to assign the resultset of this SQL to an UltraGrid for view only i.e. no editing just display. My questions are;

1. What is the fastest way to assign the result of SQL string to the UltarGrid as speed is of essence on runtime?

2. If the value of Me.MyField.text is changed by user then what code can I use to refresh the UltraGrid with the new resultset?

Thanks

Regards

Parents
No Data
Reply
  • 37774
    posted

    You will have to put the results of the SQL query into a DataSource in order for the grid to be able to work with it, so likely a DataTable is your best option.  If you need to update the grid's data, then simply setting the DataSource of the grid to this new table should refresh it.

    -Matt 

Children
No Data