title: get hyperlink list from database column in asp.net c#
body: <p>I am having 1 project website (quotes website)
  I have a page where all the quotes are displayed to gather. (screenshot below).
  I used stored procedure to display this result.</p>
  
  <p><img src="https://i.stack.imgur.com/A1714.png" alt="enter image description here"></p>
  
  <p>Now my main problem:</p>
  
  <p>As you can see there is a field for tags 
  eg: tags: Life, Funny, Leadership, Inspirational, Friendship</p>
  
  <p>But this value comes from database column category. and i am using a single label to display these all categories.</p>
  
  <p>But i want to divide it in individual category and redirect user on that particular category on which he clicks.</p>
  
  <p>Is there any way i can divide this single label in multiple hyperlinks?</p>
  
  <p>My stored procedure (in-case any1 needs)</p>
  
  <pre><code>ALTER Proc text_quotes
      (
      @cat varchar(50)
      )
  as
  begin
      select p.id,p.title,p.description,p.category,p.metadescp,p.metatitle,p.tags,f.img
      from tbl_upload_image p
      inner join tbl_author f
      on p.description = f.name
      where p.category like '%' + @cat + '%'
      order by p.upload_date desc
  end
  </code></pre>
  
  <p>Example entry from database:</p>
  
  <p>id  : 12</p>
  
  <p>Quote   : dghjn</p>
  
  <p>category: Life, Funny, Leadership, Inspirational, Friendship</p>
  
  <p>author  : Jim Carrey</p>
  
  <p>UPDATE:</p>
  
  <p>i HAVE USED BELOW CODING:</p>
  
  <pre><code>foreach (DataListItem item in DataList4.Items)
          {
              Repeater RepeaterQ = ((Repeater)(item.FindControl("Repeater1")));
              string categories = ((Label)(item.FindControl("categoryLabel"))).ToString();
  
              // Label lblCategory = ((Label)(DataList4.FindControl("categoryLabel")));
              string[] arr1 = categories.Split(',');
  
              RepeaterQ.DataSource = arr1;
  
              RepeaterQ.DataBind();
          }
  </code></pre>
  
  <p>But i am getting "System.Web.UI.WebControls.Label " as text in repeater. Any help?</p>