Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to insert text into a mutli-lined textbox from SQL 2005

Posted on 2008-10-29
16
Medium Priority
?
349 Views
Last Modified: 2011-10-19
Hi,

I currently have a web application where users can enter in multi-lined text into SQL 2005.  This part works without a problem.  The part that I am having an issue with is when the data is displayed to the user after it is entered

I have a a datareader located in a datagrid and within their I have a multi-lined textbox to display the data.  The data currently will only show the spaces between each word, but not vbCrLf (enter).  

For Example:  

123 456
789

will show:  123 456 789

I have tried everything in replacing the Environment.NewLine with  "<br>" before sending it to SQL, but still have no luck below is my HTML for the datagrid and Code behind for the submit button

Thank you for all of your help
HTML
 
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                    Width="386px" EnableTheming="True" GridLines="Horizontal" 
                    ShowHeader="False" AllowPaging="True" PageSize="5">
                            <Columns>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        <div style="color:Blue;font-weight:bold">
                                            <asp:Label ID="Label1" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"username") %>'></asp:Label>
                                            &nbsp;<asp:Label ID="Label4" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"dateCreated") %>'></asp:Label>
                                            &nbsp;<asp:Label ID="Label3" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"id") %>' Visible="False"></asp:Label>
                                        </div>
                                        <asp:Repeater ID="Repeater1" runat="server" 
                        DataSource='<%#DataBinder.Eval(Container, "DataItem.InnerVal") %>'>
                                            <ItemTemplate>
                                                <div style="padding-left:20px; padding-top:5px">
                                                    <asp:Label ID="lblAction" runat="server" Text="Action Taken"></asp:Label>
                                                    <asp:Label ID="Label2" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"ActionType").toString.Replace(vbCrLf, "")%>'></asp:Label>
                                                    <br />
                                                    <br />
                                                    <asp:textbox ID="text16" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"IssueNotes").toString.Replace(vbCrLf, " ") %>' 
                            TextMode="MultiLine" Height="133" Width="345"></asp:textbox>
                                                </div>
                                            </ItemTemplate>
                                        </asp:Repeater>
                                        <div style="text-align:right">
                                            <asp:HyperLink ID="link" runat="server" ForeColor="Blue" Target="_blank" 
                                                Font-Names="Arial" Font-Size="X-Small"
                            Font-Italic="True" Font-Bold="true" ToolTip="Click to open">Edit</asp:HyperLink>
                                        </div>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                            <PagerStyle Font-Names="Arial" Font-Size="Small" />
                        </asp:GridView>
 
Code Behind:
 
 Dim CaseID As String = Request.QueryString("id")
        Dim username As String = Session("username")
        Dim Note As String = txtDescr.Text
        Dim actionType As String = "feedback"
        Note = txtDescr.Text.Replace(Environment.NewLine, "<br>")
 
        Dim SqlCon1 As New System.Data.SqlClient.SqlConnection
        Dim sConnSTr1 As String
        sConnSTr1 = "server=tomkat\SQLEXPRESS;uid=CPDuser;pwd=Newpass01;database=CPD_Feedback"
        SqlCon1.ConnectionString = sConnSTr1
        SqlCon1.Open()
        Dim sqlCommand0 As New System.Data.SqlClient.SqlCommand
        sqlCommand0.CommandType = Data.CommandType.StoredProcedure
        sqlCommand0.CommandText = "Insert_CaseNote"
        sqlCommand0.Connection = SqlCon1
        sqlCommand0.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", ID))
        sqlCommand0.Parameters.Add(New System.Data.SqlClient.SqlParameter("@username", username))
        sqlCommand0.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CaseNote", Note))
        sqlCommand0.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ActionType", actionType))
        If File2.HasFile Then
            sqlCommand0.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FileName", File2.FileName))
            sqlCommand0.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FileData", File2.FileBytes))
            sqlCommand0.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FileSize", File2.PostedFile.ContentLength))
            sqlCommand0.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ContentType", File2.PostedFile.ContentType))
 
        End If
        sqlCommand0.ExecuteNonQuery()
        SqlCon1.Close()
        SqlCon1.Open()
        Dim sqlCommand3 As New System.Data.SqlClient.SqlCommand
        sqlCommand3.CommandType = Data.CommandType.StoredProcedure
        sqlCommand3.CommandText = "Select_CaseNotes"
        sqlCommand3.Connection = SqlCon1
        sqlCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CaseID", CaseID))
        Dim adapter As New SqlDataAdapter(sqlCommand3)
        Dim ds As New DataSet()
        adapter.Fill(ds)
        ds.Relations.Add("InnerVal", ds.Tables(0).Columns("ID"), ds.Tables(1).Columns("ID"))
        GridView1.DataSource = ds.Tables(0)
        GridView1.DataBind()
        SqlCon1.Close()
        txtDescr.Text = ""

