Skip to main content

Posts

Must To Have Utilities

FileMon - FileMon monitors and displays file system activity on a system in real-time. Note: Filemon and Regmon have been replaced by Process Monitor on versions of Windows starting with Windows 2000 SP4, Windows XP SP2, Windows Server 2003 SP1, and Windows Vista. Unlocker - The solution for "Cannot delete file: Access is denied" error message. Dependency.exe - Dependency Walker is a free utility that scans any 32-bit or 64-bit Windows module (exe, dll, ocx, sys, etc.) and builds a hierarchical tree diagram of all dependent modules. SCDL version 1.1 - Generates source code for config sections based on an XML sample, also creates the XSD schema for the section. Expresso - Regular Expression Editor and Tester

T-Sql: Error Handling Solution

The following code can be the simple solution for error handling problems in the SQL Server: Declare @ErrorCode int Select @ErrorCode = @@Error If @ErrorCode = 0 Begin --Some statement Update … Select @ErrorCode = @@Error End If @ErrorCode = 0 Begin --Another statement Insert … Select @ErrorCode = @@Error End If @ErrorCode = 0 Begin --Another statement Update … Select @ErrorCode = @@Error End Return @ErrorCode More information: http://msdn2.microsoft.com/en-us/library/aa175920(SQL.80).aspx

Improve DataView Performance Tip

Following tip will allow your to increase your performance when your are using DataView RowFilter property. Just instead of using following syntax: DataView dv = new DataView("tableName"); dv.RowFilter = "Name like '%blabla%'"; Use the next one (combine it to single statement): DataView dv = new DataView( TableName, "EName like '%Test%'", null, DataViewRowFilter.CurrentRows ); This will improve your performance !!! It's real.

Sending E-Mail (.NET 2.0)

The System.Net.Mail namespace contains all the classes required for sending mail from within a .NET application. The SmtpClient class handles the actual sending of e-mail. For a simple mail, you can directly pass in the To address, from, subject, and body of the mail to one of the SmtpClient's overloaded send methods. Client application: private void btnSendMail_Click(object sender, EventArgs e) { MailService service = new MailService(); string from = "some@yahoo.com"; string to = "some@yahoo.com"; string subject = "Sending EMails from .NET 2.0"; string body = "Message Body"; service.SendMail(from, to, subject, body); ; MessageBox.Show("Done"); } Sending method: public void SendMail(string from, string to, string subject, string body) { string mailServerName = "yoursmtpserver"; try { //MailMessage represents the e-mail being sent using (MailMessage message = new MailMessage(from...

Find If Assembly Compiled in Debug Or Release Mode

1. Locate and run ildasm.exe application on your mashine 2. From the top menu select Open-> View-> MetaInfo-> Show! 3. Find following text "System.Diagnostics.DebuggableAttribute". You should see something like CustomAttribute Type: 0a00000d CustomAttributeName: System.Diagnostics.DebuggableAttribute :: instance void .ctor(value class DebuggingModes) Length: 8 Value : 01 00 07 01 00 00 00 00 > ctor args: ( ) 4. Value of this attribute for Release Version the value should be Value : 01 00 07 01 00 00 00 00 and for Debug Version it will look like Value : 01 00 02 00 00 00 00 00