Posts

Showing posts from November, 2012

C# - Entity Framework - GROUP BY/ORDER BY/SELECT WHERE IN

var _inner_query = this.g_db_entity.ACTIVITIES                 .Where(w => (DateTime.Today <= w.ACTIVITY_DATE_TO))                 .GroupBy(g => g.ACTIVITY_DATE_FROM)                 .OrderBy(o => o.Key)                 .Select(s => s.Key)                 .Skip((pageNo - 1) * this.g_page_size)                 .Take(this.g_page_size); LIST<ACTIVITIES> _entity_activity = this.g_db_entity.ACTIVITIES                  .Where(m => _inner_q...
Read more

C# - Binary PDF File on Web Broswer via Binary Stream

Your binary PDF File was saved in MSSQL2008 in image data type. Byte[] _binary_document;// you get your binary data from database and assign to this parameter. //Result of binary stream Response.ContentType = "Application/pdf"; Response.AppendHeader("Content-Length", _binary_document.Length.ToString()); Response.BinaryWrite(_binary_document);
Read more

C# - Image to Byte Array and vise versa

System.Drawing.Image img = System.Drawing.Image . FromFile ( @"C:\Lenna.jpg" ); byte[] _byte_array = imageToByteArray(img, "jpg");     ------------------------------------------------------   public byte [] imageToByteArray(System.Drawing.Image imageIn , String imageFileType ) {    MemoryStream ms = new MemoryStream();    switch(imageFileType.ToLower()) {   case "gif": imageIn.Save(ms,System.Drawing.Imaging.ImageFormat.Gif); break; case "jpg": case "jpeg":   imageIn . Save ( ms , System . Drawing . Imaging . ImageFormat . Jpeg ); break; }   return ms.ToArray(); }   ------------------------------------------------------   public Image byteArrayToImage( byte [] byteArrayIn) { MemoryStream ms = new MemoryStream(byteArrayIn); Image returnImage = Image.FromStream(ms); return returnImage; }     web reference: http://www.codep...
Read more