<%@ page language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
OleDbConnection Conn;
protected void Page_Load(Object Src, EventArgs E ) {
	String Provider,DataBase,ConnStr,SQL;
	Provider = "Microsoft.Jet.OLEDB.4.0;";
	DataBase = Server.MapPath("person.mdb");
	ConnStr = "Provider="+Provider+"Data Source="+DataBase;
	Conn = new OleDbConnection(ConnStr);
	if (!IsPostBack) BindGrid();
}
public void Add_Click(Object sender, EventArgs E) {
   String strSQL="insert into grade(學號, 姓名, 數學) values ("
		+Stu_NO.Text+",'"
		+Stu_Name.Text+"',"+Stu_Math.Text+")";
   OleDbCommand Comm=new OleDbCommand(strSQL,Conn);
   Conn.Open();
   try    {
      Comm.ExecuteNonQuery();
      Message.InnerHtml="<b>添加成功</b>";
   }
   catch (OleDbException)   {
      Message.InnerHtml="添加失敗";
      Message.Style["color"]="red";
   }
   Conn.Close();
   BindGrid();
}
public void BindGrid() {
   OleDbDataAdapter da = new OleDbDataAdapter("select * from grade",Conn);
   DataSet ds = new DataSet();
   da.Fill(ds);
   dg.DataSource=ds;
   dg.DataBind();
}
</script>
<form runat="server">
 <table width="95%">
  <tr><td valign="top">
    <asp:DataGrid id="dg" runat="server"
          Width="400" BackColor="#ccccff" 
          BorderColor="black" ShowFooter="false" 
          CellPadding=3 CellSpacing="0"
          Font-Name="Verdana" Font-Size="8pt"
          HeaderStyle-BackColor="#aaaadd"
          AutoGenerateColumns="false"
          MaintainState="false">
       <Columns>
         <asp:BoundColumn HeaderText="學號" DataField="學號" />
         <asp:BoundColumn HeaderText="姓名" DataField="姓名" />
         <asp:BoundColumn HeaderText="數學" DataField="數學" />
      </Columns>
     </asp:DataGrid>    
    </td>
    <td valign="top">
      <table style="font: 8pt verdana">
        <tr><td colspan="2" bgcolor="#aaaadd" style="font:10pt verdana">
        添加新的學員：
        </td></tr>
        <tr><td nowrap>學號:</td>
        <td><asp:TextBox id="Stu_NO" runat="server" />
        </td></tr>
        <tr><td nowrap>姓名:</td>
            <td><asp:TextBox id="Stu_Name" runat="server" />
        </td></tr>
        <tr><td nowrap>數學成績:</td>
	    <td><asp:TextBox id="Stu_Math" runat="server" />
        </td></tr>
        <tr><td colspan="2" style="padding-top:15" align="center">
            <asp:Button text="添加" OnClick="Add_Click" runat="server" />
        </td></tr>
        <tr><td colspan="2" style="padding-top:15" align="center">
            <span id="Message" MaintainState="false" 
                style="font: arial 11pt;" runat="server"/>
        </td></tr>
     </table>
    </td></tr>
 </table></form>