TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Nepethya Rana
NA
335
151.3k
how to break line in data while inserting to a table
Aug 30 2017 12:15 PM
we have data in one of a table which has
tag to break line while rendering the data in web.
for example:
Day | ToDoList
------------ ----------------------------------
Sunday | Wake up at 8am
Visit Parents
------------ ----------------------------------
Monday | Wake up at 7am
Go to Work
------------ ----------------------------------
I need to get the data from that table and need to load in another table for another application, which also render
the data in browser. But this application export this data in excel file as well.
I do not want
tag between data in my new table and excel file but i do want line break.
Day | ToDoList
------------ ----------------------------------
Sunday | Wake up at 8am
| Visit Parents
------------ ----------------------------------
Monday | Wake up at 7am
| Go to Work
------------ ----------------------------------
How do i achieve this.
This is what i have tried but it did not work.
#1
If Not String.IsNullOrWhiteSpace(row("ToDoList").ToString) Then
cmd.Parameters.AddWithValue("@pToDoList", (row("ToDoList").ToString).Replace("
", vbCrLf))
Else
#2
If Not String.IsNullOrWhiteSpace(row("ToDoList").ToString) Then
cmd.Parameters.AddWithValue("@pToDoList", (row("ToDoList").ToString).Replace("
", Environment.NewLine))
Else
#3
If Not String.IsNullOrWhiteSpace(row("ToDoList").ToString) Then
cmd.Parameters.AddWithValue("@pToDoList", (row("ToDoList").ToString).Replace("
", "+Char(13)+char(10)"))
Else
Reply
Answers (
1
)
How to get dropdownlist value with out using post back
create textfield with different border color.