Hi,

I want to ask, can I use VB .Net to change the SQL statment of a dataset. My case is I need to prepare a UI for user to choose a criteria, then base on it to build the SQL statment where clause.

Thx.

Sure
Write a VB function that returns a string and call the function in the dataset expression. The only caveat is that the enture SQL query must be in the form of a string expression:

="SELECT some columns FROM some tables " &
"WHERE " & Code.MyWhereClauseFunction()

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner