网站设计代码.doc

Index: 欢迎光临可爱屋 首页金饰钻石925银饰流行饰品珍珠品牌专卖订制优惠券 用户登陆 用户名： 密码： 免费注册 忘记密码 按珠宝用途分类 耳饰Earrings 项链Necklaces 手镯Bracelets 戒指Finger ring 胸饰Brooches 头饰Headwear 摆件Ornament 钟表Horologe 其他Other 按珠宝性质分类 钻石Diamond 翡翠Emerald 白玉Jade 珊瑚Coral 水晶Crystal 珍珠Pearl 红宝石Ruby 蓝宝石Sapphire 贝壳Conch 黄金Gold 其他Other 本周推荐 紫水晶吊坠 紫色，充满诱惑，美丽的小花在美丽的颈边悄悄绽放。谁会忍心说不？ 原价：￥元 折扣价：￥元 购买收藏 紫水晶吊坠 紫色，充满诱惑，美丽的小花在美丽的颈边悄悄绽放。谁会忍心说不？ 原价：￥元 折扣价：￥元 购买收藏 新品上架 紫水晶吊坠 原价：￥元 折扣价：￥元 购买收藏 紫水晶吊坠 原价：￥元 折扣价：￥元 购买收藏 紫水晶吊坠 原价：￥元 折扣价：￥元 购买收藏 紫水晶吊坠 原价：￥元 折扣价：￥元 购买收藏 紫水晶吊坠 原价：￥元 折扣价：￥元 购买收藏 紫水晶吊坠 原价：￥元 折扣价：￥元 购买收藏 热销排行榜 更多>>> 优惠活动 更多>>> 可爱屋 Index.aspx.cs:using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;public partial class Index : System.Web.UI.Page public String x,y; protected void Page_Load(object sender, EventArgs e) SqlConnection conn = new SqlConnection(); SqlConnection conn1 = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStringsIndex.ConnectionString; conn1.ConnectionString = ConfigurationManager.ConnectionStringsIndex.ConnectionString; SqlCommand cmd = new SqlCommand(); SqlCommand cmd1 = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = select top 10*from GOODS order by sold_count desc; cmd.CommandType = CommandType.Text; cmd1.Connection = conn1; cmd1.CommandText = select top 6*from YHHD order by pubdate desc; cmd1.CommandType = CommandType.Text; SqlDataReader dr,dr1; try conn.Open(); dr = cmd.ExecuteReader(); while (dr.Read() x += + dr.GetValue(1).ToString() + ; dr.Close(); conn1.Open(); dr1 = cmd1.ExecuteReader(); while (dr1.Read() y += + dr1.GetValue(1).ToString() + ; dr1.Close(); finally conn.Close(); conn1.Close(); Info.aspx 无标题页 首页金饰钻石925银饰流行饰品珍珠品牌专卖订制优惠券 可爱屋 Info.aspx.cssusing System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;public partial class info : System.Web.UI.Page public string a,b,c; protected void Page_Load(object sender, EventArgs e) int yhhd_id; yhhd_id = Convert.ToInt32(Request.QueryStringid); SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStringsIndex.ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = select * from YHHD where id = id; cmd.Parameters.AddWithValue(id, yhhd_id); cmd.CommandType = CommandType.Text; SqlDataReader dr; try conn.Open(); dr = cmd.ExecuteReader(); if (dr.Read() a = dr.GetValue(1).ToString(); b = dr.GetValue(2).ToString(); c = dr.GetValue(3).ToString(); dr.Close(); finally conn.Close(); Info_more.aspx 无标题页 首页金饰钻石925银饰流行饰品珍珠品牌专卖订制优惠券 可爱屋 info_more.aspx.csusing System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;public partial class info_more : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) SqlConnection conn1 = new SqlConnection(); conn1.ConnectionString = ConfigurationManager.ConnectionStringsIndex.ConnectionString; SqlDataAdapter cmd1 = new SqlDataAdapter(select * from YHHD order by pubdate desc, conn1); DataSet dr1 = new DataSet(); try conn1.Open(); cmd1.Fill(dr1, YHHD); GridView1.DataSource = dr1; GridView1.DataBind(); finally conn1.Close(); protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) protected void GridView1_PageIndexChanging(object sender, GridViewPageEven