call the sql query from aspx page

[souravghosh18]

In my application i want to store all the queries in a text file instead of the code behind and at run time i want to call it from the code behind page.can it be possible.If yes then how??

[Vimalsoft Pty Ltd]

Very Bad Practise that is Vulnerable to SQL injection. i dont know why dont you let SQL do the SQL and ASP.nET do the ASP.NET PArt.

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[Ashfield]

Of course its possible, all you are doing is reading a file - just make sure its located in an accessible directory. take a look at the SYSTEM.IO namespace.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[Not Active]

souravghosh18 wrote:

store all the queries in a text file

How about storing them in the database, like as Stored Procedures :rolleyes:

---

only two letters away from being an asset