About Stephen Jackson Expertise I can help with questions regarding VB.NET syntax and object references, with data interfaces and with the design and creation of robust, data aware object classes. I can also be very helpful with creating distributable applications and provide tricks and tips on .msi creation. I also have extensive experience in designing SQL Server Databases and interfacing them with VB.NET. I try to avoid web specific questions, as that is an area of expertise all its own.
Experience
Experience in the Area: I have been a programmer in Visual Basic since version 1.0 and have worked with VB.NET (which is infinitely more powerful than previous versions) since its initial release and SQL Server, both as a corporate IT professional and professional consultant. I first wrote Basic in 1976 on a TRS 80 and have worked in Visual Basic 1.0 and every subsequent release of Microsoft Visual Basic. I worked for over 7 years as a Senior Level Consultant in the area and currently hold a Project Manager position in IT.
Education and Credentials: MBA in Econometrics, 1983, University of Memphis.
BBA in Financial Management, 1982, Fogelman College of Business and Economics, University of Memphis. Microsoft Certified Professional
Areas of Special Expertise:
My specialty is the design of Object Oriented Solutions with robust, data aware object classes. I generally avoid the classic ‘Three Tier’ model as I find it redundant and cumbersome to maintain. I also specialize in the creation of ‘User Friendly’ User Interfaces which help lessen the need for user training and help prevent user error. I work best with Windows Forms based applications, and while I do work in C# as well, I prefer to limit my questions here to Windows Forms based applications created in Visual Basic.NET and SQL Server. I wil also address questions relating to the distribution and installation of Windows Forms based applications created in VB.NET.
Expert: Stephen Jackson Date: 3/28/2008 Subject: format in DGV
Question How do I change the format of my column in my datagridview? ‘cause I want to change a specific column into date format.
Answer Enrico,
I am copying a sample below. There is a Format property on the column object; just set it to the date format you desire (the one below is set to "d", standard short date.
Dim dcsColumn10 As New DataGridTextBoxColumn
dcsColumn10.HeaderText = "Date Requested"
dcsColumn10.MappingName = "DATE_REQUESTED"
dcsColumn10.Alignment = HorizontalAlignment.Right
dcsColumn10.Format = "d"
dcsColumn10.Width = 110
dgsPORequests.GridColumnStyles.Add(dcsColumn10)
The standard short date format shown above will yield '03/28/2008'.
You can also use a custom date format such as "dddd, MMMM dd, yyyy" which would format a date as 'Friday, March 28, 2008'.
