Technische blog Huidige artikelen | Archieven | Zoek Zoek geboortedatum in Rijksregister nummer Categorie: Algemeen De geboortedatum is niet altijd ingevuld, maar je hebt toegang tot het rijksregisternummer, dan helpt deze functie je redelijk full-proof aan de juist... [Toon artikel] Bereken de leeftijd in SQL Categorie: SQL De meest accurate vorm die ik gevonden heb (ik vrees dat er toch nog een aantal bugs zijn, stel dat je data hebt tussen 3 jaar, stuatie 1 : er zit ee... [Toon artikel] Find text in SP - Part 2 Categorie: SQL For some reason, the code in my previous post does not work anymore. Here an alternative: DECLARE @Search varc... [Toon artikel] Grant access on a SQL TYPE Categorie: SQL grant execute on TYPE::UpdateGroupVlgnrType to public; grant execute on TYPE::CF_VertalingenTableType to public; [Toon artikel] Access controls from background worker Categorie: .NET Create the background worker: Dim worker = New BackgroundWorker() AddHandler worker.DoWork, AddressOf worker_do_work AddHandler worker.RunWorkerCom... [Toon artikel] Prevent onselectedindex_changed being fired during initialisation Categorie: .NET Global Var: &... [Toon artikel] Check if property was declared in base class or in the inheriting class Categorie: .NET For Each p As System.Reflection.PropertyInfo In Me.GetType.GetProperties() &n... [Toon artikel] Pass change events from usercontrol to parent (WPF) Categorie: .NET Add public class PublicClassCheckBoxSelectionChangedRoutedEventsArgs InheritsRoutedEventArgs... [Toon artikel] Using a datatable with primary key for vb.net Categorie: .NET Using a datatable with primary key Dim dt As New DataTable dt.Columns.Add(New DataColumn("id", GetType(Integer))) dt.PrimaryKey = New DataC... [Toon artikel] DNN Remember password default checked Categorie: DotNetNuke DNN does not allow you to check the remember password checkbox by default, a small jquery comes to the aid here. This will do the trick, at t... [Toon artikel] Generate DROP Table and Stored Procedure Categorie: SQL You want to delete all tables and stored procedures (to include them in an installation script for example): ... [Toon artikel] Set the width of the Group Tree in a Crystal Reports Viewer Categorie: Crystal Reports To set the width of the group tree in a crystal report you can use this function. It seeks out the group control in the crystalviewer control and cha... [Toon artikel] SQL Function for padding Categorie: SQL To simulate the .NET function PadLeft(18, "0") You can write in SQL: DECLARE @Amount int = 7891... [Toon artikel] Split a string on a word (instead of character) Categorie: .NET Public Shared Function WordSplit(sIn As String, sSep As String) As String() Dim a() As ... [Toon artikel] Add event to DataGridView Cell Categorie: .NET To add a custom eventhandler to your DataGridView Cell : Private Sub grdVoor_EditingControlShowing(sender As Object, e As DataGrid... [Toon artikel] Hide facebook plugin on mobile devices Categorie: CSS, DESIGN Je wil het design responsive maken maar refereert dikwijls naar 3e party code (zoals de facebook plug-ins) Het is nogal lastig om externe code te stu... [Toon artikel] Create a soft fade in PSP Categorie: DESIGN Follow this procedure to add a nice fade around your image: Open a photo Choose the selection tool and choose the type of your choice (ex.... [Toon artikel] Get profile properties in DNN Categorie: SQL, DotNetNuke This function allows you to get DNN profile properties from the system. You can even ask for custom properties you added yourself. C... [Toon artikel] Use columns with CSS unnumbered list structure Categorie: CSS Use columns in HTML using the HTML tag UL <!DOCTYPE html> <html> ... [Toon artikel] Synchronize files in DNN via application Categorie: .NET, DotNetNuke Often you're programming a custom module that is creating files in the file system of DNN. Than it would be great to have your new files immedia... [Toon artikel] Pagina 1 van 2Eerste Vorige [1] 2 Volgende Laatste