Thanks for informing me of this .
As you have realised, I am quite new to SQL .
It was quite interesting to read about the Injection Attacks .
But be wary mate, there will always be people who are unaware of this
Thanks again. I will see how I can change it.
First of all, write a store procedure that will contain all the queries in your view. If you want to check some condition
you can do it in a stored procedure too. (iProjectID and iStageID). You will have to learn the sql syntax of IF statements.
The values which i told you in last sentence, will be passed as input parameters to the stored procedure. This can be done
as told by other poster, using the command object and setting its CommandType property to StoredProcedure. Then add the
parameters to be passed to the stored procedure.
One of the things you might be wondering about, how to return multiple rows from a stored procedure. If you just
execute the query from SP and fill dataset using data-adapter, then you will get data tables for all your queries in the dataset.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder coolestCoder
I'm developing an application wherein I'm calling some classes in webforms which do some searching,addition etc on the database. Now what I need to know is how can I code the classes in such a way that if I need to call these classes through web service I won't have to redo the code.
Hi, Firstly thanks for replying. I'm already aware of these things what I'm asking is can a single class serve both webservice & web form. As in a web service syntax is little different like [WebMethod] attribute etc.
i am working on a web application i want to implement file uploading and downloading directly from the user. like user upload diectory or download directly from FTP server..
Please help me ..
Send me some Demo or articls
Downloading is as simple as placing a link directly to the file you wish to allow your users to download. So if you want to allow your users to download an MS word document use something like "href='http://www.yourWebSite.com/subFolderName/helpFile.doc'".
I don't entirely understand. Are you looking to upload multiple folders to the server or are you trying to upload a single file to multiple folders located on the server?
As far as I know, you can't upload folders directly to a server, only files (someone please correct me if I'm wrong). If you want to upload an entire directory, you should first zip it up and then upload this zipped file to the server.