Click here to Skip to main content
15,884,176 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hello,
HTML data to MSSQL I saved as HTML can not be displayed again.
text area HtmlEditorExtender and grid text area HtmlEditorExtender.
How do I make.

database table:
SQL
CREATE TABLE [dbo].[XHABER] (
    [ID]         BIGINT         IDENTITY (1, 1) NOT NULL,
    [HABER]      NVARCHAR(MAX) NOT NULL,
    [ADSOYAD]    NVARCHAR (50)  NULL,
    [CREATEDATE] DATETIME2 (7)  DEFAULT (getdate()) NULL
);


aspx; HtmlEditorExtender text area:

ASP.NET
<asp:TextBox ID="txtAcik" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="132px"
                    MaxLength="4096" TextMode="MultiLine" Width="940px" style="margin-left: 0px" BackColor="White">
    <asp:HtmlEditorExtender ID="HtmlEditorExtender1" runat="server" TargetControlID="txtAcik">




grid ItemTemplate:

ASP.NET
<itemtemplate>
                        <asp:TextBox ID="TextBoxText" runat="server" Width="900px" TextMode="MultiLine" Text='<%# Bind("HABER") %>' Height="150">
<asp:HtmlEditorExtender ID="HtmlEditorExtender1" TargetControlID="TextBoxText" DisplaySourceTab="false" runat="server">
<toolbar>
<asp:Undo />
<asp:Redo />
<asp:Copy />
<asp:Paste />
</toolbar>


save sql command;
C#
String query = "INSERT INTO XHABER " +
              " (HABER,ADSOYAD,CREATEDATE)" +
              " VALUES " +
              " (@HABER,@ADSOYAD,@CREATEDATE)";

               SqlCommand sqlCommand = new SqlCommand(query, sqllConn);

               sqlCommand.Parameters.Add("@HABER", SqlDbType.NVarChar, 19000, "HABER");
               sqlCommand.Parameters.Add("@ADSOYAD", SqlDbType.NVarChar, 50, "ADSOYAD");
               sqlCommand.Parameters.Add("@CREATEDATE", SqlDbType.DateTime, 100, "CREATEDATE");

               sqlCommand.Parameters["@HABER"].Value = txtAcik.Text;
               sqlCommand.Parameters["@ADSOYAD"].Value = Session["ADSOYAD"];
               sqlCommand.Parameters["@CREATEDATE"].Value = DateTime.Now.ToString();

               sqlCommand.Transaction = sqlTransaction;
               sqlCommand.ExecuteNonQuery();
               sqlTransaction.Commit();


It turns html code in the text section.

sample;
"<"span lang="EN-US" style=";">http://www.sahibinden.com/ilan/vasita-otomobil-toyota-ogretmenden-boyasiz-kazasiz-orijinal-auris-207668650/detay""
Posted
Updated 11-May-15 1:29am
v2
Comments
Not clear. You already have the below code...

sqlCommand.Parameters["@HABER"].Value = txtAcik.Text;

1 solution

Encode the html in c#


var encoded = Server.HtmlEncode(textbox.Text);
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900