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数据库中添加数据
部门代码: 部门名称:
评论