netad 0 Newbie Poster

Hi!,

i am a learner in asp.net, I have a page build in asp.net 2.0 in which we call data to a grid view calling different data values to different coloumns, i have a very simple issue, i want one coloumns which shows a unformatted data from the database, to show me a data in the bulleted list in that particular coloumn with the label 7 which shows the data for Products in the code as follows:
If i add the code for the bulleted list it gives an error or a blank field. Thanks for the help in advance.

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Admin.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">

    <title>WORK ORDER</title>
  <link rel ="stylesheet" href ="Style/style3.css" />  
</head>
<body style="background-color:#EBFFD7;margin:0">
    <form id="form1" runat="server">
    <div>
    <table id="Table1" class="table" width="100%" runat="server">
    <tr>
    <td align="center" style="width: 3577px; height: 27px; text-align: center;"  >
        <strong><span style="font-size: 16pt; font-family: Verdana;">WORK ORDER&nbsp;</span></strong></td>
   <td align="center" style="  height: 27px; width: 3px;"  >
      <a href="Logout.aspx"> <span style="font-size: 14pt; color: #ff6633; background-color: #ccffff; text-decoration: underline">
           <strong>
   Logout</strong></span></a>
   </td>
    </tr>
    </table>
    <table id="Gv1" runat="server" width="100%" style="border-right: #ff6600 1pt double; border-top: #ff6600 1pt double; border-left: #ff6600 1pt double; border-bottom: #ff6600 1pt double;">
   <tr>
   <td style="height: 21px"></td>
   </tr>
     <tr>
    <td align="center" style="height: 21px ;"    > 
        <span style="color: #0033ff; font-family: Verdana"><strong>
       Select Year</strong></span>
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" BackColor="#C0FFC0"
            Font-Bold="True" Font-Names="Verdana" ForeColor="#C00000" Width="106px" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged1" ToolTip="Select Year For Display Work Order Information">
            <asp:ListItem Value="1900">--select-- </asp:ListItem>
        </asp:DropDownList></td>
    </tr>
    
    <tr>
    <td align="center" style="height: 33px">
    <table>
    <tr>
    <td>
      <asp:Label ID="L1" runat="server"  Visible="False" BackColor="#FFFF80" Font-Bold="True" ></asp:Label>
    </td>
    <td>
    <asp:Label ID="L2" runat="server"  BackColor="#FFFFC0" Font-Bold="True" ></asp:Label>
    </td>
    </tr>
    </table>
   
     </td>
    </tr>
     <tr>
    <td align="center" style="background-color:#8080FF">
        <asp:Label ID="Layear" runat="server" Text="Label" BackColor="CornflowerBlue" BorderColor="DimGray" BorderStyle="Ridge" BorderWidth="2px" Font-Bold="True" Font-Size="16pt" ForeColor="White" Height="37px" Width="440px" Font-Names="Arial Rounded MT Bold" Font-Underline="True" style="text-transform: capitalize; font-variant: small-caps"></asp:Label> 
        </td>
    </tr>
    <tr>
    <td style="height: 256px">
        <asp:GridView ID="GridView1"    runat="server" AutoGenerateColumns="False"   Width="993px" OnRowCommand="Update" OnRowCreated="GridView1_RowCreated" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound" DataKeyNames="WoNo" Font-Names="Verdana" Font-Size="10pt" BackImageUrl="~/Img/row1[1].gif" ShowFooter="True" Height="10px" BorderColor="Black" BorderWidth="2px" CellPadding="1" CellSpacing="1" AllowPaging="True" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"  >
            <Columns>
                <asp:TemplateField HeaderText="Edit">
                    <ItemTemplate>
                        <asp:LinkButton   CommandName="ed" ID="lnkedi2" runat="server" OnClick="lnkedi2_Click" Style="position: relative; left: 0px;">Edit</asp:LinkButton>
                    </ItemTemplate>
                    <HeaderStyle Font-Size="12pt" />
                    <HeaderTemplate>
                        <span style="font-size: 10pt; font-family: Verdana">Edit</span>
                    </HeaderTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="WoNo">
                    <ItemTemplate>
                        &nbsp;<asp:Label  ID="Label1" runat="server" Style="position: relative" Text='<%# Bind("WONo") %>'></asp:Label>
                    </ItemTemplate>
                    <HeaderStyle CssClass="ob_gHCont" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="IssueDate">
                    <ItemTemplate>
                        &nbsp;<asp:Label ID="Label3" runat="server" Style="position: relative" Text='<%# Bind("IssueDate") %>' Width="65" ></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="LeadTime">
                    <ItemTemplate>
                        &nbsp;<asp:Label ID="Label4" runat="server" Style="position: relative" Text='<%# Bind("LeadTime") %>' Width="10px"></asp:Label>
                    </ItemTemplate>
                    <HeaderTemplate>
                        Lead<br />
                        Time
                    </HeaderTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="DelDate">
                    <ItemTemplate>
                        &nbsp;<asp:Label ID="Label5" runat="server" Style="position: relative" Text='<%# Bind("DelDate") %>' Width="65" ></asp:Label>
                    </ItemTemplate>
                    <HeaderTemplate>
                        Commited
                        <br />
                        Delivery Date
                    </HeaderTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Custname">
                    <ItemTemplate>
                        &nbsp;<asp:Label ID="Label6" runat="server" Style="position: relative" Text='<%# Bind("CustomerName") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Products">
                   <ItemTemplate>
                        &nbsp;<asp:Label ID="Label7" runat="server" Style="position: relative" Text='<%# Bind("Products") %>'></asp:Label>
                 </ItemTemplate> 
                </asp:TemplateField>
