SQL Query Validation

Question

Hi I am getting the data from the textbox  and here i want to verify whether it is a valid sql statement or not using c#.net  can any one suggest and send me the code . many thanks.

praveen Reddy · Answer

Hi Here the user enters the sql statement from the textbox but i want to know whether it is valid sql statement or not . if it is valid then only i want to send it to the server. for example let us think the user enter the following in the textbox select from usertable then i have to validate the above query and say him that it was not valid one because it was not containing any column names so here i requried how to validate it. so please can you send me the code to validate it using c#.net

Hiren Soni · Answer

In textbox. What are you going to enter any data or any sql statement? write some code so we can understand well.