>Difference b/w COUNT_BIG and COUNT in SQL server

> 1.Count_big always returns the Bingint values…but count returns theint values 2.Both count the No of Rows in a table Water for Elephants21

Read Full Post »

>To Create Custom exception in C#.Net

>#region Custom Exception Classes class ExTask : Exception { public ExTask() { } public ExTask(string message) : base(message) { } } #endregion ==================================================================To catch the custom Exception : catch (ExTask ex) { // Do to Log Handler } ================================================================== For the above example “ExTask” is the custom exception name. 1.your Exception wants to inherit the [...]

Read Full Post »

>To Execute the Remote Machine Process Example To reset the iis of remote machine

> ProcessStartInfo psi = new ProcessStartInfo(“iisreset.exe”, “RematoreMachineName -stop”); psi.UserName = “RemoteMachineUserName”; psi.Domain = “DomainNameOfRemoteMachine”; psi.UseShellExecute = false; string password = “RemoteMachinePassword”; System.Security.SecureString o = new System.Security.SecureString(); foreach (char c in password) { o.AppendChar(c); } psi.Password = o; Process.Start(psi);

Read Full Post »

>Information about W3wp.exe File

>Description: File w3wp.exe is located in a subfolder of C:\Windows\System32 or sometimes in a subfolder of “C:\Program Files”. Known file sizes on Windows XP are 7168 bytes (66% of all occurrence), 6656 bytes.w3wp.exe is a Windows system file. The program has no visible window. w3wp.exe is a trustworthy file from Microsoft. Program listens for or [...]

Read Full Post »

>Use double quotes on string in .NET

>We can use double quotes on the string.Example : Declaration:__________string a=”double quotes Example”; string b= “\””+a+”\””; The out put is like this:_________________a= double quotes Example; b= ” double quotes Example”;

Read Full Post »