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=SureshDasari;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();
}
|
Demo
|
Download sample code attached
Tutorial of RichTextBox for .NET
ReplyDelete