How To Deal With Html In Sql When Displaying Part Of The Field In A Gridview
Nov 30, 2010
I'm working on a pretty basic little site that has content that is populated from a sql database. It's important to know that the data in sql includes some html (bolds, italics, ordered lists,etc). The problem I'm running into, involves the search results. On the search results page, I display the results from a sql query in a gridview. The sql query only returns the first 200 characters of the "Description" field, and then there is a link to click if the user wants to read the full description. The problem I'm running into is when the gridview tries to format the data that has an opening html tag, but no closing html tag (becasue the closing tag is over the 200 character limit.
I want to show elements only to x% of the visitors to my page. Considering low traffic - is Random out of x% is enough in your opinion? or is it good only for high taffic?
I have a gridview with 1 field that is setup to display my clients content from the DB. Within their console, i have setup to allow them to enter that fields data with HTMLEditor.The field is setup with HTMLEncode = true but anything done to the text is being displayed as actual html code on the site, so all the html tags are shown and so on. Nothing has changed on the site now for about 2 months( with the actual .aspx pages ) they are only allowed to update the content. Can anyone tell me what i can check or change to insure that the content is displayed correctly to the browser?here is the aspx code for that field:
One of the fields in a table stores a long article. I just want to extract the beginnig part of it; could be any portion of it, like first one or two or three paragraphs. The vb code shows below:
Imports System.Data.SqlClient
Partial Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Try
[Code]....
I really don't want the whole article displaying in the literalBrief. A few paragraphs from that article would be good enough. Is it possible to achieve that? At SQL level, or in VB coding, something like substring function?
how one would retrive a value stored among several values in a single database field?
For example, the MS Customize CreateUserWizard walkthrough [URL] adds the ability to save the users preference for subscribing to a newsletter and allowing their info to be shared as 1 value in the comment column of the membership database. The result ofaspnet_Membership.Comment is Subscribe=TRUE&ShareInfo=FALSE.
My question is if Subscribe=TRUE&ShareInfo=FALSE is in one field of the database, how would you retrieve just the Subscribe=TRUE value from the field and use it to send a newsletter to the proper users while ignoring the ShareInfo=FALSE value?
I want to load part of a html-file (content.htm) in my project into an iframe in my main page (main.aspx).
Also, I want that content to take on the css, javascripts and filepath of the main page.Is this even possible?
It seems iframe is almost a separate browser, and no settings from the main page will affect it. CSS does not work, nor does the filepaths since the content.html is located in a subfolder.
My website is made up of .aspx pages.On some pages, an email gets programmatically sent, and I find it most convenient to have.html email templates (which I can edit in Visual Studio) which I load and manipulate programmatically, and then send as the body of an email. The html files are never displayed to users on the site.At the moment, I store these emails in an Email subdirectory of App_LocalResources, as this seemed like the logical place to put them.
But whenever I update an email on my IIS 6 server, then the IIS server shuts down and restarts, stating: Shutdown Message: Change Notification for critical directories. App_LocalResources dir change or directory rename HostingEnvironment initiated shutdown Change Notification for critical directories. App_LocalResources dir change or directory rename HostingEnvironment caused shutdown.
I don't want to restart my webserver every time (and lose session information) any time I change one of my email templates.
So where is the best suggested location for storing these .html files, as part of the project?
The following seems reasonable, but it returns an error:
<asp:Repeater ID="RepeaterF" runat="server" DataSourceID="DSF" > <ItemTemplate> <% If Eval("Item_Batch") = 0 Then %><tr><td></td><td colspan="2"></td><td></td></tr><% Else %>........
Error: "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."
I am finding it difficult to accept that the whole Repeater approach has any benefits over just creating a loop in code, iterating through a recordset, and building a html table into a variable, then dumping it to the page. This repeater is spawning pages of code and objects, and surely this is all using up server resources.
Error : Could not find a part of the path 'C:Images2.jpg'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:Images2.jpg'.
Source Error:
Line 86: pdfDoc.Open(); Line 87: Line 88: htmlparser.Parse(sr); Line 89: Line 90: pdfDoc.Close();
I'm building an HTML5 application (with ASP.NET back-end) and i want to develop it in such a way that i can run it locally with all my resources (such js and css) not minified (so i can debug it easily). However when i build the final version i want merge and minify the resources. At the same time i want to create several versions of the app targeting different platforms (iPhone, iPad, desktop, etc) by adding appropriate css.
I thought that the final output should be a set of html files (so the get cached nicely). I could use ASPX and just control the output by a query string parameter, but i don't really want to have the form tag on my page.
So the questions are:
What are the pros and cons of using static html pages generated from a template versus a dynamic ASPX page? (apart from being able to run on any web server) If ASPX approach good enough then how can i get rid of the form tag that's required by ASP.NET?
UDPATE
Another factor in favor of static html pages is the fact that the files are served instantly, whereas ASPX may take awhile to load if the app has recycled.
We have several asp.net web applications we've built and we also want to embed them into various sharepoint pages. We need to have them look like standalone applications when viewed in their own pages, but also have them look like they fit within the sharepoint page when embedded. We are doing this currently with IFrames and it works ok, but I'm wondering if there is some sort of proxy web part where we can configure the web part to point to an existing web app and it will proxy the contents through from the web app into the sharepoint page removing the need for an IFrame. Possible?
I have four columns in database. Consider it as a,b,c and d. I'm trying to place a and b column values in TO part and c and d column values in CC part in outlook. a,b,c,d contains six digits numeric values. I just need to place a and b columns values in to and c and d values in cc part on click of a button.
What I have below is currently working on my site to display information within an article. What I am wondering is that within a lot of stories I have more than one 'SchoolID' included. All of these IDs are in our database within the 'ArticleSchool' table and linked to an 'ArticleID.' The statement below is only displaying the first 'SchoolID' listed within an article. Is there a way I would be able to display every 'SchoolID' within an article to grab information from? Will it not work in a label if there are multiple values? The 'ArticleSchool' table has rows for every article and a new instance if more than one 'SchoolID' is attached.
I have 2 fields in my gridview one called ScriptType the other BagNo, when a user click the edit button, I would like the BagNo filed to be disabled if the ScriptType field is = "TTA" and enabled otherwise. How can I do this?..something along these lines see below..I am using VB..
When using SPWeb.GetCatalog(SPListTemplateType.WebPartCatalog), it returns an SPList which of course contains a SPListItemCollection of the web parts in the web part gallery. When looping through the items, is there any easy way to get properties of the web parts? Such as AllowClose, CatalogIconImageUrl, etc... I know I can probably accomplish this using the listItem.OpenBinaryStream etc and loading the xml of the .webpart file, but I wondered if there was an easier way to do this.
I have a multi view which contains a view which contains a panel. the name of this panel is "Panel1"I have the following code and my HTML does not display in the rendered page. Any idea why this isn't working, i must be doing something wrong? sw = simple html statement, any would produce same result.
