1@ Import Namespace="System.Data"
1@ Import Namespace="System.Data.OleDb"
1<html>
2<script language="C#" runat="server">
3
4
5protected void Page_Load(Object Src, EventArgs E)
6{
7string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
8strConnection += @"Data Source=\\\genfs1\www11\etning\xml\Northwind.mdb";
9
10if (!IsPostBack)
11BindGrid();
12}
13
14public void AddEmployees_Click(Object sender, EventArgs E)
15{
16if (EmployeeID.Value == "" || LastName.Value == "" || FirstName.Value == "" || HomePhone.Value == "")
17{
18Message.InnerHtml = "eer：“EmployeeID”、“LastName”OR“HomePhone”no hhhhhhong";
19Message.Style["color"] = "red";
20BindGrid();
21return;
22}
23
24String insertstr = "insert into Employees (EmployeeID, LastName, FirstName, HomePhone, Address, City, Country, Notes, PostalCode) values (@EmployeeID, @LastName, @FirstName, @HomePhone, @Address, @City, @Country, @Notes, @PostalCode)";
25OleDbCommand strCommand = new OleDbCommand(insertstr,strConnection);
26
27int cmdresults = 0;
28OleDbCommand2.CommandText = "NewAuthor";
29OleDbCommand2.CommandType = CommandType.StoredProcedure;
30OleDbCommand2.Parameters["EmployeeID"].Value = TextBox1.Text;
31OleDbCommand2.Parameters["LastName"].Value = TextBox2.Text;
32OleDbCommand2.Parameters["FirstName"].Value = TextBox3.Text;
33OleDbCommand2.Parameters["HomePhone"].Value = TextBox4.Text;
34OleDbCommand2.Parameters["Address"].Value = TextBox5.Text;
35OleDbCommand2.Parameters["City"].Value = TextBox6.Text;
36OleDbCommand2.Parameters["Country"].Value = TextBox7.Text;
37OleDbCommand2.Parameters["Notes"].Value = TextBox8.Text;
38OleDbCommand2.Parameters["PostalCode"].Value = CheckBox1.Checked;
39
40OleDbConnection2.Open();
41try
42{
43cmdresults = OleDbCommand2.ExecuteNonQuery();
44}
45catch (Exception ex)
46{
47MessageBox.Show("Failed to execute command, err = " + ex.Message);
48}
49OleDbConnection2.Close();
50MessageBox.Show("Number of records inserted = " + cmdresults.ToString());
51
52myCommand.Connection.Close();
53
54BindGrid();
55}
56
57public void BindGrid()
58{
59string strSQL = "SELECT * FROM Employees";
60DataSet objDataSet = new DataSet();
61OleDbConnection objConnection = new OleDbConnection(strConnection);
62OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
63objAdapter.Fill(objDataSet, "Employees");
64DataView objDataView = new DataView(objDataSet.Tables["Employees"]);
65MyDataGrid.DataSource=objDataView;
66MyDataGrid.DataBind();
67}
68
69</script>
70<body style="font: 10.5pt 宋体">
71<form runat="server">
72<h3><font face="宋体">插入数据行</font></h3>
73<table width="95%">
74<tr>
75<td valign="top">
76<asp:datagrid backcolor="#ccccff" bordercolor="black" cellpadding="3" cellspacing="0" enableviewstate="false" font-name="宋体" font-size="8pt" headerstyle-backcolor="#aaaadd" id="MyDataGrid" runat="server" showfooter="false" width="700"></asp:datagrid>
77</td>
78<td valign="top">
79<table style="font: 9pt 宋体">
80<tr>
81<td bgcolor="#aaaadd" colspan="2" style="font:10.5pt 宋体">添加新作者：</td>
82</tr>
83<tr>
84<td nowrap="">作者 ID：</td>
85<td><input id="EmployeeID" runat="server" type="text" value="000-00-0000"/></td>
86</tr>
87<tr>
88<td nowrap="">姓氏：</td>
89<td><input id="LastName" runat="server" type="text" value="Doe"/></td>
90</tr>
91<tr nowrap="">
92<td>名字：</td>
93<td><input id="FirstName" runat="server" type="text" value="John"/></td>
94</tr>
95<tr>
96<td>电话：</td>
97<td><input id="HomePhone" runat="server" type="text" value="808 555-5555"/></td>
98</tr>
99<tr>
100<td>地址：</td>
101<td><input id="Address" runat="server" type="text" value="One Microsoft Way"/></td>
102</tr>
103<tr>
104<td>城市：</td>
105<td><input id="City" runat="server" type="text" value="Redmond"/></td>
106</tr>
107<tr>
108<td>州：</td>
109<td>
110<select id="Country" runat="server">
111<option>CA</option>
112<option>IN</option>
113<option>KS</option>
114<option>MD</option>
115<option>MI</option>
116<option>OR</option>
117<option>TN</option>
118<option>UT</option>
119</select>
120</td>
121</tr>
122<tr>
123<td nowrap="">邮政编码：</td>
124<td><input id="Notes" runat="server" type="text" value="98005"/></td>
125</tr>
126<tr>
127<td>PostalCode：</td>
128<td>
129<select id="PostalCode" runat="server">
130<option value="0">假</option>
131<option value="1">真</option>
132</select>
133</td>
134</tr>
135<tr>
136<td></td>
137<td style="padding-top:15">
138<input onserverclick="AddEmployees_Click" runat="server" type="submit" value="添加作者"/>
139</td>
140</tr>
141<tr>
142<td align="center" colspan="2" style="padding-top:15">
143<span enableviewstate="false" id="Message" runat="server" style="font: arial 11pt;"></span>
144</td>
145</tr>
146</table>
147</td>
148</tr>
149</table>
150</form>
151</body>
152</html>
里面有部分错误，请各位高手指点，谢谢！
连接到演示