run dynamic sql [mysql]
-
Hi, I have a website with a textbox.. user will write the sql query in the textbox.. how can I execute the code on mysql? Thanks,
-
Hi, I have a website with a textbox.. user will write the sql query in the textbox.. how can I execute the code on mysql? Thanks,
With crossed fingers. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
Hi, I have a website with a textbox.. user will write the sql query in the textbox.. how can I execute the code on mysql? Thanks,
-
Hi, I have a website with a textbox.. user will write the sql query in the textbox.. how can I execute the code on mysql? Thanks,
That's not a good practice But If you want to go ahead with this only then I can provide you little suggestion. Just Put you query inside
Execute()and giveSqlCommandToExecute.Regards, Hiren. Microsoft Dynamics CRM My Recent Article: - Way to know which control have raised PostBack[^]
-
Hi, I have a website with a textbox.. user will write the sql query in the textbox.. how can I execute the code on mysql? Thanks,
Very simple, you need to embedded texts of textbox in the paramater of SQLCommand function and then pass connection object and then Execute it.
-
Very simple, you need to embedded texts of textbox in the paramater of SQLCommand function and then pass connection object and then Execute it.
Hi, I tried it and it's working BUT it's just executing the first query so f i type any other quesry it will just show the first query result with no error unless i signout my application or restart it.. why is this? here is the code: