Skip to content

Instantly share code, notes, and snippets.

@NPS-ARCN-CAKN
Last active October 11, 2017 16:02
Show Gist options
  • Save NPS-ARCN-CAKN/3ef207b9ee91d80838aafd34e3a25842 to your computer and use it in GitHub Desktop.
Save NPS-ARCN-CAKN/3ef207b9ee91d80838aafd34e3a25842 to your computer and use it in GitHub Desktop.
GridEX: Set column default values on the fly.
'root table
Private Sub CampaignsGridEX_SelectionChanged(sender As Object, e As EventArgs) Handles CampaignsGridEX.SelectionChanged
Me.TblVitalSignWorkLogGridEX.RootTable.Columns("LogDate").DefaultValue = Now
End Sub
'heierarchical tables
Private Sub CampaignsGridEX_SelectionChanged(sender As Object, e As EventArgs) Handles CampaignsGridEX.SelectionChanged
Me.CampaignsGridEX.Tables("Campaigns").Columns("RecordInsertedDate").DefaultValue = Now
Me.CampaignsGridEX.Tables("Campaigns").Columns("RecordInsertedBy").DefaultValue = My.User.Name
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment