CPS Does Blogging

New Start

2010-10-31T19:51:00.002+05:30

it's almost 3 years from my last post :) i feel like blogging again.may be coz of a special request.I am still thinking i should continue this or not.May be i have a feeling that i may stop this again in near future.But I have to start.As i mention ,coz of a special request :) So where should i start ?

it's again......

2007-12-26T16:39:00.001+05:30

Thanks for all the people who remembered the day... :)

Visual Studio 2008 and .NET 3.5 Released

2007-11-20T11:10:00.000+05:30

Yesterday(November 19, 2007) Microsoft has Released Visual Studio 2008 and .NET 3.5. You can download the final release using one of the links below :

you can download a 90-day free trial edition of Visual Studio 2008 Team Suite here. A 90-day free trial edition of Team Foundation Server can also be downloaded here.

Still they haven't announce about the trial of visual studio professional.

If you want to use the free Visual Studio 2008 Express editions (which are much smaller and totally free), you can download them here.
If you want to just install the .NET Framework 3.5 runtime, you can download it here.

And if you wanna know about more details about this please visit ScottGu's Blog

Dynamic Template Columns in the ASP.NET 2.0 GridView Control: Part 2

2007-08-07T14:26:00.000+05:30

Sorry for the delay. It's a bit late to publish the continuation of my earlier post. As I mentioned previously you can add a dynamic column to gridview. However there is another way of doing it. It depends on your requirement. The 2 ^ndmethod is much easier though.

You have to create a Usercontrol. Let's say you need to have a Text box in your grid. Then just add a text box to your Usercontrol and in HTML view you can edit it as shown below... (Other than a Textbox I have add a CompareValidator to check the data type of the Text box.)

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="MyUserCont.ascx.cs" Inherits="TestApp_MyUserCont" %>
' Width="90px">
ID="CompareValidator1" runat="server" Display="Dynamic" Type="Currency" Operator="DataTypeCheck"
ErrorMessage="*" ControlToValidate="txtQty">

In the code Text='<%# Bind("Quantity") %>' take care of Binding data to the Text property of the Textbox. "Quantity" is the Column name of my data table (gridview data source).

Next is to create your Dynamic column as follows...

TemplateField tmpQty = new TemplateField();
tmpQty.HeaderText = "Quantity";
tmpQty.ItemTemplate = LoadTemplate("../TestApp/MyUserCont.ascx");
tmpQty.Visible = true;
gvTransaction.Columns.Add(tmpQty);

Hope this will make things easier than the earlier method. But there are some limitations. So as I mentioned earlier you have to identify which method is suitable according to your requirement.

Dynamic Template Columns in the ASP.NET 2.0 GridView Control: Part 1

2007-08-03T16:19:00.000+05:30

Recently I was involved in a project where we needed to present the results of a database query as part of an ASP.NET application. It was such that the user can select grid columns and the type of the columns also Differentiating depending on the requirement. It may be a button, column, editable column (text box,check box,etc...) It was not known until runtime how many columns has to display, which columns has to display or which SQL query is needed to satisfy the search criteria. So I had to use dynamics template coloumns for the editable coloumns.

A GridView template is a class that implements the ITemplate interface. It defines the controls that will be displayed on the GridView in a column.I thought it's worthwhile to share it here.

// Class for define Template, this class will added to your app_Code folder.
public class SampleTemplate : ITemplate
{
private string _DataField;

public SampleTemplate (string DataField)
{
this._DataField = DataField;
}

public void InstantiateIn(Control container)
{
TextBox txtItemVal = new TextBox();
txtItemVal.DataBinding += new EventHandler(this.OnDataBinding);
txtItemVal .ID = "txtItemVal";
container.Controls.Add(txtItemVal);
}

public void OnDataBinding(object sender, EventArgs e)
{
TextBox TXT = (TextBox)sender;
GridViewRow container = (GridViewRow)TXT.NamingContainer;
string id = ((DataRowView)container.DataItem)[_DataField].ToString();
TXT.Text= id;

}
}

Adding template to your grid.code behind file.In my case i am going through a for loop with in the user datacolumns datatable and adding coloumns to gridview.

TemplateField tmpItem= new TemplateField();

// you have to specify column name as "datafield" here.as for the gridview data source.lets say you //have Employee datatable.and you want to show Empage in this template coloumn.then you should //use empAge as your dataField

SampleTemplate TEMP1 = new SampleTemplate ("Empage");
tmpUnits.HeaderText = "Employee Age"
tmpUnits.ItemTemplate = TEMP1;
gvTransaction.Columns.Add(tmpItem);

Thats it.Hope this will help you one day.And there's a another way also.will tell you latter. ;)

Mahalo

2007-06-07T16:39:00.000+05:30

Hi, I found this Mahalo while i am surfing the web.Mahalo is Hawaiian word for Thank You.But thats not the thing which i am going to talk about.Mahalo is the world's first human-powered search engine powered by an enthusiastic and energetic group of Guides.Means .Mahalo Loads only built sreach results by Mahalo Search guides.Mahalo Search guides spend their time to searching ,filtering out spam, and hand-crafting the best search results possible.If they havent built a search result, you have to request that search result. Meaning every search result is carefully reviewed by humans to select the best search results and filtering out spams.

ArrayList vs List<> Generics

