Visual Basic

If Len(strJnts) > 0 Then
    _gblString = CreateGUIDString()

    gblConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\JWI\Data\JWI.mdb;Jet OLEDB:Database Password=jWi;")

    strData = "INSERT INTO LOLItems (LOLItemsID, LOLIFormID, Type, TextBox, MaterialsID, Units, DateCreated )" _
    & " VALUES ('" & _gblString & "',  " _
    & "'" & _frmGuid & "', '" _
    & 1 & "',' " _
    & strName & "',' " _
    & _MATGuid & "',' " _
    & strJnts & "',' " _
    & Now() & "');"

    gblCMD.Connection = gblConn
    gblCMD.CommandText = strData
    Dim cmd As New System.Data.SqlClient.SqlCommand

    gblConn.Open()
    gblCMD.ExecuteNonQuery()
End If

public class NullableDateTimePicker : System.Windows.Forms.DateTimePicker
  {
    // Default Constructor
    public NullableDateTimePicker() : base()
    {
      base.Format = DateTimePickerFormat.Custom;
      NullValue = " ";
      Format = DateTimePickerFormat.Custom;
      CustomFormat = "dd MMM yyyy";

      this.DataBindings.CollectionChanged += new CollectionChangeEventHandler(DataBindings_CollectionChanged);
    }
}

//NullableDateTimePicker is the class from which DateTimePickerEditingControl class inherits.
//IDataGridViewEditingControl is the interface which DateTimePickerEditingControl class implements.
class DateTimePickerEditingControl : NullableDateTimePicker, IDataGridViewEditingControl
    {
	//Constructor
        public DateTimePickerEditingControl()
        {
            this.Format = DateTimePickerFormat.Custom;
            this.CustomFormat = "dd MMM yyyy";
        }
}