温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:Ajax实现拖动购物车源码
当前文件:
AjaxDropShoping/DropShoping.aspx.cs[2K,2009-6-12 11:31:36],打开代码结构图
AjaxDropShoping/DropShoping.aspx.cs[2K,2009-6-12 11:31:36],打开代码结构图1using System; 2
using System.Data; 3
using System.Configuration; 4
using System.Collections; 5
using System.Web; 6
using System.Web.Security; 7
using System.Web.UI; 8
using System.Web.UI.WebControls; 9
using System.Web.UI.WebControls.WebParts; 10
using System.Web.UI.HtmlControls; 11
using System.Configuration; 12
using System.Data.SqlClient; 13
//该源码下载自www.51aspx.com(51aspx.com) 14
15
public partial class DropShoping : System.Web.UI.Page,ICallbackEventHandler 16
{ 17
string result; 18
protected void Page_Load(object sender, EventArgs e) 19
{ 20
21
if (!Page.IsPostBack) 22
{ 23
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()); 24
SqlDataAdapter sda = new SqlDataAdapter("select ProductName,ProductId,ProductPrice,ProductPicture from ProductMsg", con); 25
DataSet ds = new DataSet(); 26
sda.Fill(ds, "Product"); 27
this.GridView1.DataSource = ds.Tables["Product"]; 28
this.GridView1.DataBind(); 29
30
} 31
} 32
33
34
35
public string GetCallbackResult() 36
{ 37
string res = null; 38
System.Threading.Thread.Sleep(1000); 39
int id = int.Parse(result); 40
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()); 41
con.Open(); 42
SqlCommand cmd = new SqlCommand(); 43
cmd.Connection = con; 44
//cmd.CommandType = CommandType.StoredProcedure; 45
cmd.CommandText = "select ProductName,ProductPrice,ProductDesgin,ProductPicture from ProductMsg where ProductId=@id"; 46
cmd.Parameters.Add("@id", SqlDbType.Int); 47
cmd.Parameters["@id"].Value =id; 48
SqlDataReader sdr = cmd.ExecuteReader(); 49
try 50
{ 51
while (sdr.Read()) 52
{ 53
if (sdr.GetString(2).Length <= 80) 54
{ 55
res += sdr.GetString(0) + "|" + sdr.GetDecimal(1).ToString() + "|" + sdr.GetString(2) + "|" + "picture/" + sdr.GetString(3).Trim(); 56
} 57
else 58
{ 59
string desgin =null; 60
desgin = sdr.GetString(2).Substring(0, 80) + "...."; 61
res += sdr.GetString(0) + "|" + sdr.GetDecimal(1).ToString() + "|" + desgin + "|" + "picture/" + sdr.GetString(3).Trim(); 62
} 63
} 64
sdr.Dispose(); 65
con.Close(); 66
return res; 67
} 68
catch (Exception e) 69
{ 70
Response.Write(e.Message); 71
con.Close(); 72
return "0"; 73
} 74
75
76
} 77
78
public void RaiseCallbackEvent(string eventArgument) 79
{ 80
result = eventArgument; 81
} 82
83
84
} 85






}
}