2007-03-12T13:17:00.000+05:30

when i am working with my new Team in the new place i have got a chance to work with new Generic lists witch has available in .net 2.0. when i am finding information about generic list i understood it's much more better than arraylist. i just checked

Time taken by Collection: 7044.6912 ms
Time taken by Generic: 2898.9216 ms

i just wrote small program using arraylist and the generic list witch is giving the same result.what i understood is on the Generic list you can only assign int (as for the my code.You can supply data type in to List's <> ) to the list - anything else will raise an exception.If you wanted to store a multitude of types, simply inherit from a common base, and use the base as the list identifier.(Use .GetType() ) if i simply says generic list is simple and Safe. :)

if we used arraylist in our code it has to more boxing operations b'coz it can any type.but in generic list is not allowed as i said

here is the code for what i did.

using System;
using System.Collections.Generic;
using System.Collections;
using System.Text;

namespace Listcompare
{
class Program
{
public static DateTime startTime;
public static DateTime endTime;
public static TimeSpan timeSpan;

private void CheckGenerics()
{
int total = 0;

List lstMyList = new List();
int i = 0;
for (i = 0; i < 20; i++)
lstMyList.Add(i);

for (i = 0; i < 10000000; i++)
foreach (int el in lstMyList)
total += el;

}

private void CheckCollections()
{
int total = 0;
ArrayList al = new ArrayList();
int j = 0;
for (j = 0; j < 20; j++)
al.Add(j);
for (j = 0; j < 10000000; j++)
foreach (int el in al)
total += el;
}

private void Run()
{
startTime = DateTime.Now;
CheckCollections();
endTime = DateTime.Now;
timeSpan = endTime.Subtract(startTime);
Console.Out.WriteLine("Time taken by Collection: " + timeSpan.TotalMilliseconds + " ms");

startTime = DateTime.Now;
CheckGenerics();
endTime = DateTime.Now;
timeSpan = endTime.Subtract(startTime);
Console.Out.WriteLine("Time taken by Generic: " + timeSpan.TotalMilliseconds + " ms");

Console.WriteLine("");
Console.Read();

}
static void Main(string[] args)
{
Program myPgm = new Program();
myPgm.Run();
}
}
}

Advanced to new Blogger

2007-03-11T23:53:00.001+05:30

it's very close to one month from my last post.I was bit busy with work.good news !!! Sri Lanka Telecom has provided ADSL to Homagama area.guess what I am on ADSL now.

when I logged in to blogger for the last time it advice me to associate my blogger account with my gmail account for migrate to new blogger.So I have moved to new blogger but I couldn't update my blog as for the previous look and field.Today I got a chance to make it back. :)

My blogging rate is getting down now.I should start writing. so have a look again .....

Last day at work...

2007-02-16T17:21:00.000+05:30

it's my last day at the South Asia Software... being with such a bunch of nice people was a nice experience in my life... it's really sad to leave these people... but it's for my good.. hmmm....But it's really hard to leave the place.

Miss you all. Tnx again for everything !!!

Once again i felt that i am not alone.

2006-12-26T11:12:00.000+05:30

Thanks for all the people who remembered the day... :)

Back !!!

2006-12-20T08:11:00.000+05:30

OH! I haven't come here for more than one month.I think I have really miss my blog hehehe.So wazz up with me? mmmmmmm

well I have moved in to C#.Net.(You was waiting to hear it from me. isn't it charith ? lol)I was working with VB.Net more than 2 years.But because of the new project that we have got we had to move in to C#.I have no choice.anyway it's pretty cool thing.

I miss Deep dive .NET 3.0 I always missing important things I do not know what's wrong with me.anyway hope to be alive with ma blog again.and bring up new things here.

cheers !!!

Microsoft has announced Light Weight Open Source Applications(Online)

2006-11-01T12:27:00.000+05:30

October 30th Microsoft has released a free downloadable accounting program called Office Accounting Express 2007. This software focuses on integrating with online sites like eBay, PayPal and Office Live. See for comparison Google’s partnership with Intuit.

And 31st of October they have announced that the first version of Office Live will come as beta version on the 14th of November. Office Live is a free service with premium services for small businesses. It includes online storage, webmail and calendaring.

What will be next.....

The Difference ...

2006-10-19T09:40:00.000+05:30

Found a Nice story from my emails today..... I just wanted to bring it out here ,because I feel it's special.

Little girl and her father were crossing a bridge.
The father was kind of scared so he asked his little daughter, "Sweetheart, please hold my hand so that you don't fall into the river."
The little girl said, "No, Dad. You hold my hand."
"What's the difference?" Asked the puzzled father. "There's a big difference," replied the little girl.

"If I hold your hand and something happens to me, chances are that I may let your hand go. But if you hold my hand, I know for sure that no matter what happens, you will never let my hand go."

In any relationship, the essence of trust is not in its bind, but in its bond .
So hold the hand of the person whom you love rather than expecting them to hold urs...

Nikhil Kothari's Ajax.net presentation on JAOO 2006 Conference

2006-10-18T13:51:00.000+05:30

Here is the link for nikhil Kothari's presentation on ASP.NET AJAX at the JAOO 2006 conference in Denmark.(In case you didnt visit Nikhil's Blog recently ;-))

And you can download the video of it from.....

