MS SQL Server with Khmer Unicode

MS SQL Server is a product of Microsoft that we use it for store data, information and we can easy find that data when you need. MS SQL Server is the database application for manage data or any information of organization. If we compare with MS Access we can say MS SQL Server is better because MS SQL Server have more features, tools, function than MS Access in manage data.  Today I have one topic to share you about how to make MS SQL Server support with Khmer Unicode.

This is the topic that shows you about how to insert, update, delete data in Khmer to table and how to search data as Khmer language. It is the nice topic that can help who that starting build application with Khmer Unicode

1. How can we insert Khmer Unicode to table?

You need to configure something when you create table. If you want your table support with Khmer Unicode please choose datatype is nvarchar and in collation properties Khmer_100. Please create tblStudents(ID,Name,Sex) and set datatype below:

In field Name properties please set Collation to Khmer_100

2. After you create table you need to know the query that can input Khmer Unicode to table also.

             insert into tblStudents(ID,Name,Sex)

             values('1',N'សុវណ្ណ','M')

“N” character is the special string that allow input Khmer Unicode to field of table. Please run this script and see the result in table.

       3. How to Search with Khmer Unicode

           We need still use “N” when we search data in tblStudents. Please see example below:

       Select * from tblStudents

       where Name='សុវណ្ណ'

          if we write this select we will now have data.

            Then try to change to this scripts

      Select * from tblStudents

      where Name=N'សុវណ្ណ'

              Result:

You also can use “Like” to select with Khmer Unicode too.

This topic is very useful to help you to build application by using Khmer Unicode. And I hope it can help you to build application. If you have any issue please command I will to support you.

(source: http://kh-code.blogspot.com)

Now available: No-Cost, No-Touch App Lifecycle Management for Lean Teams

It's available now. It's Team Foundation Service, a new way for teams who care about rapid software delivery to plan and manage projects. And for teams up to 5 developers, it's free.

Writing code is fun, but managing development can be complicated. Do you keep your code under version control? Where do you keep track of bugs and new features? How do you keep your team on the same page? Now you can utilize Team Foundation Service to do all these things today, with zero additional infrastructure.

Stop standing up servers. Stop installing and configuring multiple pieces of software to support your development process. With Team Foundation Service, you get an easy-to-use and easy-to-administer cloud-based solution that handles the critical elements of application lifecycle management, such as version control, agile planning and automated builds. Now available for development teams worldwide, Team Foundation Service benefits include:

	Accessible from anywhere, using existing and familiar tools.
	Plan projects, collaborate with your team, and manage your code online from anywhere using any modern web browser. Works with all editions of Visual Studio 2012 (even Express!), as well as Eclipse and other tools (by using our command line client).
	Get started quickly, with no infrastructure to manage.
	Go from "sign up" to your first project in minutes, and set up a Continuous Integration (CI) build in a few easy steps. Your source code and work items are stored in the cloud, making server configuration a thing of the past.
	All languages and platforms welcome.
	From C# to Python, from Windows to Android, you can use a variety of languages and target a variety of platforms. Our services are designed to help you focus on what you do best—building great apps.

Get started today by signing up for your free account!

Team Foundation Service is being made available to teams of up to five developers for FREE. Sign up today, invite up to four team members and start collaborating for no cost. To get started, visit: http://tfs.visualstudio.com.

Which is best for you: DataReader or DataSet?

Prior to the release of the Microsoft .NET Framework, programmers had few data access technology choices for interacting with data stored in a database. An ActiveX Data Object (ADO) Recordset was the option commonly used to hold query results and data contents. It originally required a constant database connection to maintain access to the data. Over time it was evolved to support disconnected applications as well as provide some limited support for eXtensible Markup Language (XML).

The release of ADO.NET offers a new object model for retrieving data. Now there are two data classes for query results and a slew of other classes to hold various data content. Since most programmers are used to only having a single Recordset, this raises the questions of why there are two data retrieval classes in Microsoft .NET and which is the best to use.

What is a DataReader?
A DataReader is a read-only stream of data returned from the database as the query executes. It only contains one row of data in memory at a time and is restricted to navigating forward only in the results one record at a time. The DataReader does support access to multiple result sets, but only one at a time and in the order retrieved. Just as in the original version of ADO, the data is no longer available through the DataReader once the connection to the data source is closed, which means a DataReader requires a connection to the database throughout its usage. Output parameters or return values are only available through the DataReader once the connection is closed.

Top 10 Firefox Add-Ons for Web Designers

There are plenty of Firefox add-ons at your disposal that can extend the browser’s core functionality. The types of add-ons you’ll encounter have a wide range of utility, from productivity tools that monitor the amount of time you spend on the Internet, to social media tools that conveniently give you in-browser capabilities for using popular services such as Twitter and Facebook.

The Firefox browser is a popular choice for web designers, and there are plenty of add-ons that can make the day-to-day work of web design significantly more efficient and fruitful. Here are 10 highly recommended, top-notch Firefox add-ons for web designers. Let us know what other Firefox add-ons you use in the comments.

---

1. Web Developer

---

The Web Developer Firefox add-on is a huge suite of web design tools packed with massively useful functions that will help web designers perform tasks more efficiently. By default, it displays as a toolbar towards the top of the browser, presenting you with various menus such as CSS, Resize and Cookies.

Whether you need to inspect the CSS of page, discover information about a webpage (such as seeing all the alt attributes of images on the page), quickly validate a web design for W3C compliance or measure design elements, Web Developer will likely have a convenient tool for you.

---

2. Firebug

---

Firebug is such a popular web design/front-end web development Firefox add-on that there are actually add-ons for it (see no. 5). And if you were to ask any web designer or web developer what Firefox add-on they can’t live without, chances are he’ll say Firebug.

Firebug is an open source add-on that gives web designers powerful tools for inspecting and debugging a web design. It can help you figure out what CSS styles affect certain elements (in case you’re having trouble with a style rule that doesn’t seem to render properly), inspect the document object model (DOM) to learn about the structure of the web page, determine attributes such as color, width, height of HTML elements and much more.

The extension can take a while to learn (trust me, it’s worth the time), but the creators have some helpful documentation to get you started.