Hi All:

I completed the example in chapter 16 called "DataSet Example".

I decided to modify it slightly to include placemarker variables in the SQL code, that are provided by a value in a text box.

For example, let's say I wanted to display the data grid, but only for a specific author's last name contained in a text box.

I was able to get the grid to display with an initial value supplied in the text property of my text box, so I know the placemarker is working on the load of the form.

What I need to know, is how to refresh/requery the datagrid when the user changes the last name in the text box below the datagrid and presses a "search button", basically changing the search criteria.

Can someone help me?

hi

You have to rebind the datagrid with the DataSet loaded by the SQL query with the required condition in where clause.

Prashant

Thanks... I managed to get it to work....

I also re-did my selection logic to work off of a combo box populated from a dataset read from a SQLServer table.