tag:blogger.com,1999:blog-60540259462506657292024-03-05T23:05:12.631+05:30SLIIT from the 'Beginning'A guide to the IT Undergraduates at SLIITTharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.comBlogger92125tag:blogger.com,1999:blog-6054025946250665729.post-1223379620108388272013-05-17T23:48:00.004+05:302013-05-17T23:54:04.542+05:30Memories of SLIIT Codefest 2012 - People's Award Winner<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: justify;">
It's been a long time since I blogged the last post.... thought of recalling the memories of the <a href="http://www.sliit.lk/index.php/content-joomla-default/101-front-page-news/1446-sliit-launches-codefest-2012-">SLIIT Code Fest 2012</a> as this year's event is coming nearby...</div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
It was the toughest coding project I've ever done up to now.... not because of it was hard.. but because of the limited time we got to develop our project... </div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
As I can remember we had the 3rd year 2nd semester exams at SLIIT until October 17th... and the Code Fest Competition was on 19th. Until the exams were over we couldn't find any time to develop something for Code Fest although we had got registered for the competition. Soon after the exam was over on 17th evening, we got together to plan something to be developed.. As always, Guru, Mihiran and Hiran were with me in the team... In order to align with the theme 'Mobile Gaming', we had to develop a game to be run on a mobile platform. The following are the photos that were taken while we were planning the game to be developed.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmAYWUmJG65IjrI-p7TxMbC_uNHkWeK6jZcXSgrCsKnVoPucsMtN0BRuDDwz5Yf9TUsGkEgBAxSlnmPy4NqBujvS7owfNVkfxqYjGcgHY5vDX4SCmYfKmyiKlXedD6ihBGv_2-QgjrqqQ/s1600/IMG_20121017_141921.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmAYWUmJG65IjrI-p7TxMbC_uNHkWeK6jZcXSgrCsKnVoPucsMtN0BRuDDwz5Yf9TUsGkEgBAxSlnmPy4NqBujvS7owfNVkfxqYjGcgHY5vDX4SCmYfKmyiKlXedD6ihBGv_2-QgjrqqQ/s320/IMG_20121017_141921.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
Guru & Mihiran</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ4II5ZPlNzSy9DNpXh8jbYvbR1nO_De5hov6kZMFUsWTHHiW8zV9ZJ1fbxSNmcgQCy7jkaYtDS-kJNl6MALjgHk49uRw7_5rluhJcvWxlfxV7UQPrVmekOaEswfcvPh5OhJTvsoDVni4/s1600/IMG_20121017_142122.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ4II5ZPlNzSy9DNpXh8jbYvbR1nO_De5hov6kZMFUsWTHHiW8zV9ZJ1fbxSNmcgQCy7jkaYtDS-kJNl6MALjgHk49uRw7_5rluhJcvWxlfxV7UQPrVmekOaEswfcvPh5OhJTvsoDVni4/s320/IMG_20121017_142122.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
Hiran & Me</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
The planning was very quick.. we had no time to waste as the clock was ticking.. I had the idea to develop a game that I used to play when I was in Grade 3 at school (in 1998) in a 2D brick game where it had a life guard and the player had to save the passengers of a sinking ship from a shark. </div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
We divided the tasks where Mihiran took over designing all the graphics in the game. I had to take over most of the coding part as Hiran and Guru were in their internships at MIT and Virtusa.. (At that time I had just finished my internship at Central Bank and was waiting for the internship at Virtusa to commence). </div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
Mihiran and I spent the 17th night at Hiran's place where we had a sleepless night developing the game.. We didn't use any game engine.. programmed everything from the scratch... We used images in the game and controlled their movements using threads. Windows Phone 7.5 was the platform we selected and used Silverlight and C# for programming. </div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
We also had to design a banner for the game to be displayed during the competition. Mihiran designed it and we printed it on a canvas. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUgY-QVcWl-tITEemMwzBGpgTkZrmrsF33NTmMq5SrIWBsJQQjOJdw70fYEKZ8vW-dfzmu82rVjwgzZIIAFAtHs0ZeDLmSkLEdQ3-LSGz0WJnypFlDLS54SkC_VuHZsBeqK445nVi3PnY/s1600/577243_4506637751584_1489859353_n.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUgY-QVcWl-tITEemMwzBGpgTkZrmrsF33NTmMq5SrIWBsJQQjOJdw70fYEKZ8vW-dfzmu82rVjwgzZIIAFAtHs0ZeDLmSkLEdQ3-LSGz0WJnypFlDLS54SkC_VuHZsBeqK445nVi3PnY/s320/577243_4506637751584_1489859353_n.jpg" width="239" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
Mihiran holding the banner he designed</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
Here's the final product. We named our game as 'Shark Attack'. It came really nicely with all the animations and graphics. </div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhA8ZY492WI8Ag317x2vpnHuyXwO9odSTkOzlNUbp1ROrzN_OrcM7IRSTIWs_sDF9HUmkjAll0qcyzAep6v4W7gESt-U3vZ4_2xxGHPrISpqzEr09SdlDLmFDcWvzsEDfHtTdubKpBIiuU/s1600/sharkattack.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhA8ZY492WI8Ag317x2vpnHuyXwO9odSTkOzlNUbp1ROrzN_OrcM7IRSTIWs_sDF9HUmkjAll0qcyzAep6v4W7gESt-U3vZ4_2xxGHPrISpqzEr09SdlDLmFDcWvzsEDfHtTdubKpBIiuU/s320/sharkattack.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Until last minute I was coding... fixing bugs in the threads.. as for each animation.. it had separate threads.. This photo was taken few minutes before the competition.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhl3wDIbnybnkicUu2mc6Nuvb2PpqfFTWnmTVhl5zajagLLRHdR8Cqi_5MBYYIe1VwkOAgILs29aSeS-6axH4rVKJQdM_4JSeZ6QrvQnISNbaryPELx9AQBaUeZ3LdyAtg57T0KHzYyiEY/s1600/58784_4403956049360_876072734_n.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhl3wDIbnybnkicUu2mc6Nuvb2PpqfFTWnmTVhl5zajagLLRHdR8Cqi_5MBYYIe1VwkOAgILs29aSeS-6axH4rVKJQdM_4JSeZ6QrvQnISNbaryPELx9AQBaUeZ3LdyAtg57T0KHzYyiEY/s320/58784_4403956049360_876072734_n.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
There were nearly 10 competitors in the Open Category. We had to present our game as the very first presentation in Open Category. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
So Finally we won the People's Award in SLIIT Code Fest 2012. It was a great experience where we programmed the game in just 1 day and still managed to win an award... </div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhUHuzzeVtXI9BgFhvakfOfktHTfttiQwL_cSr4a7KmIBDj9YGPBdIDFNG5aTVtmQ-4r2FRXTHDYkZ0gehOnvKbVkiaD70by5JIi6OXL_FRdQ4jO9GXsdazXRn0fhx98xmgwSJncS55ac/s1600/68318_4403962129512_1025084965_n.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhUHuzzeVtXI9BgFhvakfOfktHTfttiQwL_cSr4a7KmIBDj9YGPBdIDFNG5aTVtmQ-4r2FRXTHDYkZ0gehOnvKbVkiaD70by5JIi6OXL_FRdQ4jO9GXsdazXRn0fhx98xmgwSJncS55ac/s320/68318_4403962129512_1025084965_n.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Here's the award we got.. </div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbD2PDXLLW1I0jN4aN7RFq0tqAbzO_RTFYGQmAjvXgFTLkOCuOF3_Bqdnm1HyR1fnUO_zLPJEELE3cKjoFqF0A13O8J8T2QuRNQqO5KouSLxktPYUNASw14H3JNAbC1ZD7ez0y33CR7IY/s1600/22793_4403963569548_1921409603_n.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbD2PDXLLW1I0jN4aN7RFq0tqAbzO_RTFYGQmAjvXgFTLkOCuOF3_Bqdnm1HyR1fnUO_zLPJEELE3cKjoFqF0A13O8J8T2QuRNQqO5KouSLxktPYUNASw14H3JNAbC1ZD7ez0y33CR7IY/s320/22793_4403963569548_1921409603_n.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
The Team.. From left to right... Mihiran, Me, Hiran and Guru.... </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDPTOEW4C8S2l_0dEDta06P07B3vKRwxZo_zOUws9PCydAlGZaBc-rGnkleZfyC9eD-MFMmN3thFJbJJAoQ1EiOYSMq8C4afme1x_J_Qof29nAWttaPCs-wCvDLisaTwBC4jEhj7Mqphg/s1600/400225_4403965929607_421047547_n.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDPTOEW4C8S2l_0dEDta06P07B3vKRwxZo_zOUws9PCydAlGZaBc-rGnkleZfyC9eD-MFMmN3thFJbJJAoQ1EiOYSMq8C4afme1x_J_Qof29nAWttaPCs-wCvDLisaTwBC4jEhj7Mqphg/s320/400225_4403965929607_421047547_n.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Here's a promotional video prepared by Mihiran....</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</div>
<div style="text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="315" src="http://www.youtube.com/embed/Vj5t4wN41Rc" width="420"></iframe><br /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: left;">
Special thanks to Manesha Gunathillake... our Mentor of the project... who motivated and guided us.... and organized everything.. </div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Those memories will never be shaded...... great times at SLIIT..</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Tharindu Edirisinghe</div>
<div style="text-align: left;">
SLIIT 10'</div>
<div style="text-align: center;">
<br /></div>
<br /></div>
Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com0tag:blogger.com,1999:blog-6054025946250665729.post-42695518016730588992012-09-24T22:41:00.002+05:302012-09-24T22:41:27.401+05:30Algorithm Simulator Mini Version with Source Code<div class="separator" style="clear: both; text-align: justify;">
Once year back when I was in the 2nd year, I programmed the <a href="http://thariya.blogspot.com/2011/09/algorithm-simulator-insertion-sort.html">Algorithm Simulator</a> to demonstrate the three sorting algorithms : Insertion Sort, Selection Sort and Bubble Sort. I released the source code also but due to lack of time, the code was not well documented or commented so that I received so many comments from those who went through the code that it was too difficult to understand. I'm glad that many found the project useful and therefore I'm releasing a mini version of the simulator with less number of code lines so that it can be understood easily. Here are some screen shots of the application. Find the download link at the end of the post.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYVGLtZu41xvqLEiKa2s8ZGjsgOcWBhf_-aJD2WpJDd_oYpANsLrbInvaGwdIk9G_L0EPq0Fe5ax9E_COcdKfZjwuioAyWzirc2InCuG0dgCfxnXBPAToskYC0Z8JRlUytJUbQn8wUFzQ/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYVGLtZu41xvqLEiKa2s8ZGjsgOcWBhf_-aJD2WpJDd_oYpANsLrbInvaGwdIk9G_L0EPq0Fe5ax9E_COcdKfZjwuioAyWzirc2InCuG0dgCfxnXBPAToskYC0Z8JRlUytJUbQn8wUFzQ/s320/1.png" width="166" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaeWFpcnUEbsaci7v-eGwdaXzn3JcIvRvQlmZLB_-5gSY48IfDC30gxJTA3PoZnJjuRjq6LZiXbQLWjPZwiDuEY0XBmlXVmicscB50TP2QyLmuw1rJU-5QWYvX0MWvV79TfEFl80_kzMg/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaeWFpcnUEbsaci7v-eGwdaXzn3JcIvRvQlmZLB_-5gSY48IfDC30gxJTA3PoZnJjuRjq6LZiXbQLWjPZwiDuEY0XBmlXVmicscB50TP2QyLmuw1rJU-5QWYvX0MWvV79TfEFl80_kzMg/s320/2.png" width="170" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv-A2tl-v6zrNIi6ToPG0CZiiWpgN77mhPDygBro_Ng5LO6BndGuW-q83jsJyU6BPan3ssY0WCKx_u5AyyBPHpXawKrvi1JiUaslIfVW7TTVj-p5sA46ohW4Z29N1uPuxA-Jx34Gss7FQ/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv-A2tl-v6zrNIi6ToPG0CZiiWpgN77mhPDygBro_Ng5LO6BndGuW-q83jsJyU6BPan3ssY0WCKx_u5AyyBPHpXawKrvi1JiUaslIfVW7TTVj-p5sA46ohW4Z29N1uPuxA-Jx34Gss7FQ/s320/3.png" width="168" /></a></div>
<br />
<div>
<br /></div>
<div>
<a href="http://www.mediafire.com/?cya8z962hvfvpro">Click Here to Download</a> the Visual Studio Project (48.21 KB)</div>
<div>
<br /></div>
<div>
-Tharindu Edirisinghe</div>
<div>
-SLIIT 10'</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com0tag:blogger.com,1999:blog-6054025946250665729.post-30367764875407035412012-09-12T10:09:00.001+05:302012-09-12T10:09:24.190+05:30Blend for Visual Studio 2012 - Not working ???<div style="text-align: justify;">
Recently I installed Microsoft Visual Studio 2012 which comes with the .NET framework 4.5. Unlike the previous versions in VS, the new one comes with Blend inbuilt. After the installation, VS 2012 worked perfectly but when I tried to run Blend for Visual Studio 2012, it gave me the following error message. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJFFH0xXy5VSytOXETxjyF5FRfe4aFPPymHjNNnFxTTISrc6RV_rsbDdsltEQl-1r21OpR2fx2A8yH-7Ik3Jf1Ql1u0Ghny4vWERFuuz9HZJed8E8Dq0MQ8TMbbSHLIXdHPdg4-BvbDds/s1600/blend+error.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="85" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJFFH0xXy5VSytOXETxjyF5FRfe4aFPPymHjNNnFxTTISrc6RV_rsbDdsltEQl-1r21OpR2fx2A8yH-7Ik3Jf1Ql1u0Ghny4vWERFuuz9HZJed8E8Dq0MQ8TMbbSHLIXdHPdg4-BvbDds/s320/blend+error.png" width="320" /></a></div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: justify;">
I followed the link displayed in the message to install the Blend + SketchFlow Preview for Visual Studio 2012. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8XHjjanChDHc4gWH-3aSD40Lp1HzOpm6m9F7MjdHeZY69LS4lZra-B0nbfujnq6EOJwN4jQWyf5qOse_pv2bpdflhVFNm-YYsCsJEI6PXDZ_LNBSTvT7apYGcgisRAWStG_Pu94Z46vg/s1600/blend+and+sketch+flow.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8XHjjanChDHc4gWH-3aSD40Lp1HzOpm6m9F7MjdHeZY69LS4lZra-B0nbfujnq6EOJwN4jQWyf5qOse_pv2bpdflhVFNm-YYsCsJEI6PXDZ_LNBSTvT7apYGcgisRAWStG_Pu94Z46vg/s320/blend+and+sketch+flow.png" width="320" /></a></div>
<div style="text-align: justify;">
Then I downloaded the preview from the Microsoft Expression website which was 102.3MB. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihioVPvU8UB7fEqAx2lEDz_E1KMp2aZ3UbY4-GDp8RBYJdOFzZnmx8_Ysut3LziIWIaqbI9iBTcaDiuP1NX6u39b1ai-X7VOwFEuYHviV3lwZ6npRPTCIuyC44PEmlvA9nN8XOetf4um0/s1600/before+downloading.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihioVPvU8UB7fEqAx2lEDz_E1KMp2aZ3UbY4-GDp8RBYJdOFzZnmx8_Ysut3LziIWIaqbI9iBTcaDiuP1NX6u39b1ai-X7VOwFEuYHviV3lwZ6npRPTCIuyC44PEmlvA9nN8XOetf4um0/s320/before+downloading.png" width="320" /></a></div>
<div style="text-align: justify;">
I followed the installation steps as shown in the images below.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNTPnVIBsi-BxvKX1nFfTjAy5TMerqAFsTPcbr7IDARVYL0HDDQwEIeMIokpRoco4UEaCD6sHwsr6ZZpkd2yN4X-w8gqsyhyphenhyphenHwmohZ60Fs1F95gFjo12Kc4E1TmvsHeQHX0wXlPu2USY0/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="224" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNTPnVIBsi-BxvKX1nFfTjAy5TMerqAFsTPcbr7IDARVYL0HDDQwEIeMIokpRoco4UEaCD6sHwsr6ZZpkd2yN4X-w8gqsyhyphenhyphenHwmohZ60Fs1F95gFjo12Kc4E1TmvsHeQHX0wXlPu2USY0/s320/11.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxyMs1knqhKraJHZAxJiK0DNqu-nEr5UnmW1KoIght5IxNbumlg0WzNvZ6p89MTY1w3-FwHHugYtXJL3Qq5gpOp_ml1DSbkOH5WVSEU6AsRS5JTkt0se1UG4hHjG15Y4_CQ71UGz9jET0/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="224" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxyMs1knqhKraJHZAxJiK0DNqu-nEr5UnmW1KoIght5IxNbumlg0WzNvZ6p89MTY1w3-FwHHugYtXJL3Qq5gpOp_ml1DSbkOH5WVSEU6AsRS5JTkt0se1UG4hHjG15Y4_CQ71UGz9jET0/s320/12.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_d4Dv2n1yc5qu0mT1n0twiyWD1DrWovMXhpyR_QnKZHiLZZ_LVSsk-7uXZ9A7RjLO4SaL28oo9Xsoxg8Rd4PI3bK268HjjwXuB9OUv-Ff1soH0SwmLInjDcuW8vYQ7JXH9msDkofQCUc/s1600/13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="224" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_d4Dv2n1yc5qu0mT1n0twiyWD1DrWovMXhpyR_QnKZHiLZZ_LVSsk-7uXZ9A7RjLO4SaL28oo9Xsoxg8Rd4PI3bK268HjjwXuB9OUv-Ff1soH0SwmLInjDcuW8vYQ7JXH9msDkofQCUc/s320/13.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5aP0GjPKmNarBoknOpuQrJipNDCJ-HdJeyKkcQEdNaL3eALfwm6oQ7EJUBQesSJB22Rp11qAEtE7hKoG3-iQtZRGjiq4nfdspDn55pCz4DXJ-tARA7z2Jl2Na6zJ_RNZrlNC3ueoLJzo/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5aP0GjPKmNarBoknOpuQrJipNDCJ-HdJeyKkcQEdNaL3eALfwm6oQ7EJUBQesSJB22Rp11qAEtE7hKoG3-iQtZRGjiq4nfdspDn55pCz4DXJ-tARA7z2Jl2Na6zJ_RNZrlNC3ueoLJzo/s320/14.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgW-kwwdLvIa7lEGQF6BQRmGZKj0QvsSZ1EjNlMsR-tHSDuLxg89aXHZzOgggdWnKAwh1iQMUQoRaDxlfKvYXak8dElFrIgBtyszsMPxkwLJ_sLZkiBSIRBvulSSBxscw4YFa9j64BsW38/s1600/15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgW-kwwdLvIa7lEGQF6BQRmGZKj0QvsSZ1EjNlMsR-tHSDuLxg89aXHZzOgggdWnKAwh1iQMUQoRaDxlfKvYXak8dElFrIgBtyszsMPxkwLJ_sLZkiBSIRBvulSSBxscw4YFa9j64BsW38/s320/15.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Even after installing the preview, Blend for Visual Studio 2012 gave the same error message. Instead of that, the newly installed Blend + SketchFlow Preview for Visual Studio 2012 worked without any issue.</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGBhfNPyam1krfAkVk7_dFFOt24t5nABif8mfkyfNrTth-CkhchW1kBo6NXIV0mLM1LEMD3FB4biwKq8T3bhkX-NvX5WNNvQi0E__GqRtrPw_jOwMM0uOGr569g7oJ9Ghs_zWkDcM0QBQ/s1600/16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGBhfNPyam1krfAkVk7_dFFOt24t5nABif8mfkyfNrTth-CkhchW1kBo6NXIV0mLM1LEMD3FB4biwKq8T3bhkX-NvX5WNNvQi0E__GqRtrPw_jOwMM0uOGr569g7oJ9Ghs_zWkDcM0QBQ/s320/16.png" width="198" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2_D9vyVvAq67ulFNikG8y6Dls3o8_bDh2KZX3NTtj-LV5j2yS6nVvHY_aPJ06Ll0L7KsM4niPMc-gtyRmhPxJ2qQuUa9rQX-r6gBgkytfSH_6iD7cBkF_M3Y8v6A-jiDA0a7wlimEc2I/s1600/17.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2_D9vyVvAq67ulFNikG8y6Dls3o8_bDh2KZX3NTtj-LV5j2yS6nVvHY_aPJ06Ll0L7KsM4niPMc-gtyRmhPxJ2qQuUa9rQX-r6gBgkytfSH_6iD7cBkF_M3Y8v6A-jiDA0a7wlimEc2I/s320/17.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsZSlQngesU8ZFNU6H2080mslMj_dKiga1M8PK-GwpfS0UH1eTTFWnyl3JGxkSU-1fJ7fvkA0RBCgQ4RgqlNAmsUO3qWgPpu2wcaweHrr6BRadk2Dl1KZMNqGvqiISSJgVS2lbZEXOLkw/s1600/18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsZSlQngesU8ZFNU6H2080mslMj_dKiga1M8PK-GwpfS0UH1eTTFWnyl3JGxkSU-1fJ7fvkA0RBCgQ4RgqlNAmsUO3qWgPpu2wcaweHrr6BRadk2Dl1KZMNqGvqiISSJgVS2lbZEXOLkw/s320/18.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
The new features of Blend are yet to be tried out. If anybody already gave it a try, feel free to give your comments.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
-Tharindu Edirisinghe</div>
<div class="separator" style="clear: both; text-align: left;">
-SLIIT 10'</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com5tag:blogger.com,1999:blog-6054025946250665729.post-6886392440198290112012-04-19T13:52:00.001+05:302012-04-19T13:52:42.702+05:30How to Create a Basic Crystal Report using Windows Forms and C#<div style="text-align: justify;">
From this post, I will show you how to create a basic Crystal Report. You don't need to have previous knowledge in reporting. Just a little bit knowledge in C# and SQL would be enough.<br />
<br />
In SQL Server, I'm creating a database named 'Company' and inside that I have a table named 'Employee'. An employee has an id, a name and a designation. Sample values are added into the Employee table.</div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmZP3MsKJ48YIRyP4N7ECkfiLQ09bYOm4VzutFNN1mkqri_Gj0pfEBkERV5k0fxLpD8m-qb-jfLBVkriC_z9UuMwXnFj9OTvWYOHYvApAA-0MXhAs8wFl3sezjHlGbv3_lh4MglrugZbg/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmZP3MsKJ48YIRyP4N7ECkfiLQ09bYOm4VzutFNN1mkqri_Gj0pfEBkERV5k0fxLpD8m-qb-jfLBVkriC_z9UuMwXnFj9OTvWYOHYvApAA-0MXhAs8wFl3sezjHlGbv3_lh4MglrugZbg/s320/1.png" width="320" /></a></div>
Then in Microsoft Visual Studio, I'm creating a Windows Forms Application.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja9v2T4N1sXKTpWWegzaPrPwb5kda6U6ShGipNk4ehHPsxMYOOdIEecm87nqlY7qVOyzrDxVPjnwan5mh58Bxb6dFflRX-x10QDjHWx7kEup9hkuNqIkCZlekYHoVKpVWwm6klCNcQzMM/s1600/2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja9v2T4N1sXKTpWWegzaPrPwb5kda6U6ShGipNk4ehHPsxMYOOdIEecm87nqlY7qVOyzrDxVPjnwan5mh58Bxb6dFflRX-x10QDjHWx7kEup9hkuNqIkCZlekYHoVKpVWwm6klCNcQzMM/s320/2.PNG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
Then I need to add a data source to the project. Right click on the project in Solution Explorer. Select Add and Click on New Item.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTcL8mqAu_Nk8TDthF61HV7F_fs2b2bfRURTwjAALhzNJUS7q5lv_Ocor4zKEkUFfmh3oUu7iCvnbsn-wNCKeT0rpsP-N8yOU8JUrDij0TMePfjWO1rkRkT5TXbU0LjHgYQ83IwfsNn08/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTcL8mqAu_Nk8TDthF61HV7F_fs2b2bfRURTwjAALhzNJUS7q5lv_Ocor4zKEkUFfmh3oUu7iCvnbsn-wNCKeT0rpsP-N8yOU8JUrDij0TMePfjWO1rkRkT5TXbU0LjHgYQ83IwfsNn08/s320/3.png" width="243" /></a></div>
Then in the dialog box, select 'Data' as the Category and from Template, select DataSet. The name for the new data set is given as EmployeeDataSet.xsd in this example. Then click Add.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyRPij_Bv13vvnBBRCSY8zKY89SmFGo43OmCRDH3E3xcgR0CdiEaAORuDke14nCaGej1AuTA69nEDWn1oXXW5WJBn7u7uPWN9k9Zj-_GpK6tX_06JfOS199_uzSUg7uzaJv0DQM8ZkCaU/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="194" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyRPij_Bv13vvnBBRCSY8zKY89SmFGo43OmCRDH3E3xcgR0CdiEaAORuDke14nCaGej1AuTA69nEDWn1oXXW5WJBn7u7uPWN9k9Zj-_GpK6tX_06JfOS199_uzSUg7uzaJv0DQM8ZkCaU/s320/4.png" width="320" /></a></div>
Then the EmployeeDataSet.xsd file will be opened. If not open it from the Solution Explorer. In the Toolbox, under DataSet, click on the TableAdapter, drag it to the working area and drop it.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdF1QVi6KVXfWpX0FCFjl6gYF1eUhARCC0GEyJEOFLvrIRJPASVd8KyBzumozJyl_Vf24zY8mBy1gNet_RSPMkfecMWc7k9H_X6aXOPyJEyvijbdQRpggmL5YI7H-xJ1g58G2EyFC2_gk/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="232" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdF1QVi6KVXfWpX0FCFjl6gYF1eUhARCC0GEyJEOFLvrIRJPASVd8KyBzumozJyl_Vf24zY8mBy1gNet_RSPMkfecMWc7k9H_X6aXOPyJEyvijbdQRpggmL5YI7H-xJ1g58G2EyFC2_gk/s320/5.png" width="320" /></a></div>
Then the Table Adapter Configuration Wizard will be opened.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiz7JeWx9PBpvBEw_SrgScWE9ic3uRrPpqXLHVIrApYZjdPZJh2nd70qWg0IjLW0AxfUaQ31VTFVQJTr_zGywu-k3f25o1plYKZzASitXra_KvEA2GKVuOowIK3zlLAkgyBxchReCPnnm8/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="78" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiz7JeWx9PBpvBEw_SrgScWE9ic3uRrPpqXLHVIrApYZjdPZJh2nd70qWg0IjLW0AxfUaQ31VTFVQJTr_zGywu-k3f25o1plYKZzASitXra_KvEA2GKVuOowIK3zlLAkgyBxchReCPnnm8/s320/6.png" width="320" /></a></div>
Click on New Connection. Then give the database details appropriately. In this example, server name is localhost and the database is Company. Then test the connection.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZNBjm90KRMpoNUMaaPx3Mr3GKVhBEqQ4xfXjZa3IYKXbS7LkASOUZIO152ADMS_OLAfLPGpZWnvc5ZYSw6JS_vyVyjNiLAAp-4e1_yKRZJYKyJuvnLeml_J-tg62zBIBgu7fs8eKweiQ/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZNBjm90KRMpoNUMaaPx3Mr3GKVhBEqQ4xfXjZa3IYKXbS7LkASOUZIO152ADMS_OLAfLPGpZWnvc5ZYSw6JS_vyVyjNiLAAp-4e1_yKRZJYKyJuvnLeml_J-tg62zBIBgu7fs8eKweiQ/s320/7.png" width="220" /></a></div>
Once the connection is successful, click OK.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic9E29NVXH5_3B_ONY96916-M4XOphvIjxlbQYdfXoWNk6y_f17SRWFzsC6rPLD7MfuJZuzZJ3mpx6Yn626oYf0sBtpC9BK6uYxEiSdO3Wqp4_8BxedqXbm7mtPop3F9thT-QMqbgWgus/s1600/8.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic9E29NVXH5_3B_ONY96916-M4XOphvIjxlbQYdfXoWNk6y_f17SRWFzsC6rPLD7MfuJZuzZJ3mpx6Yn626oYf0sBtpC9BK6uYxEiSdO3Wqp4_8BxedqXbm7mtPop3F9thT-QMqbgWgus/s1600/8.PNG" /></a></div>
Now the connection string is created. Click next in the Table Adapter Configuration Wizard.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2EoM7tN3oUpLB2NN0gGQO5hLrW07txfAUzNTylXPgBsQKzb0vnKnTULs9ccJG46vxaRszYHPoTS0-eXF30GnlSasqUK9ECGUflyyMMvDghlO3a9dOsA3TiGCB_4ZjqafkR4EJ8rdBJcg/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2EoM7tN3oUpLB2NN0gGQO5hLrW07txfAUzNTylXPgBsQKzb0vnKnTULs9ccJG46vxaRszYHPoTS0-eXF30GnlSasqUK9ECGUflyyMMvDghlO3a9dOsA3TiGCB_4ZjqafkR4EJ8rdBJcg/s320/9.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
In the next window, you can give a name for the connection string. For my convenience, I'll leave the default name. Then click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDmGJlJIAsVJq3dHG2HC8h_MbgC5NZbCi1R_fVPaWTJ0RSG2GHmmVPquAhecR-AEJGgYE8VZzHdWqgjwHC-PAn56rgXTgDbSFGn7x3qPh8meUagbiCpw_QbFlbB2gEEpvWOwr5A3b11uc/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="196" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDmGJlJIAsVJq3dHG2HC8h_MbgC5NZbCi1R_fVPaWTJ0RSG2GHmmVPquAhecR-AEJGgYE8VZzHdWqgjwHC-PAn56rgXTgDbSFGn7x3qPh8meUagbiCpw_QbFlbB2gEEpvWOwr5A3b11uc/s320/10.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
In the next window, select 'Use SQL Statements' and click Next.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWPFBV-Jb9zT5Pk0YaYjN-ul1Gs2UFZaCDhfX4BJ9FoE_QAHur3vi1RWfZqnKVNy_qbkSmy-dXiMVy6pakEFvVOkfOXAIGqD01kYnYdFLXBiICBop992IAGzfNGuL_5Twey2CdnLcHym0/s1600/12.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="194" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWPFBV-Jb9zT5Pk0YaYjN-ul1Gs2UFZaCDhfX4BJ9FoE_QAHur3vi1RWfZqnKVNy_qbkSmy-dXiMVy6pakEFvVOkfOXAIGqD01kYnYdFLXBiICBop992IAGzfNGuL_5Twey2CdnLcHym0/s320/12.PNG" width="320" /></a></div>
In the next window, you can specify the SQL query for the table adapter. I'll use the Query Builder to build the query.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHiej2EvG8xWil1uNcs7NL8Dj7AUSX4AnhCBnj0vdT4_dV0BEO61UU5bujU6qqPzJr6B7748L-tdYBkhFPTeR0K0Yyv7DpiOlKyzTRjZZjHSY09FjM_1OH7jCIKz7fo6oax5KWvX9c07E/s1600/13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHiej2EvG8xWil1uNcs7NL8Dj7AUSX4AnhCBnj0vdT4_dV0BEO61UU5bujU6qqPzJr6B7748L-tdYBkhFPTeR0K0Yyv7DpiOlKyzTRjZZjHSY09FjM_1OH7jCIKz7fo6oax5KWvX9c07E/s320/13.png" width="320" /></a></div>
In the Add Table window, select the tables you want for the query and click on Add. Then close the window. In this example I'm adding the Employee table.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFArPpEoIgUyX3Fu4yp8LN7a4ibbC05Oo4VgzPsVx-6rznXPXpx1R1O7ceTrVbws6cdH71UPKi5fMY_nhjfwL_OMONodZpo25XlHFz2Hd1ysgR542HbNbuF9FU3cfjpRd_4M45uFV0Bas/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFArPpEoIgUyX3Fu4yp8LN7a4ibbC05Oo4VgzPsVx-6rznXPXpx1R1O7ceTrVbws6cdH71UPKi5fMY_nhjfwL_OMONodZpo25XlHFz2Hd1ysgR542HbNbuF9FU3cfjpRd_4M45uFV0Bas/s320/14.png" width="320" /></a>\</div>
<div class="separator" style="clear: both; text-align: left;">
Then select the columns needed for the query and click Execute Query to view the result. Then click OK.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRlisl7di7jX4vWo9Do0AltXIF7815wlcGi-2zrdGIvVkzRBZZRU8qtFWAoktjM5QHVrhGuw1I8vVteSxUH6PSsaJkD0Q_cwVur5-_3ga8PIKuGucRhdWTEzyduvkzXzIHTd6DoFJqOo4/s1600/15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="261" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRlisl7di7jX4vWo9Do0AltXIF7815wlcGi-2zrdGIvVkzRBZZRU8qtFWAoktjM5QHVrhGuw1I8vVteSxUH6PSsaJkD0Q_cwVur5-_3ga8PIKuGucRhdWTEzyduvkzXzIHTd6DoFJqOo4/s320/15.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Now the query is successfully built. Click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoj0JdxhBS3elmgjJiwfbMF6TuE7nzguNCI4jGEU_Capyx4c0yfWBSL8r36R9m3veajdnn5bD7hJdVZl-mc4gGSrVT-vN0O_JGcNZqofCdaHdk8iwLNIUTM_duyMjUxkv3d68crBmkkGc/s1600/16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoj0JdxhBS3elmgjJiwfbMF6TuE7nzguNCI4jGEU_Capyx4c0yfWBSL8r36R9m3veajdnn5bD7hJdVZl-mc4gGSrVT-vN0O_JGcNZqofCdaHdk8iwLNIUTM_duyMjUxkv3d68crBmkkGc/s320/16.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
Make the selections as shown in the following image and click Next.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTuUTN_GlMr_bozz-4dfBPeTAbnJHPuNbMMSv9u8WHMMU6luzNRCUfqkbxU4jyUaWUgH4z-0LVON6yycvRKjU3eI6_0Z6LYiovodP-_6pd2QOzlkrky8-tyQvZ3QvykPifgWvUJqoVAlw/s1600/17.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTuUTN_GlMr_bozz-4dfBPeTAbnJHPuNbMMSv9u8WHMMU6luzNRCUfqkbxU4jyUaWUgH4z-0LVON6yycvRKjU3eI6_0Z6LYiovodP-_6pd2QOzlkrky8-tyQvZ3QvykPifgWvUJqoVAlw/s320/17.png" width="320" /></a></div>
Now the table adapter is successfully configured. Click Finish.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYvyRt0wWWDFcNhjEFGsRavGxySdmy0dQb2PtsV2XLs2VCniCFxiAdj23qwZiVviCagIXMG4sWLgoIUH5ZAku4kMl8agT3DUDQGce-uVsYbuwIkrG2MdPMickEeMxhdYmpOl68k7vnv44/s1600/18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYvyRt0wWWDFcNhjEFGsRavGxySdmy0dQb2PtsV2XLs2VCniCFxiAdj23qwZiVviCagIXMG4sWLgoIUH5ZAku4kMl8agT3DUDQGce-uVsYbuwIkrG2MdPMickEeMxhdYmpOl68k7vnv44/s320/18.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
Now you can see the configured table adapter in the working area.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0fYbTM-cMX2CitQLf1sFvUJAnayHnq6cZ3kqhKiDZmAVXuXadc4bIyv6Oxj_d4Hn6r-IvMC82ZmEr3bFKOFP2xCF5RA-ivT0TiPRAke4PNFaT2K3SEKBNpldVz1Wq_uPxKANdtUbCxPg/s1600/19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0fYbTM-cMX2CitQLf1sFvUJAnayHnq6cZ3kqhKiDZmAVXuXadc4bIyv6Oxj_d4Hn6r-IvMC82ZmEr3bFKOFP2xCF5RA-ivT0TiPRAke4PNFaT2K3SEKBNpldVz1Wq_uPxKANdtUbCxPg/s320/19.png" width="318" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Now we need to add a Crystal Report to the project. Right click on the project in the Solution Explorer and select Add -> New Item. From the categories, select Reporting and from the Templates, select Crystal Report. The name given for the report in this example is EmployeeReport.rpt . Then click Add.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfCUXeNRse4XO7oHEKDwPtnS14TeIBu_X1zmOxNg0-P4NusXDLf_ZddpN47GEPxYRrUa4gZc8tEuWy3Sb8aj8EaYCAN4Ll-8u9BFKQeL0n5twuhyZNc9lnV9Ms_dumdbS9l0vL1JgTf9Y/s1600/20.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfCUXeNRse4XO7oHEKDwPtnS14TeIBu_X1zmOxNg0-P4NusXDLf_ZddpN47GEPxYRrUa4gZc8tEuWy3Sb8aj8EaYCAN4Ll-8u9BFKQeL0n5twuhyZNc9lnV9Ms_dumdbS9l0vL1JgTf9Y/s320/20.png" width="320" /></a></div>
Here I'm creating a Standard Report using the Reporting Wizard.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzesAw0RB9me1SZ_Okmppa-uk-6NGvSjjktkbF9SU2IbwdpuMg9tXQR23LKTqSlWnhJHWflEXVWQ5gkACh2yvd5q94xR5CHVNZj37bgKOEcHk0qUHkbgyKBHD-vr6Fy4i0NPVo60hWtuo/s1600/21.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzesAw0RB9me1SZ_Okmppa-uk-6NGvSjjktkbF9SU2IbwdpuMg9tXQR23LKTqSlWnhJHWflEXVWQ5gkACh2yvd5q94xR5CHVNZj37bgKOEcHk0qUHkbgyKBHD-vr6Fy4i0NPVo60hWtuo/s320/21.png" width="271" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
In the wizard, select the data table that you want in the report. Here I'm selecting the Employee table. Then click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit5Byzv6pNUo7CDiaWj0HtosPNScQY8PZ2H9n4UoCjUpE8x1OE8BJds7e6VdgyleqlDlHQEoGUATZWMJsL0V4w6l9woHCApQl669NOCOfABdgZI9eh0PbL-oC5wKlSLYEUjIuOhw9Slko/s1600/22.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit5Byzv6pNUo7CDiaWj0HtosPNScQY8PZ2H9n4UoCjUpE8x1OE8BJds7e6VdgyleqlDlHQEoGUATZWMJsL0V4w6l9woHCApQl669NOCOfABdgZI9eh0PbL-oC5wKlSLYEUjIuOhw9Slko/s320/22.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Then select the fields to be displayed in the report and click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTV777QBK9j-KiuIhZkOREhMNA3oVqdmqaP5oPxybSGx72dXJQ53CG2nHv7U7mD1lNUymKo8CnVvC2Uq7oG-dHTKDyrStHiqC29UGd7DyM_Z23_UCVy6ck_COlV1CzENNNYVBuchHnzDs/s1600/23.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTV777QBK9j-KiuIhZkOREhMNA3oVqdmqaP5oPxybSGx72dXJQ53CG2nHv7U7mD1lNUymKo8CnVvC2Uq7oG-dHTKDyrStHiqC29UGd7DyM_Z23_UCVy6ck_COlV1CzENNNYVBuchHnzDs/s320/23.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
Next thing is Grouping. Here I don't want to group the displaying fields. So I'll click Next without making any selection.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyWA1-G-V-pmIDexfHDTI9UC7lOcn0fN4gBG5FwCxZCATCdEJnGPAWBTK_zwcrolCcH3uOiUl-zAydECUTZGJptnLjMsRpO6lamo-lxW7qIUcWds-_eIg_-zjVBBdOdcKgEDPGzWNYkDU/s1600/24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyWA1-G-V-pmIDexfHDTI9UC7lOcn0fN4gBG5FwCxZCATCdEJnGPAWBTK_zwcrolCcH3uOiUl-zAydECUTZGJptnLjMsRpO6lamo-lxW7qIUcWds-_eIg_-zjVBBdOdcKgEDPGzWNYkDU/s320/24.png" width="320" /></a></div>
Next thing is filtering fields. Here I don't need any filtering so I'll click Next.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQloo87860iGPtJya0u2TTTbzfMpkHf4YOQUrnkYPP2ax4KpxFBiq01EcBw3iQDOGW3m_dm9YnjOj-aPrSJaVccoYCcTBuJPHAKi6JLfvX7MeQTfhIykruSCVqKH8XKuBlehG3ee6K3YI/s1600/25.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="271" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQloo87860iGPtJya0u2TTTbzfMpkHf4YOQUrnkYPP2ax4KpxFBiq01EcBw3iQDOGW3m_dm9YnjOj-aPrSJaVccoYCcTBuJPHAKi6JLfvX7MeQTfhIykruSCVqKH8XKuBlehG3ee6K3YI/s320/25.png" width="320" /></a></div>
Next thing is selecting a style for the report. I'll select Standard style and click Finish.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsKtzUFpP5UucmIb7pyud0cNdVyEiwGVcdjPt6Bh0TT-lWwkXL7bFskXGjnbuKsWmXHtYBYjW_SIObU3_OFXFY8wR9gatCtH-1viQteBsNjnM3nqjl4_p1KbZgFdzvrcEpBhay4oYzgEs/s1600/26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="271" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsKtzUFpP5UucmIb7pyud0cNdVyEiwGVcdjPt6Bh0TT-lWwkXL7bFskXGjnbuKsWmXHtYBYjW_SIObU3_OFXFY8wR9gatCtH-1viQteBsNjnM3nqjl4_p1KbZgFdzvrcEpBhay4oYzgEs/s320/26.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Now the report is created. You can drag the fields and customize the appearance. Add lines and images if you need. I'll just leave it as it is.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfOoByMBmxdht1_WRpR4R2HaYpJPO89-nZfs7fAf5gUgDpSqU7vcSB_hcM0uEx5mn37VU-17xba-uZFF_cmkN-2Hy6wIHvefa8QGsaO-tzg-dKUfubXIHqb-TG2JN_As8-ycYNmaNkSSU/s1600/27.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="120" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfOoByMBmxdht1_WRpR4R2HaYpJPO89-nZfs7fAf5gUgDpSqU7vcSB_hcM0uEx5mn37VU-17xba-uZFF_cmkN-2Hy6wIHvefa8QGsaO-tzg-dKUfubXIHqb-TG2JN_As8-ycYNmaNkSSU/s320/27.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Now the designing is over. Now we need to view the report. Get the Windows Form (here Form1). In Tool box, under Reporting menu, click on the Crystal Report Viewer and drag it to the form and drop. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8linKzDrmOBW5Sv_s6NuHLKPoctxqKQEufqx7xXaQYECTTXhfoWY7mNcuaOTffloODrR8bKZxsb9kJD7h_ngiywcqaJxVA4tfyQEM7nxaF-wCaZRR41f0m1DBpNrZh31y__bEh8TRKc8/s1600/28.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8linKzDrmOBW5Sv_s6NuHLKPoctxqKQEufqx7xXaQYECTTXhfoWY7mNcuaOTffloODrR8bKZxsb9kJD7h_ngiywcqaJxVA4tfyQEM7nxaF-wCaZRR41f0m1DBpNrZh31y__bEh8TRKc8/s320/28.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
Now we need to write little bit coding to display data on the report viewer. Go to the Form Load event and write the following code.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi33s3ZmEHS17hp795_9mZjN5eIwHTkfO2nv0W1x8hgtZQBjVLbTB4VLr9ayUAvQKd0SGGiHT4PBo50vpJE4x_nxwz9CM6Zp2ejT55ugXxoQO4KQ-BkEy2WAm-jKK0juXyGg1cMwQFXcIg/s1600/29.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi33s3ZmEHS17hp795_9mZjN5eIwHTkfO2nv0W1x8hgtZQBjVLbTB4VLr9ayUAvQKd0SGGiHT4PBo50vpJE4x_nxwz9CM6Zp2ejT55ugXxoQO4KQ-BkEy2WAm-jKK0juXyGg1cMwQFXcIg/s320/29.png" width="320" /></a></div>
Now run the project and see the output report.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvIQ74p-KbDwGkqnhyccrA7aFQAsmBi88mOjO1pDJnDJpx-UN1ETcvFVZ6Uywdk5T5kotAShGvo93EiWslvDHP6VBjoh_bJq-6AkcUbgW6pRfgtbWeBKKS_Zeu4XH0RkKGYyPyZJCHS0w/s1600/30.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvIQ74p-KbDwGkqnhyccrA7aFQAsmBi88mOjO1pDJnDJpx-UN1ETcvFVZ6Uywdk5T5kotAShGvo93EiWslvDHP6VBjoh_bJq-6AkcUbgW6pRfgtbWeBKKS_Zeu4XH0RkKGYyPyZJCHS0w/s320/30.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="http://www.mediafire.com/?zk3h14117l4vij0">Download the Visual Studio Project Source Code from Here.</a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Feel free to put your comments here !</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
-Tharindu Edirisinghe</div>
<div class="separator" style="clear: both; text-align: left;">
-SLIIT 10'</div>
<br />Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com73tag:blogger.com,1999:blog-6054025946250665729.post-62524560311114615522012-04-06T10:21:00.001+05:302012-04-06T10:21:09.571+05:30MySQL Basics for beginners<div style="text-align: justify;">
I thought of writing this post as a reply for a comment published in the last post I wrote on connectivity of <a href="http://thariya.blogspot.com/2012/04/java-mysql-and-ireports-st-ii.html">Java and MySQL</a>. From a previous post I showed you<a href="http://thariya.blogspot.com/2011/05/how-to-install-and-configure-mysql-on.html"> how to install and configure MySQL</a> server on your PC. From this post you can learn some of the basic but essential operations you can do using MySQL. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
First open the command prompt. These are the very first commands you should give.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
For normal login to MySQL server, type <span style="color: purple;">mysql</span> and press Enter.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
If you have a user name but no password, type the following and press Enter. Here my user name is 'root'.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="color: purple;">mysql -u root</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
If you have a username and also a password, type the following and press Enter. Here my user name is 'root'.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="color: purple;">mysql -u root -p</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Then it will prompt to enter the password. Type the password and press Enter.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Now you have successfully logged into the MySQL server. In your command prompt, the following will appear.</div>
<div style="text-align: justify;">
<span style="color: red;">mysql ></span></div>
<div style="text-align: justify;">
<span style="color: red;"><br /></span></div>
<div style="text-align: justify;">
Now let's see how to view all the databases currently in the server. The command is,</div>
<div style="text-align: justify;">
<span style="color: purple;">show databases;</span></div>
<div style="text-align: justify;">
<span style="color: purple;"><br /></span></div>
<div style="text-align: justify;">
The command to create a new database is the following. Assume my database name is sliit.</div>
<div style="text-align: justify;">
<span style="color: purple;">create database sliit;</span></div>
<div style="text-align: justify;">
<span style="color: purple;"><br /></span></div>
<div style="text-align: justify;">
In order to manipulate data inside a database, first we need to go inside the particular database. The command is the following. Assume my database name is sliit.</div>
<div style="text-align: justify;">
<span style="color: purple;">use sliit;</span></div>
<div style="text-align: justify;">
<span style="color: purple;"><br /></span></div>
<div style="text-align: justify;">
Now you are inside the database. You can view the tables inside the database using this command.</div>
<div style="text-align: justify;">
<span style="color: purple;">show tables;</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
You can create tables using MySQL statements that you already know. Given below is an example.</div>
<div style="text-align: justify;">
<span style="color: purple;">CREATE TABLE Students</span></div>
<div style="text-align: justify;">
<span style="color: purple;">(</span></div>
<div style="text-align: justify;">
<span style="color: purple;"> id INT PRIMARY KEY,</span></div>
<div style="text-align: justify;">
<span style="color: purple;"> name VARCHAR(20)</span></div>
<div style="text-align: justify;">
<span style="color: purple;">);</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
To view data in a table, you can easily type a query like this.</div>
<div style="text-align: justify;">
<span style="color: purple;">SELECT * FROM Students;</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
I hope now you are familiar with the basics. If you don't like to work in command line, there is a tool called 'MySQL GUI Tools'. It provides a easy to use graphical user interface to handle MySQL operations. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
If you have any questions, feel free to put as comments. </div>
<br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'-<br />
<br />
<br />
<br />
<br />Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com3tag:blogger.com,1999:blog-6054025946250665729.post-15066072769899911042012-04-03T06:34:00.001+05:302012-04-03T06:34:57.878+05:30Java, MySQL and iReports (ST II Assignment)<div class="separator" style="clear: both; text-align: justify;">
For our ST II subject at SLIIT in the 1st semester of the 2nd year, we had to develop an application using Java, MySQL and iReports. I used NetBeans as the IDE for the development. Using the application, the user can insert, update and delete and view records in the database. The application is for adding employees, adding projects and assigning employees to the projects. <span style="text-align: left;">The application also generates two iReports to view details of projects.</span></div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
This is the initial form of the application. </div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDA7Jpsluu72BiXct2HZ00PK8lAeCm_VrehWIEnuaF0YNRhCa0hlquNu57SLT1vUW0rCpgJNOpVEnp_8FsxRrlMtWQiyaT7jL1dQFnjvMeZR-MvS0HbNaGkqHMTBVDRIM4rdy8upf_tE8/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDA7Jpsluu72BiXct2HZ00PK8lAeCm_VrehWIEnuaF0YNRhCa0hlquNu57SLT1vUW0rCpgJNOpVEnp_8FsxRrlMtWQiyaT7jL1dQFnjvMeZR-MvS0HbNaGkqHMTBVDRIM4rdy8upf_tE8/s320/1.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Some other forms are shown below. </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEju9W4M-HEb5YtIDnf58VhaP-hGNCk4qW0rLUwIZ5dMRHWxlvixxTZDBB0n9it7rtAeQnF_ObylZT0AGCd6zHtpoRG5ZJF9Z4Ol5HfEMUAf9z6AtkJvbzlxB-7urBbdgZwL5qffymljGDA/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEju9W4M-HEb5YtIDnf58VhaP-hGNCk4qW0rLUwIZ5dMRHWxlvixxTZDBB0n9it7rtAeQnF_ObylZT0AGCd6zHtpoRG5ZJF9Z4Ol5HfEMUAf9z6AtkJvbzlxB-7urBbdgZwL5qffymljGDA/s320/2.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYjnl0txwdg4xOh6T8TO87m7JakbWaXBM9CNHmUhQWhQgCOUITKBPVCp4lCIXdvdLpNiwPFYCwQ4vws6UBwrv3nNfknhMFBAefejxI1A0GwIoHc-hWvZ_uZ7b5ywCKxEklGu3hx3v39l4/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYjnl0txwdg4xOh6T8TO87m7JakbWaXBM9CNHmUhQWhQgCOUITKBPVCp4lCIXdvdLpNiwPFYCwQ4vws6UBwrv3nNfknhMFBAefejxI1A0GwIoHc-hWvZ_uZ7b5ywCKxEklGu3hx3v39l4/s320/3.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
The database schema is attached in the project. First create the database with tables in MySQL server. You will have to change the database connection parameters in the project according to your server details. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="http://www.mediafire.com/?p2zr1m86kfywvwu">Click Here to download the NetBeans project</a> and source code. (20.5 MB)</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
-Tharindu Edirisinghe-</div>
<div class="separator" style="clear: both; text-align: left;">
-SLIIT 10'-</div>Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com9tag:blogger.com,1999:blog-6054025946250665729.post-1621126234741373922012-01-10T14:38:00.000+05:302012-01-10T14:38:04.185+05:30C# and MS SQL Database Connection Software<div style="text-align: justify;">
Using the software I have developed, it is easy to handle all the SQL server database information. When you run the software, it shows all the databases in the server. You can click on the particular database you want to manage.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCw-j1EJehnsDbsTpS3NwNSYrzI5ovKIdhGswyMaKSoo4KND8gHVAdGHJ2yl1U5MqarDF_VQtgnYqNCixRKeODBJU3j5ZB8an5c9UXxxRwyvhBkHIpiDZaJhzZj1h01kS0cXwy0G_6Oww/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCw-j1EJehnsDbsTpS3NwNSYrzI5ovKIdhGswyMaKSoo4KND8gHVAdGHJ2yl1U5MqarDF_VQtgnYqNCixRKeODBJU3j5ZB8an5c9UXxxRwyvhBkHIpiDZaJhzZj1h01kS0cXwy0G_6Oww/s320/1.png" width="320" /></a></div>
<br />
<span style="text-align: justify;"> Then it shows the tables inside that database. You can click on the table name that you want to manage.</span><br />
<span style="text-align: justify;"><br /></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy_Wkg4fstkQ6EfFwBZXug4_Xv6VlDoYuxJBlBpaYMjSWh5tj6_m6NteBbpp1gDOs0qjYgvJZO5E1C-MyXnK6dPGewomdnaB4q9wyEh_bpSl0F0jseJly4lmVadgO-QVMmdoATgTxZH3M/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="283" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy_Wkg4fstkQ6EfFwBZXug4_Xv6VlDoYuxJBlBpaYMjSWh5tj6_m6NteBbpp1gDOs0qjYgvJZO5E1C-MyXnK6dPGewomdnaB4q9wyEh_bpSl0F0jseJly4lmVadgO-QVMmdoATgTxZH3M/s320/2.png" width="320" /></a></div>
<br />
Then it shows all the data in that table. You can insert, update and delete records of that table. Once the modification is complete, press the appropriate button in the left side panel. <br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWpKZ7usGygcKjM675tMKOu-nd1k_yd_fCRsZ-wkEdaW9VqcUJpWJjO-HFmorcS2h0bKXeo8-T0Wl1_8w9tf5Z8e1A-2zOwnBOARRKy1wRkL2pQrOwFa4f9SUSIJvb478C0-Lz_Fgajr8/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="299" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWpKZ7usGygcKjM675tMKOu-nd1k_yd_fCRsZ-wkEdaW9VqcUJpWJjO-HFmorcS2h0bKXeo8-T0Wl1_8w9tf5Z8e1A-2zOwnBOARRKy1wRkL2pQrOwFa4f9SUSIJvb478C0-Lz_Fgajr8/s320/3.png" width="320" /></a></div>
<br />
It is also possible to write your own SQL statements. It comes with a syntax highlighter. Currently the syntax is limited but you can add the commands in the project source code as you wish. <br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgth7uXb0zRP5wIMxNZVII61U2oKwJR4Lq6nBpGrqeHNSaNBA8PZhGduDHnv299BiesLtBHEeiOpi1B3YO2-pt-o84ApQphY8Pz7D66pWnHRCoMVHyu9KcF0NmtUMCG5nud2PV55MxmhUQ/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgth7uXb0zRP5wIMxNZVII61U2oKwJR4Lq6nBpGrqeHNSaNBA8PZhGduDHnv299BiesLtBHEeiOpi1B3YO2-pt-o84ApQphY8Pz7D66pWnHRCoMVHyu9KcF0NmtUMCG5nud2PV55MxmhUQ/s320/4.png" width="320" /></a></div>
<br />
<br />
<a href="http://www.mediafire.com/?ffa2k5xqk0tf2yu">Click Here to download</a> the Visual Studio 2008 project source code. (63.32 KB)<br />
<br />
P.S - If the database connection fails, you will have to modify the App.config file in the project giving the correct server name, user name and password. Then rebuild the project.<br />
<br />
-Tharindu Edirisinghe<br />
-SLIIT 10'Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com3tag:blogger.com,1999:blog-6054025946250665729.post-48124430140242179972011-11-20T07:44:00.000+05:302011-11-20T07:45:04.304+05:30My very first project in 'FreeLancer'<div style="text-align: justify;">
I guess most of you know the freelancer website but you may have not tried to do a project in that yet. From this post I'm telling you about my very first project in freelancer.</div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6qzh3tFEs4uPNXEi_HSR_XpCJBp_mWDLaaKr5OYou0RU353C77MmNlDMK6gpL-IBKPl2KTybWqcN5cKI22e6awhqE6lFqbCQjyYld4MLEONUddns14okJzTy_76UOl-121JY7vnBBnMQ/s1600/freelancer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="66" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6qzh3tFEs4uPNXEi_HSR_XpCJBp_mWDLaaKr5OYou0RU353C77MmNlDMK6gpL-IBKPl2KTybWqcN5cKI22e6awhqE6lFqbCQjyYld4MLEONUddns14okJzTy_76UOl-121JY7vnBBnMQ/s320/freelancer.png" width="320" /></a></div>
<div style="text-align: justify;">
I got registered at freelancer few months back following a request sent via email by a fellow student at SLIIT (Mihiran). I didn't have any idea about completing projects and getting paid then. I wasn't even bothered to place bids on projects. </div>
<div style="text-align: justify;">
These days I'm spending holidays after completing the 2nd year at SLIIT and I thought I should really try to complete a project and earn some money without wasting time on watching movies and TV Series.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
I placed bids on 5 projects, three of them were data entry projects, one was to develop a web application with database connectivity and the other was a Java Assignment.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
I received a message from the publisher of the Java Assignment asking whether I could finish it successfully.</div>
<div style="text-align: justify;">
The price range for the project was <span class="Apple-style-span" style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px;">$30-$70 (Canadian Dollars) </span>and my bid was 30$. When I placed the bid, I mentioned that I could finish the project in one day. I replied saying that I could finish it and then I received the details of the project.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
My Java knowledge is not very high since I learned Java in the 1st semester of the 2nd year at SLIIT and after that I didn't write much programs in Java since I did the 2nd semester project in C#. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<a href="http://www.mediafire.com/?sx14y0mxi6zo5de">This is the assignment I had to do</a>. (529.58 KB)</div>
<div style="text-align: justify;">
<a href="http://www.mediafire.com/?dv56cg3nf91wa54">These are the programs I wrote for the project.</a> (4.02 KB)</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
According to that I had to write two Java programs. Both the programs were command line programs, but for inputting data I had to use GUI with JOptionPane in java. For output, both command prompt and GUI was used.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
The first program was based on a complex mathematical equation and I had to do a dry run which was a tedious task since I got some logical errors in the program. It was because a condition given in the assignment had a printing mistake where it had printed '>' instead of '<'. Finally I found it and completed the program getting the correct output.</div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_jl3-3B3XCT7pxMK1qXy0k-ogJwLYqpXf4D73lA5G3oDhme3xJrwvxYuDSBcIPxkuix-Z3CG6A0eM7RavTVvYPUTPewUkUxZDjV7zbk3SzeCEvUiZGdCgZxzZaJB1IwNZtkXjH-406_c/s1600/project1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_jl3-3B3XCT7pxMK1qXy0k-ogJwLYqpXf4D73lA5G3oDhme3xJrwvxYuDSBcIPxkuix-Z3CG6A0eM7RavTVvYPUTPewUkUxZDjV7zbk3SzeCEvUiZGdCgZxzZaJB1IwNZtkXjH-406_c/s320/project1.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigKoLqGIqr26az_H639jgixj5ZP6p7HTIBnXvAzs0xw3PsV-PU0dg8sv5aKuUVFhwWHo3WWowXCDK-8JimkHMw18pYvnr88ZPQJXVdFaIE4Zlm1-Bs9XCoqBTPda1q6jfPmyJFHss1Xvw/s1600/output.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="185" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigKoLqGIqr26az_H639jgixj5ZP6p7HTIBnXvAzs0xw3PsV-PU0dg8sv5aKuUVFhwWHo3WWowXCDK-8JimkHMw18pYvnr88ZPQJXVdFaIE4Zlm1-Bs9XCoqBTPda1q6jfPmyJFHss1Xvw/s320/output.png" width="320" /></a></div>
<br />
The second program was to develop a customized commanding environment where user can enter predefined commands. The program should implement the identification of those commands and I had to write some string handling methods for that. I could successfully finish that also.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF09x3DNowbe_QSWuiTb0TRkZakOQGq1ENFLQ2aRsUhyEWCnlhaF-jd3MBoI2wgJysdYoM8F-V382t37eBBzkWeLNBtcUbql34aZLvsnaDZgBob0wVZCYBas8UzBEG_LE_U9ql8tyXPMM/s1600/project2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF09x3DNowbe_QSWuiTb0TRkZakOQGq1ENFLQ2aRsUhyEWCnlhaF-jd3MBoI2wgJysdYoM8F-V382t37eBBzkWeLNBtcUbql34aZLvsnaDZgBob0wVZCYBas8UzBEG_LE_U9ql8tyXPMM/s320/project2.png" width="320" /></a></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br />
Finally my client asked to do some modifications to the programs saying that he would pay me additional 20$s. I did them too and after delivering the project I received 50$ (CAD). From that 5$s were deducted from the freelancer website as a commission.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0iwAZ9TMh_etdRJiYKI_19VhFtYa_IECT-D7M5akUmyK4lBkS42Tsmun2jiostpvNlp5ifmD_Xqq72oSGqAemTxJZ6WafXeNVt65dgkG6Z_UD2xoYlF4y6uj7c5ouKI547iA0tAsa378/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="199" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0iwAZ9TMh_etdRJiYKI_19VhFtYa_IECT-D7M5akUmyK4lBkS42Tsmun2jiostpvNlp5ifmD_Xqq72oSGqAemTxJZ6WafXeNVt65dgkG6Z_UD2xoYlF4y6uj7c5ouKI547iA0tAsa378/s320/1.png" width="320" /></a></div>
<br /></div>
<div style="text-align: justify;">
I take this opportunity to thank my Java teacher at SLIIT, Ms. Abarnah Kirupananda who introduced me Java and the notes she gave us were really helpful when finishing the project. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
-Tharindu Edirisinghe-</div>
<div style="text-align: justify;">
-SLIIT 10'-</div>Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com7tag:blogger.com,1999:blog-6054025946250665729.post-22479766966253836152011-11-15T00:00:00.001+05:302011-11-15T00:33:54.112+05:30Participated in the 'Etisalat Android Forum 2011'<div style="text-align: justify;">
Android is a widely spreading operating system for mobile devices such as smart phones and tabs. As IT undergraduates, we must be alerted with the latest technologies. In order to introduce the capabilities of 'Android', Etisalat (One of the leading telecommunication provider in Sri Lanka) organized a forum with the theme 'WHAT CAN ANDROID DO FOR YOU?'. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Luckily I got the chance to attend the forum by registering on the <a href="http://www.etisalat.lk/">Etisalat website</a>. It was really helpful to understand Android and Android application development. I hope to develop some Android applications very soon.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
These are some photos of the event.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
This is the beginning of the event.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguXoH8-GAmzuNTycWbdHhwycZwWQ9Vpo133La2mFh-vf-P6YrhJjN3MICONZgwAdxhjhLwOJDQVCf47yKsT1neGodl24GrtANSAPjXzj1niPrDW7623tOC_fYykyG3MQva9XJjOPO6bAU/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguXoH8-GAmzuNTycWbdHhwycZwWQ9Vpo133La2mFh-vf-P6YrhJjN3MICONZgwAdxhjhLwOJDQVCf47yKsT1neGodl24GrtANSAPjXzj1niPrDW7623tOC_fYykyG3MQva9XJjOPO6bAU/s320/5.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: justify;">
In this picture, Sameera, Guru, Sasika and I are seating in the front row if you can see :D Over 1000 people attended the event.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0Ny90VHRIwCuQQ6Mv0lHnaLLJpXOiZrYMvIc0WAT6UUfnlJwuUn-UP-s06nILh7q9rfP4BNZFDzd7jKim7DlgZhVtA7MFWfzV9WrzleT_W8uE9PwfAbnOfbr8fZycTbuB5w8fhmzrufg/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0Ny90VHRIwCuQQ6Mv0lHnaLLJpXOiZrYMvIc0WAT6UUfnlJwuUn-UP-s06nILh7q9rfP4BNZFDzd7jKim7DlgZhVtA7MFWfzV9WrzleT_W8uE9PwfAbnOfbr8fZycTbuB5w8fhmzrufg/s320/3.jpg" width="320" /></a></div>
A guest speaker.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlGqXMb6aSkPDVyuk1YSk7NN4bosQCJGqKAfHgehxpMYtWezWnDiHZx7e-Ohk4HNUx2n6Lx55lXZfQOEfP4BSiWs7tJNMMF0APmXEyg6u8qE6g8-AqjHlpmlHTGpk0iPKgaocshIuUEBI/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlGqXMb6aSkPDVyuk1YSk7NN4bosQCJGqKAfHgehxpMYtWezWnDiHZx7e-Ohk4HNUx2n6Lx55lXZfQOEfP4BSiWs7tJNMMF0APmXEyg6u8qE6g8-AqjHlpmlHTGpk0iPKgaocshIuUEBI/s320/1.jpg" width="320" /></a></div>
<div style="text-align: justify;">
A demonstration on Android application development was done by a lecturer at SLIIT (see image below) and unfortunately I can't remember his name.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPJPzX4qJ8t878NVHCoIFsXY0a64Tg10k7RP8CzkdROVcqngi54qBj2wzaGTtSoMf0cPpWnpQV0m008ppGVUkMPPyV81d2-DdVfdAKLJkLqE-2Mi697DWF2iXb3ec1_UELMmsqYHn68q4/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPJPzX4qJ8t878NVHCoIFsXY0a64Tg10k7RP8CzkdROVcqngi54qBj2wzaGTtSoMf0cPpWnpQV0m008ppGVUkMPPyV81d2-DdVfdAKLJkLqE-2Mi697DWF2iXb3ec1_UELMmsqYHn68q4/s320/2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
At the end of the event, there was a raffle draw and for the winners, Android Tabs and smart phones were awarded. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWthEM0ON56dDcUAJM51gScpNdA48qj-fiJuhNbRHVSjc4hoqBruLW7Th9WhSmLjtwv09R7dCZ8m1MXEx5BL5Vx7hiTtxGdcjNsycR-zcN2w1Fl7fGSkSxmSUKDvxo_W8_bz_Q6U2KwB4/s1600/4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWthEM0ON56dDcUAJM51gScpNdA48qj-fiJuhNbRHVSjc4hoqBruLW7Th9WhSmLjtwv09R7dCZ8m1MXEx5BL5Vx7hiTtxGdcjNsycR-zcN2w1Fl7fGSkSxmSUKDvxo_W8_bz_Q6U2KwB4/s320/4.jpg" width="320" /></a></div>
<br />
See more photos from '<a href="http://www.facebook.com/media/set/?set=a.10150928270460203.764831.10150139022550203&type=1">Etisalat Android Forum Facebook Album</a>'.<br />
<br />
For those who are interested,<br />
there is a good <a href="http://www.lynda.com/Android-2-tutorials/Android-App-Development-with-Java-Essential-Training/79825-2.html">video tutorial for Android application development in lynda.com</a>.<br />
'<a href="http://www.mediafire.com/?25ej7scckjxbbx9">Hello Android' book</a> is also a great resource for beginners.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_mGDIrDl_1CBej7vaMI3a4GgCFqE_QjXR7odIrfGGnjxJMMpvQzPPvr1JpG1_e0uf40Xd8KIqzP3qt-ZyIAEbV_oRJmYoBdav-KGcXkzsgI0mm7sDdWUQP_xpXXRJSIzdSINugviIlLk/s1600/helloandroid1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_mGDIrDl_1CBej7vaMI3a4GgCFqE_QjXR7odIrfGGnjxJMMpvQzPPvr1JpG1_e0uf40Xd8KIqzP3qt-ZyIAEbV_oRJmYoBdav-KGcXkzsgI0mm7sDdWUQP_xpXXRJSIzdSINugviIlLk/s320/helloandroid1.jpg" width="266" /></a></div>
<br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'-<br />
<br />Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com3tag:blogger.com,1999:blog-6054025946250665729.post-40219715962076873542011-09-24T08:38:00.000+05:302011-09-24T08:39:55.928+05:30Algorithm Simulator - Insertion Sort, Selection Sort and Bubble Sort<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">For the 'Design and Analysis of Algorithms' (DAA) subject in the 2nd semester of the 2nd year at SLIIT, we had to develop an application to demonstrate the usage of some algorithms. We were given a list of algorithms and we were given freedom to choose any programming language and tool for the development. </span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">I chose C# since I'm familiar with .NET framework than Java and Visual Studio 2008 as the IDE. The algorithms I selected were Insertion sort, Selection Sort and Bubble sort. The user should be able to provide inputs and then the application should simulate how the sorting is done. </span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">I used Labels to display the elements in the array and Timers to move the Labels accordingly. </span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">I'd like to share the source code so that those who are new to this can learn how to develop such kind of application.</span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.mediafire.com/?jz7cq4nf4y7tek7">Click here to download the visual studio project.</a> <span class="Apple-style-span" style="background-color: white; color: #777777; font-weight: bold;">(1.61 MB)</span></span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="background-color: white; color: #777777; font-family: Arial, Helvetica, sans-serif; font-weight: bold;"><br /></span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">To improve the user friendliness and appearance, I used an 'Outlook bar' in the application. It was an open source project where I found the code from <a href="http://www.codeproject.com/">CodeProject</a>. </span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.codeproject.com/KB/selection/csoutlookbar.aspx">This is the reference for the outlook bar.</a> </span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Special thanks to Professor <a href="http://gcmuganda.faculty.noctrl.edu/">Godfrey Muganda</a> of the Department of Computer Science, North Central College, Naperville, IL for the support provided via emails replying to my questions related to the development of this project.</span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-style-span" style="font-size: 14px;"><br /></span></span></div>
<span class="Apple-style-span" style="background-color: white; font-family: Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold;">These are some screen shots of the application.</span><br />
<span class="Apple-style-span" style="background-color: white; color: #777777; font-family: Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold;"><br /></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsdlz_qJtahCSDVX-m9s8hLtfORJpUdgWPXtOhMccJe3cda-XvNFfwiEX1LSiptoqIqGu8RWYiTBnOf_sw-KW8w0Wqwq3d2ZwF7PdXtpxeZnHFKLF-lDPzJumGKJV9N1Wtm7YfcjZNKhQ/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsdlz_qJtahCSDVX-m9s8hLtfORJpUdgWPXtOhMccJe3cda-XvNFfwiEX1LSiptoqIqGu8RWYiTBnOf_sw-KW8w0Wqwq3d2ZwF7PdXtpxeZnHFKLF-lDPzJumGKJV9N1Wtm7YfcjZNKhQ/s320/1.png" width="277" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhI7gYZ7mM5ZuopNhtwzpQXQSp0lUy1JrgiM3ObW2n94N4ibf4SeoxI3pRoDNqbDcaqhK9589e87rJn6h8ogvg_5MzKPgpuQ4P05pBAMSlYVz8gXAqLMGa91UpFnTbd41O5gp__ZsLmndM/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhI7gYZ7mM5ZuopNhtwzpQXQSp0lUy1JrgiM3ObW2n94N4ibf4SeoxI3pRoDNqbDcaqhK9589e87rJn6h8ogvg_5MzKPgpuQ4P05pBAMSlYVz8gXAqLMGa91UpFnTbd41O5gp__ZsLmndM/s320/2.png" width="279" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO6V1enZCd5Lk1MAdT402lPHSyOqc4AwVUeJ74McSTAmPYdRiJzNhBFKQ-o81tByleHiuZYPSMPLQri9TEJsDPDqpHCeEseYarodd4LD7kc4Mq2COWDmB0iNAUnHOwuckBXFVnvMl3CLU/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO6V1enZCd5Lk1MAdT402lPHSyOqc4AwVUeJ74McSTAmPYdRiJzNhBFKQ-o81tByleHiuZYPSMPLQri9TEJsDPDqpHCeEseYarodd4LD7kc4Mq2COWDmB0iNAUnHOwuckBXFVnvMl3CLU/s320/3.png" width="277" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuvO9f0YybXH1lZjWffTFQjrm6aFEgMBouU5TfLFuDDfKg6Xh1ZzsdvBVPvmRoPfTWSIFTH2TcbRYJW7xr70PIZeYxWs2JQ6bWZOqTe73nJcUSct1O2qMi8-siBPWi9VDkP7F0C83lC1s/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuvO9f0YybXH1lZjWffTFQjrm6aFEgMBouU5TfLFuDDfKg6Xh1ZzsdvBVPvmRoPfTWSIFTH2TcbRYJW7xr70PIZeYxWs2JQ6bWZOqTe73nJcUSct1O2qMi8-siBPWi9VDkP7F0C83lC1s/s320/4.png" width="276" /></a></div>
<span class="Apple-style-span" style="background-color: white; color: #777777; font-family: Arial, Helvetica, sans-serif; font-weight: bold;"><br /></span><br />
<span class="Apple-style-span" style="font-family: inherit;">-Tharindu Edirisinghe-</span><br />
<span class="Apple-style-span" style="font-family: inherit;">-SLIIT 10'-</span>Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com10tag:blogger.com,1999:blog-6054025946250665729.post-67834072471825233732011-09-03T06:36:00.000+05:302011-09-03T06:36:05.613+05:30Issue with DropBox<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0vp0THXMi6GxelZHpJLgetocrIEcrYmTKy8bq9ZVI5VGfxqErH-UAiUhT6KKrAWDMssT6ywySSxxrUtzpA-sBuMhwvFxzcNwvNtdTqmMEmpShOyoUheVhqwP_9DlDzNEwcLa-7v61Cb0/s1600/dropbox_logo_home.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0vp0THXMi6GxelZHpJLgetocrIEcrYmTKy8bq9ZVI5VGfxqErH-UAiUhT6KKrAWDMssT6ywySSxxrUtzpA-sBuMhwvFxzcNwvNtdTqmMEmpShOyoUheVhqwP_9DlDzNEwcLa-7v61Cb0/s1600/dropbox_logo_home.png" /></a></div>
<div style="text-align: justify;">
I normally use <a href="http://www.mediafire.com/">mediafire</a> to share my files but sometimes mediafire is not working at SLIIT due to the proxy server. Therefore I wanted to find a better way to share files. Emailing is not possible because most of the time my files contain exe files and gmail is not allowing exe file attachments.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Then I moved into <a href="http://www.dropbox.com/">dropbox</a>. It is a very good solution since it synchronizes the files in my PC so that I can access them from anywhere. Sharing is also easy because we can get a public link and share the link so that the particular file can be downloaded using the link.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
This is the place where the problem encountered. When I drag a file into the public folder of dropbox in my PC, the file is uploaded to the server. I can right click on that file and get the link for public sharing.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcbJ_EYLZCWwmIrYDKmHT8FZTz4DcBK6y4CniqVaONX2xDwcufgHgREnp1enxklGZ4bXc-YccfNP9MXzf5K1lcD-wuhnzAT6EAAXOBY4KulJClSLhGFAFv-fK3SEY6jLzmN-CuISwilOM/s1600/publicLink.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="221" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcbJ_EYLZCWwmIrYDKmHT8FZTz4DcBK6y4CniqVaONX2xDwcufgHgREnp1enxklGZ4bXc-YccfNP9MXzf5K1lcD-wuhnzAT6EAAXOBY4KulJClSLhGFAFv-fK3SEY6jLzmN-CuISwilOM/s320/publicLink.JPG" width="320" /></a></div>
Suppose I have two files in my drop box called 'Simulator.zip' and 'MATCH.exe'. Now I'll get the public sharing links for those two files.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsU7xVSJEz-eG7vGcIxaQprJUT_fHmt2b4aphxFHVSJD_yyf4tx0J_PAVE9yPf5Qv7yFtgoBcfTLUWhYLFfutoqYbRVsSjJPHCdbfK3csrW9aJe3lsknEctz_BaS2amfr7EzZmEpm79Qs/s1600/twoLinks.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="190" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsU7xVSJEz-eG7vGcIxaQprJUT_fHmt2b4aphxFHVSJD_yyf4tx0J_PAVE9yPf5Qv7yFtgoBcfTLUWhYLFfutoqYbRVsSjJPHCdbfK3csrW9aJe3lsknEctz_BaS2amfr7EzZmEpm79Qs/s320/twoLinks.JPG" width="320" /></a></div>
<div style="text-align: justify;">
For security reasons I've indicated some part of the link as 'XXXXXXX' but in both links those are same. Now suppose I have another file called 'Hello.txt' in my public folder. Now somebody who has a public link of my drop box can download it without knowing the URL for that file. </div>
<div style="text-align: justify;">
It can be derived as 'http://dl.dropbox.com/u/XXXXXXXX/Hello.txt'. So if somebody has a link of a file in my dropbox and also if he knows the file name then he can download that file like this. Or even by guessing the name of the file it might work. So when you are putting your personal files to your dropbox, be careful.</div>
<br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com0tag:blogger.com,1999:blog-6054025946250665729.post-88225707498054208182011-08-27T23:12:00.000+05:302011-08-27T23:12:07.118+05:30Looking Back<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgS-vIgHTTMDKOz0Mu-1io5kgSQBgqNZi0Td6xlKAb3m1y4oyXZ6MpjEvdEvVfqXjiCq8h4ZLBlftYk7-P85Ko79tyMEYGCsKHJguBC_av1BDhbMDS8L47yewZ-008t1HC_wwAjHlTV4ck/s1600/back.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgS-vIgHTTMDKOz0Mu-1io5kgSQBgqNZi0Td6xlKAb3m1y4oyXZ6MpjEvdEvVfqXjiCq8h4ZLBlftYk7-P85Ko79tyMEYGCsKHJguBC_av1BDhbMDS8L47yewZ-008t1HC_wwAjHlTV4ck/s320/back.jpg" width="320" /></a></div>
<br />
<div style="text-align: justify;">
It's been long since I wrote the last post. Not because I was busy, just because I didn't feel like writing. I'm reaching to the end of the 2nd year at SLIIT. 2 years is not a very long period but during that I had so many experiences, learned so many things and also made mistakes.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
I received so many good comments for the series of posts I wrote (<a href="http://thariya.blogspot.com/2011/03/mission-40-gpa-at-sliit-part-1.html">Mission 4.0 GPA at SLIIT</a>) before the final semester examination of last semester. Unfortunately I couldn't get 4.0 GPA this time but finally ended up getting 3.94 GPA. I made some silly mistakes in Software Engineering I paper and so I got an A- for that. Anyway I'm happy because I was not just studying the subjects but besides that I did so many extra things including blogging, experimenting technologies and also helping my friends. I received a full scholarship for my results this time also which means I have saved nearly Rs. 75,000 during the last semester. This time the cut off GPA for full scholarships was 3.94.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
I still remember how I did the '<a href="http://thariya.blogspot.com/2011/01/software-technology-1-assignment-at.html">ST 1</a>' and '<a href="http://thariya.blogspot.com/2011/02/ita-group-project-part-i.html">ITA</a>' group projects last year and sometimes I read the blog posts I have written and I wonder how I could complete them successfully. When I started doing them there were so many things I didn't know but one by one I learned them on my own and did them. The resources were limited such as previously done projects by SLIIT students. That's why I have posted the source codes of my projects so that our juniors can learn. Unfortunately it doesn't seem like happening when I see how the 1st years do their projects. Anyway I don't want to talk about it much.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
I wrote this post just to avoid removal of my blog from the blog syndicatiors. Hope to write something meaningful next time. Thanks for reading.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
-Tharindu Edirisinghe-</div>
<div style="text-align: justify;">
-SLIIT 10'- </div>
Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com0tag:blogger.com,1999:blog-6054025946250665729.post-38680549458667963862011-07-17T23:27:00.001+05:302011-07-17T23:28:02.250+05:30Tak Tik Tuk Version 3.0 with improved Algorithms<div style="text-align: justify;">
From my last post I introduced the <a href="http://thariya.blogspot.com/2011/07/tak-tik-tuk-game-version-20.html">version 2.0</a> of the game I developed. I further developed it by adding new algorithms with pattern matching capabilities. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdBk1pfYNGc0vYDOExzf9SbU6ogg9XaMcbgcNTLuFfJetZU3gpUAqSnmGzhvO_eQUDs9WyTVjRnDzEYsx42rSDursY2ko3tJufF_luzB42g904Fw8dwxNggQ6tBbJmVPLRSHG2vFODJAI/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdBk1pfYNGc0vYDOExzf9SbU6ogg9XaMcbgcNTLuFfJetZU3gpUAqSnmGzhvO_eQUDs9WyTVjRnDzEYsx42rSDursY2ko3tJufF_luzB42g904Fw8dwxNggQ6tBbJmVPLRSHG2vFODJAI/s320/1.jpg" width="288" /></a></div>
<br />
<div style="text-align: justify;">
Now the difficulty level of the game is so high and even I cannot win the game. If you can, please let me know :D</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
I changed the user interface of the game a little bit to improve the appearance.Same as the previous version, .NET framework 3.5 is required to play the game.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<a href="http://www.mediafire.com/?1hsaylrnt2nqljv">Follow this link to download</a> the game. (144.31 KB)</div>
<div class="separator" style="clear: both; text-align: justify;">
</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
These are some screen shots of the game. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhBvvxfp0abIXWDhmoHcpsni-JzNOQadIP0W03zMU-Kww4HHXHebnLKUnuJ_cxsgWR_n2RgSqGbFdd1D4vIj5Dbrr-qe7Vx7GMXmXTBszao7Nbrx0S6GcyJqS037iPt6CB9AIWJWyZQkE/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhBvvxfp0abIXWDhmoHcpsni-JzNOQadIP0W03zMU-Kww4HHXHebnLKUnuJ_cxsgWR_n2RgSqGbFdd1D4vIj5Dbrr-qe7Vx7GMXmXTBszao7Nbrx0S6GcyJqS037iPt6CB9AIWJWyZQkE/s320/2.jpg" width="295" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiSBmiYfNeIo8tLC4Z5awJmRZkmbX_u-3YRQeIMPmkzHFyxiw_4AwZTcupYSF85DsbC7a07_3j5rztowE9CAJwlDpLuzBHnoADOJNdx9L1g9Et0TceKrDvpvcR8LTKBOB568WRqAeNlas/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiSBmiYfNeIo8tLC4Z5awJmRZkmbX_u-3YRQeIMPmkzHFyxiw_4AwZTcupYSF85DsbC7a07_3j5rztowE9CAJwlDpLuzBHnoADOJNdx9L1g9Et0TceKrDvpvcR8LTKBOB568WRqAeNlas/s320/3.jpg" width="258" /></a></div>
Enjoy playing and send me your comments. <br />
<br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'-Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com2tag:blogger.com,1999:blog-6054025946250665729.post-56423058913640720712011-07-04T23:49:00.000+05:302011-07-04T23:49:04.237+05:30Tak Tik Tuk Game Version 2.0<div style="text-align: justify;">Recently I developed a Tak Tik Tuk game (<a href="http://www.mediafire.com/?82qn3oloid26scx">Version 1.0</a>) using Microsoft Visual Studio 2010, WPF and C#. Since it wasn't much capable of matching the winning patterns, I released it among very few of my friends to gather a feed back. Then I developed an algorithm to match the winning patterns and it succeeded. I used the <a href="http://malliyaa.blogspot.com/2011/07/wpf-transparent-form-application.html">Transparent Effect in WPF</a> which improves the appearance of the game. Besides that I added some voice features also to improve the interactivity. Here are some screen shots.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJM212NsiEKwi7nR5jCnh2zZN7a3v-SHUkBambipLoEt1_860MN6bxeqryR4AHCGsW16vA_k69oimQbGI4ksEBczwi-cJ3xnyBY2esSF6UBYxmsnXAgvZuuNgxrctLPI0W14lzGtMnwXg/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJM212NsiEKwi7nR5jCnh2zZN7a3v-SHUkBambipLoEt1_860MN6bxeqryR4AHCGsW16vA_k69oimQbGI4ksEBczwi-cJ3xnyBY2esSF6UBYxmsnXAgvZuuNgxrctLPI0W14lzGtMnwXg/s320/1.jpg" width="228" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyW4mIowH-BSgOr2wVUsET4hQr67CPYi-iX8x7lyd9XCUrGKtQRUl9tx8BjK4n3xl-FwOqLo9_2lRd1JVgFyKtQ1G4miau3yK7Fff-FS-p-yx1VZiXxNiX3i9Ss9z7ylkki_cazDyB4r8/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyW4mIowH-BSgOr2wVUsET4hQr67CPYi-iX8x7lyd9XCUrGKtQRUl9tx8BjK4n3xl-FwOqLo9_2lRd1JVgFyKtQ1G4miau3yK7Fff-FS-p-yx1VZiXxNiX3i9Ss9z7ylkki_cazDyB4r8/s320/2.jpg" width="251" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiTHVwu3h3Wf5tziC8Hs8JOmC0rYX-L631YZd4I_nvZwMpBTAexSCV6lC29OayFCq09oB1RYM6N46Qk2b8_Ya-sYvuuyI1noVU6K2bMS3ETVqEtekPGWLUpQ1CV4We8OQMU8GO4m3xMD4/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiTHVwu3h3Wf5tziC8Hs8JOmC0rYX-L631YZd4I_nvZwMpBTAexSCV6lC29OayFCq09oB1RYM6N46Qk2b8_Ya-sYvuuyI1noVU6K2bMS3ETVqEtekPGWLUpQ1CV4We8OQMU8GO4m3xMD4/s320/3.jpg" width="231" /></a></div><a href="http://www.mediafire.com/?cgksctwszvd2im1">Click Here to download</a> the game. (110.42 KB)<br />
You need to have .NET Framework 3.5 installed in your PC to play this game.<br />
<br />
Enjoy it and send me your comments. <br />
<br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'-Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com1tag:blogger.com,1999:blog-6054025946250665729.post-52799220360886459422011-07-02T12:26:00.001+05:302011-07-02T12:27:40.844+05:30Stacks and Queues GUI applications<div style="text-align: justify;">These are some GUI applications I developed when I was following the 'Software Technology I' subject when I was in the second semester of the first year at SLIIT. I think this will be useful to learn not only Stacks and Queues but also tasks like exception handling when implementing a C++ GUI application in Visual Studio.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">This Stack application demonstrates the fundamental tasks of a Stacks such as Push, Pop and Peek methods.</div><br />
<div style="text-align: justify;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_c-qP7qDN1VWR6rBFB7kKIDzmO8FIszIlOkETaE0k-6lhgT0-sHzne3LGkhk0dArMiy4T14XHMtuRHlD3op_7xLexSDzlMqH-Xyco4GDCAO5Ej_fpXhiC-2Nvh_UsrooU3XB5FV0mvmY/s1600/stack.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="274" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_c-qP7qDN1VWR6rBFB7kKIDzmO8FIszIlOkETaE0k-6lhgT0-sHzne3LGkhk0dArMiy4T14XHMtuRHlD3op_7xLexSDzlMqH-Xyco4GDCAO5Ej_fpXhiC-2Nvh_UsrooU3XB5FV0mvmY/s320/stack.jpg" width="320" /></a></div><div style="text-align: justify;"><br />
<br />
<div style="text-align: justify;"><a href="http://www.mediafire.com/?vi8tamgay7jyl7h">Click Here to download</a> the application. (19.84 KB)</div><div style="text-align: justify;"><a href="http://www.mediafire.com/?q0ncdaabz133qv0">Click Here to download</a> the Visual Studio project source code. (2.4 MB)</div><br />
<br />
The Queue application demonstrates the tasks related to Queues such as Enqueue, Dequeue and Peek Front.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMk-nnJcEstg_Srh5rBHy6nFs5CW3AQ1RzieQnzesuIvNmtCptAmC4ZxsohPcalkMbEJ-s2dqYC9I5-m6x8rA83No12SXRCuny5rMSDUeS0EtqH2WHq7vj4gm5JcYuW77PVdnM2wuc9yg/s1600/queue.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMk-nnJcEstg_Srh5rBHy6nFs5CW3AQ1RzieQnzesuIvNmtCptAmC4ZxsohPcalkMbEJ-s2dqYC9I5-m6x8rA83No12SXRCuny5rMSDUeS0EtqH2WHq7vj4gm5JcYuW77PVdnM2wuc9yg/s320/queue.jpg" width="320" /></a></div><br />
<div style="text-align: justify;"><a href="http://www.mediafire.com/?2j057p2rflrc6k9">Click Here to download</a> the application. (20.09 KB)</div><div style="text-align: justify;"><a href="http://www.mediafire.com/?ccwg6sx66rs262e">Click Here to download</a> the Visual Studio project source code. (3.11 MB)</div><br />
You need to have .NET Framework 3.5 installed in your PC to run these applications.<br />
<br />
<br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'-Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com0tag:blogger.com,1999:blog-6054025946250665729.post-26631873708544247992011-06-15T23:23:00.001+05:302011-06-15T23:36:24.641+05:30Ebook Linker Down - Source CODE Released !!!<div style="text-align: justify;"> During the last examination period at SLIIT, the Ebook sharing website (<a href="http://thariya.blogspot.com/2011/03/thariyas-ebook-linker.html">Thariya's Ebook Linker</a>) which I designed was very much helpful for me and for my friends to share the learning resources we had. I received so many good comments for developing that from my friends as well as my lecturers at SLIIT. </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg67mIq5YPL8N8u01TpFnpI4VeDTsUcJuOGU5qZflpnKMvm476MrYY_Nj9sZHm25IHH1Yv74pKskuyVNj25p683fNbhh80g7QlMrNvJ2DwhiL5tPHlULI9xjgV_ULWHYlsSVJ306lRYOSA/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg67mIq5YPL8N8u01TpFnpI4VeDTsUcJuOGU5qZflpnKMvm476MrYY_Nj9sZHm25IHH1Yv74pKskuyVNj25p683fNbhh80g7QlMrNvJ2DwhiL5tPHlULI9xjgV_ULWHYlsSVJ306lRYOSA/s320/2.jpg" width="212" /></a></div><br />
<div style="text-align: justify;">It was successfully hosted at http://tharindu.somee.com but after two or three weeks I got to know that the website was not working properly. The reason was the deletion of the database from the server. I guess it was done by the site administrators at somee.com and I can't blame them since it's a free hosting service. Maybe they received complains from the book authors for violating copy rights. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">I have no intention of running the site by uploading a database to the server. Therefore I thought of sharing the source code of the website with you. It was developed using Microsoft Visual Studio 2008, .NET framework 3.5, ASP.NET and C# as the programming language. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">This will be useful for 1st year students at SLIIT for the <a href="http://thariya.blogspot.com/2011/02/ita-group-project-part-i.html">ITA group project</a>. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><a href="http://www.mediafire.com/?nz0n6v6650zzlae">Click Here to download.</a> (5.76 MB)</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">The database is also included in the Zip file. You have to attach the database to the MS SQL server on your PC when running the website. (<a href="http://thariya.blogspot.com/2010/12/how-to-copy-microsoft-sql-server.html">Read this post for more information</a>) </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Then open the project in Microsoft Visual Studio. You need to modify the web.config file with your MS SQL server name. In my PC it is (local). Replace (local) with your server name. </div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJAdHEA9IUWEnudcj5dpz2pzGt2rBqdimD0NBXe2N5pNAqFGuec46Jbr53q-QezDSQ7QnP7irKDJoID4liFXgADrS0BYEciBA2mxRyTAknZ3syHZ84yypn7utrcsTDfU7xaQi44_eo23M/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="146" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJAdHEA9IUWEnudcj5dpz2pzGt2rBqdimD0NBXe2N5pNAqFGuec46Jbr53q-QezDSQ7QnP7irKDJoID4liFXgADrS0BYEciBA2mxRyTAknZ3syHZ84yypn7utrcsTDfU7xaQi44_eo23M/s320/1.jpg" width="320" /></a></div><div style="text-align: justify;">If you don't know the server name, you can open the Microsoft SQL Server Management Studio and the Server Name will appear as shown in the image below. </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvIwkN36FLeTx1f3ODj4fJOpflE4BtYdn1lmHadsoOLlkFiBwhaFB2Gmya1WpXeRa7cUfKNk-Fbn5IIKyqACG5M99J_ikzA5RrdR46YxzGlnR6OcLIG815BNYMEyY1FQZWJYSRcvBhrW8/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvIwkN36FLeTx1f3ODj4fJOpflE4BtYdn1lmHadsoOLlkFiBwhaFB2Gmya1WpXeRa7cUfKNk-Fbn5IIKyqACG5M99J_ikzA5RrdR46YxzGlnR6OcLIG815BNYMEyY1FQZWJYSRcvBhrW8/s320/2.jpg" width="320" /></a></div><div style="text-align: justify;">If you have any problem regarding the source code, just drop me a message via the contact me page.</div><br />
-Tharindu Edirisinghe-<br />
-SLIIT 10-Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com9tag:blogger.com,1999:blog-6054025946250665729.post-29040837688147739812011-05-06T10:10:00.002+05:302011-11-08T22:45:08.927+05:30How to install and configure mySQL on Windows<div style="text-align: justify;">
Before going to install mySQL, first lets check whether we have already installed mySQL on the PC. Go to the command prompt and type 'mysql' and press Enter key.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-B9pa99eZEu4/TcMNJA8vNzI/AAAAAAAAA_s/lOy8db-PCCI/s1600/1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="86" src="http://4.bp.blogspot.com/-B9pa99eZEu4/TcMNJA8vNzI/AAAAAAAAA_s/lOy8db-PCCI/s320/1.JPG" width="320" /></a></div>
<div style="text-align: justify;">
If it is not installed you will get an error message saying 'mysql is not reconnized as an internal or external command, operable program or batch file'. Now lets look at how to install it. </div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
First you need to have the MySQL community server. You can download the installer package from <a href="http://dev.mysql.com/downloads/mysql/5.1.html#downloads">this link</a>. Select the platform as 'Microsoft Windows' and download the MSI installer according to your operating system (either 32 bit or 64 bit). </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-1BpKeIvv4LI/TcNwDl9GvoI/AAAAAAAABBE/97ruzONI870/s1600/mm.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" src="http://4.bp.blogspot.com/-1BpKeIvv4LI/TcNwDl9GvoI/AAAAAAAABBE/97ruzONI870/s320/mm.jpg" width="320" /></a></div>
<div style="text-align: justify;">
Once you have downloaded the MSI package, it will appear like this.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-F8FA70zBxU8/TcMNHLPdVgI/AAAAAAAAA_k/5wcmeF2JlpY/s1600/2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-F8FA70zBxU8/TcMNHLPdVgI/AAAAAAAAA_k/5wcmeF2JlpY/s1600/2.JPG" /></a></div>
<div style="text-align: justify;">
Double click on the installer and run it. The the following window appears. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-504KbfFXHrw/TcMNI63rVlI/AAAAAAAAA_o/EJ15k-ahToc/s1600/3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="243" src="http://4.bp.blogspot.com/-504KbfFXHrw/TcMNI63rVlI/AAAAAAAAA_o/EJ15k-ahToc/s320/3.JPG" width="320" /></a></div>
<br />
Click Next.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-PJDtj6fmrwE/TcMNL1dcReI/AAAAAAAAA_w/KCSVyhyMkbw/s1600/4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="245" src="http://1.bp.blogspot.com/-PJDtj6fmrwE/TcMNL1dcReI/AAAAAAAAA_w/KCSVyhyMkbw/s320/4.JPG" width="320" /></a></div>
<div style="text-align: justify;">
select 'I accept the terms in the license agreement' and click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-GwQQHwCnGYs/TcMNMp_IPfI/AAAAAAAAA_0/GtxG02gt0oA/s1600/5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="http://1.bp.blogspot.com/-GwQQHwCnGYs/TcMNMp_IPfI/AAAAAAAAA_0/GtxG02gt0oA/s320/5.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Now you need to select the setup type. I'll select 'Typical and click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_RTzVFtPl8zZg0COjOony-h8iPX7QMPlj_l4ya8lyPFZ-DLLTYe5O0lwAxNFAkHqgq9CPXM8dZ4b-xVM4Q4wh-Cd-i8ka7j0H79hyphenhyphenzDVUlGbF9wfdhqvU-bFGNnt6BYpxzxFe-6DHZwY/s1600/6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_RTzVFtPl8zZg0COjOony-h8iPX7QMPlj_l4ya8lyPFZ-DLLTYe5O0lwAxNFAkHqgq9CPXM8dZ4b-xVM4Q4wh-Cd-i8ka7j0H79hyphenhyphenzDVUlGbF9wfdhqvU-bFGNnt6BYpxzxFe-6DHZwY/s320/6.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Now it shows the destination folder of the installation. Click 'Install'.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-j3vw656AFY8/TcMNQGWLs0I/AAAAAAAAA_4/ddRfvxbcrGk/s1600/7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="243" src="http://3.bp.blogspot.com/-j3vw656AFY8/TcMNQGWLs0I/AAAAAAAAA_4/ddRfvxbcrGk/s320/7.JPG" width="320" /></a></div>
<div style="text-align: justify;">
It may take few minutes. For the next dialogue boxes appear, click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-tm1B7b3vYeE/TcMNZS0MLtI/AAAAAAAABAI/p1v1ZAxb3do/s1600/8.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="245" src="http://2.bp.blogspot.com/-tm1B7b3vYeE/TcMNZS0MLtI/AAAAAAAABAI/p1v1ZAxb3do/s320/8.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-ldZoiBWxtYY/TcMNVzwlnUI/AAAAAAAABAA/xYvVgmxxeGM/s1600/9.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="http://1.bp.blogspot.com/-ldZoiBWxtYY/TcMNVzwlnUI/AAAAAAAABAA/xYvVgmxxeGM/s320/9.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Now you get the following window.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-E7gGAmxq20w/TcMNXhHXI8I/AAAAAAAABAE/Vul0XhT_Aeg/s1600/10.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="http://1.bp.blogspot.com/-E7gGAmxq20w/TcMNXhHXI8I/AAAAAAAABAE/Vul0XhT_Aeg/s320/10.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Tick 'Configure the MySQL Server now' and click 'Finish'.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-E7gGAmxq20w/TcMNXhHXI8I/AAAAAAAABAE/Vul0XhT_Aeg/s1600/10.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="http://1.bp.blogspot.com/-E7gGAmxq20w/TcMNXhHXI8I/AAAAAAAABAE/Vul0XhT_Aeg/s320/10.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-gHuUt-4Necg/TcMNZaeIFFI/AAAAAAAABAM/9lU3oBbt5B8/s1600/11.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="245" src="http://3.bp.blogspot.com/-gHuUt-4Necg/TcMNZaeIFFI/AAAAAAAABAM/9lU3oBbt5B8/s320/11.JPG" width="320" /></a></div>
Click Next.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-eMuz5pvBHn0/TcMNcdSmmFI/AAAAAAAABAQ/-yzsUKktzV8/s1600/12.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="http://3.bp.blogspot.com/-eMuz5pvBHn0/TcMNcdSmmFI/AAAAAAAABAQ/-yzsUKktzV8/s320/12.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Select 'Standard Configuration' and click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-t8WaPOjevPM/TcMNegjUanI/AAAAAAAABAU/bzFE0AkbO00/s1600/13.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="http://4.bp.blogspot.com/-t8WaPOjevPM/TcMNegjUanI/AAAAAAAABAU/bzFE0AkbO00/s320/13.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Make the selections as in the above image and click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-r3CvQ1MSTlc/TcMNfOW6f2I/AAAAAAAABAY/uZ_XfGeX8fQ/s1600/14.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="245" src="http://4.bp.blogspot.com/-r3CvQ1MSTlc/TcMNfOW6f2I/AAAAAAAABAY/uZ_XfGeX8fQ/s320/14.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Select 'Modify Security Settings' and type the root password. This password is needed when we do modifications to the server so don't forget it. Click Next.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-4gO3WCcHAh8/TcMNg4DNFOI/AAAAAAAABAc/7W9YNGLxO4g/s1600/15.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="245" src="http://1.bp.blogspot.com/-4gO3WCcHAh8/TcMNg4DNFOI/AAAAAAAABAc/7W9YNGLxO4g/s320/15.JPG" width="320" /></a></div>
Click 'Execute'.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-V6dG13Vm20I/TcMNj3YBWUI/AAAAAAAABAk/UUPZ58CV_tA/s1600/16.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="246" src="http://1.bp.blogspot.com/-V6dG13Vm20I/TcMNj3YBWUI/AAAAAAAABAk/UUPZ58CV_tA/s320/16.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Click Finish. Now we have successfully installed the mySQL server on the PC.</div>
<div style="text-align: justify;">
Go to command prompt and type 'mysql' and press Enter.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmghPrrtV1JQI2OksCNwW68zYaLP41zLkSGS92uoZMdvIP5gX1ri0ZizoSoLTXMIMzC9jNocElEGZGGeGah-jo0WmUdmNFlydUu5sr4aqbiprZsEB18XKZijgxbNja5A7KQPJ1Ll9GhE8/s1600/17.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="80" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmghPrrtV1JQI2OksCNwW68zYaLP41zLkSGS92uoZMdvIP5gX1ri0ZizoSoLTXMIMzC9jNocElEGZGGeGah-jo0WmUdmNFlydUu5sr4aqbiprZsEB18XKZijgxbNja5A7KQPJ1Ll9GhE8/s320/17.JPG" width="320" /></a></div>
<div style="text-align: justify;">
Now we are getting an error message because it cannot identify the user. So lets create a user account on the server. First you need to login to the root account. Type the following in the command prompt and press Enter.</div>
<br />
<span style="color: #351c75;">mysql -u root -p</span><br />
<br />
It will prompt to enter the root password. Type your root password and press enter.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiz0iVowikBGP1R_7v0fLAnGLG27khREHXKoYElMy6Oci86psd5ou5XVI8d82xfm9IvwHE7nJBHh5lPFKIaRasmhF6ky9JxASSlVwLljiEPsYelkSx2UKLGQvnSA0lSldW_OCE4HxRpPSc/s1600/18.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="105" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiz0iVowikBGP1R_7v0fLAnGLG27khREHXKoYElMy6Oci86psd5ou5XVI8d82xfm9IvwHE7nJBHh5lPFKIaRasmhF6ky9JxASSlVwLljiEPsYelkSx2UKLGQvnSA0lSldW_OCE4HxRpPSc/s320/18.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
Now you are in the root account. So lets create a user. The commands are shown in the image below. Don't forget to put semicolons (;) at the end of each statement.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-eaP0JuyxxW0/TcN4BbOzX2I/AAAAAAAABBI/VIj-rtKsWy8/s1600/19.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="http://3.bp.blogspot.com/-eaP0JuyxxW0/TcN4BbOzX2I/AAAAAAAABBI/VIj-rtKsWy8/s320/19.JPG" width="320" /></a></div>
<br />
<div style="color: #351c75; text-align: justify;">
CREATE USER <span style="color: #cc0000;">username</span> ;</div>
<div style="color: #351c75; text-align: justify;">
GRANT ALL ON *.* TO <span style="color: #cc0000;">username</span> WITH GRANT OPTION ;</div>
<div style="color: #351c75; text-align: justify;">
FLUSH PRIVILEGES ;</div>
<div style="color: #351c75; text-align: justify;">
UPDATE mysql.user SET Password = PASSWORD ('<span style="color: #cc0000;">your password</span>') WHERE User = '<span style="color: #cc0000;">username</span>' ;</div>
<div style="color: #351c75; text-align: justify;">
FLUSH PRIVILEGES ;</div>
<div style="color: #351c75; text-align: justify;">
exit ;</div>
<br />
<div style="text-align: justify;">
Here I have granted all the permission for this user also. If not you can grant permissions for a selected set of commands. Setting a password for the account is optional. You need to change the words appearing in red color.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
If you didn't set a password for the account, this is the command to login to the account.</div>
<br />
<div style="text-align: justify;">
<span style="color: #674ea7;">mysql -u <span style="color: #cc0000;">username</span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
If you set a password this is the command to login.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<span style="color: #674ea7;">mysql -u <span style="color: #cc0000;">username <span style="color: #674ea7;">-p</span></span></span></div>
<br />
<div style="text-align: justify;">
<span style="color: #674ea7;"><span style="color: #cc0000;"><span style="color: black;">Then it will prompt to enter the password of the account. Type it and press enter. </span></span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Instead of command prompt, you can also use the 'MySQL Command Line Client'. You can find it in </div>
<div style="text-align: justify;">
Start -> All Programs - > MySQL - > MySQL Server </div>
<div style="text-align: justify;">
if you are using Windows 7. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
From my next post I'll show you some important commands in mySQL. So keep in touch.</div>
<br />
-Tharindu Edirisinghe-<br />
-SLIIT 10-<br />
<div class="separator" style="clear: both; text-align: center;">
</div>Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com1tag:blogger.com,1999:blog-6054025946250665729.post-51541872885143513112011-03-27T17:22:00.001+05:302011-03-27T17:24:00.509+05:30Mission 4.0 GPA at SLIIT - Part 3<div style="text-align: justify;">Earlier I thought of updating the blog everyday but for the last few days I couldn't because I wasn't in a good mood..... kind of fed up after all of these... This semester is not like the previous two semesters and the content we have to learn is very much high comparatively. So I got the feeling that I'm still not ready to expect getting 4.0 GPA this time which means I shouldn't be wasting time with blogging and extra work. So this will be the last post of this series of posts and the last post I'm writing until the exams are over. Therefore I'll tell you my plan to get good results.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">All the reference books I have mentioned are available for downloading at "<a href="http://tharindu.somee.com/">Thariya's Ebook Linker</a>".Search under the given category.</div><div style="text-align: justify;"></div><div style="text-align: justify;"><br />
<br />
<u><b>Probability & Statistics</b></u></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">This is the most critical subject. Read my <a href="http://thariya.blogspot.com/2011/03/mission-40-gpa-at-sliit-part-1.html">1st post</a> and <a href="http://thariya.blogspot.com/2011/03/mission-40-gpa-at-sliit-part-2.html">2nd post</a> of this series and do the Crash Course book (Category : Probability & Statistics). Then you can get an idea about the units easily. Then start learning the units in the Text book. Then watch the videos on Probability and Statistics done by Khan Academy. You can watch and download them from "<a href="http://amalan008.blog.com/">Amalan's Blog</a>". Then try the exercises in the Text book. Do the Lab assignments on your own and get familiar with the SPSS generated outputs. Do the final exam past papers from 2007 to 2010. No need to do the repeat papers because that is really unnecessary. If you have more time, refer the "Probability & Statistics for Engineers & Scientists 8th Edition". The solution manual is also available for downloading (Category : Probability & Statics). </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><u><b>Data Communication & Computer Networks II</b></u></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">This is the easiest subject for me. Read the text book and learn the concepts. Do the assignment on your own and learn about the protocols and get some idea about them. Do all the lab sheets so that you will learn the concepts without much effort. <a href="http://dinnaz06.blogspot.com/">Visit Dinuka's Blog for more help</a>.You can <a href="http://www.mediafire.com/?01pgbmm883353r5">download the answers for all the lab sheets from here</a>. Go through the lecture slides available in the course web. Refer the book 'TCP/IP Protocol Suite'. The power point presentation slides of this book are available for downloading at the Ebook Linker (Category : TCP/IP). Do the past papers from 2007 to 2010 without waiting till the last moment. Then you will see the pattern of the questions.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><u><b>Software Technology II</b></u></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Read the text book so that you won't repent if something in the book comes for the exam. Do all the lab sheets on your own. Do the past papers and also the tutorials. Get ready for the second online exam so that you can get rid of the score board pressure at the final exam. Do the programming assignment well and you are done.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><u><b>Systems Programming & Design</b></u></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">This is one of the critical subjects but if you have the practical knowledge and hands on experience with Shell Scripting, System Calls, Perl and CGI, then it won't be that much hard. For shell programming, refer the book 'Unix Shell Programming' (Category : Shell Programming). For System Calls, refer the books 'Let us C' (Category : C) and 'Linux System Programming' (Category : Systems Programming) . No need to read the whole book, just go through the relevant chapters.For perl programming<a href="http://thariya.blogspot.com/2011/03/stepping-to-next-level-of-perl.html"> read this post first</a> and watch the lynda.com videos. Refer the book 'Learning Perl' (Category : Perl). For CGI scripting also lynda.com videos are really helpful. <a href="http://draft.blogger.com/%20http://www.downeu.com/forum/video-tutorials/469652-lynda-com-using-perl-cgi-scripts.html">This is the link where I downloaded CGI/Perl videos</a>. This is the link where<a href="http://www.filestube.com/80b6ff72450e955c03e9,g/Lynda-Com-CGI-Essential-Training-iRONiSO-%20%20KELCYRA4EVER.html"> I downloaded the CGI Essential Training videos</a>. Read the text book and do the lab sheets also. Then try the past papers.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><b><u>Software Engineering I</u></b></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Go through the notes of the lectures. Do the group assignment well and understand the concepts. Then try the past papers. No need to refer the text book or any other reference book.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Hay everybody..... Let's get good results from the upcoming exams !!!</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">P.S - All the reference books I have mentioned are available for downloading at "<a href="http://tharindu.somee.com/">Thariya's Ebook Linker</a>".Search under the given category.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">-Tharindu Edirisinghe-</div><div style="text-align: justify;">-SLIIT 10'-</div>Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com2tag:blogger.com,1999:blog-6054025946250665729.post-73621077400678431292011-03-20T22:32:00.002+05:302011-03-21T21:13:53.566+05:30Mission 4.0 GPA at SLIIT - Part 2<div style="text-align: justify;">Today is 20th March 2011 and it's 9 : 53 P.M. I'm going to write what happened today. The alarm rang at 4 : 00 A.M and I woke up and hurried to turn it off because I didn't want to wake up Isuru's parents by letting the alarm ring continuously. Isuru was sleeping and I tried to wake him up. Then he told me that he wanted to sleep another half an hour. So I continued learning the PS book alone. Isuru woke up at 4 : 30 A.M and we both did some questions together and discussed them.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">The discussion was very much helpful where he asked me some questions which are really important and I figured out the answers on my own. For example do you know why the probability of getting an exact value in a continuous probability distribution is zero ? Think about it like this. Imagine the graph of the probability density function. Now the specific area under that particular value is the required probability. To get that area, you have to integrate the probability density function. When you integrate, both the upper and lower limits are equal to that particular value which you want to find the probability. So when you substitute them, the answer becomes zero. I hope you got it.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">I came home around 11 : 00 A.M. Despite having a lot of work to do, I watched the movie '<a href="http://www.imdb.com/title/tt1470827/">Monsters</a>'. That's my hobby. I can remember when I was doing the final exams of the last semester at SLIIT, even on the day before the exam started I watched a movie. After that I had a nap for around two hours and started the work again. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">I completed up to the chapter 6 of that <a href="http://thariya.blogspot.com/2011/03/mission-40-gpa-at-sliit-part-1.html">PS Crash Course book</a> and started doing some past papers. I answered some questions in 2010, 2009 and 2008 P&S final past papers. The paper seems to be really easy than I expected. If you know the theories well and if you are good in analytical thinking, then it won't be hard. One thing I realized is that following only the text book is not enough. This PS crash course is really good in that case. For example in 2009 PS final paper, see the last part of the 1st Question. To answer that, you need to know that </div><br />
E [ X + Y ] = E [ X ] + E [ Y ]<br />
E [ X - Y ] = E [ X ] - E [ Y ]<br />
E [ X . Y ] = E [ X ] . E [ Y ]<br />
E [ c . x ] = c . E [ X ]<br />
Var [ c . X ] = c ^2 Var [ X ]<br />
Var [ X + Y ] = Var [ X ] + Var [ Y ] <br />
Var [ X - Y ] = Var [ X ] + Var [ Y ] <br />
<div style="text-align: justify;"><br />
</div><div style="text-align: justify;">These things are not in the PS text book. But they are in that PS Crash Course Book. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">When answering the 1st Question of 2009 final paper, we have to draw a stem and leaf plot. I didn't know how to choose the stem width and leaves so that I used SPSS software to do it for me.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://lh6.googleusercontent.com/-_z7h5wCQbOU/TYYuwGJ7uCI/AAAAAAAAA-o/ATtbr50Yyqg/s1600/2009.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="156" src="https://lh6.googleusercontent.com/-_z7h5wCQbOU/TYYuwGJ7uCI/AAAAAAAAA-o/ATtbr50Yyqg/s320/2009.jpg" width="320" /></a></div><div style="text-align: justify;">Click on the image to zoom it. See that every leaf is zero.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Then in 2008 final PS paper, Question 1. </div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh6.googleusercontent.com/-6lcLWESvX8U/TYYuu530yPI/AAAAAAAAA-k/rcHluWqDxGQ/s1600/2008.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://lh6.googleusercontent.com/-6lcLWESvX8U/TYYuu530yPI/AAAAAAAAA-k/rcHluWqDxGQ/s320/2008.jpg" width="320" /></a></div><div style="text-align: justify;">A stem and leaf plot is given. Stem width is 10. Here, in between the stem value and leaf value, a decimal point is not given. I have a little bit of confusion here. According to this, to get the values we have to concatenate the stem value and the leaf value and then multiply it by the stem width. Then we get values like 110, 120, 120, 130 .... and so on. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">I checked this further by putting some values in SPSS software. Click on the image below to zoom.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh4.googleusercontent.com/-qz2V1neT5Rg/TYYud_eqc2I/AAAAAAAAA-g/e1kod4H9fYk/s1600/test.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://lh4.googleusercontent.com/-qz2V1neT5Rg/TYYud_eqc2I/AAAAAAAAA-g/e1kod4H9fYk/s320/test.JPG" width="300" /></a></div><div style="text-align: justify;">My input values were 11, 12, 12, 13, ... and so on. It gave me the stem width 10 and you see a decimal point in between the stem value and the leaf value. I hope to further clarify this at the PS help desk from Hansa sir. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">I'll be continuously writing this series of posts until the exams start, so keep in touch with my blog. My instinct tells me what to do next and I simply follow that as I did in previous exams and got good results. So follow me and get good results.</div><br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'-Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com0tag:blogger.com,1999:blog-6054025946250665729.post-43170242132781773572011-03-20T00:14:00.000+05:302011-03-20T00:14:18.152+05:30Mission 4.0 GPA at SLIIT - Part 1<div style="text-align: justify;">Today is 19th March 2011 and my clock shows the time as 11:33 P.M. Few minutes more to the mid night and I'm infront of Isuru's PC at his place. He is doing some PS questions and I'm little bit exausted now and so thought of writing something which will be useful to all my friends at SLIIT. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">We have around 1 month for the final exam at SLIIT. So I started getting ready for the exam today. So I came to Isuru's place and we are studying together. We have come up with a plan to get good results from the exam and I thought of sharing it with my friends. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Now the most difficult and the critical subject is 'Probability and Statistics' (PS). Even I don't have a clear understanding on this subject. Unfortunately we don't have electives and it's a must to follow this subject. I found a good learning material which simply describes everything in this subject. That is "Schaum's easy outlines Probability and Statistics Crash Course". I got it printed because it's really worth learning.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">You can download it from "<a href="http://tharindu.somee.com/">Thariya's Ebook Linker</a>" (Search under the category "Probability & Statistics"). </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ3D68ZXPvY7baLja4T8Kx1jAmPYUwW32-C2ykVWIW1jKyGzYxMeNFwRVFP-_D7bEx1oqSi-zXEpPKhue_5PpvZIUj-Y5ag0FL2xSg5ogCq-PMSxtkFDrx0QhcPWqhwkgkMDC4Wn7496U/s1600/ps.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ3D68ZXPvY7baLja4T8Kx1jAmPYUwW32-C2ykVWIW1jKyGzYxMeNFwRVFP-_D7bEx1oqSi-zXEpPKhue_5PpvZIUj-Y5ag0FL2xSg5ogCq-PMSxtkFDrx0QhcPWqhwkgkMDC4Wn7496U/s320/ps.jpg" width="207" /></a></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">At the moment I have completed three chapters from that. Now we are going to sleep. Hope to wake up at 4.00 A.M tomorrow and finish PS and try to answer some past paper questions. I hope everybody would follow this book and I want to see everybody getting 'A' passes for PS.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDI2VbvMQy8MNN6mgK0X5z4Kv2v3wYwBjxiseWAaJfMWN2xsMWiObEeWmtLu-MlhPdSENKY-UjPy_ccJUPkdH1PCxel5-Nr4AZ4LFSbXQSmZn8LBAta8WQNq3SVO9Jt_qREPYtaZGjef0/s1600/dfdf.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDI2VbvMQy8MNN6mgK0X5z4Kv2v3wYwBjxiseWAaJfMWN2xsMWiObEeWmtLu-MlhPdSENKY-UjPy_ccJUPkdH1PCxel5-Nr4AZ4LFSbXQSmZn8LBAta8WQNq3SVO9Jt_qREPYtaZGjef0/s320/dfdf.JPG" width="320" /></a></div><div style="text-align: center;">(Left : Isuru, Right : myself - Rocking PS)</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">-Tharindu Edirisinghe-</div><div style="text-align: justify;">-SLIIT 10'-</div><div style="text-align: justify;"> </div>Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com6tag:blogger.com,1999:blog-6054025946250665729.post-49894607471679884202011-03-17T20:47:00.001+05:302011-03-17T21:47:53.488+05:30Thariya's Ebook Linker<div style="text-align: justify;">In this fast growing IT field, technology is changing day by day. Therefore as the IT undergraduates, we must always update our knowledge and we should be aware of what's happening in the Information Technology world.Other thing is getting good results from the exams in our degree programs. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">There are so many good learning resources on the internet. We must refer them when we are studying, but the problem is we have to put more effort to find good resources other than using them. I came up with a solution to overcome this problem. That is developing a web based application to share learning resources. It was a difficult task because I'm still learning the web developing technologies where I had to learn some methods from the beginning.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">I developed the website '<a href="http://tharindu.somee.com/">Thariya's Ebook Linker'</a> where anybody can visit, create an account and download the resources. At the same time, the registered members can share the learning material they have by adding it's download link to the database. I used ASP.NET technology with C# as the programming language and a Microsoft SQL database to store data. The experience I got from the<a href="http://thariya.blogspot.com/2011/02/ita-group-project-part-i.html"> ITA project in the 1st year</a> 2nd semester was very much useful when developing the website. As new things, I learned how to upload images from the user's PC to the web site through a file uploader, resize the images to predefined dimensions and save them in the server.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">This is the login page of the website.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh5.googleusercontent.com/-kWexluIn9jo/TYF1mlFR3AI/AAAAAAAAA9U/jbUqK3MxNZs/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="228" r6="true" src="https://lh5.googleusercontent.com/-kWexluIn9jo/TYF1mlFR3AI/AAAAAAAAA9U/jbUqK3MxNZs/s320/1.jpg" width="320" /></a></div><div class="separator" style="clear: both; text-align: left;">Some of the resources shared by the members of the website.</div><div align="left" class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg67mIq5YPL8N8u01TpFnpI4VeDTsUcJuOGU5qZflpnKMvm476MrYY_Nj9sZHm25IHH1Yv74pKskuyVNj25p683fNbhh80g7QlMrNvJ2DwhiL5tPHlULI9xjgV_ULWHYlsSVJ306lRYOSA/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" r6="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg67mIq5YPL8N8u01TpFnpI4VeDTsUcJuOGU5qZflpnKMvm476MrYY_Nj9sZHm25IHH1Yv74pKskuyVNj25p683fNbhh80g7QlMrNvJ2DwhiL5tPHlULI9xjgV_ULWHYlsSVJ306lRYOSA/s320/2.jpg" width="212" /></a></div>Users can search for learning material by categories. <br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://lh4.googleusercontent.com/-Zwdb7qklBWg/TYF13py4wHI/AAAAAAAAA9o/E1WDY0OzxX0/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" r6="true" src="https://lh4.googleusercontent.com/-Zwdb7qklBWg/TYF13py4wHI/AAAAAAAAA9o/E1WDY0OzxX0/s320/5.jpg" width="314" /></a></div>Some of the interfaces of the website. This is the first time I designed all the interfaces on my own. For some interfaces, I used the same coding and the pages form our <a href="http://teamss.somee.com/">ITA project website</a>. <br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://lh6.googleusercontent.com/-4GwzlVNIoYk/TYF2kHB4wrI/AAAAAAAAA90/sb68rKZovbM/s1600/Collages.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" r6="true" src="https://lh6.googleusercontent.com/-4GwzlVNIoYk/TYF2kHB4wrI/AAAAAAAAA90/sb68rKZovbM/s320/Collages.jpg" width="320" /></a></div><div style="text-align: justify;"></div><div style="text-align: justify;">You can <a href="http://tharindu.somee.com/">visit the website from this Link</a>. Share your learning resources with others. </div><div style="text-align: justify;"><br />
P.S - Special thanks to Mr. Jagath Wickramarathne<span class="profileName ginormousProfileName fwb"> (My ITA lecturer) for introducing ASP.NET and C# to me. </span><br />
<span class="profileName ginormousProfileName fwb">Special thanks to Mr. Asitha Perera and </span>Ms. Manori Gamage <span class="profileName ginormousProfileName fwb">(My DBMS I lecturers) for introducing SQL and database management systems to me.</span><br />
<span class="profileName ginormousProfileName fwb"><br />
</span></div><div style="text-align: justify;">-Tharindu Edirisinghe-</div><div style="text-align: justify;">-SLIIT 10'-</div>Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com3tag:blogger.com,1999:blog-6054025946250665729.post-52802038915493973452011-03-16T05:37:00.000+05:302011-03-16T05:37:54.578+05:30Stepping to the next level of Perl Programming<div style="text-align: justify;">From my previous post I told you<a href="http://thariya.blogspot.com/2011/03/starting-perl-programming-on-windows.html"> how to start Perl programming on windows</a>. After being familiar with the syntax of Perl, all what you need is a good IDE where you could write the programs, run and easily get the output while being in the same place. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">One of the IDEs I found convenient to use is the '<a href="http://www.eclipse.org/">Eclipse</a>' IDE. It is originally developed for java development, but by downloading and installing the Perl extension for Eclipse, you can use it for Perl programming.The following video describes how to download the IDE and how to configure it for Perl.</div><br />
<div class="separator" style="clear: both; text-align: center;"><object width="320" height="266" class="BLOGGER-youtube-video" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" data-thumbnail-src="http://i.ytimg.com/vi/irnJ_NymEFA/0.jpg"><param name="movie" value="http://www.youtube.com/v/irnJ_NymEFA?f=user_uploads&c=google-webdrive-0&app=youtube_gdata" /><param name="bgcolor" value="#FFFFFF" /><embed width="320" height="266" src="http://www.youtube.com/v/irnJ_NymEFA?f=user_uploads&c=google-webdrive-0&app=youtube_gdata" type="application/x-shockwave-flash"></embed></object></div><div style="text-align: justify;">To master Perl Programming, you can refer books written on Perl development, but my recommendation is <a href="http://www.lynda.com/">Lynda</a> 's Video tutorials series. You can download the Lynda.com Perl 5 Essentials video series free.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><a href="http://www.esoft.in/ebooks/36973-lyndacom-perl-5-essential-training-ironiso.html">This is the link where I downloaded it from.</a> If the link doesn't work, just search in google for 'Lynda.com Perl rapidshare, hotfile, megaupload'. There are plenty of download links available.</div><br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'-Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com0tag:blogger.com,1999:blog-6054025946250665729.post-6681276640125624052011-03-13T13:29:00.001+05:302011-03-13T13:34:02.624+05:30Statistical Data Analyzer V 2.0 with Source Code<div style="text-align: justify;">I hope now you are familiar with this software since the <a href="http://thariya.blogspot.com/2011/01/thariyas-statistics-data-analyzer.html">Beta version</a> and the <a href="http://thariya.blogspot.com/2011/02/thariyas-statistical-data-analyzer.html">Version 1.0</a> were released previously. Let's see what are the newly added features and the functionality of this software.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">This is the first window. Same as the previous versions. Enter the number of data points and proceed. </div><div style="text-align: center;"><a href="https://lh5.googleusercontent.com/--uI1ue291HY/TXxGJyrR8xI/AAAAAAAAA8I/rPZxx5qmzsQ/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="152" src="https://lh5.googleusercontent.com/--uI1ue291HY/TXxGJyrR8xI/AAAAAAAAA8I/rPZxx5qmzsQ/s320/1.jpg" width="320" /></a> </div><div style="text-align: justify;">Then you get the data entering window. Here I have added some sample data to demonstrate what is happening. </div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-u0GuttjnlDY/TXxGReaVd3I/AAAAAAAAA8Q/-ImPAQC--NQ/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://lh3.googleusercontent.com/-u0GuttjnlDY/TXxGReaVd3I/AAAAAAAAA8Q/-ImPAQC--NQ/s320/2.jpg" width="241" /></a></div><div style="text-align: justify;">Enter your data one by one. No need to sort and enter. It can sort your data itself. To see the descriptive statistics, press the button 'Statistics Analyzer'. Then you get the following window. Now you see the modification. In the previous versions it showed all the data in the same window itself. Here it is well organized and you can get the conclusions one by one.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-mkuEZuSkTbo/TXxGOV2xh1I/AAAAAAAAA8M/C0pe5DVnio0/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://lh3.googleusercontent.com/-mkuEZuSkTbo/TXxGOV2xh1I/AAAAAAAAA8M/C0pe5DVnio0/s320/3.jpg" width="260" /></a></div><div style="text-align: justify;">These are the operations performed by each of the buttons.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">'Min Max Range' button will open a window as follows.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh4.googleusercontent.com/-hjPJNqTFcmI/TXxGV2zMKII/AAAAAAAAA8Y/3hikLAMWpms/s1600/4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://lh4.googleusercontent.com/-hjPJNqTFcmI/TXxGV2zMKII/AAAAAAAAA8Y/3hikLAMWpms/s1600/4.jpg" /></a></div><div style="text-align: justify;">'Quartiles' button will show the Quartiles and the Inter Quartile Range (IQR). In previous versions this was misspelled as IRQ. Now it is corrected.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-k6X19N9fRs0/TXxGTNcCWHI/AAAAAAAAA8U/4sIxQtCicL8/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="195" src="https://lh3.googleusercontent.com/-k6X19N9fRs0/TXxGTNcCWHI/AAAAAAAAA8U/4sIxQtCicL8/s320/5.jpg" width="320" /></a></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">'Calculations' button gives you some important calculations which are helpful to find the descriptive statistics manually and obtain results. In the previous versions, instead of Sigma sign I had used 'E'. because the program didn't support the Unicode characters. It wasn't correct because 'E' stands for the 'Expected Value' and gives a different meaning. In this version that is also corrected.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh6.googleusercontent.com/-lA413daS21I/TXxGXki_qfI/AAAAAAAAA8c/mbAAhC8dd_M/s1600/6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="260" src="https://lh6.googleusercontent.com/-lA413daS21I/TXxGXki_qfI/AAAAAAAAA8c/mbAAhC8dd_M/s320/6.jpg" width="320" /></a></div><div style="text-align: justify;">'Variance and Standard Deviation' button will give you the Variances and the Standard Deviations of the Sample as well as the population.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-Kzc3cIlNnMw/TXxGX_W_ZJI/AAAAAAAAA8g/PBww2q1FIRQ/s1600/7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="132" src="https://lh3.googleusercontent.com/-Kzc3cIlNnMw/TXxGX_W_ZJI/AAAAAAAAA8g/PBww2q1FIRQ/s320/7.jpg" width="320" /></a></div><div style="text-align: justify;">'Mode' button will give you the mode of the sample data set. It is capable of finding multiple modes if exists. In the Beta Version it wasn't implemented and then the Version 1.0 came with that. The important thing is that the algorithm I used in Version 1.0 was not capable to handle every possible combination of data. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">eg: If your sorted data set is like ' 1 , 19, 19, 22, 23, 25, 25, 27, 29, 29 ' , the modes should be 19, 25 and 29. The algorithm could identify only 19 and 25. It ignored 29. This error was reported by 'Praveen Dehideniya', a fellow student of SLIIT in his feed back. In this version, I modified the algorithm and now it's working perfectly.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-_UFeNEx8elY/TXxGaNri5pI/AAAAAAAAA8k/BaRnsuJfSMA/s1600/8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://lh3.googleusercontent.com/-_UFeNEx8elY/TXxGaNri5pI/AAAAAAAAA8k/BaRnsuJfSMA/s320/8.jpg" width="223" /></a></div><div style="text-align: justify;">'Outliers' button will show the bounds of the data set and the outliers if any. </div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh6.googleusercontent.com/-fzh2VDU3Pt8/TXxGaIe9z2I/AAAAAAAAA8o/YiN2pIRnAPQ/s1600/9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://lh6.googleusercontent.com/-fzh2VDU3Pt8/TXxGaIe9z2I/AAAAAAAAA8o/YiN2pIRnAPQ/s1600/9.jpg" /></a></div><div style="text-align: justify;">'Box Plot Example' button will show a sample Box Plot and will provide you some hints on how to draw the Box Plot correctly. This is a newly implemented feature and it can generate four different Box Plots depending on your data set. These sample Box Plots are predefined and will show the correct one appropriately.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMmgrFd961qQuquympMcnGi5oQ5Z7_B2LBQt8ay4_H6BgCoPWAVGs03LMy4Pttgn9kMA0LzMACNqVZp6K6P2tYn_UBONlNNLwYuaTSrcIGKHqJ-JViZpebgrLfOUn8eH9nZsR9drdUKQk/s1600/10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMmgrFd961qQuquympMcnGi5oQ5Z7_B2LBQt8ay4_H6BgCoPWAVGs03LMy4Pttgn9kMA0LzMACNqVZp6K6P2tYn_UBONlNNLwYuaTSrcIGKHqJ-JViZpebgrLfOUn8eH9nZsR9drdUKQk/s320/10.jpg" width="320" /></a></div><div style="text-align: justify;">That's all about the software and you can easily use this when you are doing the 'Probability & Statistics' final exam past papers to check whether your answers are correct instead of using SPSS software.</div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXIQjc0rzDmpNyTawQNcaa_T3xCvFtOgUUf7kM8IEn5d7LGWZBNrxtospBIPrNXEfRibchcLcM7qzS9Tbtnx-4swxeqjdDBAuZwvZtDl3Im12BwFjpIleCwje7IrxNLM_TpJYQt5HMeQo/s1600/11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXIQjc0rzDmpNyTawQNcaa_T3xCvFtOgUUf7kM8IEn5d7LGWZBNrxtospBIPrNXEfRibchcLcM7qzS9Tbtnx-4swxeqjdDBAuZwvZtDl3Im12BwFjpIleCwje7IrxNLM_TpJYQt5HMeQo/s320/11.jpg" width="320" /></a></div><div style="text-align: justify;">Finally, if you find this software is useful, just send me your comments because despite having all the work, I dedicated much time on developing this. So no point if this is not useful for anybody. Your comments are warmly welcome and they will encourage me to continue my work.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">You need to have the .NET Framework 3.5 or above to run this software.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><a href="http://www.mediafire.com/?n3udzf67atjpld2">Click Here to Download</a> the Portable Version (718.08 KB). No need of installation.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><a href="http://www.mediafire.com/?ram6pq7a46bwah9">Click Here to Download</a> the Setup (1.06 MB). This needs installation.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><a href="http://www.mediafire.com/?ddemlf0tu4e2050">Click Here to Download</a> the Source Code (8.2 MB). You can customize the software according to your requirements.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh4.googleusercontent.com/-Ppwyp28xECI/TXxGw580IeI/AAAAAAAAA80/-zB5j4dH57s/s1600/stat+soft.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" src="https://lh4.googleusercontent.com/-Ppwyp28xECI/TXxGw580IeI/AAAAAAAAA80/-zB5j4dH57s/s320/stat+soft.jpg" width="320" /></a></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">P.S - 'Hard to Use' things are easy to build. 'Easy to Use' things are hard to build.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">-Tharindu Edirisinghe-</div><div style="text-align: justify;">-SLIIT 10-</div><div style="text-align: justify;"><br />
</div>Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com7tag:blogger.com,1999:blog-6054025946250665729.post-76338691043426119852011-03-09T20:14:00.000+05:302011-03-09T20:14:45.426+05:30Starting Perl Programming on Windows<div style="text-align: justify;">We learn Perl Programming for "Systems Programming and Design" subject. Since most of the students are using Windows as the main operating system and use Linux operating systems installed as virtual PCs on windows, I thought of writing this post and show you how to install Perl on windows and start Perl programming.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">All the major Linux operating systems are coming with Perl installed but on windows, you have to manually install Perl. First go to the Command Prompt and check whether your Windows operating system is already having a Perl installation. To check that type '<span style="color: #20124d;">perl -version</span>' or <span style="color: #274e13;">'<span style="color: #20124d;">perl -v</span></span>' and press Enter. If Perl is already installed it will show information about the installation. If not it will give an error message.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">You can download Perl from <a href="http://www.activestate.com/">http://www.activestate.com/</a> website.The size of the setup file will be around 25 MB so don't worry. Download the correct setup according to your Windows operating system.</div><div class="separator" style="clear: both; text-align: justify;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaR-sYe0VWxTrPBASQ2-kx-yR7DI51rHu_pKazlfgyYUjdm83TkRlYfPtM2hQqlGtdhUdRWUxwBm1JDJcOp2wl6rMh4vWf97wpvg6CGEfI6ZXbozuHAyBYhqne66awMIbZcEFrY8PqgOk/s1600/download+perl.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaR-sYe0VWxTrPBASQ2-kx-yR7DI51rHu_pKazlfgyYUjdm83TkRlYfPtM2hQqlGtdhUdRWUxwBm1JDJcOp2wl6rMh4vWf97wpvg6CGEfI6ZXbozuHAyBYhqne66awMIbZcEFrY8PqgOk/s320/download+perl.jpg" width="320" /></a></div><div style="text-align: justify;">After that install it. When you are installing it will ask you whether to update the PATH variable. Tick that and continue installation so that you don't need to update the PATH manually to run your Perl programs.</div><div style="text-align: justify;"> </div><div style="text-align: justify;"> Once you have installed, go to Command Prompt and check whether it is installed correctly. Type 'perl -v' and you will get the information about the version. Now we have successfully installed Perl.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><u><b>How to start Perl Programming ?</b></u></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">To write your Perl programs, you need a text editor. You can use the Notepad but my opinion is it is not good when you wish to do some serious programming because it doesn't highlight the syntax. I recommend 'Notepad++' which is a free software. You can download it from <a href="http://notepad-plus-plus.org/download">http://notepad-plus-plus.org/download</a> . Download it and install.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Then create a new file in Notepad++ and before writing your program, save it with .pl extension. For the file type, select 'Perl Source File (.pl.....)'. Now type your first program and save it.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><span style="color: red;">printf</span>("<span style="color: #20124d;">Hello world ! \n</span>");</div><div style="text-align: justify;"><span style="color: red;">printf</span>("<span style="color: #351c75;">This is my first Perl Program \n</span>");</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Open the command prompt and change your current directory to the location where your Perl program is saved. Now type </div><div style="text-align: justify;">'<span style="color: #20124d;">perl filename.pl</span>' and you will get the output as below.</div><div style="text-align: justify;"><br />
</div><div style="color: #4c1130; text-align: justify;">Hello world !</div><div style="text-align: justify;"><span style="color: #4c1130;">This is my first Perl Program</span></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">P.S - From my next post I'll tell you how to master Perl Programming on your own.</div><div style="text-align: justify;"><br />
</div>-Tharindu Edirisinghe-<br />
-SLIIT 10'-Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com3tag:blogger.com,1999:blog-6054025946250665729.post-2094899615373953672011-03-08T00:26:00.001+05:302011-03-08T00:29:21.164+05:30ITA Group Project - Part V<div style="text-align: justify;">If you couldn't read the previous posts of this series, first read them. <a href="http://thariya.blogspot.com/2011/02/ita-group-project-part-i.html">Part I</a>, <a href="http://thariya.blogspot.com/2011/02/ita-group-project-part-ii.html">Part II</a>, <a href="http://thariya.blogspot.com/2011/03/ita-group-project-part-iii.html">Part III</a>, <a href="http://thariya.blogspot.com/2011/03/ita-group-project-part-iv.html">Part IV</a>.</div><div style="text-align: justify;"><br />
Fortunately 12 Lab II had plug bases under the computers (In some other labs they were sealed I guess) and all of them were occupied. I shutdown a PC in the lab and plugged my laptop there. We had to hurry up because we were only given 5 minutes to get prepared. I asked Sasika to turn his laptop on and give me a copy of the home page he designed for the website. I hurried up to paste it in the project and integrated them. Then I gave an introduction to Mezaj and Sajee what we should do and did a quick demonstration.</div><div style="text-align: justify;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6vOeor3YdxdUmPqdtct9V4lmjD2pGzn6PEsfeNwuz-Tg3vkkwkbJPZhgAW-sQshc1BLD96jJLBY2voKprOklckTXeDMFkxGuJarZoZuQJpp-TsbW3sEZ-c1MeVLZr7advpL-M4NoFZqU/s1600/38064_1499910065271_1459750096_1318308_1153688_n.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6vOeor3YdxdUmPqdtct9V4lmjD2pGzn6PEsfeNwuz-Tg3vkkwkbJPZhgAW-sQshc1BLD96jJLBY2voKprOklckTXeDMFkxGuJarZoZuQJpp-TsbW3sEZ-c1MeVLZr7advpL-M4NoFZqU/s320/38064_1499910065271_1459750096_1318308_1153688_n.jpg" width="320" /></a></div>(Mezaj and myself..... Planning something serious !!!)</div><div style="text-align: justify;"></div><div style="text-align: justify;"><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEia9ZARYPJf8oifiI8xK4gctDliUNwNEgDCyYsV4jZGnzrAEwrPMyOtFIzM58qABzJGYKNzUbcRbuAQ56jclnpKpKzi7IQ4vwwrU2y_N5-j-nq4HLikWLyWO1xM9f6XdyrVzR08D0meBkQ/s1600/38064_1499910145273_1459750096_1318310_7848707_n.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEia9ZARYPJf8oifiI8xK4gctDliUNwNEgDCyYsV4jZGnzrAEwrPMyOtFIzM58qABzJGYKNzUbcRbuAQ56jclnpKpKzi7IQ4vwwrU2y_N5-j-nq4HLikWLyWO1xM9f6XdyrVzR08D0meBkQ/s320/38064_1499910145273_1459750096_1318310_7848707_n.jpg" width="240" /></a></div></div><div style="text-align: justify;">(Dasun and Sajee..... Watching me working I guess :D)<br />
<br />
</div><div style="text-align: justify;">Then we plugged the projector to my laptop and I started presenting our project. I demonstrated the user levels of the website and then showed how to register a new customer. The validation was also working perfectly. Then I showed how to login to the website. Also I showed how to recover the password using the security question and how to modify the account details without letting Ms. Isuri ask even a single question. I think she was extremely satisfied with the workability of our solution. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Then Sasika described and showed how to make a reservation using the website and the functionality of the shopping cart feature. Then Mezaj showed how the data of the extra facilities of our apartment reservation system are generated and loaded into the grid view of the web page. He also described the functionality of the Contact Us page. Then Sajee expressed the difference between the dynamically generated pages and the statically designed pages using the About Us page.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Unfortunately the Searching function was not working correctly but other than that all the other features , functionality and the interfaces of the website were relatively at a higher level when compared to the work done by other groups. </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT2HMfWm_K0JaPYb6kbgW3xC0C36JZmj85Wj_lbkFDuH5-RtBtn-vRVk0zLiw-Ae8V1aoaYSTdZgLf_1CkeuqylHLD7t563DvfBax2XgPtf-iuNzYSWx5lBfns4or3I45n9Z0QgFjPTNU/s1600/38064_1499910265276_1459750096_1318313_6999329_n.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT2HMfWm_K0JaPYb6kbgW3xC0C36JZmj85Wj_lbkFDuH5-RtBtn-vRVk0zLiw-Ae8V1aoaYSTdZgLf_1CkeuqylHLD7t563DvfBax2XgPtf-iuNzYSWx5lBfns4or3I45n9Z0QgFjPTNU/s320/38064_1499910265276_1459750096_1318313_6999329_n.jpg" width="320" /></a></div><div style="text-align: justify;">(Sasika in a lab session of ITA. The Interface designer of the project)</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">After doing the presentation, we uploaded the source code to the course web. Then I went home and had a long sleep as I couldn't have for over four days.</div><br />
<div style="text-align: justify;">P.S - The successful completion of the project and the presentation led me to get an <a href="http://thariya.blogspot.com/2010/12/1st-year-2nd-semester-results.html">'A' for the ITA</a> subject from the 2nd semester exam of the 1st year. I further developed the website during the vacation and hosted it on a free server. You can visit it from <a href="http://teamss.somee.com/">http://teamss.somee.com</a>. This is the end of this series of posts. Finally let me tell you one thing. Always try to be the guy who saves the day. Even when the other group members go down, you must be able to do the whole thing and save your GPA.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEganlMSm175Aj7-sCj5I32KuqMPzL9pPssvDFrCixCiy8ik556fcaSc_FEOk8nbq-GAW0mxW_qbfGLSDm01u0J8eiGL1yJW5R-wA-ONk9P5nMwx0jNfmn1t53KixK0AE_x9uJIAwak9Hgo/s1600/thari.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEganlMSm175Aj7-sCj5I32KuqMPzL9pPssvDFrCixCiy8ik556fcaSc_FEOk8nbq-GAW0mxW_qbfGLSDm01u0J8eiGL1yJW5R-wA-ONk9P5nMwx0jNfmn1t53KixK0AE_x9uJIAwak9Hgo/s320/thari.jpg" width="320" /></a></div><div style="text-align: justify;">(Every single coding came from my head)</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><a href="http://www.mediafire.com/?6dz967oqdeme87k">Click Here to Download the Source code and the database</a>. (6.14 MB)</div><div style="text-align: justify;">Extract the downloaded zip file. Then you'll get a folder and inside that there are two folders. One of them contains the MS SQL database and the log file. <a href="http://thariya.blogspot.com/2010/12/how-to-copy-microsoft-sql-server.html">Read this post</a> and paste the database and the log file where your other databases are stored in your PC and attach the database.</div><div style="text-align: justify;">The other folder contains the web pages. Edit the web.config file by modifying the connection string.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">my connection string : Data Source=YASIRU-PC;Initial Catalog=ssbooks;Integrated Security=True </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Instead of 'YASIRU-PC', put your SQL server name there. Then build the project and run. You have to run the 'Default.aspx' page and unless it will redirect you to the error page since I have created and managed the sessions in the Default page. </div><br />
-Tharindu Edirisinghe-<br />
-SLIIT 10'-Tharindu Edirisinghehttp://www.blogger.com/profile/12940283701735485444noreply@blogger.com9