test1.aspx:<%@ Page Language="C#"%><%@ Import namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><html><head><script language="C#" runat="server">private void Page_Load(Object Src, EventArgs E) { if (!IsPostBack) BindGrid();}private void Add_Click(Object sender, EventArgs E) { string connStr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source="+Server.MapPath("test.mdb"); string insertCmd = "INSERT INTO [dept](dept_id,dept_name) VALUES (@dept_id,@dept_name)"; OleDbConnection myConnection = new OleDbConnection(connStr); OleDbCommand myCommand = new OleDbCommand(insertCmd, myConnection); myCommand.Parameters.Add(new OleDbParameter("@dept_id", OleDbType.Integer)); myCommand.Parameters.Add(new OleDbParameter("@dept_name",OleDbType.VarChar)); myCommand.Parameters["@dept_id"].Value = dept_id.Value; myCommand.Parameters["@dept_name"].Value = dept_name.Value; myConnection.Open(); try { myCommand.ExecuteNonQuery(); Message.Style["color"] = "blue"; Message.InnerHtml = "添加数据:数据已成功的加入数据库"; } catch (System.Exception e) { Message.Style["color"] = "red" ; Message.InnerHtml = "ERROR: " +e.ToString(); } myConnection.Close(); BindGrid();} private void BindGrid() { try{ string connStr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source="+Server.MapPath("test.mdb"); OleDbConnection myConnection = new OleDbConnection(connStr); OleDbDataAdapter myCommand = new OleDbDataAdapter("select dept_id,dept_name from dept ", myConnection); DataSet ds = new DataSet(); myCommand.Fill(ds, "dept"); MyDataGrid.DataSource=ds.Tables["dept"].DefaultView; MyDataGrid.DataBind(); } catch (System.Exception e){ Message.Style["color"] = "red"; Message.InnerHtml = "ERROR:"+e.ToString(); }}</script></head><body style="font: 10pt verdana"><form runat="server" ><table width=100% cellspacing=0 cellpadding=0><tr> <td class="CONTENTTITLE" width="100%" bgcolor="D3C9C7"> 向ACCESS数据库中添加数据 <asp:RequiredFieldValidator ControlToValidate="dept_id" Display="Static" ErrorMessage="*:部门代码不可空白" runat=server/> <asp:RequiredFieldValidator ControlToValidate="dept_name" Display="Static" ErrorMessage="*:部门名称不可空白" runat=server/> </td></tr></table><table style="font: 8pt verdana"> <tr> <TD VALIGN="top" ALIGN="left">部门代码:<input type="text" id="dept_id" value="" runat="server"> 部门名称:<input type="text" id="dept_name" value="" runat="server"> <input type="submit" OnServerClick="Add_Click" value="添加" runat="server"></TD> </TR> </table> <ASP:DataGrid id="MyDataGrid" runat="server" BackColor="#F4FFF4" BorderColor="black" ShowFooter="false" CellPadding=3 CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="lightblue" AutoGenerateColumns="false" > <Columns> <asp:BoundColumn HeaderText="部门代码" DataField="dept_id" /> <asp:BoundColumn HeaderText="部门名称" DataField="dept_name" /> </Columns> </ASP:DataGrid><table><tr> <td> <span id="Message" EnableViewState="false" class="MESSAGE" runat="server"/> </td> </tr></table></form></body></html>外观： 向ACCESS数据库中添加数据 部门代码: 部门名称: 当然还有建立一个TEST.MDB的ACCESS数据库，里面有一个表“DEPT”，有字段“dept_id”“dept_name”。
评论