test18.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 MyDataGrid_Delete(Object sender, DataGridCommandEventArgs E) { try{ string connStr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source="+Server.MapPath("test.mdb"); String deleteCmd = "delete from dept where dept_id = @dept_id"; OleDbConnection myConnection = new OleDbConnection(connStr); OleDbCommand myCommand = new OleDbCommand(deleteCmd, myConnection); myCommand.Parameters.Add(new OleDbParameter("@dept_id", OleDbType.Integer)); myCommand.Parameters["@dept_id"].Value =MyDataGrid.DataKeys[E.Item.ItemIndex]; 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(); MyDataGrid.EditItemIndex = -1; BindGrid(); } catch (System.Exception e) { Message.Style["color"] = "red" ; Message.InnerHtml = "ERROR: " +e.ToString(); }} private void MyDataGrid_Edit(Object sender, DataGridCommandEventArgs E) { try{ MyDataGrid.EditItemIndex = E.Item.ItemIndex; BindGrid(); } catch (System.Exception e) { Message.Style["color"] = "red" ; Message.InnerHtml = "ERROR: " +e.ToString(); }} private void MyDataGrid_Cancel(Object sender, DataGridCommandEventArgs E) { try{ MyDataGrid.EditItemIndex = -1; BindGrid(); } catch (System.Exception e) { Message.Style["color"] = "red" ; Message.InnerHtml = "ERROR: " +e.ToString(); }} private void MyDataGrid_Update(Object sender, DataGridCommandEventArgs E) { try{ if (Page.IsValid) { string updateCmd = "update dept set dept_name = @dept_name where dept_id = @dept_id"; string connStr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source="+Server.MapPath("test.mdb"); OleDbConnection myConnection = new OleDbConnection(connStr); OleDbCommand myCommand = new OleDbCommand(updateCmd, myConnection); myCommand.Parameters.Add(new OleDbParameter("@dept_name", OleDbType.VarChar)); myCommand.Parameters.Add(new OleDbParameter("@dept_id", OleDbType.Integer)); myCommand.Parameters["@dept_id"].Value = MyDataGrid.DataKeys[(int)E.Item.ItemIndex]; myCommand.Parameters["@dept_name"].Value = ((TextBox)E.Item.FindControl("edit_dept_name")).Text; 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(); MyDataGrid.EditItemIndex = -1; BindGrid(); } } catch (System.Exception e) { Message.Style["color"] = "red" ; Message.InnerHtml = "ERROR: " +e.ToString(); }} 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" OnEditCommand="MyDataGrid_Edit" OnCancelCommand="MyDataGrid_Cancel" OnDeleteCommand="MyDataGrid_Delete" OnUpdateCommand="MyDataGrid_Update" DataKeyField="dept_id" AutoGenerateColumns="false" > <Columns> <asp:EditCommandColumn EditText="修改" CancelText="取消" UpdateText="保存" ItemStyle-Wrap="false" ButtonType="PushButton" /> <asp:ButtonColumn Text="删除" CommandName="Delete" ButtonType="PushButton" /> <asp:BoundColumn HeaderText="部门代码" Readonly="True" DataField="dept_id" /> <asp:TemplateColumn HeaderText="部门名称" SortExpression="dept_name"> <ItemTemplate> <asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "dept_name") %>'/> </ItemTemplate> <EditItemTemplate> <nobr> <asp:TextBox runat="server" id="edit_dept_name" Text='<%# DataBinder.Eval(Container.DataItem, "dept_name") %>'/> <asp:RequiredFieldValidator id="dept_name_ReqVal" ControlToValidate="edit_dept_name" Display="Dynamic" Font-Name="Verdana" Font-Size="12" runat=server> * </asp:RequiredFieldValidator> </EditItemTemplate> </asp:TemplateColumn> </Columns> </ASP:DataGrid><table><tr> <td> <span id="Message" EnableViewState="false" class="MESSAGE" runat="server"/> </td> </tr></table></form></body></html>数据库：TEST.MDB，同上一贴。
评论