Opinion on the bast deisgn layout.

[VBJames]

Hi,

I am wanting a design layout like this basically it be on 2 tv screens.

The layout be like the below but 9 engineers:



Like the image below but in a more pretty format



I have the basic layout at the moment using a datagridview but its not dospalying any jobs.

        Dim items() As String = frmJobBoardSet.ListBox2.Items.Cast(Of Object).Select(Function(o) frmJobBoardSet.ListBox2.GetItemText(o)).ToArray
        Dim subsets() As Control = {Label1, Label2, Label3, Label4, Label5, Label6, Label7, Label8, Label9}
        Dim SubsetsDB() As DataGridView = {DataGridView1, DataGridView2, DataGridView3, DataGridView4, DataGridView5, DataGridView6, DataGridView7, DataGridView8, DataGridView9}
        Dim i As Integer
        Dim myfont As New Font("Microsoft Sans Serif", 15)
        '0 = 1 so 0-7 = 8
        For i = 0 To 7
            subsets(i).Font = myfont
            subsets(i).Text = items(i)

            Dim ds As New DataSet
            Dim Sqlcon As SqlConnection = New SqlConnection("Data Source=JAMESPC\SUPPORTDB;Initial Catalog=Support_DB;Persist Security Info=True;User ID=username;Password=password")
            Dim QueryOpen As String = "select [Job Number], Customer, fault from ['Job info$'] where [Job Completed?] = 0 and [attended by] = ' " & items(i) & " ' ORDER BY [job number] desc"
            Dim dataAdpt As New SqlDataAdapter(QueryOpen, Sqlcon)
            Sqlcon.Open()
            dataAdpt.Fill(ds, "['Job_Info$']")
            SubsetsDB(i).DataSource = ds.Tables("['Job_Info$']")
        Next i

    End Sub

I am would like other people's on idea on the best way to achieve this ia design and code manner .