.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL server 2005 +asp.net 4.0 +html special characters problems saving special characters

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :ASP.Net

Hello all

Could I please ask - how do I go about inserting into a database special characters such as the uppercase O, umlaut 


Please understand that I have been able to insert the special character from inside MMS by putting an N in front of the value

but when I run the  SQL file from inside an ASP.net 4.0 page it comes up as a diamond with a question mark in it

Does anyone have any idea how I would be able to acheive this?

View Complete Post

More Related Resource Links

GridView crashes when user enters html open "<" or close ">" characters in a textbox

My GridView is bound to a sql data source and allows editing of fields. Coding is in C# and JavaScript. Using Visual Studio 2008 in test mode, if I enter a less-than "<" or greater-than ">" character in a GridView textbox an error is immediately thrown upon pressing enter: "Microsoft Visual StudioMirosoft JScript runtime error:Sys.WebForms.PageRequestManagerServerErrorException: An unknown erroroccurred while processing the request on the server. The status dode returnedfrom the server was: 500"When the < or > is entered in production, the page aborts and loads the application start page. I need to be able to catch and replace those characters BEFORE the error is thrown. I've tried hooking OnTextChange code to the textboxes, but the error is thrown as soon as I press enter...the OnTextChange code never runs. Any help will be greatly appreciated.

Not escaping html characters?


I want to output this: "style="float:right;" " if some bool is true inside a helper.

The following code:

@helper imageLink(string url, string title, bool right)
        var rightText = "";
        if (right) {rightText = "style=\"float:right;\" ";}
        <a href="@url" class="colorbox" rel="groep" title="@title">
            <img @rightText width="300" height="225" src="@url" alt="@title" />

Produces this result:

<img style=&quot;float:right;&quot;

The problem is with @rightText, wich is escaped and the HTML doesn't work anymore...

Please advise me!

VB.NET - store HTML code in SQL Server


Hey guys/gals!!

Quick question - I want to allow someone to enter HTML markup in a control, and save the input exactly as entered. 

I want people to put a minimum of 50 words, to maximum of 500, and be able to save the formatting of their text in SQL 2005 server database. 

Also, I understand this is two questions, but how do I save metadata of an image file in the sql database? I mean, I get the gist of it, but how do I do it? 

Thanks everyone!

Generating and storing html pages in User Directories on the server



I come from corporate asp.net development, and I am now working on a public website which will get a lot of traffic, perhaps a million users a day.  So I am faced with a ton of performance and scalability questions.

I would like to share some thoughts and see if my approaches resonate with any good practices, or perhaps I am heading down the wrong path...  Either way, I want to hear opinions.

