DISPLAY DATA AT DATALIST BOX

[zaq888]

i have create sql command in dataenvironment... it need to pass the date value. I HAVE MADE IT.
theproblem is, how can i displays all the data in datalist box?
i have make the rowsource,rowmember,n listfield. but it shows all the data without having any sql generated..
here is code:

Private Sub cmdReport_Click()
buka

End Sub
Sub buka()
Dim a, b, sqlcmd1 As String
a = mula.Value
b = tamat.Value
If DataEnvironment1.rstodayReport.State = adStateOpen Then _
DataEnvironment1.rstodayReport.Close
DataEnvironment1.todayReport a, b
DataReport1.Show ' IF USING DATA REPORT IT DISPLAYS
'THE CORRECT DATA
DataList1.Refresh 'IF USING DATALIST,IT DISPLAY ALL
End Sub

I'm Keep Studying.... please show the way...
Not Good in English

 

[BobRodes]

I'm not sure just what you're using for "datalist". If you use a DataGrid control, you need to set the DataSource property to your Data environment, and the DataMember property to a Command in your Data environment. Then it should work. Some older data controls don't work with the Data Environment, so that might be part of your problem.

Bob Rodes

 

[zaq888]

i try to use the datagrid, seem it bring the same problem. it still capture all the data. its not generating the sql statement

anybody? can help

I'm Keep Studying.... please show the way...
Not Good in English