Recent content by Walid

Thanks for the reply. This is what I thought of, originally. But I am looking for more generic way without the code itself being aware of the conditional execution. One of these architectural wows we get here some times. Walid Magd (MCP) The primary challenge of every software development...

Hi, I am trying to find an elegant way to check, in the beginning of a sproc, if I am in production environment. In which case, I will prevent the code from running. This is suppose to be the last level of protection, of course we will be careful and try to check for this in so many different...

You did not specify an access modifier for the methods (i.e. private, public or protected) so they are by default “private”. That is way you can’t access then using a reference to the class. Add the key word public in the front of each method and you will be fine Walid Magd (MCP) The primary...

Please explain Walid Magd (MCP) The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity. -Grady Booch

Try this Write a batch file with the commands you want to execute and modify your code to execute this batch file instead. Only one line of code need to be modified for this test System.Diagnostics.ProcessStartInfo sinf = new System.Diagnostics.ProcessStartInfo("cmd", @"/c C:\myBat"); Hope...

The intrinsic data types in C# are no more than aliases for structures and classes defined in the System namespace. So, string is an alias for System.String and the compiler will resolve it for you as such. If you so choose, feel free to declare your built-in data types using their real name as...

You are very welcome. I am gald you got it to work and I respect your persistance. Walid Magd (MCP) The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity. -Grady Booch

Do you the interaction to take place using an application you will develop or a web browser or both? Please explain the problem in more details. Walid Magd (MCP) The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential...

Hey man, Setting the value of a Cell is very simple task oSheet.Cells[1, "A"] = 2; oSheet.Cells[1, 1] = 2; Why you get the same 2 for every row, I simply don’t know but you can set a break point and see exactly what is the range object contains in each iteration. It works fine in this sample...

In that case you don’t need to worry about security; you still can use the integrated security and windows authentication. Just provide the server name \\ServerName instead of (local) in the connection string and you will be fine. Most likely that the configuration of the LAN allows SQL-Server...

Is this another computer located in the same LAN? or you want to connect through the internet? Walid Magd (MCP) The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity. -Grady Booch

In C#, there is no global data, every thing need to be in types. Even if you store these values in an app settings file, XML file or even a plain text file, it will still be your responsibility to extract these values from wherever and assign them to the symbols in your code, the media you used...

Use these commands while the database you want to grant access to is selected sp_grantlogin 'YourMachineName\ASPNET' sp_grantdbaccess 'YourMachineName\ASPNET' Walid Magd (MCP) The primary challenge of every software development team is to engineer the illusion of simplicity in the face of...

Not the whole framework, if your intention is just to run the application on this machine you will have no need for the compiles and tools in the SDK. You need only the redistributable part of the framework. Google “.NET Distributable” it will take you to the page in Microsoft web site. In there...

Hi, try this code, please change x2 to your table name and do the same for columns names. SELECT Product, SUM(CONVERT(INT,quantity)) FROM x2 GROUP BY Product ORDER BY Product good luck Walid Magd (MCP) The primary challenge of every software development team is to engineer the illusion of...