http://channel9.msdn.com/Screencasts/243775_JAOOLapAroundAtlas.wmv

Save Your eyes !!!

2006-10-17T13:51:00.000+05:30

Normally I use anti-reflect Lenses when I am working.But last 2 days I forgot to bring it. So I feel bit uncomfortable when I am working.One of my office buddy gave me a article about what you can do with your Monitor to Save your Eyes. So I felt it's worth while to bring out some information out here......

By side staring at my monitor hour after hour Cause headaches and eye fatigue.according to the article one of simple thing we can do to help this problem is to raise the refresh rate. Monitors often come with refresh rates set too low, I.e. 60 Hz which causes flickering. A higher refresh rate helps reduce the flickering effect and lessen eye strain.(More than 75Hz).(You can usually set your refresh rate under display properties/settings. Also, RefreshForce is a free tool that lets you quickly change the monitor's refresh rate.)

Another cause of eye strain that many people tend to just live with is font size. Higher resolutions on monitors can cause quite small fonts. Also, many web sites use small fonts. If you catch yourself leaning toward the monitor, or squinting uncomfortably, right click on your desktop to bring up display properties, select appearance, and choose font size. You can further adjust the font you see when surfing by choosing text size from Internet Explorer's view menu and selecting your preference. This may cause some of your favorite web pages to display a little oddly, but at least you'll be able to read them!

Make sure you have proper lighting on your monitor (it's more effective to have a light shining from behind your shoulder or above the monitor than behind the desk).

Even using these measures, we should take frequent breaks from the computer. Look away from your monitor at least once every fifteen minutes; preferably, step away from the computer altogether.

So try to take care of your eyes too,while you are working

After the silence....

2006-10-13T16:04:00.000+05:30

Well, I couldn't write anything during the last 2 ,3 weeks. Many changes have been going on in ma life since that period(still the same :)). I never thought this will happen to me. For the first time I'm fed up with ma Job. And I have to tnx all my friends who were with me for all this time. It helped me a lot. I got loads of advice what I have to do in such a situation.

Anyway that's enough about that. The good news is two of my buddies have started their own Blogs. (Suresh and vajira). So good luck yo buddies. Welcome to blogging.. lol..

So now what I have to do is try to cheer up and continue my life. Isnt it?? But I'm still trying ....

Ashi has came back...

2006-09-28T13:03:00.000+05:30

One of ma good friend; ashini(Akki) has came back to blogging again ('coz of my request. ;-) ) She's a very close friend of mine and a good sister for me. I always try to accept all her advice ;) (even though you think you are not a good adviser. lol...) and those advice is worth for me. I have changed some qualities of mine. he he he... As my knowledge we don't know how much we are worth for others. So you have to start a new blog life with all your thoughts, and with your knowledge (which is being updated daily... ). So wish you all the best Akki !!!

You can visit her blog.... http://ashinie.blogspot.com/

Common Table Expression(CTE)

2006-09-21T11:33:00.000+05:30

This is a new Enhancement of SQL server 2005(as my knowledge).we can think CTE's as a simple and more powerful alternative to derived Tables.In my case Now I am using CTE's where I used Temporary Tables before and I replaced so many views.

A CTE can be defined as a temporary named result set, which is derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement. It is important to note that the scope of a CTE is just the statement in which it is declared. The CTE named result set is not available after the statement in which it is declared and used.

Here I am putting a code sample for CTE witch I have taken from AdventureWorks Database then you all can check this SQL script in your SQL server 2005(if you have installed AdventureWorks DB.)

WITH YearlyOrderAmtCTE(OrderYear, TotalAmount)
AS
(
SELECT YEAR(OrderDate), SUM(OrderQty*UnitPrice)
FROM Sales.SalesOrderHeader AS H JOIN Sales.SalesOrderDetail AS D
ON H.SalesOrderID = D.SalesOrderID
GROUP BY YEAR(OrderDate)
),
SalesTrendCTE(OrderYear, Amount, AmtYearBefore, AmtDifference, DiffPerc)
AS
(
SELECT thisYear.OrderYear, thisYear.TotalAmount,
lastYear.TotalAmount,
thisYear.TotalAmount - lastYear.TotalAmount,
(thisYear.TotalAmount/lastYear.TotalAmount - 1) * 100
FROM YearlyOrderAmtCTE AS thisYear
LEFT OUTER JOIN YearlyOrderAmtCTE AS lastYear
ON thisYear.OrderYear = lastYear.OrderYear + 1
)
SELECT * FROM SalesTrendCTE
GO

Down with a fever... and now Gastritis....

2006-09-18T10:18:00.000+05:30

Now I feel bit better after the fever since last Wednesday. I wanted to be @ office last thursday and friday coz I had to complete something with new SQL Report server. But I couldn't make it. After the fever last friday i got Gastritis also. Now I have to take medicine for Gastritis too.That's a damn sickness. NowI feel bit better. And now I am trying to Eat on time. And I am warning you all my buddies. Please take care of your meals. Simply EAT ON TIME.

Microsoft .NET Framework 3.0

2006-09-05T10:42:00.000+05:30

Microst has Released Microsoft .NET Framework 3.0(pre-Released) for the general public.(May be this an Old news ;) ).We can download new framework and Related resources from here. and also we can download RC1 SDK tooo.Wow.....

Tutorials on Enterprise Library

2006-08-31T09:24:00.000+05:30

These days i got a chance to start working with one of the tool witch i was dreaming to work with.Enterprise Library.When i am Searching for Tutorials for Enterprise Library i found Some great Great articles.So i thought to share them with you all.

The Enterprise Library Data Access Application Block

Online Tutorials about Enterprise Library

Using the Enterprise Library Data Access Block for .NET 2.0

And some Links was available in Angelos Petropoulos' WebLog

(archive Tutorials on using Enterprise Library )

Upuli got Married

2006-08-26T09:27:00.000+05:30

One of ma good friend Upuli got Married y’day.wedding was @ koggala beach Hotel.

Hmmm very nice to see you as a bride buddy. Hope you will get all the happy things in your new life.

Best wishes to both of you !!!!.

The best Is yet to come lu ne????

Congrats..... !!!

I just started photo sharing

2006-08-23T11:38:00.000+05:30

I started my old habit again.but still didnt feel much comfortable on it.anyway hope you all will help me to improve.i always welcome your comments on it.I just started my photosharing at flickr.com.And click here to go to my photo sharing at flickr.com.

cheers

What can we do for this?As a Sri Lankan

2006-08-22T08:27:00.000+05:30

Here are some pics witch i have got from one of my friend.can u understand how much Tamil people are in Canada supporting to establish "EELAM" as their homeland. See how our flag has been disgraced by Tamils can we call them as Sri Lankans ?????

Creating thumbnail Image(VB.NET)

2006-08-02T12:25:00.000+05:30

I wanted To Create a thumbnail Image from Original Picture And save it in Employee Data.I used image.GetThumbnailImage function to sort this out.So i thught to Publish it here ,it will be a Help for someone else.

' Photo path(Actual path to Uploaded Pic)

Public Shared Function CreateThumbnail(ByVal imagePath As String, ByVal Folder As String) As Boolean

Dim createdThumbnail As Boolean = False

Dim thumbnail As Image

Dim image As Bitmap

Try

' get full path to the thumbnail image

Dim thumbnailPath As String = Path.Combine(Folder, GetThumbnailName(imagePath))

' check thumbnail already exist

If Not File.Exists(thumbnailPath) Then

image = New Bitmap(imagePath)

' create thumbnail image

thumbnail =GetThumbnail(image, 120)

' save thumbnail

thumbnail.Save(thumbnailPath, ImageFormat.Jpeg)

createdThumbnail = True

End If

Catch ex As Exception

' an error occurred, return null

Finally

' clean up

If Not thumbnail Is Nothing Then thumbnail.Dispose()

If Not (image Is Nothing) Then image.Dispose()

End Try

Return createdThumbnail

End Function

Public Shared Function GetThumbnail(ByVal image As Bitmap, ByVal longestSide As Integer) As Image

Dim thumbnail As Image

Try

' determine scale of the image

Dim scale As Single = CSng(IIf(image.Width > image.Height, _

longestSide / image.Width, longestSide / image.Height))

Dim width As Integer = CInt(image.Width * scale)

Dim height As Integer = CInt(image.Height * scale)

thumbnail = image.GetThumbnailImage(width, height, Nothing, IntPtr.Zero)

Catch ex As Exception

' an error occurred, return null

End Try

Return thumbnail

End Function

Generated using PrettyCode.Encoder

Am I working too Hard ???

2006-07-19T16:27:00.000+05:30

Well..... now I feel my happy life has come to an end. I have been selected for a new project… and it’s the end of ma life of fun….. Hmmm. what to do? Have to go ahead with our life noh.... And these days I am learning alot of things again. Crystal Report again lol…. Even though I have used Crystal Report b4 now I am learning alot more things on it. Now I feel like I didn’t know anything about it. From next week our Project has to be online and we have to work with live data (Gone mad…. ;) ).I never thought this would happen to me.. lol..

