Hi all,
I have a DataGrid on my form which is ok and works.. I want to get rid of the DataGrid and use a DataList, How do I do it. The code that I am using to fill my DataGrid is below:

Code:
Private Sub Form_Load()
cn.CursorLocation = adUseClient
cn.Open "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=testitem;User=root;Password=mysql;Option=3;
End Sub"

Private Sub Command1_Click()
rs.Open "select * from item where itemname = '" & Text9.Text & "'", cn, adOpenDynamic, adLockOptimistic
Set DataList1.RowSource = rs
DataList1.DataField = itemno
Set DataGrid3.DataSource = rs
End Sub
The datagrid gets populated just fine but the datalist is always empty

What am I missing here?
Please help.