Introduction
Here
I will explain how to use richtextbox and how we can save our richtextbox data
in database and how we can retrieve and display saved richtextbox data into our
application using asp.net.
Description:
Today
I am writing this post to explain about freely available richtextbox.
Previously I worked on one social networking site for that we got requirement
to use richtextbox at that time we search so many websites to use richtextbox
but we didn’t find useful ones. Recently I came across one website and I found
one free available richtextbox. We can validate and we can use richtextbox very
easily and by using this richtextbox we can insert data in different formats
like bold, italic and different color format texts and we can insert images
also. To use free Richtextbox download available dll here FreeTextbox . After download dll from that site
create one new website in visual studio and add FreeTextbox dll reference to
newly created website after that design aspx page like this
After
that Design your aspx page like this
|
<%@ Register Assembly="FreeTextBox" Namespace="FreeTextBoxControls" TagPrefix="FTB"
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Richtextbox Sample</title>
<script type="text/javascript">
function validate() {
var doc =
document.getElementById('FreeTextBox1');
if (doc.value.length
== 0) {
alert('Please Enter data in Richtextbox');
return false;
}
}
</script>
</head>
<body>
<form id="form1"
runat="server">
<div>
<table>
<tr>
<td>
<FTB:FreeTextBox ID="FreeTextBox1"
runat="server">
</FTB:FreeTextBox>
</td>
<td valign="top">
<asp:GridView runat="server"
ID="gvdetails"
AutoGenerateColumns="false">
<Columns>
<asp:TemplateField HeaderText="RichtextBoxData">
<ItemTemplate>
<asp:Label ID="lbltxt"
runat="server"
Text='<%#Bind("RichtextData") %>'/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
<asp:Button ID="btnSubmit"
runat="server"
OnClientClick="return
validate()"
Text="Submit" onclick="btnSubmit_Click"
/><br
/>
<asp:Label ID="lbltxt"
runat="server"/>
</form>
</body>
</html>
|
After
that run your application richtextbox appears like this
 |
Now
our richtextbox is ready do you know how we can save richtextbox data into
database and which datatype is used to save richtextbox data and do you know
how to display richtextbox on our web page no problem we can implement it now.
To
save richtextbox data we need to use datatype nvarchar(MAX) now Design table like this in your SQL Server
database and give name as RichTextBoxData
|
Column Name
|
Data Type
|
Allow Nulls
|
|
Id
|
Int(Set
Identity=true)
|
No
|
|
RichTextData
|
nvarchar(MAX)
|
Yes
|
After
that add following namespaces in code behind
|
using System.Data;
using
System.Data.SqlClient;
|
Now
write the following code in code behind
|
SqlConnection con = new SqlConnection("Data Source=GohilRajni;Integrated
Security=true;Initial Catalog=MySampleDB");
protected void Page_Load(object
sender, EventArgs e)
{
if(!IsPostBack)
{
BindGridview();
}
}
protected void BindGridview()
{
con.Open();
SqlCommand cmd = new SqlCommand("select RichTextData from RichTextBoxData",
con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
gvdetails.DataSource
= ds;
gvdetails.DataBind();
}
protected void btnSubmit_Click(object
sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into RichTextBoxData(RichTextData)
values(@Richtextbox)", con);
cmd.Parameters.AddWithValue("@Richtextbox", FreeTextBox1.Text);
cmd.ExecuteNonQuery();
con.Close();
FreeTextBox1.Text =
"";
BindGridview();
}
|
Hi,
ReplyDeleteI implemented this code works perfectly. Thanks. I had an issue with displaying table tags in my reportviewer. I then had to think of a workaround solution to save this freetextbox as varibinary so the reportviewer can view as image. How do i achieve this?