In this article i'm going to explain how to store HTML Tags in SQL Server With C# Coding in ASP.NET. For that first we need to add two control
1.) TextBox or Textarea Control - which is used to enter html tags or code in it.
2.) Button Control - which is used to store what ever value we entered in above TextBox (i.e HTML Code ) that data stored in SQL SERVER after clicking this button.
for more info we see practically in below sections
Create Database
Create Table StoreHTML(
title varchar(50),
htmldata varchar(max)
)
HTML Design
In HTML Design Page we need to add some code i.e validateRequest="false" in @page page directives other wise its won't work. why we need to add ValidateRequest to know more Click Here
<%@ Page Language="C#" AutoEventWireup="true" ValidateRequest="false" CodeBehind="WebForm1.aspx.cs" Inherits="StoreHTMLCodetoDatabase.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>Title : </td>
<td>
<asp:TextBox ID="txttitle" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="2">
<asp:TextBox ID="txtcode" runat="server" TextMode="MultiLine" Width="400" Height="250"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="btnCode" runat="server" Text="Post" OnClick="btnCode_Click"/>
</td>
</tr>
</table>
</div>
<br />
<asp:Label ID="lbldisplay" runat="server"></asp:Label>
</form>
</body>
</html>
Web Config :
why we are adding httpruntime in web.config to know more about info, please read this article Click Here
<?xml version="1.0"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<system.web>
<compilation debug="true" targetFramework="4.5.1" />
<httpRuntime targetFramework="4.5.1" />
</system.web>
</configuration>
C# Coding : Button Click
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
namespace StoreHTMLCodetoDatabase
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnCode_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.; User ID=sa; Password=tiger; Database=master;");
SqlCommand cmd = new SqlCommand("Insert into testcode values('" + txttitle.Text + "','" + txtcode.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
lbldisplay.Text = "Code Inserted Successfully...";
}
}
}
0 Comments