01.Dim column As New System.Windows.Forms.DataGridViewComboBoxColumn
02.
03. sb = New StringBuilder()
04. sb.Append("SELECT StaffID,StaffName FROM Staff")
05.
06.
07. Dim sqlIni As String
08. sqlIni = sb.ToString()
09.
10. com = New SqlCommand()
11. With com
12. .CommandText = sqlIni
13. .CommandType = CommandType.Text
14. .Connection = Conn
15. dr = .ExecuteReader()
16. End With
17.
18. If dr.HasRows Then
19. Dim dtDepartment As DataTable
20. dtDepartment = New DataTable()
21. dtDepartment.Load(dr)
22. With column
23. .HeaderText = "คนที่"
24. .DisplayMember = "StaffName"
25. .ValueMember = "StaffID"
26. .DataSource = dtDepartment
27.
28. End With
29.
30. End If
31. dr.Close()
