How to change Label text in DataList

See more:

OleDb

datalist

I want to change the Label text in my DataList. I want to check whether the product stock is 0 or not, if the stock is large from 0 to notify: Available in stock, if the stock is 0 to notify: Not available stock.

My code is:

int stock = 0;
      OleDbConnection con1 = new OleDbConnection();
      con1.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("") + "\\Database1.accdb";
      con1.Open();
      string sqlstring2Stock = "select * from ProductsTable where ProductModel like '%" + search.Text + "%' or ProductManufacturer like '%" + search.Text + "%' or ProductManufacturer + ' ' + ProductModel  like '%" +         search.Text + "%' order by CatalogNumber";
      OleDbCommand Cmd22 = new OleDbCommand(sqlstring2Stock, con1);
      OleDbDataReader d1r = Cmd22.ExecuteReader();
      d1r.Read();
      stock = int.Parse(d1r["ProductStock"].ToString());
      con1.Close();

      if (stock <= 0)
      {
          LabelAvailable.Text = "Not available";
      }
      else
      {
          LabelAvailable.Text = "Available";
      }

My DataList is:

<asp:DataList ID="DataList1" runat="server"  DataKeyField="ProductModel" RepeatDirection="Horizontal" 
        RepeatColumns="5" Width="100%">
        <ItemTemplate>
         <td align="center" >
                          <img src="<%# DataBinder.Eval(Container.DataItem, "ProductImage")%>" height='120' width='150' /><br />
                          <%# DataBinder.Eval(Container.DataItem, "ProductManufacturer")%> 
                          <%# DataBinder.Eval(Container.DataItem, "ProductModel")%><br />                    
                         <%# DataBinder.Eval(Container.DataItem, "Price")%> $<%--<br />--%>
                         <asp:Label ID="LabelAvailable" runat="server" Text="Label"></asp:Label><br />
                          <a href="ShowProductSearch.aspx?Model=<%# DataBinder.Eval(Container.DataItem, "ProductModel")%>">For details
</a><br />
                          <asp:Button ID="AddToCart" runat="server" Text="Add To Cart" />
                          </td>
        </ItemTemplate>
        </asp:DataList>

Thanks for your help!!!