DataList Is not showing Data using ASP.NET and C#

kmazumdar · August 18th, 2004, 08:20 PM

I have to get data from a Oracle DB and show it based on the user input for Where clause.

I have created 2 DropDownList and populating them from DB using page_load method.

User picks up the desired value and clicks on the submit button.

Code behind the click event connects to the oracle using oleDb, generates sql, fills the DataSet and binds it to the DataList.

But no data, only the labels in template is showing up. However, if I use a DataGrid, it is showing the data.

Please help - this is my first form in .NET .

Thanks
Kmazumdar

desmond047 · August 18th, 2004, 10:23 PM

DataList ?
What i understand ur describes is U have a form that contain some textbox and dropdownlist, u have successful bind some data from db to the 2 dropdown list.

then when submit the data by click a button, it doesnt save into db but show the data on the grid only is it ?

is it asp.net or ???

~ Human Knowledge Belongs to the World !

planoie · August 19th, 2004, 07:45 AM

What does the markup for the DataList control look like?

kmazumdar · August 19th, 2004, 11:40 AM

Here is the markup for DataList

Code:

<asp:datalist id="DataList1" style="Z-INDEX: 110; LEFT: 133px; POSITION: absolute; TOP: 364px" runat="server" Width="539px" Height="92px" RepeatLayout=Flow>
                                <ItemTemplate>
                                    <TABLE>
                                        <tr>
                                            <td><b>NPA: </b>
                                                <asp:label id=lblNpa td < text='<%# DataBinder.Eval(Container.DataItem,"C1") %>'</td>
                                            <td><b>NXX: </b>
                                                <asp:label id="lblNxx" text='<%# DataBinder.Eval(Container.DataItem,"C2") %>' </td>
                                            <td><b>LATA: </b>
                                                <asp:label id="lblLata" text='<%# DataBinder.Eval(Container.DataItem,"C3") %>' </td>
                                        </tr>
                                        <tr>
                                            <td><b>Time Zone: </b>
                                                <asp:label id="lblTimeZone" text='<%# DataBinder.Eval(Container.DataItem,"C4") %>' </td>
                                            <td><b>Day Light Saving : </b>
                                                <asp:label id="lblDayLightSav" text='<%# DataBinder.Eval(Container.DataItem,"C5") %>' </td>
                                            <td><b>State Code: </b>
                                                <asp:label id="lblStateCd" text='<%# DataBinder.Eval(Container.DataItem,"C6") %>' </td>
                                        </tr>
                                        <tr>
                                            <td colspan="3"><b>Split From NPA: </b>
                                                <asp:label id="lblSplitFromNpa" text='<%# DataBinder.Eval(Container.DataItem,"C7") %>' </td>
                                        </tr>
                                        <tr>
                                            <td colspan="3"><b>Split From NXX: </b>
                                                <asp:label id="lblSplitFromNxx" text='<%# DataBinder.Eval(Container.DataItem,"C8") %>' </td>
                                        </tr>
                                        <tr>
                                            <td><b>Vertical Coordinate: </b>
                                                <asp:label id="lblVerticalCoordinate" text='<%# DataBinder.Eval(Container.DataItem,"C9") %>' </td>
                                            <td><b>Horizontal Coordinate : </b>
                                                <asp:label id="lblHorizontalCoordinate" text='<%# DataBinder.Eval(Container.DataItem,"C10") %>' </td>
                                            <td>&nbsp;</td>
                                        </tr>
                                        <tr>
                                            <td colspan="3"><b>Border Town: </b>
                                                <asp:label id="lblBorderTown" text='<%# DataBinder.Eval(Container.DataItem,"C11") %>' </td>
                                        </tr>
                                    </TABLE>
                                </ItemTemplate>
                            </asp:datalist>

===================
Code behind the click event of submit button
===================

Code:

DataList1.DataSource = ds;
DataList1.DataBind();

planoie · August 19th, 2004, 12:29 PM

A) This line is incorrect:
<asp:label id=lblNpa td < text='<%# DataBinder.Eval(Container.DataItem,"C1") %>'</td>

B) None of your label's are "runat='server'". Add that and see what happens.

kmazumdar · August 20th, 2004, 10:18 AM

Thank you.

I remove the label tag completely and it is working. However with 'runat"server"' directive, I was getting an error message saying Server directive not properly formed.

Thanks for all the help.