Παρουσίαση με Ετικέτες

• .NET
• 2038
• ASP.net
• Binding
• ClipFlair
• Contracts
• Controls
• CSS
• Database
• DateTime
• Filename
• Filesystem
• Filters
• Fix
• Folders
• Formatting
• Future
• Grid
• HowTo
• jqGrid
• jQuery
• Lists
• MVC
• MySQL
• Overflow
• Posts
• Prometheus
• Serialization
• Silverlight
• SQL
• Styling
• Timestamp
• Types
• XML
• ZIP

MySQL DATETIME vs TIMESTAMP and the year 2038
01 Νοεμβρίου 19 09:45 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

Judging from MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/datetime.html, it sounds best to use DATETIME rather than TIMESTAMP if you want your database to be future proof. After all 2038 is only 18+ years away. The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' […]

Δημοσίευση στην κατηγορία: Posts, Data, Database, Types, SQL, DateTime, Future, Timestamp, Overflow, 2038, MySQL

Fix: jQuery’s jqGrid search UI custom styling
03 Οκτωβρίου 18 01:35 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

Lately, I’ve got the task of maintaining/extending an ASP.net MVC web application that is using jQuery’s jqGrid for data grids on its UI. First thing I noticed was how confusing the search UI on the grid’s header was: Those symbols on the left-side of each column’s searchbox are for the type of search (e.g. contains, […]

Δημοσίευση στην κατηγορία: Posts, Fix, CSS, ASP.net, Data, Styling, jqGrid, Prometheus, Grid, MVC, jQuery

HowTo: Bind ASP.net control to list of files or folders
15 Ιουλίου 13 03:33 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

At from ClipFlair Gallery metadata input pages for Activities and Clips I had to bind an ASP.net control to a list of files and folders respectively and although I found a Folder Contents DataSource control, it didn’t cover my needs (like filtering of a folder contents). I just contributed my solution using .NET Anonymous Types and […]

Δημοσίευση στην κατηγορία: .NET, Filters, Posts, Filesystem, Lists, ClipFlair, Controls, HowTo, ASP.net, Binding, Data, Filename, Folders

HowTo: format XML output of DataContractSerializer
22 Φεβρουαρίου 13 04:52 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

based on the other samples posted at StackOverflow on how to format XML created by DataContractSerializer, that use XmlWriter, here’s a version (from ClipFlair source code) that works with streams (and Ionic.Zip library in specific). It also shows how the code is when you don’t apply formatting (using conditional compilation).  Just comment out the #define [...]

Δημοσίευση στην κατηγορία: .NET, Posts, Silverlight, ClipFlair, HowTo, XML, ZIP, Contracts, Data, Serialization, Formatting