Skip to posts
  • About

Win Web Hosting

Web Hosting Information
  • Home
  • ASP.NET
  • Cloud Hosting
  • Dedicated Servers
  • Linux Web Hosting
  • Microsoft AJAX
  • Microsoft Siverlight
  • Windows Web Hosting

how can i retrieve data line by line from database in asp.net?

May 31, 2010 James 2 comments
ASP.NET ASP.NET, data, database, from, line, retrieve

Comments

Leave a comment Trackback
  • Written by chengfee.Zvet about 2 years ago.

    Perhaps do you have a delimeter for the poem? say comma or something so that it can clearly shows that when is the end of the line. for instance:
    bla bla bla,
    bla bla bla,
    bla bla bla,
    bla bla bla.

    So when you store them into the table column, it will look something like:
    bla bla bla, bla bla bla, bla bla bla, bla bla bla.

    And this will be what you see as well when you display them out. If you have a delimeter like “,” in your poem, when you display out you can actually break them and store them into an array, and display them back in line by line. Code should look something like this:

    Dim poem() as String = Split(xxx, “,”)
    Note: xxx is the source of your data from DB, it should look something like dataset.Tables(“poem”).rows(0).item(“columnname”)

    Dim line1 as String = poem[0]
    Dim line2 as String = poem[1]
    Dim line3 as String = poem[2]
    Dim line4 as String = poem[3]

    Me.txtPoem.text = line1 & “
    ” & line2 & “
    ” & line3 & “
    ” & line4

    I’m not sure is this what you want, hope it will help. And please note that this code will only works if you have only ONE comma in each line and the comma is located at the end of the line. (last line can have no comma at all) :)

  • Written by tingtong about 2 years ago.

    Change the DataBase field as text field.And Use Fck editor to write and save text.It will save exactly the same format u write on editor.Do some R&D.

Comment Pages:

Leave a Comment

Cancel Reply

You must be logged in to post a comment.

RSS

Win Web Hosting Home Page

Cheap Windows Hosting

 

February 2012
M T W T F S S
« Jan    
 12345
6789101112
13141516171819
20212223242526
272829  

Archives

  • February 2012 (60)
  • January 2012 (92)
  • December 2011 (163)
  • November 2011 (205)
  • October 2011 (339)
  • September 2011 (367)
  • August 2011 (367)
  • July 2011 (322)
  • June 2011 (338)
  • May 2011 (358)
  • April 2011 (94)
  • March 2011 (40)
  • February 2011 (36)
  • January 2011 (41)
  • December 2010 (30)
  • November 2010 (40)
  • October 2010 (41)
  • September 2010 (52)
  • August 2010 (150)
  • July 2010 (165)
  • June 2010 (159)
  • May 2010 (238)
  • April 2010 (248)
  • March 2010 (202)
  • February 2010 (576)

Recent Posts

  • Joopk.com Asp.Net Content Management System (CMS) setup and installation on Godaddy Hosting
  • How to have SilverLight on your Linux
  • Simple Web Form in ASP.NET
  • Running Silverlight in PHP – Part II
  • DataBaseConnectivity in Asp.Net with SQL Server

Tags

.NET 2010 about AJAX Application ASP.NET best Business cheap cloud Company Computing Control Create data Dedicated Development Free from help Host hosting India Internet Introduction Linux Microsoft more need Page Part private Server servers service Services Silverlight Site Software Source Tutorial Using Video website Windows

Categories

  • ASP.NET
  • Cloud Hosting
  • Dedicated Servers
  • Linux Web Hosting
  • Microsoft AJAX
  • Microsoft Siverlight
  • Windows Web Hosting

Meta

  • Register
  • Log in
  • Valid XHTML
Powered by WordPress Web Design by SRS Solutions © 2012 Win Web Hosting