C# - How To Output SQL To DIV InnerHTML
Mar 30, 2011
Im trying to output my SQL to a div using the InnerHTML. but I cant get more than one record to show up. How do I make it so that it will out put all of my records to the DIV? On my page I have the DIV contained within a UpdatePanel, but I only ever get 1 row displayed (and yes the query does return more than one row).
string sql = "Select * From Events";
SqlCommand command = new SqlCommand(sql, conn);
command.CommandType = CommandType.Text;
conn.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
divout1.InnerHtml += "Name: " + reader["Name"].ToString() + "<br />" +
"Date: " + reader["Date"].ToString() + "<br />" +
"Location: " + reader["Location"].ToString() + "<br />";
divout.Visible = true;
}
View 5 Replies
Similar Messages:
Apr 18, 2010
First off, suggest better ways if you want rather than patch up this code. I am just starting this project and it is first time I have tried to code a web site so anything you suggest is very much welcomed. I have spent the last 2 and 1/2 days trying to find workable answers to this but none I have found and tried seem to fit. If needed I can email screens shots or code. I am trying to construct a website that will have the same main theme throughout as far as the header, navbars sitemap, and footer go. Naturally the content will vary from page to page. I want to use a single master page and css stylesheet for this main theme and I will change the content format as needed per page because each page may vary somewhat.
However, about 15 of the pages will all use the same format for their content and this format will differ from the rest of the site but the format of the main theme will stay the same. So I am trying to create a nested master page to use to format the just the content area for all these pages while retaining the main theme for the header, etc.. I believe I should use a separate css file with the nested master page to handle the formatting of the content areas for these 15 pages. I have code that looks like it works when viewed in web developer but design view but does not work when viewd through a browser (IE, Chrome, Firefox). So far I have the following done in web developer.
If it helps the code and screen shots follow. Master Page called "Parent.master". For all theme throughout site Nested Master Page called "Lab.master". For the 15 like pages Primary stylesheet file for main theme called "StylesheetNew.css" For site theme Secondary stylesheet file to syle the 15 like formatted pages. It is called Labmaster.css Labs.apsx file to use as first of the 15 like pages.
Finally screens shots from web developer and browser. Sorry try as I might I could not capture screenshots and put them into this post. The problem is that web developer shows all the area (many lines high) with gray background and with the XXX text that I want to allocate for content in the 15 pages. Yet all the browser show is one line of text o a white background followed by the footer. It looks like the LabStyleSheet works in Web Developer but not in a browser.
Parent.master
<%@ Master Language="VB" CodeFile="Parent.master.vb" Inherits="MasterPage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL]">
<html xmlns="[URL]">
<head id="ParentHeader" runat="server">
<title>HX5</title>
<asp:ContentPlaceHolder runat="server" id="headerPlaceHolder" />
<link href="~/StyleSheetNew.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div id="wrapper" >
<div id="Header" >
<table class="hdrtbl1" >
<tr>
<td id="hdrtd1" style="width:175px; height:100px;" >
<img id="logo" alt="Logo" src="../Images/logo.png" style="width: 136px; height: 87px" />
</td>
</tr>
</table >
<table class="hdrtbl2" >
<tr><td id="hdrtbl2td1"><b> Providing Professional Technical, Manangement and Business Solution</b></td></tr>
<tr><td id="hdrtbl2td2"> <b> Services since 2004 </b></td></tr>
<tr> <td id="hdrtbl2td3" align="center" ><img id="rdln" alt="RedLine" style=" height:3px;" src="../Images/RedLine.png" /></td></tr>
<tr><td id="hdrtbl2td4" > <b>Committed to Excellence In All We Do</b></td></tr>
</table>
</div>
<div id="navbardiv">
<ul id="topnav">
<li><a href="../pages/about.aspx" >About Us <img style=" border: none; " src="../Images/arrow-down.gif" /></a>
<!--Subnav Starts Here-->
<span>
<a style="font-weight:lighter; " href="#" >Who We Are </a> |
<a href="#">Locations</a> |
<a href="#">Business Classifications</a> |
<a href="#">Contact Us</a> |
</span>
</li>
<!--Subnav Ends Here-->
<li><a href="../pages/services.aspx">Services <img alt="arrow" style="border: none; " src="../Images/arrow-down.gif" /></a>
<!--Subnav Starts Here-->
<span>
<a style="font-weight:lighter; " href="#" >Capabilities</a> |
</span>
<!--Subnav Ends Here-->
</li>
<li><a href="#">Customers <img style=" border: none; " src="../Images/arrow-down.gif" /></a>
<span>
<a style="font-weight:lighter; " href="#" >Subnav Link</a> |
<a href="#">Customer Locations</a> |
<a href="../pages/labs.aspx">Labs</a> |
</span>
</li>
<li><a href="#">Careers <img style=" border: none; " src="../Images/arrow-down.gif" /></a>
<!--Subnav Starts Here-->
<span>
<a style="font-weight:lighter; " href="#" >Joining the HX5 Team</a> |
<a href="#">Current Opportunities</a> |
</span>
</li>
</ul>
</div>
<div id="subnavbar" >
<!-- <asp:SiteMapPath ID="SiteMapPath" runat="server">
</asp:SiteMapPath> -->
</div>
<div id="topContent" style="border-bottom:solid 1px #191970;">
<table>
<tr><td style="height:30px; width:900px;" >
<asp:ContentPlaceHolder id="TopPlaceHolder" runat="server">
</asp:ContentPlaceHolder>
</td>
</tr>
</table>
</div>
<!-- <div id="mainContent"> -->
<asp:ContentPlaceHolder id="MainPlaceHolder" runat="server" />
<!-- </div> -->
<!-- <div id="lowerContent"> -->
<asp:ContentPlaceHolder id="LowerPlaceHolder" runat="server">
</asp:ContentPlaceHolder>
<!-- </div> -->
<div id="footerContent" style=" height:50px; width:900px; text-align: right; background-color: #ccc; ">
<span style=" font-family: Arial, Helvetica, sans-serif; font-size: xx-small; font-weight: bold; color: #000080; margin: 30px 20px 0px 0px;"> Copyright 2010 HX5, LLC All rights reserved</span></div>
</div>
</form>
</body>
</html>
View 4 Replies
Jan 25, 2011
what I am trying to do is
i have fname,lastname and email
div1.innertext="fname";
div1.innertext+=" ";
div1.innertext+="lname";
div1.innerhtml="environment.newline"; not working
div1.innertext+="
"; not working
div1.innertext +="<br />"; not working
??
How can I insert a new line in thid <div>
??
I am looking to get the o/p like below
fname lastname
email
View 8 Replies
Mar 11, 2010
I have a asp:label that i've set the innerHTML to a string from javascript. How can I now read this string from my code behind?
View 3 Replies
Feb 28, 2011
How come an ASP.Net button "caption" is it's value and a regular html button "caption" comes from the innerHTML.
And why do I not get intellisense for sender.innerHTML in VS?
ASP.Net
Code:
[code]....
View 4 Replies
Aug 2, 2010
In the Page_Load, I dynamically assign a string which contians asp:checkbox to a InnerHtml. But the checkbox does not display on the page after the page loaded.
View 1 Replies
Feb 2, 2011
what disadvantages are there to use inner HTML to populate a div tag consider, all scenarios possible.
View 2 Replies
Mar 10, 2010
i need to pass a div id and convert its innerHtml to pdf document. with helpfull link, sample, code
View 4 Replies
May 5, 2010
My code behind reads from a database and depending on the results depends on the display. It then allows the user to choose one item. However, I want to also give a checkboxlist to allow multiple options.
My function shows (currently only one option available to select at a time)
[code]....
View 2 Replies
Jan 14, 2011
In Aspx
Code:
<div id="Text1" runat=server ></div>
$('#<%= Text1.ClientID %>').html('someText');
In VB
Code:
Protected Sub BtnInboxReply_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnInboxReply.Click
Response.Write(Text1.InnerHtml.Length)
End Sub
I can't get Text1.InnerHtml or Text1.InnerText on server side. When it's changed in client side.
View 4 Replies
Apr 22, 2010
How to Add a DIV dynamicly and set its innerHTML or text if request.QueryString("admin_delete_design") != "" then
View 2 Replies
Apr 20, 2010
I have some data in database.
Data's like <p style="text-align:justify;"> Hyper-V installation,<div class="text">
I want to remove style. I try to replace all but it's to long and all texts are different format.
View 3 Replies
Aug 2, 2010
In the Page_Load, I dynamically assign a string which contains asp:checkbox to a InnerHtml of a <td>. But when the page is loaded, I can not see the checkbox on the page
View 2 Replies
Mar 25, 2010
I'm trying to access the innerHTML of a span tag modified by jQuery using C#. This is my first project shunning the AJAX libs in favor of jQuery, so I'm not sure how I can get the codebehind to recognize the manipulated innerHTML. I've set all the spans I want to tap into with runat="server", but all I pull are the values I've set when the page was designed.
What steps should I be taking to enable communication between the client-side and my codebehind, and am I even using the best practice here?
View 2 Replies
Aug 28, 2010
I had a usercontrol (TextEditor).To get the content of this TextEditor I used the code
string strquestion = Texteditor1.ContentInnerHtml;
. It returns the string
strquestion=<P>Which one is rectangle?</P><P>1 <IMG src="http://localhost:3032/IHSOnline/editorimages/UserImages/35907.JPG" width=150></P><P>2 <IMG src="http://localhost:3032/IHSOnline/editorimages/UserImages/df943.JPG"
width=150></P>
My texteditor will contain both text and image as seen in the string.
Now i want to store it in database and retrieve and display in a gridview.
View 1 Replies
May 20, 2010
I want to set an iframe innerhtml from codebehind, i have an html page, i load that,and set myiframe.innerhtml from code behind, i dont know why its not working . M using VS 2005 / c#.I ve googled it , and what i found is not working, it ld be easy and straight,
View 7 Replies
Oct 31, 2010
I would like to change the innerHTML of a LinkButton programmatically.Example:
[Code]....How can i get ChangeThisValue changed programmatically?
View 5 Replies
Jan 10, 2011
How can I set the InnerHtml of programmatically-created controls? For instance, I want a LinkButton's final output to be something like this:
<a href...(LinkButton code)><span style="position: absolute">Some text</span></a>
View 2 Replies
Mar 4, 2010
I am going to set a couple of span controls to some text. The span controls have ids like,
<span ID="text1" runat="server" />
<span ID="text2" runat="server" />
<span ID="text3" runat="server" />
And now I want to set the innethml to every span control with a while end, like while dr.read I would like to set the ID to the span dynamic, like text & I.innerhtml = "something" I = I + 1 end while but how do a refer to a ID dynamic of a control in the code?
View 1 Replies
Apr 22, 2010
I know I can use a code like this:
[Code]....
To create a DIV in my body but how do I then add innerHTML to this control? Or can I directly add an Label to the newly created control and set tag ones text?
View 1 Replies
Feb 25, 2011
In the below code, "Hello" displayed inside <p> element is getting invisible within a second after clicking button.
So how to display it permanently?
<%@ Page Language="C#" AutoEventWireup="false" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
[Code]....
View 2 Replies
May 7, 2010
I'm Adding Some Linkbutton At Runtime In InnerHtml Of Div. And I Want To Call a Single Method For All The LinkButton With An Argument. My Code Is Below:
protected void Page_Load(object sender, EventArgs e)
{
DivBookList.InnerHtml = "<ul>";
i = 0;
foreach (IFolder f in Client.MailboxManager.Folders)
View 2 Replies
Jan 12, 2010
I have a hidden TextBox control on my page that updates a span tag on the keyup event using jQuery. When the page is posted back to the server, the innerHTML attribute is empty.
How do I get the value that was set during the keyup event?
Client side code:
[code]....
Server side code
[code]....
View 4 Replies
Jul 14, 2010
How to get updated values of fields in form through InnerHTML tag?
View 1 Replies
May 4, 2010
I have a textarea HtmlControl. If I write a paragraph in it, press enter and write another paragraph I can see on the page that I have two paragraphs. But when I submit the form and then try to access the paragraphs using myTextArea.InnerHtml the value that I get is of all the text in one paragraph with out any formatting.
How do I get the text out formatted in html <p> tags?
View 2 Replies