How to display information in a custom format using one Textbox and a Literal or Label control

Question

Hi,

Is there a way to display database column values in a label, exactly the way it looked in a textbox in the previous page?

What I mean is, if I insert data into database, and in the textbox where the data was typed, the data will be stored in DB and in the next page, the information is displayed as it was inserted.

example:

I want to insert details as below:

Name: My Inc.

Account: 123456

Account Type: Newbie

Station: Media Team

My Textbox TextMode is set to MultiLine

In the above details, you can see that each data is typed on a different row. The data is then stored in the database. But when it is displayed in a label,

it shows like this:

Name: My Inc.Account: 123456Account Type: NewbieStation: Media Team

How can I make it to display as below, with the use of one asp textbox and one Literal or label control?

Name: My Inc.

Account: 123456

Account Type: Newbie

Station: Media Team

I want to know if it is possible with one Textbox and one Literal or Label control, without having to use 4 Textboxes and 4 Literal or Label controls

private void DetailsDisplay()
        {
            try
            {
                using (SqlConnection con = new SqlConnection())
                {
                    con.ConnectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
                    using (SqlCommand cmd = new SqlCommand("SELECT Details FROM TableRecord WHERE CreatedBy=@CreatedBy", con))
                    {
                        cmd.Parameters.AddWithValue("@CreatedBy", createby.Text);
                        con.Open();
                        SqlDataReader dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            DetailLiteral.Text = dr["details"].ToString();
                        }
                        con.Close();
                    }
                }
            }
            catch (SqlException ex)
            {
                string msg = "Error:";
                msg += ex.Message;
                throw new Exception(msg);
            }
        }

Answer

I want to know if it is possible with one Textbox and one Literal or Label control, without having to use 4 Textboxes and 4 Literal or Label controls

The design is possible if the data (record) ends with a newline character. Basically the user presses enter. The enter key adds a newline character ( ) within the text entered by the user. In order to display a new line in HTML we need to converting the new line characters to an HTML
. Also set the literal's Mode property to "PassThrough".

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebForms.Basic.Default" %>

Code behind

namespace WebForms.Basic
{
    public partial class Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Page.IsPostBack)
            {
                string Html = DetailTxt.Text.Replace("
", "
");
                DetailLiteral.Text = Html;
            }
        }
    }
}

However, I do not recommend this approach because it opens the page for cross site scripting attacks . Also, it is difficult to get a user to press the enter key or enter a specific format like "text: text".

Answer

Well, I don't often use the so called DetailsView control.

However, that control is made for your question.

So, say this markup:

And code behind is this:

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                LoadMyView();
        }

        void LoadMyView()
        {
            string strSQL =
                @"SELECT FirstName, LastName, City, HotelName, Description
                FROM tblHotelsA WHERE ID = 97";
            DetailsView1.DataSource = General.MyRst(strSQL);
            DetailsView1.DataBind();
        }

And the output is now this:

User's image

So, you can consider using the DetailsView control.

Another approach is to say use a repeater, but you have to "transform" the table columns into the first row in the table - this would require code, and the DetailsView does this transform for you.

Share via

How to display information in a custom format using one Textbox and a Literal or Label control

2 answers

Your answer