无法将数据拖放到sql中 [英] Not able to insert drag and drop data in to sql
本文介绍了无法将数据拖放到sql中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
hi。
我可以将数据从一个gridview拖动到另一个gridview。但是无法将拖动的数据保存到database.some请帮帮我。
我在aspx页面中使用
--- -----------------
hi.
i'm able to drag data from one gridview to another gridview. but not able to save the dragged data in to database.some one please help me.
in aspx page i use
--------------------
<script src="js/jquery-1.8.0.js" type="text/javascript"></script>
<script src="js/jquery-ui.js" type="text/javascript"></script>
<link href="css/jquery-ui.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
$(function () {
$(".drag_drop_grid").sortable({
items: 'tr:not(tr:first-child)',
cursor: 'crosshair',
connectWith: '.drag_drop_grid',
axis: 'y',
dropOnEmpty: true,
receive: function (e, ui) {
$(this).find("tbody").append(ui.item);
}
});
$("[id*=gvDest] tr:not(tr:first-child)").remove();
});
</script>
cs
-
cs
--
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[2] { new DataColumn("Item"), new DataColumn("Price") });
dt.Rows.Add("Shirt", 450);
dt.Rows.Add("Jeans", 3200);
dt.Rows.Add("Trousers", 1900);
dt.Rows.Add("Tie", 185);
dt.Rows.Add("Cap", 100);
dt.Rows.Add("Hat", 120);
dt.Rows.Add("Scarf", 290);
dt.Rows.Add("Belt", 150);
gvSource.UseAccessibleHeader = true;
gvSource.DataSource = dt;
gvSource.DataBind();
dt.Rows.Clear();
dt.Rows.Add();
gvDest.DataSource = dt;
gvDest.DataBind();
}
}
但我无法从gvDest检索数据并插入数据库。请帮我找一个解决方案
but i am not able to retrieve data from gvDest and insert into database. please help me to find a solution
推荐答案
(function(){
(function () {
(。drag_drop_grid)。sortable({
项:'tr:not(tr:first-child)',
cursor:'crosshair',
connectWith:'。drag_drop_grid',
轴:'y',
dropOnEmpty:true,
receive:function(e,ui){
(".drag_drop_grid").sortable({ items: 'tr:not(tr:first-child)', cursor: 'crosshair', connectWith: '.drag_drop_grid', axis: 'y', dropOnEmpty: true, receive: function (e, ui) {
(this).find(tbody)。append(ui .item);
}
});
(this).find("tbody").append(ui.item); } });
这篇关于无法将数据拖放到sql中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文