商务网站代码.docVIP

using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { //页面加载的时候给dlstGoods绑定数据源 string sql = select top 16 * from dbo.tb_Goods order by AddDate desc; SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings[connstr]); SqlDataAdapter sda = new SqlDataAdapter(sql, conn);//sda得到查询结果——外存对象 DataSet ds = new DataSet();//内存对象 sda.Fill(ds);//ds dlstGoods.DataSource = ds.Tables[0].DefaultView; dlstGoods.DataBind();//dlstGoods绑定数据源 if (Session[MemberName] != null) { //会员没有退出登陆 divLogin.Visible = false; divShow.Visible = true; } } protected void Button2_Click(object sender, EventArgs e) { //Response.Redirect(register.aspx); //在当前页打开 Response.Write(script language=javascriptwindow.open(HTMLPage.aspx);/script);　　//在新窗口中打开 Response.Write(scriptdocument.location=document.location;/script);//执行后当前页面字体会变大,解决办法是加入当前这句代码 } protected void btLogin_Click(object sender, EventArgs e) { //登陆 /*程序思路： * 1 获得输入的会员名和密码 * 2 生成select语句，定义变量sql来接受 * 3 建立conn、sda、ds，执行查询语句sql * 4 根据ds中是否有记录判定输入的信息是否正确，如果正确则显示登陆后的信息；否则提示用户重新登陆 */ //此处添加代码 string membername = txtMemberName.Text.Trim();//Trim() 去掉字符串前后的无效空格 string pwd = txtPWD.Text; string sql1 = select *from tb_Member where MemberName={0}and MemberPwd={1}; string sql2 = string.Format(sql1, membername, pwd); SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings[connstr]); //string sql = select * fr