<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<script language="C#" runat="server">
protected void Page_Load(Object Src, EventArgs E)
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=\\genfs1\www11\etning\xml\Northwind.mdb";
if (!IsPostBack)
BindGrid();
}
public void AddEmployees_Click(Object sender, EventArgs E)
{
if (EmployeeID.Value == "" || LastName.Value == "" || FirstName.Value == "" || HomePhone.Value == "")
{
Message.InnerHtml = "eer：“EmployeeID”、“LastName”OR“HomePhone”no hhhhhhong";
Message.Style["color"] = "red";
BindGrid();
return;
}
String insertstr = "insert into Employees (EmployeeID, LastName, FirstName, HomePhone, Address, City, Country, Notes, PostalCode) values (@EmployeeID, @LastName, @FirstName, @HomePhone, @Address, @City, @Country, @Notes, @PostalCode)";
OleDbCommand strCommand = new OleDbCommand(insertstr,strConnection);
int cmdresults = 0;
OleDbCommand2.CommandText = "NewAuthor";
OleDbCommand2.CommandType = CommandType.StoredProcedure;
OleDbCommand2.Parameters["EmployeeID"].Value = TextBox1.Text;
OleDbCommand2.Parameters["LastName"].Value = TextBox2.Text;
OleDbCommand2.Parameters["FirstName"].Value = TextBox3.Text;
OleDbCommand2.Parameters["HomePhone"].Value = TextBox4.Text;
OleDbCommand2.Parameters["Address"].Value = TextBox5.Text;
OleDbCommand2.Parameters["City"].Value = TextBox6.Text;
OleDbCommand2.Parameters["Country"].Value = TextBox7.Text;
OleDbCommand2.Parameters["Notes"].Value = TextBox8.Text;
OleDbCommand2.Parameters["PostalCode"].Value = CheckBox1.Checked;
OleDbConnection2.Open();
try
{
cmdresults = OleDbCommand2.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Failed to execute command, err = " + ex.Message);
}
OleDbConnection2.Close();
MessageBox.Show("Number of records inserted = " + cmdresults.ToString());
myCommand.Connection.Close();
BindGrid();
}
public void BindGrid()
{
string strSQL = "SELECT * FROM Employees";
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
objAdapter.Fill(objDataSet, "Employees");
DataView objDataView = new DataView(objDataSet.Tables["Employees"]);
MyDataGrid.DataSource=objDataView;
MyDataGrid.DataBind();
}
</script>
<body style="font: 10.5pt 宋体">
<form runat="server">
<h3><font face="宋体">插入数据行</font></h3>
<table width="95%">
<tr>
<td valign="top">
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/>
</td>
<td valign="top">
<table style="font: 9pt 宋体">
<tr>
<td colspan="2" bgcolor="#aaaadd" style="font:10.5pt 宋体">添加新作者：</td>
</tr>
<tr>
<td nowrap>作者 ID：</td>
<td><input type="text" id="EmployeeID" value="000-00-0000" runat="server"></td>
</tr>
<tr>
<td nowrap>姓氏：</td>
<td><input type="text" id="LastName" value="Doe" runat="server"></td>
</tr>
<tr nowrap>
<td>名字：</td>
<td><input type="text" id="FirstName" value="John" runat="server"></td>
</tr>
<tr>
<td>电话：</td>
<td><input type="text" id="HomePhone" value="808 555-5555" runat="server"></td>
</tr>
<tr>
<td>地址：</td>
<td><input type="text" id="Address" value="One Microsoft Way" runat="server"></td>
</tr>
<tr>
<td>城市：</td>
<td><input type="text" id="City" value="Redmond" runat="server"></td>
</tr>
<tr>
<td>州：</td>
<td>
<select id="Country" runat="server">
<option>CA</option>
<option>IN</option>
<option>KS</option>
<option>MD</option>
<option>MI</option>
<option>OR</option>
<option>TN</option>
<option>UT</option>
</select>
</td>
</tr>
<tr>
<td nowrap>邮政编码：</td>
<td><input type="text" id="Notes" value="98005" runat="server"></td>
</tr>
<tr>
<td>PostalCode：</td>
<td>
<select id="PostalCode" runat="server">
<option value="0">假</option>
<option value="1">真</option>
</select>
</td>
</tr>
<tr>
<td></td>
<td style="padding-top:15">
<input type="submit" OnServerClick="AddEmployees_Click" value="添加作者" runat="server">
</td>
</tr>
<tr>
<td colspan="2" style="padding-top:15" align="center">
<span id="Message" EnableViewState="false" style="font: arial 11pt;" runat="server"/>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
里面有部分错误，请各位高手指点，谢谢！