Make the combined FirstName/LastName unique : DataGrid « Database ADO.net « VB.Net Tutorial

Home
VB.Net Tutorial
1.Language Basics
2.Data Type
3.Operator
4.Statements
5.Date Time
6.Class Module
7.Development
8.Collections
9.Generics
10.Attributes
11.Event
12.LINQ
13.Stream File
14.GUI
15.GUI Applications
16.Windows Presentation Foundation
17.2D Graphics
18.I18N Internationlization
19.Reflection
20.Regular Expressions
21.Security
22.Socket Network
23.Thread
24.Windows
25.XML
26.Database ADO.net
27.Design Patterns
VB.Net
VB.Net by API
VB.Net Tutorial » Database ADO.net » DataGrid 
26.3.3.Make the combined FirstName/LastName unique
Make the combined FirstName/LastName unique
Imports System.Windows.Forms
Imports System.Data
Imports System.Data.OleDb

public class CreateDataTableAndMakeCombinedColumnUnique
   public Shared Sub Main
        Application.Run(New Form1)
   End Sub
End class


Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, _
     ByVal e As System.EventArgsHandles MyBase.Load
        Dim contacts_table As New DataTable("Contacts")

        ' Add columns.
        contacts_table.Columns.Add("FirstName", GetType(String))
        contacts_table.Columns.Add("LastName", GetType(String))
        contacts_table.Columns.Add("Street", GetType(String))
        contacts_table.Columns.Add("City", GetType(String))
        contacts_table.Columns.Add("State", GetType(String))
        contacts_table.Columns.Add("Zip", GetType(String))

        ' Make the combined FirstName/LastName unique.
        Dim first_last_columns() As DataColumn = _
            contacts_table.Columns("FirstName"), _
            contacts_table.Columns("LastName"_
        }
        contacts_table.Constraints.Add_
            New UniqueConstraint(first_last_columns))



        ' Make some contact data.
        contacts_table.Rows.Add(New Object() {"A""A", _
            "1234""B""A""11111"})
        contacts_table.Rows.Add(New Object() {"B""B", _
            "22""B""C""22222"})
        contacts_table.Rows.Add(New Object() {"C""C", _
            "3""P""K""33333"})
        contacts_table.Rows.Add(New Object() {"""D", _
            "4""P""KS""44444"})

        grdAll.DataSource = contacts_table
        grdAll.CaptionText = "All Records"

    End Sub
End Class

<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Public Class Form1
    Inherits System.Windows.Forms.Form

    'Form overrides dispose to clean up the component list.
    <System.Diagnostics.DebuggerNonUserCode()> _
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing AndAlso components IsNot Nothing Then
            components.Dispose()
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()> _
    Private Sub InitializeComponent()
        Me.SplitContainer1 = New System.Windows.Forms.SplitContainer
        Me.SplitContainer2 = New System.Windows.Forms.SplitContainer
        Me.grdAll = New System.Windows.Forms.DataGrid
        Me.grdCO = New System.Windows.Forms.DataGrid
        Me.grdName = New System.Windows.Forms.DataGrid
        Me.SplitContainer1.Panel1.SuspendLayout()
        Me.SplitContainer1.Panel2.SuspendLayout()
        Me.SplitContainer1.SuspendLayout()
        Me.SplitContainer2.Panel1.SuspendLayout()
        Me.SplitContainer2.Panel2.SuspendLayout()
        Me.SplitContainer2.SuspendLayout()
        CType(Me.grdAll, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.grdCO, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.grdName, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'SplitContainer1
        '
        Me.SplitContainer1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.SplitContainer1.Location = New System.Drawing.Point(00)
        Me.SplitContainer1.Name = "SplitContainer1"
        Me.SplitContainer1.Orientation = System.Windows.Forms.Orientation.Horizontal
        '
        'SplitContainer1.Panel1
        '
        Me.SplitContainer1.Panel1.Controls.Add(Me.grdAll)
        '
        'SplitContainer1.Panel2
        '
        Me.SplitContainer1.Panel2.Controls.Add(Me.SplitContainer2)
        Me.SplitContainer1.Size = New System.Drawing.Size(519485)
        Me.SplitContainer1.SplitterDistance = 180
        Me.SplitContainer1.TabIndex = 2
        Me.SplitContainer1.Text = "SplitContainer1"
        '
        'SplitContainer2
        '
        Me.SplitContainer2.Dock = System.Windows.Forms.DockStyle.Fill
        Me.SplitContainer2.Location = New System.Drawing.Point(00)
        Me.SplitContainer2.Name = "SplitContainer2"
        Me.SplitContainer2.Orientation = System.Windows.Forms.Orientation.Horizontal
        '
        'SplitContainer2.Panel1
        '
        Me.SplitContainer2.Panel1.Controls.Add(Me.grdCO)
        '
        'SplitContainer2.Panel2
        '
        Me.SplitContainer2.Panel2.Controls.Add(Me.grdName)
        Me.SplitContainer2.Size = New System.Drawing.Size(519301)
        Me.SplitContainer2.SplitterDistance = 173
        Me.SplitContainer2.TabIndex = 0
        Me.SplitContainer2.Text = "SplitContainer2"
        '
        'grdAll
        '
        Me.grdAll.DataMember = ""
        Me.grdAll.Dock = System.Windows.Forms.DockStyle.Fill
        Me.grdAll.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.grdAll.Location = New System.Drawing.Point(00)
        Me.grdAll.Name = "grdAll"
        Me.grdAll.Size = New System.Drawing.Size(519180)
        Me.grdAll.TabIndex = 0
        '
        'grdCO
        '
        Me.grdCO.DataMember = ""
        Me.grdCO.Dock = System.Windows.Forms.DockStyle.Fill
        Me.grdCO.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.grdCO.Location = New System.Drawing.Point(00)
        Me.grdCO.Name = "grdCO"
        Me.grdCO.Size = New System.Drawing.Size(519173)
        Me.grdCO.TabIndex = 1
        '
        'grdName
        '
        Me.grdName.DataMember = ""
        Me.grdName.Dock = System.Windows.Forms.DockStyle.Fill
        Me.grdName.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.grdName.Location = New System.Drawing.Point(00)
        Me.grdName.Name = "grdName"
        Me.grdName.Size = New System.Drawing.Size(519124)
        Me.grdName.TabIndex = 1
        '
        'Form1
        '
        Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
        Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
        Me.ClientSize = New System.Drawing.Size(519485)
        Me.Controls.Add(Me.SplitContainer1)
        Me.Name = "Form1"
        Me.Text = "Contacts"
        Me.SplitContainer1.Panel1.ResumeLayout(False)
        Me.SplitContainer1.Panel2.ResumeLayout(False)
        Me.SplitContainer1.ResumeLayout(False)
        Me.SplitContainer2.Panel1.ResumeLayout(False)
        Me.SplitContainer2.Panel2.ResumeLayout(False)
        Me.SplitContainer2.ResumeLayout(False)
        CType(Me.grdAll, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.grdCO, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.grdName, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub
    Friend WithEvents SplitContainer1 As System.Windows.Forms.SplitContainer
    Friend WithEvents grdAll As System.Windows.Forms.DataGrid
    Friend WithEvents SplitContainer2 As System.Windows.Forms.SplitContainer
    Friend WithEvents grdCO As System.Windows.Forms.DataGrid
    Friend WithEvents grdName As System.Windows.Forms.DataGrid

End Class
26.3.DataGrid
26.3.1.Create DataTable and add to DataGridCreate DataTable and add to DataGrid
26.3.2.Add DataRow to DataGridAdd DataRow to DataGrid
26.3.3.Make the combined FirstName/LastName uniqueMake the combined FirstName/LastName unique
26.3.4.Use DataView to filter data tableUse DataView to filter data table
26.3.5.Load XML data to DataGrid
26.3.6.DataGrid with Error markDataGrid with Error mark
26.3.7.DataGrid: DataSet RelationDataGrid: DataSet Relation
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.