Test Your Programs with the NUnit C# Unit-Tester

microsoft access 2010 tutorialIn the world of computer programming, no task is as despised as business logic debugging. The debugging wouldn’t be so bad if we could easily find them in our code, but most business logic errors only happen while the programs run. Some of them even happen with no fault from the programmer. Either way, we have to fix every bug in our programs long before our end users get their hands on them, and the only way to do that is to thoroughly test our programs. Fortunately, we have special tools such as the NUnit C# unit-testing framework to help us out.

Learn how to handle C# errors at Udemy

[Read more…]

Display Special Characters with Escape Sequences

escape sequencesUnless you’re programming in Assembly, you have to use ordinary letters, numbers, and other symbols to write you code. There’s no way out of this. Regardless of your programming language of choice, every keyword, operator, and symbol you will ever use comes from real world languages. This wouldn’t be so bad if we didn’t need to use strings in our program. But, any program worth using has to interact with the user, and strings are the only tools we have to accomplish this. Fortunately, all programming languages come with a set of string escape sequences that we can use implement special characters and phrases in our strings.

See how to use escape sequences in C++ at Udemy

[Read more…]

Assign Values to Your Variables with the .Net = Operator

microsoft access 2010 tutorialOperators are symbols that tell us when to perform some set of manipulations on a collection of data. More than simply mathematical or logical functions, we use operators for a wide variety of activities from computer programming to everyday tasks. Even in programming, we have enough operators to perform any task our hearts desire and then some. However, they would all be worthless without assignment operators. In .Net, the assignment operator is represented by the .Net = operator and I hope this post will show you how powerful it is.

Find out how VB.Net uses the = operator at Udemy.

[Read more…]

Search Your Database with the CONTAINS SQL Function

normalization in sqlThe right SQL statement makes databases the perfect tool for any task. All you have to do is populate your database tables with the data you need, and use your SQL queries to combine them into useful pieces of information. The power of SQL lies in the WHERE clause, which lets you input filters and other search criteria to create the perfect solution to your problem. However, there will be times when you only know a portion of the information you need. Regular SQL logical and equality statements only handle whole pieces of data. If you need to test your database against substrings, you need use the CONTAINS SQL function.

Read about other SQL data manipulation functions at Udemy

[Read more…]

Get Better Database Results with the SQL IN Statement

normalization in sqlDatabases let us organize our lives like nothing else. Whether for work or play, a properly normalized SQL database makes life easier. We can store just about any information in them, and retrieve it later with gusto.  While these databases let us store anything in them, their power comes from the SQL language. You can do anything with the right SQL statement. These statements can be ridiculously simply or unfathomably complex depending on your needs. For instance, if you need to retrieve records containing certain specific pieces of information in the same column, you have two options. You can either include them as separate “OR” command conditions or you can use a single SQL “IN” statement to grab them all in one line.

Learn what relational databases can do for you at Udemy

[Read more…]

Modify your Database Records with the REPLACE SQL Keyword

normalization in sqlA normalized database makes life simple. Whether for work or for play, these wonders of technology organize our lives in more ways than we may realize. We can store just about anything in a database. We just have to set up the right tables to store the data, and then use the right SQL statements to retrieve them again. Unfortunately, like any tool, databases have their limits. We can’t store everything under the sun in them. However, we can store most of the things we need in a database, and use the replace SQL keyword when we need something different.

Brush up on  the fundaments of SQL at Udemy

[Read more…]

How to Use Aspect Oriented Programming in C#?

microsoft access 2010 tutorialI have been fortunate enough that my programming tasks were simple. All my projects were for the Internet, which meant that my classes only had to handle one or two aspects of my programs. I always had a main function to dump global instructions and procedures. Object-oriented programming (OOP) with a little web scripting did everything I needed without much code rewriting.

However, I know not every program is as easy to develop. Some require runtime tasks that must be done at every method call. While you can create special classes to handle these tasks, you still have to write the code that calls these classes in each and every class and method you write. Fortunately, we have aspect-oriented programming. By adding some aspect-oriented programming in your C# code, you can kis your programming nightmares goodbye.

Learn how to use OOP strategies in C# at Udemy [Read more…]