»ùÓÚc#aspnetÍøÉϹºÎïÉ̳ÇÍøÕ¾Éè¼ÆÓëʵÏÖ - ͼÎÄ ÏÂÔØ±¾ÎÄ

6. ¶©µ¥ä¯ÀÀ

¶©µ¥¹ÜÀíÖ÷ÒªÊǶÔÍøÂ繺ÎïÉ̳ÇÍøÉϹºÎïµÄ¶©µ¥¹ÜÀí

6.1 ¶©µ¥ä¯ÀÀ

6.1.1 ¶©µ¥ä¯ÀÀ ½çÃæÈçͼËùʾ¡£

½çÃæ

using System; using System.Data;

using System.Configuration; using System.Collections; using System.Web;

using System.Web.Security; using System.Web.UI;

21

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Drawing;

public partial class orderbrown : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

if (!Page.IsPostBack) {

databind(); } }

public void databind() {

string orderbook = \; GridView1.DataSource = Class1.ExecSel(orderbook); GridView1.DataBind(); }

protected void GridView1_PageIndexChanging(object sender,

22

GridViewPageEventArgs e) {

GridView1.PageIndex = e.NewPageIndex; databind(); }

protected void Button2_Click(object sender, EventArgs e) {

string px = \

orderID ,orderTime,orderSum,payment,ship,buyerName,buyerEmail,buyerAddress,buyerCode,buyerTel,Payed from tblorder order by orderTime desc \;

GridView1.DataSource = Class1.ExecSel(px); GridView1.DataBind(); }

protected void Button4_Click(object sender, EventArgs e) {

string px = \

orderID,orderTime,orderSum,payment,ship,buyerName,buyerEmail,buyerAddress,buyerCode,buyerTel,Payed from tblorder order by orderTime asc \;

GridView1.DataSource = Class1.ExecSel(px);

23

GridView1.DataBind(); } }

7£®²âÊÔ·ÖÎö±¨¸æ

ÓÐÁ½ÖÖ»ù±¾·½·¨¿ÉÒÔÓÃÀ´±êʶ²âÊÔÓÃÀý£¬¼´¹¦ÄܲâÊÔ£¨ºÚºÐ²âÊÔ£©ºÍ½á¹¹²âÊÔ£¨°×ºÐ²âÊÔ£©¡£±¾´Î²âÊÔÎÒÖ÷Òª²ÉÓÃÁ˹¦ÄܲâÊÔ¡£

¹¦ÄܲâÊԵĻù±¾¹ÛµãÊÇ£¬ÈκγÌÐò¶¼¿ÉÒÔ¿´×÷Êǽ«ÊäÈ붨ÒåÓòȡֵӳÉäµ½Êä³öÖµÓòµÄº¯Êý¡£

7.1 ²âÊԼƻ®ºÍÒªµã

Èí¼þ²âÊԵı¾ÖÊÊÇÕë¶ÔÒª²âÊÔµÄÄÚÈÝÈ·¶¨Ò»×é²âÊÔÓÃÀý¡£ÔÚÌÖÂÛ֮ǰ£¬ÎÒÏȰÑÒª²âÊÔ¸÷¸öÄ£¿éµÄ¼Æ»®ºÍÒªµãÁгö¡£

7.1.1 ×Öµäά»¤²âÊÔÒªµã

Êý¾Ý¿âÁ¬½ÓÇé¿ö£ºÕý³£Çé¿ö£¬Êý¾Ý¿âÎļþȱÉÙ£¬ÍⲿϵͳÒì³£¡£ ϵͳÉèÖûñÈ¡£ºÕý³£Çé¿ö£¬ÍⲿϵͳÒì³£¡£

¶ÔÓû§ÊäÈëµÄÏìÓ¦£ººÏ·¨ÊäÈ룬Äܹ»Õý³£µ÷ÓÃ×ÓÄ£¿é£» ·Ç·¨ÊäÈ룬ϵͳÄÜ·ñ±æ±ð£¬²¢×÷³öÏìÓ¦(Ìá³ö¾¯¸æ)£» ×ÓÄ£¿éµÄÒì³£×´¿ö£¬ÏµÍ³ÄÜ·ñ¼°Ê±×ö³öÏìÓ¦¡£

7.1.2 Óû§¹ÜÀí²âÊÔÒªµã Ä£¿éÕý³£ÔËÐÐÁ÷³Ì

Óû§ÊäÈëÊý¾Ý¼ì²é£¬°üÀ¨Êý¾ÝºÏÀíÐÔ¼ì²é£¬ÒÔ¼°ºÏ·¨ÐÔ¼ì²é Êý¾Ý¿â²Ù×÷

24