Saturday, 21 November 2009

Configuring canon powershot A70 or A60 as webcam.

*note* this works for canon A70 but should work for other cameras that are compatible with Canon RemoteCapture software.

1.Download the free manycam software from
2.Download remote capture software from canon website href="
3. Install both pieces of software.
4. Start Canon RemoteCapture software. If using windows 7 or vista you must setup up the Remote capture software to run in Windows XP SP3 compatibility mode. Plug the camera to your PC with the USB cable, set the camera in review mode(the mode for viewing taken pictures), and then turn it on. In the Remote capture software click on connect. If all works OK a new dialog should open titled Shooting - Remote Capture. Click on the arrow next to "detail setting" to expand dialog. Now there should be a blank panel and a button saying viewfinder off. click viewfinder off button to turn it on. There should now be a live stream from the camera displayed in the dialog. There are also plenty of setting to change to optimise the image.
5. Open manycam software click on source->desktop>custom-desktop place the target window over the camera live stream from step 4. Click close on the target window once it is matched up correctly.
6. Done, you should now have a decent quality webcam from just using the camera, usb cable and free software.

Saturday, 31 October 2009

C# asp.Net Master Page

In .Net 2.0 and above there are Master pages in asp.Net. Create a master page such as a header and footer that you want across the site and then on the master page add the contentplaceholder tag to mark a point where content will be added to the master page.

Then on the asp web pages for the site add put all the code in content tags setting the contentplaceholderID attribute to the id of the contentplaceholder in the master page.

<asp:content id="Content1" runat="Server" contentplaceholderid="ContentPlaceHolder1">

When the browser requests the page the content in the content tag of the asp page will be inserted into the master page at a point according to the contentplaceholder ID. The approach is flexible because it allows for lots of options in the places the data is inserted into the main page. For example you could have two different point in the master file where code was inserted.

Thursday, 22 October 2009

Inner Join

An inner join is when you combine the rows of two tables based on a condition.

select * from customers on pet INNER JOIN =

A cross join is the complete data of all the combinations when picking a row from each of the two tables.

Out Join

A left outer Join combines two tables based on a condition. If condition is not met the result from the left table is returned with null entries added for the right table.

select * from customer on pet LEFT OUTER JOIN =

A right outer join is the same as left outer join but results from the right hand (second mentioned table in query) are returned

A full outer join combines the results of both left and right outer joins. Duplicate rows are not included.