Menu
i have created the html editor successfully.
but whenever i store the content of iframe to oracle table the html tag
also get stored.
so while displaying the same data in a textbox it is not displaying the formatted data.
insted it displays like this
<strong>hello<strong>
i want ‘hello’ should be display like bolded one.
i will copy the entire source code
<%@ Page Language=”VB” AutoEventWireup=”false” CodeFile=”Default.aspx.vb” Inherits=”_Default” ValidateRequest=”false”%>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “
<html xmlns=”
<head runat=”server”>
<title>Untitled Page</title>
<style type=”text/css”>
.butClass
{
border: 1px solid;
border-color: #D6D3CE;
}
</style>
</head>
<body>
<form id=”frmMain” method=”post” runat=”server”>
<div>
<table id=”tblCtrls” border=”0″ cellspacing=”0″ cellpadding=”0″ style=”background-color:#D6D3CE; z-index: 104; left: 13px; position: absolute; top: 219px; width: 301px;”>
<tr>
<td class=”tdClass” style=”width: 415px; height: 28px;”>
<img alt=”Bold” class=”butClass” src=”image/bold.gif” onclick=”doBold()” id=”IMG1″/>
</td>
</tr>
</table>
<asp:Button ID=”Button1″ runat=”server” Style=”z-index: 100; left: 494px; position: absolute;
top: 192px” Text=”Button” />
<asp:TextBox ID=”TextBox1″ runat=”server” Style=”z-index: 107; left: 589px; position: absolute;
top: 191px” TextMode=”MultiLine”></asp:TextBox>
<asp:Button ID=”cmdSubmit” runat=”server” Style=”z-index: 102; left: 37px;position: absolute;
top: 190px” Text=”Button” />
<%–<input type=”text” id=”text1″ name=”hidValue” style=”z-index: 104; left: 355px; position: absolute; top: 243px” />–%>
<asp:Button id=”cmdSend” runat=”server” Text=”Send” style=”z-index: 103; left: 339px; position: absolute; top: 368px”></asp:Button>
<iframe id=”ifrHTML” title=”ifrHTML” runat=”server” style=”z-index: 105; left: 14px; position: absolute; top: 248px”></iframe>
<input type=”hidden” name=”hidValue” style=”z-index: 106; left: 398px; position: absolute; top: 367px”/></div>
</form>
<script>
//Set the IFRame to Desing Mode.
ifrHTML.document.designMode = “on”;
function doBold()
{
ifrHTML.document.execCommand(‘bold’, false, null);
}
</script>
</body>
</html>
Imports System.Data
Imports System.Data.OleDb
Partial Class _Default
Inherits System.Web.UI.Page
Dim cn As New OleDbConnection(“provider=msdaora.1;user id=scott;password=tiger;data source=ora”)
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cmdSubmit.Attributes.Add(“onClick”, “document.frmMain.hidValue.value = ifrHTML.document.body.innerHTML;”)
End Sub
Private Sub cmdSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSubmit.Click
Dim strValue As String
strValue = Server.HtmlEncode(Request.Form(“hidValue”)).ToString()
Try
Dim s As String
cn.Open()
s = “insert into iframe values(‘” + strValue + “‘)” //iframe is my table in oracle
Dim cmd As New OleDbCommand
cmd.Connection = cn
cmd.CommandText = s
cmd.ExecuteNonQuery()
MsgBox(“records inserted”)
cn.Close()
Catch ex As Exception
MsgBox(ex)
End Try
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
cn.Open()
Dim s1 As String
s1 = “select * from iframe”
Dim cmd1 As New OleDbCommand
cmd1.CommandText = s1
cmd1.Connection = cn
Dim dr As OleDbDataReader
dr = cmd1.ExecuteReader
While dr.Read()
TextBox1.Text &= HttpUtility.HtmlEncode(dr.GetValue(0))
End While
dr.Close()
cn.Close()
End Sub
End Class