C#

<br />
        public class RecordData<br />
        {<br />
            public int ID { get; set; }<br />
            public DateTime DateNR { get; set; }<br />
        }<br />

<br />
        GridViewColumnHeader gvch = new GridViewColumnHeader();<br />
        GridViewColumn gvc = new GridViewColumn();<br />
        Binding bind = new Binding("DateNR");<br />
        bind.Converter = new FormattingConverter();<br />
        bind.ConverterParameter = @"{0:dd-MMM-yy}";<br />
        gvc.Width = 80;<br />
        gvc.DisplayMemberBinding = bind;<br />
        gvch.Content = "NR Date";<br />
        gvc.Header = gvch;<br />
        myGridView.Columns.Add(gvc);<br />

<br />
        SqlConnection sqlConn = new SqlConnection(myConnectionString);<br />
        SqlCommand sqlComm = new SqlCommand("...", sqlConn);<br />
        SqlDataReader sqlDR = sqlComm.ExecuteReader();<br />
        // ...<br />
        RecordData rd = new RecordData();<br />
        rd.ID = sqlDR.GetInt32(0);<br />
        if (sqlDR.IsDBNull(1) == false)<br />
            rd.DateNR = sqlDR.GetDateTime(1);<br />
        // ...<br />
       _MyCollection.Add(rd);<br />

this.Validate();
     this.trainingBindingSource.EndEdit();
     this.membersBindingSource.EndEdit();
     this.membersTableAdapter.Update(this.trainingDataSet.Members);
     this.trainingTableAdapter.Update(this.trainingDataSet.Training);

     trainingDataSet.AcceptChanges();
     trainingDataSet.Dispose();