How to convert an excel serial date to a .NET date time?

How to convert an excel serial date to a .NET date time?
[ For eg: '29815' to '17/Aug/1981' ]

Use :

DateTime dt = DateTime.FromOADate(29815);

Upload a file using Web Service

Upload a file using byte array :

Web service method:


  [WebMethod]
        public string UploadFile(byte[] f, string fileName)
        {
            // the byte array argument contains the content of the file and 
            //the string argument contains the name and extension
            try
            {
                MemoryStream ms = new MemoryStream(f);

                //open a file stream pointing the storage folder 'uFiles'

                FileStream fs = new FileStream(System.Web.Hosting.HostingEnvironment.MapPath
                            ("~/uFiles/") + fileName, FileMode.Create);

                // write the memory stream  to the filestream
                ms.WriteTo(fs);
               
                ms.Close();
                fs.Close();
                fs.Dispose();
                return "OK";
            }

            catch (Exception ex)
            {
                     return ex.Message.ToString();
            }
        }


Sample win application code which consumes the method.


 FileInfo fInfo = new FileInfo(<<path & filename>>);

 FileStream fStream = new FileStream(<<path & filename>>,FileMode.Open, FileAccess.Read);

 BinaryReader br = new BinaryReader(fStream);
                 
 // convert the file to a byte array
 byte[] data = br.ReadBytes((int) fInfo.Length);
 br.Close();

localhost.Service1 s = new localhost.Service1();

s.UploadFile(data, <<filename>>);

 fStream.Close();

fStream.Dispose();

Upload an image using web service

Using Base64String:


Soap Web Service Method:-

 [WebMethod]
        public string UploadImage(string imgBase64String, string fname)
        {
            try
            {
                //Converts the base64String to byte array
                byte[] imageBytes = Convert.FromBase64String(imgBase64String);

                //store it in a memory stream
                MemoryStream ms1 = new MemoryStream(imageBytes);

                //generate image from stream
                Image img = Image.FromStream(ms1);

                //Map the folder to store image
                string actFolder = Server.MapPath("~/uFiles/");

                //save the image
                img.Save(actFolder + fname);

                return "OK";
            }
            catch (Exception e)
            {
                return e.Message;
            }

        }



Sample Win application code which consumes above service

// don't forget to add the web reference before using this code. 
//here the reference name is localhost and service name is Service 1 

            string base64;
            using (MemoryStream ms = new MemoryStream())
            {

                Image ximg = Image.FromFile(<<filepath>>);
                ximg.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);

                base64 = Convert.ToBase64String(ms.ToArray());
               
                localhost.Service1 S1 = new localhost.Service1();

               string r = S1.UploadImage(base64, "MyFile.Jpg");

               MessageBox.Show(r);

            }