This is another scenario where using SPs may not be the best solution. When I'm going to develop an application that works with more than one DB provider. If I go for SPs, I had to make a separate layer (SPs) for each provider and repeat the code even if my queries are standard PLSQL and straight forward.

plextoR

Stored procedures would also contain BL which is not good for an N-Tier application. and harder to maintain. again,, it depends

plextoR

I prefer using SPs whenever it's possible. but in some work environments, you are required to attach condition to existing SQL statements or constructing SQL statements based on program flow. it would be slower but this is can't be done using SPs except when you use

exec

and in such case you will lose the value of SPs or you will - and that mostly happen - have to make large number of SPs or put lot of business on them. but if we are talking about parameterized queries, then it differs: when using TSQL with parameterized queries you nearly get the same performance of SPs as it's also cached. and yes SPs are debuggable but debugging parameterized queries is much much easier. again if you are going to ask, I'll definitely choose SPs but with respect to the above issues. shortly, the correct answer is 'it depends'. and the correct question should be 'What scenarios would using SPs is preferred to TSQL?'

plextoR

i dunno.. but i seems easy ques.(may be) I want to make a button that is capable of moving the VScroll bar of the form to a certain position or to the end. how can i do such thing? thx plextoR

Salamo 3alekom, i'm doing a program like windows explorer.. things are going great except that i faced 2 problems that i couldn't solve. 1- i couldn't get the labels of drives (for ex. drive c:\ label is system) also the lable of "my computer". 2- i couldn't get the icons of the files & folders & drives . anyhelp? thanks:rose: plextoR

i really dunno but i want to tell u that when i open the file using the same application that created it , it opens successfully but when i try to open it from other application it gives the error. Do you think that saved files can be opened ONLY by the application that created it. thanks for replaying :) plextoR plextoR

Hi all In my app i want to know when user tries to open any file. i tried FileSystemWatcher but it raises events only when file is created , deleted , renamed. is there anything like this that i can use to receive an event when user tries to open any file .. may be any folder too. thanks plextoR

Hi all, In my application i need to save a file (HashTable) using BinaryFormatters & i wanna load that file from another application. The problem that when i try to load it from another app. it sayes " [app1 Name] or one off it's refrences are minssing" how can i do such a thinG? thanks all. plextoR plextoR

Thanks Alot but sorry i can't understand what do you mean with PE/COFF :confused:. As i told you i'm new with this operations. i'll read the article .. thanks alot plextoR

now , i'm thinking about developing a simple anti-virus program as a graduation project.So anyone know where to find articles that would help me .. about Virtual computers for example. all i know about virtual computer is that i isolate a part of the memory & create a virtual computer & test the file on it .. if it destroyed the computer ,then it's a virus. aslo what i should read about or know to such idea ? thanks plextoR plextoR

Dear Paul (without sir;) ) Thanks i think i got the point. plextoR

Thanks for your help. Nick Parker wrote : "Open a command prompt, then: C:\>fc /b file1.exe file2.exe" But i was talking about how to compare 2 files using C# code. Nick Parker wrote : "How do you expect to see a corruption or virus, you are going to see binary." I mean i would find a virus signiture or something like that. So i need to read the binary of the file . plextoR plextoR

Dear sir, Thanks for replaying but.. is it differes when i use streamReader for reading *.txt files from reading *.exe files?? i tried to read ana exe file the same way i do when reading *.txt files in C# but i got strange characters!! is that ordinary or i'm using the a wrong way. if i'm using a wrong way would you direct me to an article or tutorial that help me . & thanks alot & sorry 4 long msg. plextoR plextoR

Hi All, I want to ask how i can open an exe file with C#. the idea i want to compare the binary code of 2 files . So i want to open each. i aslo wanna check if the file corrupted or not - infected with a virus or not. Note : I never do that even with C++ or other so plz try to be descriptive. thanks alot for your co-operate :) plextoR plextoR