How to format string in gridview in c#

Question

I am fetching Two Columns from database, one column has data type as varbinary. I am converting the varbinary column to byte[] and then to string. Code is working for console application and keeping the string format. But when i am using the same code in Web Application and displaying the data in GridView, it losing the format. For Ex:

Hello

World

will be displaying as Hello World in Grid View. Here is my code :

    SqlConnection con = new SqlConnection("Data Source=.; Initial Catalog=legal; Integrated Security=True");
    SqlCommand cmd = new SqlCommand("usp_output_repayment  @id=1", con);

    con.Open();
    SqlDataReader dr = cmd.ExecuteReader();
    DataTable dt = new DataTable();
    dt.Columns.Add("Category");
    dt.Columns.Add("Description");

    while (dr.Read())
    {
    DataRow dr1 = dt.NewRow();

        dr1["Category"] = dr[0];
        dr1["Description"] = System.Text.ASCIIEncoding.ASCII.GetString((byte[])dr[1]).Normalize();
        dt.Rows.Add(dr1);


    }

    GridView1.DataSource = dt;
    GridView1.DataBind();

What are you targetting: Winforms, WPF, ASP..? You should always TAG your questions correctly so one can see it on the questions page! - Also note that DataGridView != GridView — TaW
– TaW, Commented Aug 16, 2018 at 20:08
@TaW should ASP.NET since OP says i am using the same code in Web Application and displaying the data in GridView. Moreover there is no DataBind() in Winform — Rahul
– Rahul, Commented Aug 16, 2018 at 20:10
@Rahul: This information should be in a Tag and not hidden in the question! — TaW
– TaW, Commented Aug 16, 2018 at 20:10

Arslan Ali · Accepted Answer · 2018-08-16 20:49:40Z

1

When you are working on the asp.net side then you should use DataBound inside the gridview as well as setting AutoGenerateColumns="false"

Now it's my main point of view if you are getting description of whatever format as well then use HtmlEncode="false" for your column that you used

Few Code of GridView,that you will have to utilize as such format described.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
        <Columns>
            <asp:BoundField DataField="Description" HeaderText="Description" HtmlEncode="false" />
        </Columns>
    </asp:GridView>

Error format that I could faced using HtmlEncode="true" or removing it

Tested and got well using HtmlEncode="false" upon following result

edited Aug 16, 2018 at 20:49

answered Aug 16, 2018 at 20:41

Arslan Ali

4604 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ankit Tyagi Over a year ago

Hi Ali, thanks for the answer. did you make any changes in your code as well?

Arslan Ali Over a year ago

Don't add columns through code make a list or what you think is better but solution provided as well for your problem using HtmlEncode

Ankit Tyagi Over a year ago

it worked for me, With you code and little modification in code as as well, Thanks. :)

Collectives™ on Stack Overflow

How to format string in gridview in c#

Hello

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Hello

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related