Reset Identity to 0 in SQL Server

If you are using identity (auto increasment) column on your SQL Server tables,
you can reset identity value to 0 (Zero) or whatever value you want is very easy.

Below command set next insert value to 1 :

DBCC CHECKIDENT (TableName, RESEED, 0)

To set the value of the next ID to be 1000, You can use this command:

DBCC CHECKIDENT (TableName, RESEED, 999)

English Myanmar Dictionary

Hi Everybody …

I would like to introduce English Myanmar Dictionary software developed by WhizzoSystem. It look great user interface and easy to use for computer beginner. You can use Myanmar3 or ZawGyi. It contains over 36,000 words according to it’s offcial website. You can download from WhizzoSystem

Myanmar IT

TeamViewer for Remote Desktop Access

TeamViewer is the best remote desktop sharing tool. TeamViewer connects to any PC or server around the world within a few seconds. You can remote control your partner’s PC as if you were sitting right in front of it. Find out why more than 100 million users trust TeamViewer. With the numerous new remote control features, you can now work more intuitively, easily and quickly. Expand your possibilities as well and start using TeamViewer 7 for online meetings today.

The customizable TeamViewer applications allow you to link professional software with your corporate design.

TeamViewer offers a clean and easy to use interface.

You get to choose whether you want to remote control your partner, share your own desktop with a partner, or just transfer files without sharing your desktop.

Google Chrome Standalone for Myanmar

Some time We have a problem to install google chrome with standard installer. With standard installer, we need good internet connection to download and install. Myanmar internet connection is not a good way to install google chrome.

Standalone installer doesn’t need internet connection to install google chrome.

Here is Standalone Google Chrome

Mozilla Firefox 9.0 release

 

Mozilla Firefox 9 is  faster, more secure, easier to use and sporting a new look, this latest Firefox release sets a new standard for web browser innovation. Mozilla Firefox project (formerly Firebird, which was formerly Phoenix) is a redesign of Mozilla’s browser component, written using the XUL user interface language and designed to be cross-platform. It is small, fast and easy to use, and offers many advantages over other web browsers, such as the tabbed browsing and the ability to block pop-up windows.

What is Web 2.0

Nowadays everybody is talking about Web 2.0 lately. It’s a real hype, but do you know what it is all about? Web 2.0 refers to the second stage of development of the Internet, according to some people. It’s about the change of a collection of websites to a complete platform for interactive web applications for the end-users on the World Wide Web.

For some people it will mean the end of desktop applications. These web-based services make it easy for people to place things online, such as documents, pictures, movies, to-do lists… and share them with others by just using your browser. Software is no longer needed. Everything happens online: sharing information, collaborating etc. It’s a social happening. People are organizing and sharing their lives on the Web.

Web 2?0 is a social phenomenon that gives users freedom to share and re-use, that uses technologies such as social bookmarking, weblogs, podcasts, RSS Feeds, wikis… The users are the force behind the Internet, we make the Web every day. We publish pieces of our lives, day after day. The new thing about Web 2.0 is that all this sharing of personal information is so much easier and more attractive than it used to be. Information from different websites can easily be combined for you to make it easy to track it, or even better the new information, based on your own preferences, will be delivered to you.

The key principles of the new Internet and its web-applications are:

* The main force is data: the users own the data and are able to control that data. Users are responsible for the growing hype of Web 2.0

* The World Wide Web is being used as a platform: allowing users to use applications through a browser. Lots of the web 2.0 applications couldn’t exist without the use of the Internet such as Skype or Wikipedia or eBay…

* A lot of people participate which causes an architecture of participation and democracy, this will lead to various effects in the network. This can also be described as the wisdom of crowds. People judge if news is hot or not on web 2.0 sites such as digg or Reddit and del.icio.us.

* Features from lots of independent developers are being combined and assembled together to create innovative sites and systems: RSS, APIs, Social Networking and Folksonomies are being implemented to create powerful fast applications. And all these applications are quite inexpensive.

* The perpetual beta: a lot of web 2.0 sites are constantly under development and therefore will never pass the beta-stage

* User-friendly, rich and interactive interfaces: the sites of the new generation web use CSS, Ajax… to create dynamic pages that makes it easy for us to see even more information. It’s all about rich user experience.

* The Internet is a Read/Write Web: it is no longer a one-way medium, social-networking aspects became a main ingredient. The social software allows collaboration and communication between more than two people

* Early adopters will find it easy to join in

* Have faith in users: let users play with your applications, and remodel your site, bring content and give them freedom. Don’t tell them what to do and what not to do. They will find their own ways to work with your services and applications

“Service Unavailable” error message in Sharepoint

This issue may occur if the application pool for the virtual server is configured incorrectly in Microsoft Internet Information Services (IIS) 6.0. This issue may occur if one or more of the following conditions are true:

* The application pool is not running.
* The application pool account uses an incorrect password.
* The application pool account is not a member of both the IIS_WPG group and  the STS_WPG group on the server.

Assign a Strong Name to a Compiled Third Party Dll

Assign a Strong Name to a Compiled Third Party Dll

When you go to build your VS project you will get the following error

            ‘Referenced assembly doesn’t have strong name’

So how can I sign/strongly name the dll I hear you ask? Well here’s how:

Step 1

Open the Visual Studio Command Prompt – probably best to copy the dll in into the VC folder to save you having to cd or type a long path in

Step 2

Create a key pair to sign the assembly

– sn.exe –k key.snk

Step 3

Disassemble the dll using

ILDASM   ILDASM.exe    Yourdll.dll   /out=Yourdll.il

This will create a ‘Yourdll.il’ file containing the IL for the assembly. It will also extract the assembly so you will now have a folder  with lots of files, you will also see a .res file containing the resources for the dll.

Step 4

   Reassemble the dll using ILASM to sign the output with the key created above

ILASM.exe Yourdll.il /dll /out=Yourdll2.dll /key=key.snk

Step 5

         Done

Copy DataRow from one DataTable to another DataTable

Here is the sample code for copying DataRow from one DataTable to another DataTable in ADO.NET 2.0.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
public DataTable CopyDataTable(DataTable OldTable)
{
    DataTable NewTable = new DataTable();
    DataRow NewRow = null;
 
    try
    {
        NewTable = OldTable.Clone();
        foreach(DataRow OldRow in OldTable.Rows)
        {
              NewRow = NewTable.NewRow();
              NewRow.ItemArray = OldRow.ItemArray;
              NewTable.Rows.Add(NewRow);
        }
     }
     catch (Exception) { throw; }
 
     return NewTable;
}