Open in new window

0
Comment
Question by:thomasm1948
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 6
16 Comments
 
LVL 7

Expert Comment

by:ASPSQLServerCOM
ID: 22833291
could you please paste the generated HTML (browser view source)
0
 

Author Comment

by:thomasm1948
ID: 22833459
Attached is the HTML

Thank you for all of your help
<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="CaseComments.aspx.vb" Inherits="CaseComments" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style44
        {
            width: 414px;
        }
    </style>
 
    
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:Label ID="Label7" runat="server" Text="Case Notes" Font-Bold="True" 
        Font-Names="Arial" Font-Size="Small"></asp:Label>
    
    <table id="gridTable" runat="server" style="width: 100%;">
        <tr>
            <td width="50%">
               
                &nbsp;</td>
            <td id="tdgridcenter00011" class="style44">
                <asp:Label ID="Label18" runat="server" Font-Bold="True" Font-Italic="True" 
                    Font-Names="Arial" Font-Size="X-Small" Text="Part Number:"></asp:Label>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:Label ID="Label19" runat="server" Font-Bold="True" Font-Italic="True" 
                    Font-Names="Arial" Font-Size="X-Small" Text="Model Number:"></asp:Label>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:Label ID="Label20" runat="server" Font-Bold="True" Font-Italic="True" 
                    Font-Names="Arial" Font-Size="X-Small" Text="Revision:"></asp:Label>
                <br />
                <asp:TextBox ID="txtPartNumber" runat="server" Font-Names="Arial" 
                    Font-Size="Small" Height="15px" Width="133px" ReadOnly="True" 
                    ForeColor="#999999"></asp:TextBox>
            &nbsp;<asp:TextBox ID="txtModelNum" runat="server" Font-Names="Arial" 
                    Font-Size="Small" Height="15px" Width="133px" ReadOnly="True" 
                    ForeColor="#999999"></asp:TextBox>
            &nbsp;<asp:TextBox ID="txtRev" runat="server" Font-Names="Arial" Font-Size="Small" 
                    Height="15px" Width="100px" ReadOnly="True" ForeColor="#999999"></asp:TextBox>
            </td>
            <td id="tdGridright0033" width="50%">
                
                &nbsp;</td>
        </tr>
        <tr>
            <td width="50%">
               
                &nbsp;</td>
            <td id="tdgridcenter100" class="style44">
                <asp:Label ID="Label17" runat="server" Font-Bold="True" Font-Italic="True" 
                    Font-Names="Arial" Font-Size="X-Small" Text="Sales Order Number:"></asp:Label>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:Label ID="Label5" runat="server" Font-Bold="True" Font-Italic="True" 
                    Font-Names="Arial" Font-Size="X-Small" Text="Job Number:"></asp:Label>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:Label ID="Label6" runat="server" Font-Bold="True" Font-Italic="True" 
                    Font-Names="Arial" Font-Size="X-Small" Text="Quantity"></asp:Label>
                <br />
                <asp:TextBox ID="txtSalesOrder" runat="server" Font-Names="Arial" 
                    Font-Size="Small" Height="15px" Width="133px" ReadOnly="True" 
                    ForeColor="#999999"></asp:TextBox>
            &nbsp;<asp:TextBox ID="txtJobNumber" runat="server" Font-Names="Arial" 
                    Font-Size="Small" Height="15px" Width="133px" ReadOnly="True" 
                    ForeColor="#999999"></asp:TextBox>
            &nbsp;<asp:TextBox ID="txtQuantity" runat="server" Font-Italic="False" 
                    Font-Names="Arial" Font-Size="Small" Height="15px" Width="100px" 
                    ReadOnly="True" ForeColor="#999999"></asp:TextBox>
            </td>
            <td id="tdGridright20" width="50%">
                
                &nbsp;</td>
        </tr>
        <tr>
            <td width="50%">
               
                &nbsp;</td>
            <td id="tdgridcenter10" class="style44">
                <hr />
            </td>
            <td id="tdGridright30" width="50%">
                
                &nbsp;</td>
        </tr>
        <tr>
            <td width="50%" valign="bottom">
               
                &nbsp;</td>
            <td id="tdgridcenter40" class="style44">
                &nbsp;&nbsp;&nbsp;
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <br />
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                    Width="386px" EnableTheming="True" GridLines="Horizontal" 
                    ShowHeader="False" AllowPaging="True" PageSize="5">
                            <Columns>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        <div style="color:Blue;font-weight:bold">
                                            <asp:Label ID="Label1" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"username") %>'></asp:Label>
                                            &nbsp;<asp:Label ID="Label4" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"dateCreated") %>'></asp:Label>
                                            &nbsp;<asp:Label ID="Label3" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"id") %>' Visible="False"></asp:Label>
                                        </div>
                                        <asp:Repeater ID="Repeater1" runat="server" 
                        DataSource='<%#DataBinder.Eval(Container, "DataItem.InnerVal") %>'>
                                            <ItemTemplate>
                                                <div style="padding-left:20px; padding-top:5px">
                                                    <asp:Label ID="lblAction" runat="server" Text="Action Taken"></asp:Label>
                                                    <asp:Label ID="Label2" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"ActionType").toString.Replace(vbCrLf, "")%>'></asp:Label>
                                                    <br />
                                                    <br />
                                                    <asp:textbox ID="text16" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"IssueNotes").toString.Replace(vbCrLf, " ") %>' 
                            TextMode="MultiLine" Height="133" Width="345"></asp:textbox>
                                                </div>
                                            </ItemTemplate>
                                        </asp:Repeater>
                                        <div style="text-align:right">
                                            <asp:HyperLink ID="link" runat="server" ForeColor="Blue" Target="_blank" 
                                                Font-Names="Arial" Font-Size="X-Small"
                            Font-Italic="True" Font-Bold="true" ToolTip="Click to open">Edit</asp:HyperLink>
                                        </div>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                            <PagerStyle Font-Names="Arial" Font-Size="Small" />
                        </asp:GridView>
                <br />
            </td>
            <td id="tdGridright02" width="50%">
                
                &nbsp;</td>
        </tr>
        <tr>
            <td width="50%">
               
                &nbsp;</td>
            <td id="tdgridcente03" class="style44">
            <hr />
            </td>
            <td id="tdGridright04" width="50%">
                
                &nbsp;</td>
        </tr>
        <tr>
            <td width="50%">
               
                &nbsp;</td>
            <td id="tdgridcenter00044" class="style44">
                <asp:Label ID="Label8" runat="server" Font-Bold="True" Font-Italic="True" 
                Font-Names="Arial" Font-Size="X-Small" 
                Text="Describe the issue/Problem and any action taken:"></asp:Label>
                <br />
                    <asp:TextBox ID="txtDescr" runat="server" Font-Names="Arial" Font-Size="Small" 
                Height="102px" TextMode="MultiLine" Width="398px" 
    style="margin-left: 4px"></asp:TextBox>
            </td>
            <td id="tdGridright1144" width="50%">
                
                &nbsp;</td>
        </tr>
        <tr>
            <td width="50%">
               
                &nbsp;</td>
            <td id="tdgridcenter4455" class="style44">
            <asp:Label ID="Label9" runat="server" Text="Attach File" Font-Bold="True" 
                Font-Italic="True" Font-Names="Arial" Font-Size="XX-Small"></asp:Label>
                <br />
        
                &nbsp;<asp:FileUpload ID="File2" runat="server" />