<asp:TemplateField HeaderText="ReadyDate">
                    <ItemTemplate>
                        &nbsp;<asp:Label ID="Label8" runat="server" Style="position: relative" Text='<%# Bind("ReadyDate") %>'  Width="65"   ></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="InspDate">
                    <ItemTemplate>
                        &nbsp;<asp:Label ID="Label9" runat="server" Style="position: relative" Text='<%# Bind("InspDate") %>'  Width="65"  ></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                   
                <asp:TemplateField HeaderText="Del_Date">
                    <ItemTemplate>
                        <asp:Label ID="Label10" runat="server" Style="position: relative" Text='<%# Bind("del_date") %>'  Width="65"  ></asp:Label><asp:CheckBox
                            ID="Ch1" runat="server" Font-Bold="True" ForeColor="Green" Style="left: 0px;
                            position: relative" Text="Yes" /><asp:CheckBox ID="Ch2" runat="server" ForeColor="Red"
                                Style="position: relative" Text="No" />&nbsp;<span style="font-size: 7pt"> </span>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="[DelayCause/Remarks]">
                    <ItemTemplate>
                        &nbsp;<asp:Label ID="Label11" runat="server" Style="position: relative" Text='<%# Bind("DelayCauseRemarks") %>'></asp:Label>
                    </ItemTemplate>
                    <HeaderTemplate>
                        Remarks
                    </HeaderTemplate>
                    </asp:TemplateField>
                <asp:TemplateField HeaderText="Edit">
                    <ItemTemplate>
                        <asp:LinkButton ID="LnEdit" CommandName="ed" runat="server" Style="position: relative" OnClick="LnEdit_Click">Edit</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="PK" >
                    <ItemTemplate>
                        <asp:Label ID="Pk" runat="server" Style="position: relative" Text='<%# Bind("WorkNo") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="DelCheck">
                    <ItemTemplate>
                        <asp:Label ID="lbRb" runat="server" Style="position: relative" Text='<%# Bind("Rb") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Ch1">
                    <ItemTemplate>
                        <asp:Label ID="lbRb1" runat="server" Style="position: relative" Text='<%# Bind("Rb1") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <RowStyle BorderColor="#FFC080" BorderStyle="Outset" BorderWidth="1px" />
            <HeaderStyle Font-Size="12px" CssClass=" ob_gHCont" Font-Bold="True" Height="10px" BorderStyle="Groove" Wrap="False" />
            <AlternatingRowStyle CssClass="row" />
            <FooterStyle CssClass="&quot;ob_gBH&quot;" BackColor="#8080FF" />
            <EditRowStyle BackColor="#FFE0C0" CssClass="gridcell" />
            <PagerSettings FirstPageText="First" LastPageText="Last" NextPageText="Next" PreviousPageText="Prevous" />
            <PagerStyle BackColor="#8080FF" BorderColor="#FF8000" BorderStyle="Solid" BorderWidth="1px"
                Font-Bold="True" ForeColor="White" HorizontalAlign="Center" VerticalAlign="Middle"
                Width="12px" Wrap="False" />
        </asp:GridView>
        <br />
       <div align="center"><asp:Label ID="Lbnull" Visible="False" runat="server" Text="Label" BackColor="InactiveCaptionText" BorderColor="#C04000" BorderStyle="Groove" BorderWidth="2px" Font-Bold="True" Font-Names="Verdana" Font-Size="20pt" ForeColor="#C00000"></asp:Label><br />
           &nbsp;</div> 
    </td>
    </tr>
    <tr>
    <td style="height: 26px" class="ob_gH td">
        <table>
        <tr>
        <td style="width: 244px"></td>
        <td style="width: 784px"> <asp:Button ID="Button1" runat="server" Text="Back" OnClick="Button1_Click" Width="69px" CssClass="btn" />
        <asp:Button ID="Insert" runat="server" Text="Insert"  Width="69px" OnClick="Insert_Click" CssClass="btn" />
        <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Create and edit user  " Width="168px" CssClass="btn" />
        <asp:Button ID="Button3" runat="server" Text="Latest update"  Width="115px" OnClick="LatestUpdate" style="position: relative" CssClass="btn" />
        <asp:Button ID="Button4" runat="server" Text="Commited order"  Width="115px" OnClick="Completed" style="position: relative" CssClass="btn" /></td>
        <td style="width: 387px"></td>
        
        </tr>
        </table>
        </td>
   
    </tr>
        
    </table>
 </div>
 
     
</form>
</body>
</html>