Loading

Tutorials

  • Webcam face detection in C# using Emgu CV

    Submitted by: 
    itachi_philip
    Wednesday, May 25, 2011 - 21:19
    Language: 
    C#

    This tutorial has already been posted on the other sites, since maybe few have only knew about that site then I'll have to post it here. This tutorial has also been explain in the Emgu CV website that refers in this link: http://www.emgu.com/wiki/index.php/Face_detection in which that link refers also in this link http://friism.com/webcam-face-detection-in-c-using-emgu-cv Notes in order to run this example: *Create a Windows Form Application *Add a PictureBox and a Timer (and Enable it) *Run it on a x86 system

  • Camera Capture in 7 lines of code using Emgu CV

    Submitted by: 
    itachi_philip
    Wednesday, May 25, 2011 - 21:09
    Language: 
    C#

    This tutorial are for those who had a background in Emgu CV and for those who are new in EmguCV visit this link: http://www.emgu.com/wiki/index.php/Download_And_Installation This tutorial talks about on how to use your webcam in your pc using EmguCV with C# as your code. So first create a project then name it whatever you want then after that add the following references in your project Emgu.CV.dll,Emgu.CV.UI.dll, and Emgu.Util. After adding those referrences add a new form then add a picture box.

  • Face Detection with Emgu CV

    Submitted by: 
    itachi_philip
    Wednesday, May 25, 2011 - 20:51
    Language: 
    .NET

    Emgu CV is a cross platform .Net wrapper to the Intel OpenCV image processing library.Allowing OpenCV functions to be called from .NET compatible languages such as C#, VB, VC++, IronPython etc. OpenCV (Open Source Computer Vision) is a library of programming functions for real time computer vision.Unlike other wrappers such as OpenCVDotNet, SharperCV or Code Project which use unsafe code, Emgu CV is written entirely in C#. The benefit is that it can be compiled in Mono and therefore is able to run on any platform Mono supports, including Linux, Solaris and Mac OS X.

  • SQL DROP Statement

    Submitted by: 
    admin
    Monday, May 23, 2011 - 09:17
    Language: 
    SQL

    The DROP statement is used to delete object in SQL, with the DROP statement we can remove index, tables and even databases easily. DROP INDEX The indexes of the table can be dropped by the using the following command. SYNTAX for MS Access DROP INDEX index_name ON TABLE_NAME SYNTAX for SQL SERVER DROP INDEX TABLE_NAME.index_name SYNTAX for Oracle DROP INDEX index_name SYNTAX for MySQL ALTER TABLE TABLE_NAME DROP INDEX index_name For various DBMS the respective statement will drop the indexes from the table. TO DROP TABLES

  • SQL MID() Function

    Submitted by: 
    admin
    Monday, May 16, 2011 - 09:24
    Language: 
    SQL

    The MID() function is used to extract values from a column. The MID() contain three (3) parameters. The first one is used to select which column to extract, the second one is the starting position, the last one is the number of characters to be extracted. SQL MID() Syntax SELECT MID(column_name,START[,LENGTH]) FROM TABLE_NAME Consider the following table for this exercise Users Firstname Lastname Salary DeptID John Smith 1000 1 Mathew Simon 3000 1 Bill Steve 2200 1 Amanda Rogers 1800 2 Steve Hills 2800 2 Steve jobs 2400 2 bill cosby 700 3 Example # 1

  • SQL AVG() Function

    Submitted by: 
    admin
    Monday, May 9, 2011 - 14:41
    Language: 
    SQL

    The AVG function calculates the average of a specified column. It works only on a numeric column. It first sums up all data and then divides it by the total number of rows.For example if the sum of 5 items is 10 then average is 10/5 = 2. SQL AVG() Syntax SELECT AVG(column_name) FROM TABLE Consider the following table for this exercise Users Firstname Lastname Salary deptnumber John Smith 1000 1 Mathew Simon 3000 1 Bill Steve 2200 1 Amanda Rogers 1800 2 Steve Hills 2800 2 Steve jobs 2400 2 bill cosby 700 3 Example # 1 SELECT AVG(Monthly_Salary) AS AverageSalary FROM Users

  • SQL FIRST Function

    Submitted by: 
    admin
    Saturday, May 7, 2011 - 18:12
    Language: 
    SQL

    The FIRST function returns the first value of the selected column. FIRST function is not standard SQL function so it cannot be used with other DBMS like MySQL. However this is very useful with MS Access OR SQL Server. SQL FIRST() Syntax SELECT FIRST(column_name) FROM TABLE Consider the following table for this exercise Users Firstname Lastname Salary DeptID John Smith 1000 1 Mathew Simon 3000 1 Bill Steve 2200 1 Amanda Rogers 1800 2 Steve Hills 2800 2 Steve jobs 2400 2 bill cosby 700 3 Example # 1 SELECT FIRST(Firstname) AS FIRST FROM Users

  • SQL Max() Function

    Submitted by: 
    admin
    Thursday, May 5, 2011 - 09:44
    Language: 
    SQL

    The MAX function is use to return the largest value of the selected column. MAX can be use only in numeric column. As with other function, you can also give an Alias to the MAX function. SQL MIN() Syntax SELECT MAX(column_name) FROM TABLE Consider the following table for this exercise Users Firstname Lastname Salary DeptID John Smith 1000 1 Mathew Simon 3000 1 Bill Steve 2200 1 Amanda Rogers 1800 2 Steve Hills 2800 2 Steve jobs 2400 2 bill cosby 700 3 Example # 1 SELECT MAX(Salary) AS MaximumSalary FROM users

  • SQL Min() Function

    Submitted by: 
    admin
    Wednesday, May 4, 2011 - 20:30
    Language: 
    SQL

    The MIN function is use to return the smallest value of the selected column. MIN can be use only in numeric column. As with other function, you can also give an Alias to the MIN function. SQL MIN() Syntax SELECT MIN(column_name) FROM TABLE Consider the following table for this exercise Users Firstname Lastname Salary DeptID John Smith 1000 1 Mathew Simon 3000 1 Bill Steve 2200 1 Amanda Rogers 1800 2 Steve Hills 2800 2 Steve jobs 2400 2 bill cosby 700 3 Example # 1 SELECT MIN(Salary) AS MinimumSalary FROM Users

  • SQL SUM() Function

    Submitted by: 
    admin
    Tuesday, May 3, 2011 - 10:51
    Language: 
    SQL

    The SUM function is an aggregate function use to calculate the total amount of a column. SUM function can be use only in numeric column. Syntax SELECT SUM(column_name) FROM TABLE Consider the following table for this exercise Users Firstname Lastname Salary DeptID John Smith 1000 1 Mathew Simon 3000 1 Bill Steve 2200 1 Amanda Rogers 1800 2 Steve Hills 2800 2 Steve jobs 2400 2 bill cosby 700 3 Example # 1 SELECT SUM(Monthly_Salary) AS TotalSalary FROM Users Result of the Query TotalSalary 13900 You can also add other field and using the GROUP BY Clause.

Pages