using design patterns for software development

Question

I am developing a desktop application using C#. I want to use design patterns but do not have any experience in using them. I searched in net but can not found any good examples helpful for me like beginners. They have some block of code to demonstrate the design patterns but I can not understand how can I use them when I develop my applications.

How can I implement design patterns when developing real life applications, please can anyone guide me. Can we use design patter with sql code too?

I've no experience in using design patterns now I really want to use them in my application development. I searched in net, I can found only code blocks showing examples of design patterns but they do not explain how it can be implemented in s/w development, or may be for me beginners hard to understand those examples.

Please can anyone share me how can I write code for my application implementing the design patterns.

Note :: I am coding for a desktop application (inventory management system), so please if you provide examples related to this it will be more helpful for me to understand.