Databases
StackOverflow2013
Postsdbo
POHow to Display the Data have more than two spaces in Repeater?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to Display the Data have more than two spaces in Repeater?
    primarykey
    data
    text
    <p>I got the data from database into my dataset is <img src="https://i.stack.imgur.com/0cmoD.png" alt="enter image description here"> and then i bind into my repeater control but its is been showing like "Prince Antony G". It eliminated the Spaces.<br> and also i export those data into excel, In excel also the spaces were removed.<br> I need the show data whatever in my Database. Any idea to solve this problem.</p> <p><strong>In stack overflow Question box also remove more spaces in between two words</strong></p> <p>My Excel Coding:</p> <pre><code> DataTable dt = new DataTable("Report"); DataRow dr; dt.Columns.Add("Name"); for (int i = 0; i &lt; dt_Status.Rows.Count; i++) { dr = dt.NewRow(); dr["Name"] ="&lt;pre&gt;"+ dt_Status.Rows[i]["NAME"].ToString() +"&lt;/pre&gt;"; dt.Rows.Add(dr); } HttpResponse response = HttpContext.Current.Response; // first let's clean up the response.object response.Clear(); response.Charset = ""; // set the response mime type for excel response.ContentType = "application/vnd.ms-excel"; response.AddHeader("Content-Disposition", "attachment;filename=Report.xls"); // create a string writer using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { // instantiate a datagrid DataGrid dg = new DataGrid(); dg.DataSource = dt; dg.DataBind(); dg.RenderControl(htw); response.Write(sw.ToString()); response.End(); } } </code></pre> <p>After updating my code i got the excel output as:</p> <p><img src="https://i.stack.imgur.com/8b47P.jpg" alt="enter image description here"></p> <p>I need to display in a single cell.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPrince Antony G
    1. USPrince Antony G
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to Display the Data have more than two spaces in Repeater?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. CO@Star:Why you remove the last line?
      singulars
      1. POHow to Display the Data have more than two spaces in Repeater?
      1. USPrince Antony G
    2. COi didn't. you can see older versions of you Q when you edit it
      singulars
      1. POHow to Display the Data have more than two spaces in Repeater?
      1. USStar
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload