Learn to share

http://computer-experience.blogspot.com/2008/12/khmer-unicode-with-crystal-report-in-c.html http://sochinda.wordpress.com/2009/10/07/print-crystal-report-with-khmer-unicode-in-c-application/

    I have been taking a while for searching for feasibility to use Khmer Unicode in SQL Server. Recently I have found article posted by sochinda  related to how to be able to use in SQL Server. We need to have our database   . Collation as SQL_Latin1_General_CP850_BIN   . Defined fields as NChar, NVarchar, ... When insert we need to use such syntax as : insert into tblUser(Name) VALUES(N'សួស្តី') insert into tblUser(Name) VALUES(N'វាសនា') insert into tblUser(Name) VALUES(N'ស្រីអៀប') And When we do some search we need to applied :  select * from tblUser where Name LIKE N'%សន%'

The followiing are that code that I have used to read excel file: DataSet myDataset = new DataSet(); if (!FullFileName.Equals("")){ OleDbConnection conn = new OleDbConnection(); OleDbCommand cmd = new OleDbCommand(); OleDbDataAdapter da = new OleDbDataAdapter(); string query = null; string connString = ""; string strFileType = System.IO.Path.GetExtension(FullFileName).ToString().ToLower(); if (strFileType.Trim() == ".xls"){ connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FullFileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } else if (strFileType.Trim() == ".xlsx"){ connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FullFileName + ...

http://www.techrepublic.com/blog/datacenter/help-my-sql-server-log-file-is-too-big/448 http://blog.sqlauthority.com/2007/11/22/sql-server-shrinking-truncate-log-file-log-full-part-2/

19 August 2011 @ 10:45AM (3.05Kg) @ Calmet Hospital. ត្រូវ​នឹង ថ្ងៃសុក្រ ៥​រោច  ខែ ស្រាពណ៍ ឆ្នាំ ថោះ ត្រីសក័ ពស ២៥៥៥ គស ២០១១

      You can customize Ms Access 2007 ribbon by adding Zoom feature in table [USysRibbons] with the following code : <group id="grpZoom" label="Zoom" visible="true"> <splitButton idMso="PrintPreviewZoomMenu" size="large"/> <toggleButton idMso="ZoomFitToWindow" size="large"/> <toggleButton idMso="ZoomOnePage" size="large"/> <toggleButton idMso="PrintPreviewZoomTwoPages" size="large"/> </group> You can also see original post at rptsoftware  

    I have found a simple explanation on sqlteam website related to the table inheritane design. It look cool and easy to understand the feature.  I have convert web page into pdf file .