Storing data which in the form of a list to database.

[udaykatakam]

Can we store data which is in the form of a list(Bulleted list or Numbered list) to the database as is with out wrapping the text? If we cannot then what is the best way to store a list to database?

-UdayKiran

[Mycroft Holmes]

Wow, this question is so wrong in so many ways. Databases store structured data (generally) A list (complete) is unstructured data Text wrap is not a concept a database has. The way to go Create a table with 3 fields ID int identity(1,1) Sequence int ListText varchar(a number > the possible text length) Into this you store the bullet number in Sequence and the text in ListText When you retrieve the data you order it by Sequence and it is up to you to display the text in the control you want.

Never underestimate the power of human stupidity RAH

[udaykatakam]

Yeah you are right thanks for your reply may be I did not frame my question right. Lets say my data is as follows.

Col1

Col2

Col3

1

Line1 Line2 Line3

xxx

2

ABC

XYZ

This is 2 rows of data and since database stores structured data first row would be stored as: 1 Line1Line2Line3 xxx So my question is what method should I adapt so that when I pull the data from the database I would know that the data in Col2 and Row1 is in the form of: Line1 Line2 Line3 I hope now I made my self clear.

-UdayKiran

[Mycroft Holmes]

I have the nasty suspicion you are working with a lousy data structure, I am assuming that Line1,Line2,Line3 should be stored as seperate pieces of data, in a related table. I do not know enough about your structure or what you are trying to acheive to give any useful feedback.

[udaykatakam]

Alright Thanks for your time. Is there anybody who could help me with my problem.

-UdayKiran