&nbsp;<asp:Button ID="btnSubmit" runat="server" Height="22px" Text="Submit" />
            
       &nbsp;
            <asp:Button ID="Button1" runat="server" Height="22px" Text="Submit" />
            
            </td>
            <td id="tdGridright111" width="50%">
                
                &nbsp;</td>
        </tr>
        </table>
    <table style="width: 100%;">
    <tr>
        <td>
            &nbsp;
        </td>
        <td>
            &nbsp;
        </td>
        <td>
            &nbsp;
        </td>
    </tr>
    <tr>
        <td>
            &nbsp;
        </td>
        <td>
            &nbsp;
        </td>
        <td>
            &nbsp;
        </td>
    </tr>
</table>
 
</asp:Content>

Open in new window

0
 

Author Comment

by:thomasm1948
ID: 22833485
text16 is where the data is loaded from SQL in the repeater
0
Understanding Web Applications

Without even knowing it, most of us are using web applications on a daily basis. Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We often confuse these web applications tools for websites.  So, what is the difference?

 
LVL 7

Expert Comment

by:ASPSQLServerCOM
ID: 22833570
hi, please paste the browser HTML and not ASPX file code
I mean to say, in internet explorer when you are viewing the page at that time the text is not getting wrapped correct, so please paste the internet explorer view source HTML
0
 

