0

How to create a datalist table layout in vb?

I am using vb .net

I have a following data:

DataBase: databaseName
Table : tableName

--------------------
| ID | randomNames |
--------------------
| 1  | name1       |
| 2  | name2       |
| 3  | name3       |
| 4  | name4       |
| 5  | name5       |
| 6  | name6       |
--------------------

I want to take all the data from database and display datalist table in the following format.

------------------------
|name1 | name2 | name3 |
|name4 | name5 | name6 |
------------------------

I set up the code but having hard time understanding how to format it like a table.

    Try
        sqlConn.Open()

        Dim cmd = New SqlCommand(SelectQuery, sqlConn)
        reader = cmd.ExecuteReader()

        While reader.Read()
            dr = dt.NewRow()
            dr(0) = reader(1)
            dt.Rows.Add(dr)

            'return a DataView to the DataTable
            CreateDataSource = New DataView(dt)
        End While
    Catch ex As Exception
        ErrorL.Text = "Error1 - Can't connect to database.<br/>" & ex.Message
    End Try
2
Contributors
1
Reply
9
Views
1 Year
Discussion Span
Last Post by rproffitt
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.