产品发布

<% @ Page Language = " C# "  Debug = " True " %>
<% @ Import NameSpace = " System.Data "   %>
<% @ Import NameSpace = " System.Data.OleDb "   %>

< script runat = " server " >
OleDbConnection myConn;
void  Page_Load( object  sender,EventArgs e)
... {
    if(!IsPostBack)
    ...{
        //Comm();
        Grid1.DataSource=Dis(0);
        Grid1.DataBind();
    }
}
void  ConnOpen()
... {
    string connStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("test.mdb");
    myConn=new OleDbConnection(connStr);
    myConn.Open();
}
void  Comm()
... {
    ConnOpen();
    string commStr="select * from table1";
    OleDbDataAdapter myDA=new OleDbDataAdapter(commStr,myConn);
    DataSet myDS=new DataSet();
    myDA.Fill(myDS,"table1");
    Grid1.DataSource=myDS;
    Grid1.DataBind();    
}
DataSet Dis( int  pid)
... {
    DataTable dt;
    string strSel;
    ConnOpen();
    strSel="select * from Class where pid="+pid+" order by id desc";
    OleDbDataAdapter myDA=new OleDbDataAdapter(strSel,myConn);
    DataSet ds=new DataSet();
    myDA.Fill(ds,"Class");
    dt=ds.Tables["Class"];
    
    if(dt.Rows.Count>0)
    ...{
        foreach(DataRow rows in dt.Rows)
        ...{
            Dis(Convert.ToInt32(rows["ID"]));
        }
    }
    return ds;
}
</ script >

< html >
< body >
< form id = " form1 "  method = " post "  runat = " server " >
< asp:DataGrid ID = " Grid1 "  runat = " server " >
</ asp:DataGrid >
< table >
< tr >
< td >

</ td >
< td >
</ td >
</ tr >
</ table >
</ form >
</ body >
</ html >