ahbeng123
April 28th, 2005, 04:11 AM
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
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