Got stuck with ASP.NET Popup Windows: With Return Values???

2006-07-17T10:52:00.000+05:30

I am sure we have written so many Java scrpits to open a popup window and return values to the parent page. In my case I have used this line within the Java script to get values from the popup Window.
document.getElementById('txtDateValue').innerText=returnVal._date

This Code works perfect in normal forms but I got a javascript error when the Parent page uses a master page(wich is in VS2005), I was wondering. Got through.... ;)

Problem is because ASP adds the name of the content placeholder to the front of the text box when generating the html. If you do a right-click, 'view source' on the parent page, scroll down to where the html is for the text box and look at the ID. Thats what we have to specify as the name in the document.getelementbyid command.

For a Example :

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

For this ContentPlaceHolder, Your java script shold be:

document.getElementById('ctl00$ContentPlaceHolder1$txtDateValue').value = returnVal._date;

Consolas Font Pack for Microsoft Visual Studio 2005

2006-07-13T16:17:00.000+05:30

Consolas is one of the new fonts included in Vista. It is cleartype font designed specifically to make code more readable. You can download it from Microsoft Download Center .

I'M Back !!!

2006-07-11T13:17:00.000+05:30

May and June 2006 were those empty days for my blog.Oh!!! I forgot!, June 2006 is the first anniversary of my blogging.Have to thank my buddy charith who made me start blogging.
Anyway "Today" is a Bigday for me, coz it's my first day @ my new job.I resigned from my previous one last May and had a fantastic time with ma family and my friends.I think now it's back to work......Hope everything will be fine this time. So? Will c :-)

