Assigning multiline text to datagrid

[PerumalSamy]

Hi,

I have multiline textbox in which i am getting suggestions from user and storing in MS ACCESS table.

While i displaying in datagrid, the text is not coming as multiline. Instead it was binding as continuous line.

ex: input
test1
test2
test3

in datagrid it is displaying as test1 test2 test3

any idea to resolve this.

[shweta123]

Hi,

My guess is that you should check the max length for the multiline textbox.
If it's MaxLenght is already greater than the input ,it will show you it in the same line instead of multiple lines.

[gomzi]

Hi,

I have multiline textbox in which i am getting suggestions from user and storing in MS ACCESS table.

While i displaying in datagrid, the text is not coming as multiline. Instead it was binding as continuous line.

ex: input
test1
test2
test3

in datagrid it is displaying as test1 test2 test3

any idea to resolve this.

If you want to display the output on different lines (i.e. same as input) in a datagrid, then you will have to use a literal tag .
place the literal inside the template field and bind the output from the db to the literal tag.
Also, see to it that before binding the output to the literal tag, you convert the line breaks to <br/>,
i.e. replace vbCrLf in the string that you are binding to <br/>

[PerumalSamy]

Thanks Gomzi,

How can i place litreal tag in template column. I mean where the literal tag is and how can i write codings to convert the line breaks to <br/>

[gomzi]

Thanks Gomzi,

How can i place litreal tag in template column. I mean where the literal tag is and how can i write codings to convert the line breaks to <br/>

Try this,

       <asp:GridView ID="GridView1" runat="server">
            <Columns>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:Literal ID="litsomething" runat="Server"></asp:Literal>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
 

IN CODE BEHIND,
In page load or whereever you are binding the dataset to a datagrid, run a loop to replace the vbCrLf to <br/> for that column before binding.
THEN,

 
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
        If e.Row.RowType = DataControlRowType.DataRow Then
            CType(e.Row.FindControl("litsomething"), Literal).Text = e.Row.DataItem("yourcolumnname")
        End If
    End Sub
 

[PerumalSamy]

Hi Gomzi,

sorry for disturbing you.

still i am not clear. i am doing program in asp.net using vb coding.

could you please explain in detail.

[gomzi]

Hi Gomzi,

sorry for disturbing you.

still i am not clear. i am doing program in asp.net using vb coding.

could you please explain in detail.

Did you try out the code that i posted last time?
If yes, are you getting any output? or any errors?

[PerumalSamy]

Yes. your coding is working properly.

There is no error in it.

But i not got solution for my question.

I need to display multiline content as such. For Ex: if there is 10 lines in database means i need to display as such.But your coding is not helpful for me.

Because it is displaying the content as a single line. It is not considering more than one space and even the next line.

I need to display the following sample coding in datagrid as such.

This is for testing
multiline
option display in
datagrid
<blank spaces>using asp.net

any idea.

[gomzi]

Yes. your coding is working properly.

There is no error in it.

But i not got solution for my question.

I need to display multiline content as such. For Ex: if there is 10 lines in database means i need to display as such.But your coding is not helpful for me.

Because it is displaying the content as a single line. It is not considering more than one space and even the next line.

I need to display the following sample coding in datagrid as such.

This is for testing
multiline
option display in
datagrid
<blank spaces>using asp.net

any idea.

Hope you are changing the line feeds from vbCrLf to <br/> .

If you done that too, then I guess posting your code might be helpful in solving the problem.

[WebGuru]

Problem resolved as the description in the blog
http://eblog.lichao.net/2007/05/21/p...ing/dotnet/59/