(My number one concern is the fact that I am using asp.net for a public website.  I don't know of a lot of websites using asp.net)

I am using asp.net 2.0 (I know, its not the latest technology but I don't need any advanced features of asp.net 3.5 or 4, unless there are significant improvements geared towards what I am doing) 

On launch date, this will be running on a dedicated Windows Server 2008 running on Intel ATOM 330 1MB L2 Cache 1.6Ghz Dual-Core with 2GB DDR RAM.  Its fully managed by a full service hosting company which gives me an option to upgrade to a bigger server within a few hours.  I can even move the site to a webfarm if the traffic demands it.

So I have a User Dashboard, where users can create albums and upload pictures.  So what I am doing

SQL Server + ASP.NET Security Validation + HTML Markup Security

Hey everyone!I have an application, that for example, the customer gives me their Address. I store it in my database using the below code:        Dim connectionString As String = ConfigurationManager.ConnectionStrings("DMBConnstring").ConnectionString         Dim insertSql As String = "INSERT INTO BasicUserProfile(UserGuid, Firstname, Lastname, Nickname, Address1, City, State, Zip, DOB, Gender, SeekingGender, Sexuality, SeekingSexuality, HaveKids, WantKids, BodyType, SeekingBodyType, Ethnicity, SeekingEthnicity, Religion, SeekingReligion, Smoking, SeekingSmoking, Education, SeekingEducation, Relationship, SeekingRelationship) " _         & "VALUES (@UserGuid, @Firstname, @Lastname, @Nickname, @Address1, @City, @State, @Zip, @DOB, @Gender, @SeekingGender, @Sexuality, @SeekingSexuality, @HaveKids, @WantKids, @BodyType, @SeekingBodyType, @Ethnicity, @SeekingEthnicity, @Religion, @SeekingReligion, @Smoking, @SeekingSmoking, @Education, @SeekingEducation, @Relationship, @SeekingRelationship)"         Dim connectionString As String = ConfigurationManager.ConnectionStrings("myconnstring").ConnectionString        Dim insertSql As String = "INSERT INTO BasicUserProfile(UserGuid, Firstname, Lastname, Nickname, A

Problems trying to format HTML tables


I have two one-line x 2-column HTML tables that I want to horizontally line with each other.  To be specific, here's the formatting I'm looking for:


                                 |                    Feet of Advance:  | [TextBox] ft                       | 



server controls inside asp:wizard, doesnt render html when step is not first..


I have a server control which consists of a gridview with custom navigation&information capabilities and with javascript functions to highlight the selected grid items or highlight when mouse over event occurs.. (full tested outside asp:wizard)

I'm trying to use that server control inside a template wizard step, when I drop such server control in the first step of the wizard everything goes ok.

When I insert even a blank step previous to the step which contains the server control, the javasript code of the server control is not rendered at all, the page doesn't fail during load but until I go with mouse over an item of the grid for instance.

When I check the rendered HTML I can see no HTML, nor javascript events of this server control where rendered, neither the implementation nor calls to javascript, but even rarer what is there visible in the grid for ie, even the other components of the server control, are not in the "view source code" content.  

I seems it was sent to the client, even showed, but truncated in some phase..

Thanks in advance for your comments,


Call server control from HTML string


Hi you guys, is there any way to create a server control from html string, i mean in code behind i have a string like this:

string html = "<asp:CheckBox ID=\"CheckBox1\" runat=\"server\" />";

So how to insert it into aspx page and when the page is rendering, it convert my string as i write it own in the webpage
Hope you guys can help
Thanks in advance!

Grab output HTML and write to SQL Server


Hi all -

I've got a requirement to add a feature that will save off a dynamically created asp.net page so it can be recalled and reviewed at a later date. I was thinking of just adding a 'Save' button to the page and in the code-behind using VB to write the output HTML to a varchar(MAX) field in my database.

Does anyone know how (in VB) to grab the entire page HTML so it can be inserted into a database?

Thanks for any help!



HTML input type value in server side



I am making use of XSLT in showing a XML form. But in XSLT file along with the path of XML, I have a checkbox and a textbox input html control type. My question is how can I access these html control input value in the server page?


handling html server control events


How to wire up HTML server controls events?

I added a Input (Text) control in my web form and turned it into an HTML server control so its an instance of HtmlInputText class.

If I double click on the control It only adds a OnClick event handler method inside the script tags in the HTML doc of the web form but how to I get to handle its Serverchange event exactly? does VS.net 2008 has no ability to auto wire up the event to the control, do I have to manually wire up the event handler?

SharePoint Server 2010 - API to convert word docs to FILTERED HTML


Using word automation services, we cannot convert a doc/docx to FILTERED html, which can be done on client side using "saveas".

Is there any unexposed API through which one can achieve this using SharePointServer2010 + c# programatically.

or any alternative way to get FILTERED HTML format file from doc/docx?

I knew the way to do this as a client side application. This can be acheived simply by recording macros.

Ref: http://tudorstoian.blogspot.com/2008/02/word-automation.html

I want sharepoint 2010 server side way to do this task.

how to convert simple html to asp.net control( server side useing C#,Jquery,xml,xslt)


input form 
<FORM METHOD=POST ACTION="mailto:someone@$nailmail.com" ENCTYPE="text/plain"> <table border=0 cellspacing=0 cellpadding=2> <tr> <td colspan=2> <font size=2 face="arial" color="#000000"> <INPUT type="text" name=URL size=17 value="http://"> :Your URL<BR> <INPUT type="text" name=user size=17> :Your Username<BR> <INPUT type="text" name=email size=17> :Your E-mail </font> </td> </tr> <tr> <td> <font size=1 face="arial" color="#000000"> <INPUT name=subscribe type=radio value="yes" CHECKED> subscribe<BR> <INPUT name=subscribe type=radio value="no"> unsubscribe<BR> </font> </td> <td> <SELECT name="choices" size=1> <OPTION selected> OPTIONS <OPTION> OPTION 1 <OPTION> OPTION 2 <OPTION> OPTION 3 <OPTION> OPTION 4 <OPTION> OPTION 5 </SELECT> </td> </tr> <tr> <td colspan=2> <font size=1 face="arial" color="#000000"> <INPUT type=checkbox name="html" value="sendme" CHECKED> i can recive email as html<BR> <INPUT type=checkbox name="receipt"

Call a SQL Server function(cleans html tags) on a derived column in SSIS


I have a task to move table having "text" data type for a column from SQL Server to CSV file so while transfering the data using SSIS I want to perform Cleanup on this column such as removing HTML tags, White spaces etc and then transfer it. Note: I dont have any option to store the table in the staging database as I will be running it on the production server directly.

Can any one help me accomplish this task???





Add Runat server to all element in html string



I have one html string in DB like below

<div style="padding-left: 200px; padding-top: 20px">
        <div style="text-align: left;padding-top:10px">
            <input id="Text1" type="text" /></div>
        <div style="text-align: left;padding-top:10px">
            <input id="Text2" type="text" /></div>
        <div style="text-align: left; padding-top: 10px">
            <input id="Button1" type="button" value="Submit" /></div>


i wan to render this in aspx page. but before this i want to all runat server to all html control in above string


<div style="padding-left: 200px; padding-top: 20px">
        <div style="text-align: left;padding-top:10px">
            <input id="Text1" runat="server&

ASP.NET, HTML, JavaScript Snippet Support (VS 2010 and .NET 4.0 Series)

This post covers another useful improvement in VS 2010 - HTML/ASP.NET/JavaScript snippet support. Snippets allow you to be more productive within source view by allowing you to create chunks of code and markup that you can quickly apply and use in your application with a minimum of character typing.

Visual Studio has supported the concept of "snippets" for VB and C# in previous releases - but not for HTML, ASP.NET markup and JavaScript. With VS 2010 we now support snippets for these content types as well.

Maintain HTML Radio Button Selection Inside GridView After Postback

Long time ago I wrote an article about getting the value of the selected RadioButtons inside the GridView control. The code did not addresssed the postback issue which means that the selected radio button was cleared after the postback occurs.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend