Using SQLite with C#

1. Include System.Data.SQLite.dll into the project

2. Optional, use IDE for SQLite (http://sqliteadmin.orbmu2k.de/)

Tutorials

http://brennydoogles.wordpress.com/2010/02/26/using-sqlite-with-csharp/

http://www.mikeduncan.com/sqlite-on-dotnet-in-3-mins/

Develop Android apps in C#

Great! Awesome! I've always wanted to write some neat mobile app, but was too lazy to learn Objective-C or Java topped with BlackBerry API or Android. That also meant learning a new IDE. Oh how lazy.

I actually even got myself Eclipse + Android SDK + Java SDK and started to play around with this but then I discovered MonoDroid, a wrap for Android for Visual Studio. I happily tossed away Java and jumped back to .Net.

So, this will give you the start :

http://xamarin.com/monoforandroid

It's almost the same Android API as in Java but using the C# syntax and .Net libraries.

Enjoy!

Recommended references (.net Dev and related)

• Android

Examples
http://grepcode.com/file/repository.grepcode.com/java/ext/com.google.android/android/2.1_r2/android/widget/VideoView.java#VideoView.%3Cinit%3E(android.content.Context)

• C# 

http://roque-patrick.com/windows/final/bbl0190.html

• DirectShow

short summary about
http://www.gdcl.co.uk/dshow.htm  
book
http://mathinfo.univ-reims.fr/image/mmVideo/cours/DirectShow3Annexe.pdf 
code samples 
http://www.informikon.com/directshow-tutorials/ 
forum
http://social.msdn.microsoft.com/Forums/en-US/windowsdirectshowdevelopment/threads

• XMarine

online API documentation
http://docs.xamarin.com/mono/api
forum
http://mono-for-android.1047100.n5.nabble.com/
open source (code samples)
http://grepcode.com/file/repository.grepcode.com/java/ext/com.google.android/android/2.1_r2/android/widget/VideoView.java#VideoView.%3Cinit%3E(android.content.Context)
 

• SQL Server Hacks and Handy scripts

by Denis Gobo, Microsoft SQL MVP:
http://wiki.lessthandot.com/index.php/Category:Microsoft_SQL_Server 

Common Solutions for T-SQL Problems
http://archive.msdn.microsoft.com/SQLExamples 

Some basics just in case
http://sqltutorials.blogspot.ca/search/label/SQL%20CASE
  

• Microsoft DOS and command prompt

http://www.computerhope.com/msdos.htm

http://ss64.com/nt/

•  Find PInvoke* signature related to calling Win32 

http://www.pinvoke.net/search.aspx?search=folder&namespace=kernel32

•  Shell Objects

http://msdn.microsoft.com/en-us/library/windows/desktop/bb774094(v=VS.85).aspx 

• Ask a Question

http://stackoverflow.com/search?q=GStreamer

• Git 

http://wiki.sourcemage.org/Git_Guide  
http://cheat.errtheblog.com/s/git
http://help.github.com

How to programmatically click a button - WPF

Back in WinForms it was really easy to simulate a user clicking a Button, you just call a Button’s PerformClick method. In WPF it's not quite as intuitive as the old Windows Forms way, but it is more powerful since you can raise most events now.


System.Windows.Controls.Button btnLaunch = new Button();

btnLaunch.RaiseEvent(new RoutedEventArgs(Button.ClickEvent, btnLaunch));


Since I love the new 3.5 Extensions, I've made an extension method that mimics the old Windows Forms method.


/// <summary>


/// Manally performs a <seealso cref="System.Windows.Controls.Button.Click"/> event for a supplied


/// <seealso cref="System.Windows.Controls.Button"/>.


/// </summary>


/// <param name="btnObject">The <seealso cref="System.Windows.Controls.Button"/> object to


/// be clicked.</param>


public static void PerformClick(this System.Windows.Controls.Button btnObject)


{


btnObject.RaiseEvent(


new System.Windows.RoutedEventArgs(


System.Windows.Controls.Button.ClickEvent,


btnObject));


}