Tag Archive: programming

Oct 12

How can I delete records from MS SQL Server database using Python?

The following code will delete all records from table in database on server. import win32com.client connectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=database;Data Source=server;" query = "delete from table;" con = win32com.client.Dispatch(‘ADODB.Connection’) con.Open(connectionString) con.Execute(query) con.Close( ) Note: This code works on Windows only. You will also need to install excellent Python for Windows extensions (pywin32) by …

Continue reading »

Feb 03

How can I get application’s directory in a WPF application?

string appPath = AppDomain.CurrentDomain.BaseDirectory;

Dec 28

Look What I Found #5

PDFsharp: .NET library for creating and processing PDF documents on the fly. SSH.NET: .NET 4.0 library for SSH client protocol. MailSystem.NET: suite of .NET components with support for SMTP, POP3, IMAP4, NNTP, MIME, S/MIME, OpenPGP, DNS, vCard, vCalendar, Anti-Spam (Bayesian , RBL, DomainKeys), Queueing, Mail Merge and WhoIs. Json.NET: makes working with JSON formatted data …

Continue reading »

Dec 28

Free books from Microsoft Press

Microsoft Press offers several e-books free of charge. For developers Programming Windows Phone 7, by Charles Petzold Moving to Microsoft Visual Studio 2010, by Patrice Pelland, Pascal ParĂ©, and Ken Haines Parallel Programming with Microsoft .NET, by Colin Campbell, Ralph Johnson, Ade Miller and Stephen ToubIntroducing Microsoft SQL Server 2008 R2, by Ross Mistry and …

Continue reading »

Dec 06

How can I tell if Silverlight application is running out of browser?

Application.Current.IsRunningOutOfBrowser indicates whether application was launched as an out-of-browser application. Application.Current.HasElevatedPermissions indicates if application is running as an out-of-browser application with elevated permissions. Elevated permissions give you direct access to clipboard, user folder and COM enabled applications.