Summer Note EDITOR

 Step-1 

<%@ Page Title="" Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="aboutschool.aspx.cs" Inherits="admin_aboutschool" 

ValidateRequest="false" %>

STEP-2

 <script src="/ckeditor/ckeditor.js"></script>  (  IF FOLDER WITHIN FOLDER ADMIN / )

STEP-3  CREATE EDITOR USING  TEXTAREA TAG 

 <textarea runat="server" id="txtAboutInternship" class="ckeditor"></textarea>

STEP-4  CRAETE TABLE USING NVARCHAR 

create table aboutschool(about nvarchar(MAX));

STEP-5 CODE DATABASE 

 string k1 = "insert into aboutschool values(@about1)";

        cm = new SqlCommand(k1, cn);

        cm.Parameters.AddWithValue("about1", txtAboutInternship.InnerText);

        cm.ExecuteNonQuery();

        Label4.Text = "update Successfully";

    }

Step-6  display data in summer note editor 

 protected void display()

    {

        string path = ConfigurationManager.AppSettings["emrsdb1"];

        cn = new SqlConnection(path);

        cn.Open();

        string k1 = "select * from aboutschool";

        cm = new SqlCommand(k1, cn);

        dr = cm.ExecuteReader();

        if (dr.Read())

        {

            txtAboutInternship.InnerText = dr["about"].ToString();

        }

        dr.Close();

    }

ADVANCE AUGUST 2025 - 2026

 HOW TO SET  PATH FROM HYPERLINK CONTROL WITH EVEL 

 <asp:TemplateField HeaderText="View PDF">

          <ItemTemplate>

  <asp:HyperLink ID="HyperLink1" runat="server" Text="Vew" 

  NavigateUrl='<%#  "/upload/" + Eval("filename") %>' >

</asp:HyperLink>

            </ItemTemplate>

   </asp:TemplateField>

---------------------------------------------------------------------------

HINDI STORAGE IN NVARCHAR COLUMN 

create table newsdb(id int identity(1,1), title nvarchar(MAX), filename varchar(MAX));

-----------------------------------------------------------------------------------------------------------------

DIRECT UPLOAD DATA TO SERVER FOLDER 

 FileUpload1.SaveAs(Server.MapPath(@"~") + "//upload//" + FileUpload1.FileName);