Another step Forward....

2006-06-26T14:57:00.000+05:30

I got through Microsoft certified Exam (70-305). "Web Application Development with ASP.Net". All credit goes to the Author (jeff webb with Microsoft Corporation) of the book "MCAD/MCSD self-paced training kit: Developing web Applications with microsoft visual basic.net and microsoft C#.net", my buddy Thusitha who always guided me when I got any doubt and my loving parents.

Live Messenger Beta Has Updated Again

2006-05-08T16:24:00.000+05:30

I couldn't sign in into Messenger for one week.Today, when I tried to sign in, it gave me this updating message.

I think they have given a cool UI once again. It's nice. Actually the previous version gave me trouble when trying to sign in. Hope they have fixed that! :) Speed and memory usage is considarably enhanced compared to the previous release. New icons: I'd say "wow!". It's really cool! So lets wait for the new release...... Hope they will add some new emoticons too ;)

New Laws of Software Engineering...

2006-04-21T15:09:00.002+05:30

Today I backed-up my old mails. Found a good one while doing so...

New Laws of Software Engineering...
Law 1.
Every Software Engineer continues his state of chatting or forwarding mails unless he is assigned work by external unbalanced manager.

Law 2.
The rate of change in the software is directly proportional to the payment received from client and takes place at the quick rate as when deadline force is applied.

Law 3.
For every Use Case Manifestation there is an equal but opposite Software Implementation.

Bonus :-) Law 4.
Bugs can neither be created nor be removed from software by a developer. It can only be converted from one form to another. The total number of bugs in the software always remains constant.

????????????

2006-04-18T11:13:00.000+05:30

