粘贴后,数据不会保存在fckeditor中的数据库中 [英] After pasting, data in not saving in database in fckeditor
本文介绍了粘贴后,数据不会保存在fckeditor中的数据库中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我遇到FCKeditor的问题是,当我输入一些数据然后jquery调用SaveData函数并成功存储数据...但是当我从任何word文档/ excel粘贴数据时sheet /任何其他文档,然后jquery不调用SaveData函数,数据不保存在数据库中..
我的JQuery代码是
$( #btnSave)。click(function(){
debugger;
var datatosave = $ .fck.content(''fck1'','''');
$ .ajax ({
类型:''POST'',
url:''Default.aspx / SaveData'',
data:{''dataToSave'':''+ datatosave + ''},
contentType:application / json; charset = utf-8,
dataType:json,
success:function(){
alert( 数据保存成功);
$(#fckDiv)。slideUp(慢);
}
});
});
我的aspx.cs文件代码是
[WebMethod ]
public static void SaveData(string dataToSave)
{
SqlConnection con;
string connectionstring = ConfigurationManager.ConnectionStrings [ConnectionString]。ConnectionString;
using(con = new SqlConnection(connectionstring))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText =INSERT into DataToPdf(Data)values(''+ dataToSave +'');
尝试
{
con.Open();
cmd.ExecuteNonQuery();
}
catch(例外情况)
{}
最后
{
con.Close();
}
}
}
解决方案
(#btnSave)。 click(function(){
debugger;
var datatosave =
.fck.content(''fck1'','''');
.ajax({
type:''POST'',
url:''Default.aspx / SaveData'',
data:{'' dataToSave'':''+ datatosave +''},
contentType:application / json; charset = utf-8,
dataType:json,
成功: function(){
alert(Data savedd successfuly);
Hi,
I am facing problem with FCKeditor is that, when i type some data then jquery call SaveData function and store data successfuly... but when i paste data from any word document/excel sheet/ any other document then jquery does not call the SaveData function and data is not saved in database..
my JQuery code is
$("#btnSave").click(function () { debugger; var datatosave = $.fck.content(''fck1'', ''''); $.ajax({ type: ''POST'', url: ''Default.aspx/SaveData'', data: "{ ''dataToSave'': '' " + datatosave + "''}", contentType: "application/json; charset=utf-8", dataType: "json", success: function () { alert("Data Saved successfuly"); $("#fckDiv").slideUp("slow"); } }); });
my aspx.cs file code is
[WebMethod] public static void SaveData(string dataToSave) { SqlConnection con; string connectionstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; using (con = new SqlConnection(connectionstring)) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "INSERT into DataToPdf (Data) values (''" + dataToSave + "'')"; try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { } finally { con.Close(); } } }
解决方案
("#btnSave").click(function () { debugger; var datatosave =
.fck.content(''fck1'', '''');
.ajax({ type: ''POST'', url: ''Default.aspx/SaveData'', data: "{ ''dataToSave'': '' " + datatosave + "''}", contentType: "application/json; charset=utf-8", dataType: "json", success: function () { alert("Data Saved successfuly");
这篇关于粘贴后,数据不会保存在fckeditor中的数据库中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文