<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Post_News.aspx.cs" Inherits="News_Post_News_Post_News" Title="Untitled Page" %>
<%@ Register TagPrefix="CE" Namespace="CuteEditor" Assembly="CuteEditor" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data.Sql" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Data.SqlTypes" %>

    

<asp:Content ID="Content1" ContentPlaceHolderID="PortalCPH" Runat="Server">
    <script runat="server">

    void btnSave_Click(object sender, EventArgs e)
    {
        string xmlValue = Editor1.Text;
        //Get the connection string from the web.config file
        string connString = System.Configuration.ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;        
        using (SqlConnection conn = new SqlConnection(connString))
        {
            conn.Open();            
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "Insert News(Post) Values(@Post)";
            //Set value of parameters
            SqlParameter firstColParameter = cmd.Parameters.Add("@Post", SqlDbType.Xml);
            firstColParameter.Value = new SqlXml(new XmlTextReader(xmlValue, XmlNodeType.Document, null));
            //Execute update and close connection
            cmd.ExecuteNonQuery();         
        }
        Response.Write("Saved values successfully");
    }
</script>

<CE:Editor id="Editor1" runat="server" />

    <asp:Button ID="btnSave" runat="server" onclick="btnSave_Click" Text="Post"
        Height="24px" Width="89px" />

</asp:Content>