Hi,

I am trying to display the result from my query.....
I just can able to see the result as below :

Field1 Field2 Field3 Field4
Value1 Value2 Value3 Value4

Just wonder whether can i display my result as below or not(vertical display)?

Field1 Value1
Field2 Value2
Field3 Value3
Field4 Value4

#####################################
Dim Adapter1 As New OleDbDataAdapter(sql, oledbconn)
Dim ds1 As New DataSet

Adapter1.Fill(ds1)
DataList1.DataSource = ds1
DataList1.DataBind()
DataGrid1.DataSource = ds1
DataGrid1.DataBind()
oledbconn.Close()

######################################
Please give some advice.....Thanks