不知道怎么的,我在虚目录下就两个aspx文件和一个score.mdb,search.aspx用于通过学号查询,result1用于返回结果
search.aspx<html>
<body>
<h2>我是天才!</h2>
<form action="result1.aspx" method="post" runat="server">
Please enter your 学号!<a color="red">(例如:01112201)</a>
<asp:textbox id="sno1" runat="server" />
<br/>
<input type="Submit">
<input type="Reset">
</form>
</body>
</html>result1.aspx<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
string strSno=Request.Form["sno1"];
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=d:\MyProgram\score.mdb";
string strSQL="select * from [011122期末考试成绩表] where sno=" + strSno + ";";
OleDbConnection objConnection=new OleDbConnection(strConnection);
OleDbCommand objCommand=new OleDbCommand(strSQL,objConnection);
objConnection.Open();
dgEmps.DataSource=objCommand.ExecuteReader(CommandBehavior.CloseConnection);
dgEmps.DataBind();
}</script>
<html>
<body>
<h2>我是天才!</h2>
<asp:datagrid id="dgEmps" runat="server" CellPadding="3" Font-Name="arial" Font-Size="8pt" HeaderStyle-BackColor="#dcdcdc" HeaderStyle-ForeColor="blue"/>
</body>
</html>它就跳不过去,为什么?
search.aspx<html>
<body>
<h2>我是天才!</h2>
<form action="result1.aspx" method="post" runat="server">
Please enter your 学号!<a color="red">(例如:01112201)</a>
<asp:textbox id="sno1" runat="server" />
<br/>
<input type="Submit">
<input type="Reset">
</form>
</body>
</html>result1.aspx<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
string strSno=Request.Form["sno1"];
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=d:\MyProgram\score.mdb";
string strSQL="select * from [011122期末考试成绩表] where sno=" + strSno + ";";
OleDbConnection objConnection=new OleDbConnection(strConnection);
OleDbCommand objCommand=new OleDbCommand(strSQL,objConnection);
objConnection.Open();
dgEmps.DataSource=objCommand.ExecuteReader(CommandBehavior.CloseConnection);
dgEmps.DataBind();
}</script>
<html>
<body>
<h2>我是天才!</h2>
<asp:datagrid id="dgEmps" runat="server" CellPadding="3" Font-Name="arial" Font-Size="8pt" HeaderStyle-BackColor="#dcdcdc" HeaderStyle-ForeColor="blue"/>
</body>
</html>它就跳不过去,为什么?
不过你这两页里的毛病多的都数不过来,根本就不是ASPX,而是ASP,建议先看看相关方面的书
<%@ Page language="c#" Codebehind="test.aspx.cs" AutoEventWireup="false" Inherits="test.test" %>
<form id="Form1" method="post" runat="server">
<asp:Button ID="Button1" runat="server" Text="确定">
</asp:Button>
</form>
----------------------------------------------------------------------test.aspx.cs:
----------------------------------------------------------------------
private void Button1_Click(object sender, System.EventArgs e)
{
//提交代码 }
----------------------------------------------------------------------