Thank you for your consideration!
In fact, I would like to validate a SQL statement is inputed by user. For example, if users input a SQL statement from a textbox:" Select product_name, product_type from Products inner join ProductTypes on Products.product_typeid=ProductTypes.product_typeid where Products.product_typeid='1' ", I will validate this statement, so that I parse fields returned (product_name, product_type) I want in my program in VB.NET.
Pls help me!
Thanks a lot
Uh oh! Please google "sql injection" before you get to far along with your project, the type of application you are proposing is incredibly risky/dangerous.
In fact, I would like to thank, thank all of you. I changed the requirement and performed by another way. Thank you any ways.
I too had a developer ask me about validating sql data from an app he wrote that allowed users to input T-SQL statements and the SET PARSEONLY worked out great.
Thanks again for your posting of that info.