Author Comment

by:thomasm1948
ID: 22833895
Attached are two word document with the outputs from the HTML site

Before-Pressing-Submit.doc
After-Pressing-Submit.doc
0
 

Author Comment

by:thomasm1948
ID: 22833972
Attached is the text file for the source code on the HTML Page
Source.txt
0
 
LVL 7

Expert Comment

by:ASPSQLServerCOM
ID: 22834535
http://forums.codecharge.com/posts.php?post_id=46647&post_rerlyPage=2


The problem is, you cannot insert the line breaks in VBScript, I know because I have been messing with the problem for awhile and gave up on it after awhile after trying everything. I was told to come back and fix the problem and finally I was able to, but not through vbscript, through javascript. You need to create a javascript function to insert the line break, and then run that function from the vbscript. So in javascript lets say you have a textarea box named TextareaText. You could then run the following javascript to grab the current value of the textarea and append the line break to the end:

document.all('TextareaText').value = document.all('TextareaText').value + '\n';

If you want to run this from vbscript put it in a function and just call the function name from within vbscript to execute a line break, for instance if the javascript function is named TextareaLineBreak and you wanted to insert a line break after the current text in the textarea box, then insert new text you could simply put the following in your vbscript:

document.body.all("TextareaText").value = TextareaLineBreak() + 'this text will appear on a new line'

I just tested this and it works fine
0
 
LVL 7

Expert Comment

by:ASPSQLServerCOM
ID: 22834546
load the normal text in text area with BR tag and on page load call javascript which replace the BR tag with \n and it will solve yopur problem
0
 

Author Comment

by:thomasm1948
ID: 22834898
Can you post an example based on what I currently have
0
 

Author Comment

by:thomasm1948
ID: 22834914
Also, I am using VB.NET ASP.NET 2.0
0
 
LVL 7

Accepted Solution

by:
ASPSQLServerCOM earned 1500 total points
ID: 22835019
click on Button and see the text area

ssame way you display the web page and write one javascript function which will get called on the form load where in it will replace the <BR/> tag with \n tag, and it will work for you

 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>
 
</title>
    <style type="text/css">
        .style44
        {
            width: 414px;
        }
    </style>
 
    
 
    
    <style type="text/css">
        .style1
        {
            height: 277px;
        }
        .style2
        {
            height: 46px;
        }
                  
    </style>
    
