Read Excel Date in C#

Microsoft Excel stores dates as sequential numbers known as serial values.

DateTime.FromOADate Method
Returns a DateTime equivalent to the specified OLE Automation Date.

public static DateTime FromOADate(
double d
)

double _d = double.Parse(values.GetValue(1, i).ToString());
DateTime.FromOADate(_d).ToShortDateString();

Comments

Web synchronization option for merge replication

http://msdn2.microsoft.com/en-us/library/ms151319.aspx SQL Server 2005 Books Online Implementing Replication over the Internet Replicating data over the Internet allows remote, disconnected users to access data when they need it using a connection to the Internet. Replicate data over the Internet using: A Virtual Private Network (VPN). For more information, see Publishing Data over the Internet Using VPN . The Web synchronization option for merge replication. For more information, see Web Synchronization for Merge Replication . All types of Microsoft SQL Server replication can replicate data over a VPN, but you should consider Web synchronization if you are using merge replication.

html5 file upload

Note: slice method from File API was replaced by mozSlice in Firefox and webkitSlice in Google Chrome

Request Signatures in Blackberry

Request Signatures in Blackberry need copy sigtool.db, sigtool.csk to SDK/component/Bin folder for example V 4.2.1 ../eclipse\plugins\net.rim.eide.componentpack4.2.1_4.2.1.17\components\bin

Field Mapping

Search This Blog