I couldn't post from about two weeks, wondered why,cant think of a Reason for it.
I was wondering...... ,I started ma career in software development in 2004.(new comer isn't it???? ;) ) but I think as a software Developer we have to have self satisfaction about what we have done and what we have to do isn't it? However, but now I think I'm fed up with ma work. Thinking of moveing away.Anyway i have decided to resign.May be it's ma fault. :( so ?All of you Comfortable with your work and place? I never think about the Name of the company.i am just asking about what you all feel about your work place?So what you all think about it???Write some comments here.It will be of use to me. Thanks everyone!!!!

CPS tried Singleton form in vb.net

2006-03-28T11:15:00.000+05:30

We all get one object each time a constructor is called. If we call a class' constructor three times, we get three instances of the class. Also even if we don't write a constructor in our class, the VB.NET compiler creates a no-argument. However, if a class does have a constructor, whether it is a no-argument constructor or one that accepts arguments, the VB.NET compiler does not create a new one. Normally, these constructors have a public access modifier because they are meant to be invoked from outside of the class.
But sometimes there are cases where we want to limit the number of instances of a class to one. When we Press win+ R in windows XP ( I am using windows xp) it will display a RUN dialog. But when it loaded if we press Win + R button again and again we will get only one RUN dialog. How can we do this in vb.net? The Singleton pattern can be used for this purpose. This pattern is effective for limiting the maximum number of instances of a class to exactly one.

Imports System
Imports System.Windows.Forms
Imports System.ComponentModel

Public Class SingletonForm : Inherits Form

Private Shared myInstance As SingletonForm

#Region " Windows Form Designer generated code "

Private Sub New()
MyBase.New()
InitializeComponent()
End Sub

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub

Me.Name = "SingletonForm"
Me.Text = " CPS Tried Singleton Form "
Me.Width = 450
Me.Height = 150
End Sub
#End Region

Protected Overrides Sub OnClosing (ByVal e As CancelEventArgs)
e.Cancel = True
Me.Hide()
End Sub

Public Shared Function GetInstance() As SingletonForm
If myInstance Is Nothing Then
myInstance = New SingletonForm
End If
Return myInstance
End Function
End Class

Using Sigleton form

Public Class UsingSingletonform
Inherits System.Windows.Forms.Form

Private Sub New()
MyBase.New()
InitializeComponent()
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim CPSsingleton As SingletonForm = SingletonForm.GetInstance()
CPSsingleton.Show()
End Sub

Public Shared Sub Main()
Application.Run(New UsingSingletonform)
End Sub
End Class

Finally I got Atlas again

2006-03-25T11:45:00.000+05:30

I read about Atlas project in 2005 july or augest @ news.com.and i was lookng @ Atlas Project for more infomations.But wonder i have missed that.i do not know how(may be i was away from web Last 5 months.Sadly i coudnt come online :( ).Anyhow my buddy Charith helped me to Find it again.@ last i got it again.so like to say visit here for more information. So charith thank you once again.

Are you Interested in ORM tools ?

2006-03-24T09:37:00.000+05:30

I think I have mentioned about ORM( object Relational Mappers) in here some time ago.But I got a nice artical about how to Select a good ORM tool. it's name goes as How-To-Select an Object-Relational Mapping Tool for .NET . There are about 15 Tools. I have already used some of them.I loved some of them, like My Generation , NHibernate before.But there are some more.

And I got another Great artical about Data Modeling.it's great. try it guys/gals.

aloha, my blog is going to be a Database Blog .......... I have to stop writing about Databases lol

Bloggers Meetup ...

2006-03-22T09:23:00.000+05:30

Y'day My buddy charith wanted me to be @ Barefoot.So finally I got there. As a Sri lankan Charith got Late(around 30 mints.) Now don't kick my A**.Charith ,Casper and I hanged around barefoot cafe till Razor came to the picture.After Razor's Arrival we met Indi.So hiiiiiii indi ;) Until Wela came it was boring. We were about to leave isn't it?
I met some people for the first time in ma life.But I have read about them before.It's nice to meet u guys.Lot of open source guys were there.Mahangu, Dilantha, Chamil and many more. and I'm very glad to meet The DOTNET guy, wela. :)

More commentary about the meetup.....

Wela, (with some cool pictures).
Charith, (with stolen pictures from wela)
Razor
Mahangu (The open sorce)
Dilantha (A nice guy. I like his way of talking)

Did you Try to Create Reports in SQL Server 2005

2006-03-21T09:22:00.000+05:30

I just went through Report Option in SQL server 2005. It looks good, can do a lot of things on it just like crystal report.But we can't compare it. b'coz Crystal Reports only for Reporting isn't it?.So Here is some screens which I did.i think You have to Use Business Intelligence Development Studio which is in SQL server 2005. If you need more information about Business Intelligence and Data Warehousing in SQL Server 2005 just click here

How is it? you can Set Server URL for Report Engine In project properties.Then You can view the Report in Internet Explorer

What happened to my Domain name?

2006-03-15T11:19:00.000+05:30

I wanted to buy a Domain name CPS.net or .com as my Home page. But it's already taken. So I decided to buy Chaminda.net Last December. But b’coz of some problems I postponed that. Actually I forgot to resolve. I wanted to buy it Today. Gone mad it is not available now. I am sure it was available till January. B’coz I checked about it. So I am warning you all. If u want to buy a domain name do it ASAP. Otherwise it will no longer be available. So do it today.

I don't know whats wrong with me!

2006-03-13T10:49:00.000+05:30

I haven’t done anything since last Friday. I didn’t open Sql server or visual studio for the weekend. I do not know what i was doing in the weekends. Didn’t go through a book even. I have to complete thousands of work. What’s wrong with me? Can’t I change my Mind?? :(

Got my new Mobile

2006-03-10T12:16:00.000+05:30

i sold my Old Nokia 6260 and was hanging without a mobile the last 2 weeks.b'coz Softlogic had no stock of nokia 6630.finallyI got my new Nokia 6630 Today.It's not da Phone which i was dreaming.i was dreaming about Sony Ericsson W800 or a K750i.but it was tooo expensive :( so i changed ma mind and thought to buy a 6630.but it's great.it has a nice Head set with good sound quality.i think i can use my mobile as a mp3 player.it's great.now i am searching for a mp3 player with a equalizer for my mobile.i have to say it again it's a great mobile which i ever used.

It's interesting to work with sql Server 2005

2006-03-09T10:13:00.000+05:30

I imported Some of my sql server 2000 Databases In to new Sql server 2005.i saw something new in sql TOP Key word.The TOP operator has been around since SQL Server 7.0( i think so.), in the past it only accepted a constant as the number of rows to return or as the percentage of the rows to return. The TOP statement in SQL Server 7.0 and SQL Server 2000 was also limited to SELECT statements. Thanks to improvements in the TOP operator for SQL Server 2005, the TOP statement can now accept variables and subqueries for the number of rows to return or the percentage of the rows to return. The TOP operator has also been enhanced so that it can be used with INSERT, UPDATE, and DELETE statements in addition to the SELECT statement.

DECLARE @intRows INTEGER;
DECLARE @startAfter INTEGER;
SET @intRows = 12 ;
SET @startAfter = 10;
SELECT TOP (@intRows) * FROM HumanResources.Employee
WHERE EmployeeID > @startAfter
ORDER BY EmployeeID;
GO

And we Can set Varible Values programicaly.

We can still use the PERCENT keyword to return a percentage of rows instead of a fixed number of rows. And sql server 2005 we can use it with Top keyword with a variable value.

DECLARE @intPercRows INTEGER
DECLARE @intPage INTEGER
SET @intPercRows = 12
SET @intPage = 10
SELECT TOP (@intPercRows) PERCENT * FROM HumanResources.Employee
WHERE EmployeeID > @intPage
ORDER BY EmployeeID;
GO

In addition to passing an expression, we can also use a subquery to satisfy the TOP statement value requirement.

DECLARE @startAfter INTEGER;
SET @startAfter = 0;
SELECT TOP (SELECT COUNT(*)/11 FROM HumanResources.Employee) *
FROM HumanResources.Employee
WHERE EmployeeID > @startAfter
ORDER BY EmployeeID;
GO

First Day in Sql 2005

2006-03-08T09:24:00.000+05:30

First time i Enter in to sql 2005.Where is that Enterprise Manager,Query Analyzer and Analysis Manager Short cuts?? They have remove them and introduce a new interface call SQL Server Management Studio.its a new integrated tool that combines the functionality of three tools: Query Analyzer, Enterprise Manager, and Analysis Manager. In addition, it allows us to manage all other components, such as Reporting Services, SQL Server Integration Services (SSIS; formerly known as DTS), Notification Services, and SQL Server Mobile. WOW.......

and it has Template Explorer.we can can lot of Templates for various sql functions from this Template Explorer. So what else we need??? .let me go through and find out ;)

working with Sql server 2005

2006-03-07T16:02:00.000+05:30

I installed sql server 2005 Work group Edition at my home compuater last december. but Still i could not work on it well.i thot to start it today.yeah it has great new features with a reporting Server. so ?? lets move

Back to blogger.com

2006-03-06T15:53:00.000+05:30

It's all Most 5 months from my last blog entry.could not write here i do not know wot happned ? Did some Smart clients project for the company with web service support.hmmmmm it was a great Opportunity to me.i learn lot of things from it.

So ? it's great to back in blogspot. :)

Grand Theft Auto: San Andreas/Appendices/Game Mods - Wikibooks

2005-08-15T15:47:00.000+05:30

Grand Theft Auto: San Andreas/Appendices/Game Mods - Wikibooks

how Software Engineers jump from company to company!!!

2005-08-08T09:54:00.001+05:30

I got this mail from one of my friend.mmmm Do we like this ???

Windows Vista: Next-generation platform

2005-08-02T15:35:00.000+05:30

Windows Vista: Next-generation platform

Stuck with GTA San Andreas

2005-07-28T20:27:00.000+05:30

I dont know why i am loving this Rockstar games.i have played lot of gems like Maxpayne,Manhunt,GTA 1,2,3 and GTA San Anderas.if u want to play Advanced games(3rd person) u have to paly with Rockstar

Interested in new Windows Vista Development??

2005-07-22T15:39:00.000+05:30

Interested in new Windows Vista Development??

Have you Heard about Hakon Lie

2005-07-20T16:26:00.000+05:30

Have You Heard About Hakon Lie ???

Creation of CSS. All the credits goes to Hakon Lie ?????

Hakon Lie works for Opera Software as Chief Technology Officer. He came to Opera from W3C, where he was responsible for style sheets. In 1994, Hakon proposed the concept of Cascading Style Sheets, which now are implemented by all major browsers. He is a graduate of the MIT Media Lab.

Read More >>

Data Access Application Block for .NET

2005-07-18T06:59:00.000+05:30

I got someinfo from MSDN(2004 july).it's very interesting. have a look.

Are you involved in the design and development of data access code for .NET-based applications? Have you ever felt that you write the same data access code again and again? Have you wrapped data access code in helper functions that let you call a stored procedure in one line? If so, the Microsoft Data Access Application Block for .NET is for you.

The Data Access Application Block encapsulates performance and resource management best practices for accessing Microsoft SQL Server databases. It can easily be used as a building block in your own .NET-based application. If you use it, you will reduce the amount of custom code you need to create, test, and maintain.

So we can Create One data access class for all da application wich access Data base.

Public Shared Sub PrepareCommand(ByVal command As SqlCommand, _
ByRef connection As SqlConnection, _
ByVal commandType As CommandType, _
ByVal commandText As String, _
ByRef mustCloseConnection As Boolean)

If (command Is Nothing) Then Throw New ArgumentNullException("command")
If (commandText Is Nothing OrElse commandText.Length = 0) Then Throw New ArgumentNullException("commandText")

If connection.State <> ConnectionState.Open Then
connection.Open()
mustCloseConnection = True
Else
mustCloseConnection = False
End If

command.Connection = connection
command.CommandText = commandText
command.CommandType = commandType
Return

End Sub

Comman Select Statement

Private Shared Function PrepareSQLSelect(ByVal strSQL As SqlSelect) As String

If (strSQL Is Nothing) Then
Throw New ArgumentNullException("strSQL")
Else
If strSQL.TableName = "" Then
Throw New ArgumentNullException("strSQL.TableName")
End If
End If

'create SQL Select
Dim str As New StringBuilder(QuerySize)
With strSQL
If .FieldName <> "" Then
str.Append("SELECT ")
str.Append(.FieldName)
str.Append(" FROM ")
str.Append(.TableName)
Else
str.Append("SELECT * FROM ")
str.Append(.TableName)
End If

If .CmdWhere <> "" Then
str.Append(" WHERE ")
str.Append(.CmdWhere)
End If
If .SortBy <> "" Then
str.Append(" ORDER BY ")
str.Append(.SortBy)
End If
End With
Return str.ToString
End Function

Like wise we can write other functions like Insert,Delete and update.once You Create SQLHELPER Class, i think your data accessing will be Nothing

Source
http://www.gotdotnet.com/workspaces/workspace.aspx?id=c20d12b0-af52-402b-9b7c-aaeb21d1f431

"Designed for Windows XP" Application Specification

2005-07-12T23:45:00.000+05:30

Microsoft has developed this specification to identify applications that run successfully on Windows XP and provide a quality user experience. This specification will help software developers by defining the minimum requirements for applications to operate on Windows XP. Sections include: How to Comply with Windows Fundamental Requirements; Install/Uninstall Requirements; Data and Settings Management; and Checklist for Windows XP Compatibility.
See http://www.microsoft.com/winlogo/software/downloads.mspx
http://www.microsoft.com/winlogo/software/

These are the top reasons that your customers benefit from an application that meets this compatibility specification:

· The installation and removal of the application are similar to other applications with which the user is familiar.

· Application installation and application execution are less likely to interfere with other applications that the user has already installed.

· The user’s first experience with an application is improved because unnecessary reboots are eliminated.

· The application is unlikely to cause the user’s computer to fail or function improperly.

· The application makes it easier for family or friends to share a personal computer.

· The application runs in a tightly controlled environment to enable parents to secure the computer but still allow children to run applications, or enable Information Technology professionals to secure the computer properly.

· The application runs correctly on Microsoft® Windows XP, reducing customer frustration and reducing support calls.

Logo Options(sample)

Resources :-

Windows Logo Program Website
http://www.microsoft.com/winlogo
Application Compatibility Toolkit (including Application Verifier)
http://www.microsoft.com/winlogo/downloads/tools.asp
“Designed for Windows XP” for software developers
http://www.microsoft.com/winlogo/software
“Designed for Windows XP” support email
swlogo@microsoft.com
“Certified for Windows” logo program
http://msdn.microsoft.com/certification
Developer information
http://msdn.microsoft.com/windows
Application compatibility Information
http://msdn.microsoft.com/compatibility
Knowledge Base
http://www.microsoft.com/support
Microsoft Platform SDK (Software Developer Kit)
Win32® and Win64™ application programming interfaces (APIs) - http://msdn.microsoft.com/downloads/

Can we Run ASP.NEt in Linux Web Server

2005-07-12T07:39:00.000+05:30

I had to Run our ASP.NEt Web Portal on Linux web server.what do u think???.can we do it.Thanks for MONo it's not a big issue now.u can convert ur ASp.net project to linux webserver.But u hvae to use C# other than Vb.net.

Some ADO.NET Tricks

2005-07-11T11:50:00.000+05:30

Passing Null as a Parameter Value

When sending a null value as a Parameter value in a command to the database, you cannot use null Instead you need to use DBNull.Value.
For example:

VB.NET
Dim param As SqlParameter = New SqlParameter("@Name", SqlDbType.NVarChar, 20)
param.Value = DBNull.Value

C#

SqlParameter param = new SqlParameter("@Name", SqlDbType.NVarChar, 20);
param.Value = DBNull.Value;

Optimizing Connections with the DataAdapter

The Fill and Update methods, of the DataAdapter, automatically open the connection specified for the related command property if Specific Connection is closed. If the Fill or Update method open the connection, Fill or Update will close it when the operation is complete. For best performance, keep connections to the database open only when required. Also, reduce the number of times you open and close a connection for multiple operations.

when performing transactions, explicitly open the connection before beginning the transaction and close the connection after you commit

Public Sub RunSqlTransaction(ByVal MyDA As SqlDataAdapter, ByVal myConn As SqlConnection, ByVal MyDS As DataSet)

myConn.Open()
Dim myTrans As SqlTransaction = myConn.BeginTransaction()
myCommand.Transaction = myTrans

Try
MyDA.Update(MyDS)
myTrans.Commit()
Console.WriteLine("Update successful.")

Catch e As Exception

Try
myTrans.Rollback()

Catch ex As SqlException

If Not myTrans.Connection Is Nothing Then
Console.WriteLine("An exception of type " & ex.GetType().ToString() & _
" was encountered while attempting to roll back the transaction.")
End If

End Try

Console.WriteLine("An exception of type " & e.GetType().ToString() & " was encountered.")
Console.WriteLine("Update failed.")
End Try

myConn.Close()

End Sub

Still First in ma Mind

2005-07-10T11:03:00.000+05:30

everyone may come and go. but i still prefer theese guys

Here with out u (3 doors Down)

(image from http://www.3doorsdown.com)

The Reason (Hoobastank)

I'm not a perfect person
There's many things I wish I didn't do
But I continue learning
I never meant to do those things to you
And so I have to say before I go
That I just want you to know

I've found a reason for me
To change who I used to be
A reason to start over new
and the reason is you......
................

(image from http://www.hoobastank.com)

I got through my first MCP.

2005-07-06T12:26:00.000+05:30

i got through my first Microsoft Certified Exam(70-316) last Sunday.mmm wanna lean more about XML and Coding Technics.lets Do it

Searching About Object-relational mapping

2005-06-17T12:02:00.000+05:30

Creating Classes was becoming a Headache .But then I start to find a way to go beyond from this Coding. if we can Create Classes according to our Tables,Stored procedures and views then it will be Easy. I had never heard about this term call ORM before. Thanks my buddy thusitha giving this term.So I started to Search about ORM and I found this NHibernate. Mmmmmmm…… wanna learn about ORM now. :)

Help me ..........................

Going through the MS self pass Training kit

2005-06-13T12:51:00.000+05:30

it's very hard to remember all these prperties and methods. what to do.any how i have to be a God refarance for my self.these days i am gooing through ADO.net Chapter.i wish i can remember all theese thigs

Will it be possible to Go through ma Exam

2005-06-10T10:59:00.000+05:30

i want to go through my first exam of MCSD.NET. hmmmmm, Doing some Self Studies with MS self Pass training Kit.i dont think it will b Enough

have to find some Resourses.......

waiting 4 Testking new version

What is a Blog ??????

2005-06-09T11:05:00.000+05:30

Started my first ever blog coz one of ma friend (tnx Buddy). Hope to do my first Microsoft exam on end of this Month.
Oh God Help Me !!!!!

More Details coming soon ...