<style type="text/css">
	.ctl00_Menu1_0 { background-color:white;visibility:hidden;display:none;position:absolute;left:0px;top:0px; }
	.ctl00_Menu1_1 { color:Blue;font-family:Arial;font-size:Small;text-decoration:none; }
	.ctl00_Menu1_2 { color:Blue;font-family:Arial;font-size:Small;height:16px;width:321px; }
	.ctl00_Menu1_3 { color:White;font-weight:bold; }
	.ctl00_Menu1_4 { color:White;background-color:#9999FF;font-weight:bold; }
	.ctl00_Menu1_5 { color:White; }
	.ctl00_Menu1_6 { color:White;background-color:#3366FF; }
 
</style></head>
<body>
    <form name="aspnetForm" method="post" action="CaseComments.aspx?caseid=8" id="aspnetForm" enctype="multipart/form-data">
<div>
    &nbsp;&nbsp;
</div>
 
<script type="text/javascript">
//<![CDATA[
var theForm = document.forms['aspnetForm'];
if (!theForm) {
    theForm = document.aspnetForm;
}
function __doPostBack(eventTarget, eventArgument) {
    if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
        theForm.__EVENTTARGET.value = eventTarget;
        theForm.__EVENTARGUMENT.value = eventArgument;
        theForm.submit();
    }
}
function linebreak(obj)
{
document.all('Address').value = document.all('Address').value.replace(/<br\/>/g,'\n');
}
 
//]]>
</script>
 
 
<script src="/CPDSupplierCustomerFeedback/WebResource.axd?d=vYCr00mLXWu2xzpfvLv8iQ2&amp;t=633485587467187500" type="text/javascript"></script>
 
 
<script src="/CPDSupplierCustomerFeedback/WebResource.axd?d=CPHdM9hGg3b2OFmc70a5sw2&amp;t=633485587467187500" type="text/javascript"></script>
    
    <table style="width: 100%; height: 346px;">
        <tr>
            <td class="style2" align="left" colspan="0" valign="middle">
                &nbsp;</td>
        </tr>
        <tr style="border: thin solid #C0C0C0; background-color: #C0C0C0">
            <td id="tLeftSearchBar" style="border: thin solid #C0C0C0;" colspan="0">
                <a href="#ctl00_Menu1_SkipLink"><img alt="Skip Navigation Links" src="/CPDSupplierCustomerFeedback/WebResource.axd?d=aWM-9hTLw82RrXtxjYdmmA2&amp;t=633485587467187500" width="0" height="0" style="border-width:0px;" /></a><table id="ctl00_Menu1" class="ctl00_Menu1_2" cellpadding="0" cellspacing="0" border="0">
 
</table><a id="ctl00_Menu1_SkipLink"></a>
            </td>
            <td id="tdRightSearchBar" align="right" 
                style="border: thin solid #C0C0C0;" valign="bottom" width="20%">
                <a id="ctl00_linkLogout" href="javascript:__doPostBack('ctl00$linkLogout','')" style="font-family:Arial;font-size:Small;">Logout</a>
            </td>
        </tr>
        <tr>
            <td id="tdContent" class="style1" colspan="2" valign="top">
                
    <span id="ctl00_ContentPlaceHolder1_Label7" style="font-family:Arial;font-size:Small;font-weight:bold;">Case Notes</span>
    
    <table id="ctl00_ContentPlaceHolder1_gridTable" style="width: 100%;">
	
 
	<tr>
		<td width="50%" valign="bottom">
               </td>
		<td id="ctl00_ContentPlaceHolder1_tdgridcenter40" class="style44">
                &nbsp;&nbsp;&nbsp;
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <br />
            <div>
			<table cellspacing="0" rules="rows" border="1" id="ctl00_ContentPlaceHolder1_GridView1" style="width:386px;border-collapse:collapse;">
				<tr>
					<td>
                                  
                                        
                                                <div style="padding-left:20px; padding-top:5px">
                                                    <span id="ctl00_ContentPlaceHolder1_GridView1_ctl02_Repeater1_ctl00_lblAction">Action Taken</span>
                                                    <span id="ctl00_ContentPlaceHolder1_GridView1_ctl02_Repeater1_ctl00_Label2">feedback</span>
                                                    <br />
                                                    <br />
                                                    <textarea name="ctl00$ContentPlaceHolder1$GridView1$ctl02$Repeater1$ctl00$text16" rows="2" cols="20" id="ctl00_ContentPlaceHolder1_GridView1_ctl02_Repeater1_ctl00_text16" style="height:133px;width:345px;">test1\n test2 test3</textarea>
                                                <textarea name="Address" rows="5" cols="35">test1 <br/> test2 <br/> test3</textarea> 
                                                </div>
                                            
                                        <div style="text-align:right">
                                            <a id="ctl00_ContentPlaceHolder1_GridView1_ctl02_link" title="Click to open" target="_blank" style="color:Blue;font-family:Arial;font-size:X-Small;font-weight:bold;font-style:italic;"></a>
                                        </div>
                                    </td>
				</tr>
			</table>
		</div>
                <br />
            </td>
		<td id="ctl00_ContentPlaceHolder1_tdGridright02" width="50%">
                
                &nbsp;</td>
	</tr>
 
	<tr>
		<td width="50%">
               
                &nbsp;</td>
		<td id="ctl00_ContentPlaceHolder1_tdgridcenter4455" class="style44">
           
            <input type="button" name="button1" value="button" onclick="javascript:linebreak(this);" title="Button1"/>
            </td>
		<td id="ctl00_ContentPlaceHolder1_tdGridright111" width="50%">
                
                &nbsp;</td>
	</tr>
</table>
 
 
            </td>
        </tr>
        <tr>
            <td colspan="2" style="background-color: #C0C0C0">
                &nbsp;</td>
        </tr>
    </table>
    
    
 
 
<script type="text/javascript">
//<![CDATA[
var ctl00_Menu1_Data = new Object();
ctl00_Menu1_Data.disappearAfter = 500;
ctl00_Menu1_Data.horizontalOffset = 0;
ctl00_Menu1_Data.verticalOffset = 0;
ctl00_Menu1_Data.hoverClass = 'ctl00_Menu1_6';
ctl00_Menu1_Data.hoverHyperLinkClass = 'ctl00_Menu1_5';
ctl00_Menu1_Data.staticHoverClass = 'ctl00_Menu1_4';
ctl00_Menu1_Data.staticHoverHyperLinkClass = 'ctl00_Menu1_3';
//]]>
</script>
</form>
</body>
</html>

Open in new window

0
 

Author Comment

by:thomasm1948
ID: 22837102
OK, I figured it out.   The following is my adjustment to my code:

I am not sure why this worked exactly being that I am replacing cbCrlf with cbCrLf.  Logically this does not work for me, but at the same time I couldn't get anything else to work.

I thank you all for your help and I hope the answer that I put here help others and maybe someone can explain it to me
<asp:textbox ID="text16" runat="server" 
                            Text='<%# DataBinder.Eval(Container.DataItem,"IssueNotes").toString.Replace(vbCrLf, vbCrLf) %>' 
                            TextMode="MultiLine" Height="133" Width="345"></asp:textbox>

Open in new window

0
 

Author Comment

by:thomasm1948
ID: 22837108
I will keep this case open just for one more day and see if I get any responses and then award the points
0
 
LVL 7

Expert Comment

by:ASPSQLServerCOM
ID: 22841658
did you tried my solution
0
 

Author Comment

by:thomasm1948
ID: 22842018
I couldn't get it to work right.  I am using master pages and so forth; so I figure that I did not do it incorrectly.
0
 

Author Closing Comment

by:thomasm1948
ID: 31511278
I think that this solution will work in most instances, but in this instance it did not workout.  Thank you for all of your help as it is a great value
0

Featured Post

Create CentOS 7 Newton Packstack Running Keystone

A bug was filed against RDO for the installation of Keystone v3. This guide is designed to walk you through the configuration for using Keystone v3 with Packstack. You will accomplish this using various repos and the Answers file.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question