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

 

May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Archives

  • May 2012 (45)
  • April 2012 (81)
  • March 2012 (82)
  • February 2012 (79)
  • 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

  • 02 – Custom CMS In Asp.Net 4 – Preparing Our Database
  • Mr Percival Live Performance at Microsoft Remix 2011, Sydney
  • Using a Security Token Service with an ASP.NET Application
  • PlayBits – Silverlight Game Engine
  • asp 10 add menu control and sitemap datasource

Tags

.NET 2010 about AJAX Application Applications ASP.NET best Business cheap cloud Company Computing Control Create data Dedicated Development Free from help Host hosting India 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