New Line in GridView cell

Abby

Hi. I am working on a school project and I want a new line in a cell. I tried using
, \n, and Environment.NewLine but nothing works.

I have my grid code in a class:

public DataTable quoteorder(order ord, int index) //show in grid
        {
            DataTable table = new DataTable();
            table.Columns.Add("Qty. (pieces)");
            table.Columns.Add("Qty. (kilos)");
            table.Columns.Add("Description");
            table.Columns.Add("Print");
            table.Columns.Add("Print Color");
            table.Columns.Add("Hole");
            table.Columns.Add("Price");

            int x = 0;
            //String num = "";
            while (x < index)
            {
                //num = sale.getStockID(x);

                DataRow row = table.NewRow();
                row["Qty. (pieces)"] = ord.getQtypcs2(x);
                row["Qty. (kilos)"] = ord.getQtykgs2(x);
                row["Description"] = ord.getProdtype2(x);
                row["Print"] = ord.getPrint2(x) +" - " + ord.getPrint12(x);
                row["Print Color"] = ord.getPcolor2(x);
                row["Hole"] = ord.getHoles2(x) + " - " + ord.getHoles12(x);
                row["Price"] = ord.getPrice2(x);
                table.Rows.Add(row);

                x++;
            }

            return table;

        }

Instead of having 7 columns, I want the data in the follwing columns:
            table.Columns.Add("Print");
            table.Columns.Add("Print Color");
            table.Columns.Add("Hole");
            table.Columns.Add("Price");

under the Description column. That's why I need to have a new line like this:

row["Description"] = ord.getProdtype2(x)+ NEW LINE +ord.getPrint2(x) +" - " + ord.getPrint12(x);

but I can't make
work. If I put
and run my program, it displays "
" in the grid.

The grid is called in the pageload using this code:
        order.DataSource = ord.quoteorder(ord, index);
        order.DataBind();

Can anyone help me on this?

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Parveen Siwach10y ago
Use RowDataBound event to add/update style like: New Line,

protected void gvTest_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string finalString = "Parveen
Siwach";
e.Row.Cells[0].Text = finalString;
}
}

Thanks,
Rosie R13y ago
Use Template Field. The GridView smart tag shows Edit columns---> then add a new column where you want your add the new lines, set this column as a template field.

Template field allows you to set the data with the format that you need, you can add labels, text boxes or any other toolbox control, you can alternatively add a label and then press enter to add new line and add another label

Then in the smart tag of each label, select edit data bindings and use your own data to bind the labels.

This is the complete tutorial:
http://www.asp.net/web-forms/tutorials/data-access/custom-formatting/using-templatefields-in-the-detailsview-control-cs
sam smr17y ago
Try this, this will work ...

//In ur html code.

//In ur c# code use
to denote line change. for ex :

string str = "Whats up?
How u doin?" ;
Abby18y ago
I am using a gridview and i am trying to figure out how to create a new line inside a gridview cell.
jarizzard18y ago
Instead of that, I think it is easy to use DataGridView or GridView. You can put the rows and columns as you like and you can also customize it. I suggest to do that base on my assumption and i don't know what is your purpose. So if i wrong, sorry yeah...
Abby18y ago
thanks for your help. i think that the 2nd solution you gave should've work.. i was surprised that it didn't work.

i think the tutorial is for the desktop application not for the web application (ASP.net)
Dave18y ago
The only thing that I can think of that might help is to make the relevant column in the DataGridView a DataGridViewTextBoxColumn.

I've never actually tried it myself, but a quick Google search turned up this tutorial.
Abby18y ago
it showed the same result as the first one. i also tried using \n, Environment.NewLine and
and it didn't create a new line.
Dave18y ago
Try building the string first:

string cellContent = ord.getProdtype2(x) + "\r\n" + ord.getPrint2(x) + " - " + ord.getPrint12(x);
row["Description"] = cellContent;

Also, note I used the escape character for the carriage return, rather than the form feed (which I previously suggested). The combination of carriage return followed by new line should work.
Abby18y ago
it didn't work. instead of having a new line, it just added a space.
Dave18y ago
I am not sure whether this will work, but try \f\n (escape character for form feed followed by line feed).

This works for me when I want to add a new line to text in a textbox.