Datalist: what am I missing here? 1

[coco86]

I'm trying to create a datalist for an ASP.NET page. I get multiple rows in the list but they all contain the same data...the first record.

i.e.
White
White
White
White
White

and so on and so on. It should be

White
Green
Carson
O'Leary
Straight


I've tried creating a datagrid using the same dataset and I get all the rows the way I'm supposed to. I've also tried creating a different page in a different project with a different table in a different database...same problem. So I'm pretty sure it's not the data.

Is there a setting I've missed somewhere?



-Coco

 

[BoulderBum]

Can we see the code where you set up the DataBinding/DataSource?

 

[coco86]

The datasource is a dataset that I let VS create for me. I'm using the authors table from Pubs in SQL server. I just dragged and dropped the table to create the Connection and dataAdapter objects and then generated the dataset.

I set the datasource of the datalist and the datagrid in the properties and then in the page load event I have:


Me.SqlDataAdapter1.Fill(Me.DataSet11)
Me.DataList1.DataBind()
Me.DataGrid1.DataBind()

(once again, the datagrid works fine and it uses the same dataset)

-Coco

 

[DaZZleD]

for the datalist, have you set the
DataTextField
and
DataValueField

for the list?

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[coco86]

I'm not sure where those properties are located. I did add a label to the item template. It's databinding properties are set to have the bindable property be text and using simple binding, the text property is bound to the au_lname field of the dataset.

-Coco

 

[BoulderBum]

Nevermind my last post, in my haste I misread the post.

Can you post the ItemTemplate code (from the .aspx markup)? Maybe you're referencing the first element of the DataSource or something by mistake.

 

[coco86]

Ok, here it is:


<aspataList id=DataList1 DataMember="authors" DataSource="<%# DataSet11 %>" runat="server" Width="100%" DataKeyField="au_id">
<HeaderTemplate>
<asp:Label id="Label2" runat="server" Font-Bold="True">Last Name</asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Label id=Label1 Width="50%" runat="server" Height="100%" Text='<%# DataBinder.Eval(DataSet11, "Tables[authors].DefaultView.[0].au_Lname") %>'>
</asp:Label>
</ItemTemplate>
</aspataList>


-Coco

 

[Veep]

Try:

<asp:Label id=Label1 Width="50%" runat="server" Height="100%" Text='<%# DataBinder.Eval(Container.DataItem, "au_Lname") %>'>

 

[coco86]

WOO-HOO!!!

It worked! Thanks!

Now can you tell me why the other doesn't?

-Coco

 

[BoulderBum]

Because "you're referencing the first element of the DataSource or something by mistake". ;-)

 

[coco86]

okaaaay...

because of this...DefaultView.[0]?

-Coco