Solved

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

Posted on 2008-10-29
16
315 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
  • 10
  • 6
16 Comments
 
LVL 7

Expert Comment

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

Author Comment

by:thomasm1948
Comment Utility
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
Comment Utility
text16 is where the data is loaded from SQL in the repeater
0
 
LVL 7

Expert Comment

by:ASPSQLServerCOM
Comment Utility
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
Comment Utility
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
Comment Utility
Attached is the text file for the source code on the HTML Page
Source.txt
0
 
LVL 7

Expert Comment

by:ASPSQLServerCOM
Comment Utility
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
Comment Utility
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:thomasm1948
Comment Utility
Can you post an example based on what I currently have
0
 

Author Comment

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

Accepted Solution

by:
ASPSQLServerCOM earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
did you tried my solution
0
 

Author Comment

by:thomasm1948
Comment Utility
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
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

A publishing tool, a Version Control System, or a Collaboration Platform! These can be some of the defining words for the two very famous web-hosting Git repositories: Bitbucket and Github. Git is widely used amongst the programmers and developers f…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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 custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now