商务网站设计讲义.docVIP

教考分离—6套试题不考类对象 1.数据库操作—查询、插入删除修改 Select * from book Insert?usename values(,张三,,chen@163.com,北京,北京海淀,) insert usename(账号，姓名，密码，email)? values(,李四,kj0641,li123@163.com)Delete from?usename where 账号=Update?usename set 账号=,姓名=张三 where 账号= 注意：C#使用查询、增加、删除、修改命令,必须注意一些特点。举例：string SelSql=select * from 顾客 where 姓名=+name+ and 密码=+pwd+; 2.GridView应用—查询、选择删除修改,链接分页 3.商务网站设计商品演示、登陆注册、按书名作 者出版社查询、购物车下订单功能 登陆??private void Button1_Click(object sender, System.EventArgs e)??{ ??????? string num = TBnum.Text;??????? string pwd = TBpwd.Text;??????? if (num.Length 0 pwd.Length 0)??????? {??????????? string sel = select * from usename where 账号= + num + and 密码= + pwd + ; ??????????? //1说明SQl服务器数据库??????????? string strconn = server=(local);database=dangdang;uid=sa;pwd=;??????????? SqlConnection SqlConn = new SqlConnection(strconn);??????????? SqlConn.Open(); ??????????? //2定义C#数据缓冲??????????? DataSet ds = new DataSet();??????????? //3定义连接SQL与DataSet的桥梁??????????? SqlDataAdapter ada = new SqlDataAdapter(sel, SqlConn); ??????????? //4把Sql中数据拿到DataSet中??????????? ada.Fill(ds, chen); ??????????? //5判断是否有此人??????????? int i = ds.Tables[chen].Rows.Count;??????????? if (i 0)??????????????? Label1.Text = 热烈欢迎笨 + ds.Tables[chen].Rows[0][姓名].ToString();??????????? else??????????????? Label1.Text = 无;??????????? //7关闭??????????? SqlConn.Close(); ??????? } 举例四、注册新用户 ?protected void BtnReg_Click(object sender, EventArgs e)??? {??????? string num = TBnum.Text;??????? string name = TBname.Text;??????? string pwd1 = TBpwd1.Text;??????? string pwd2 = TBpwd2.Text;??????? string email = TBemail.Text;??????? string city1 = DDLcity1.SelectedValue;??????? string city2 = DDLcity2.SelectedValue;??????? string phone = TBphone.Text;??????? //1说明sql的服务器和数据库??????? string strconn = server=(local);database=dangdang;uid=sa;pwd=;??????? SqlConnection SqlConn = new SqlConnection(strconn);??????? SqlConn.Open();??????? //insert usename values(,六六大顺,,abc666@163.com