编译能通过,页面却没有结果显式
<%@ Import namespace=System.Data.OleDb%>
<%@ Import namespace=System.Data%>
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="web调用.WebForm1" %>
<script language="C#" runat="server">
public void Page_Load()
{
string strConnection="Provider=SQLOLEDB.1;Data Source=dbserver\\u8m;Initial Catalog=u8m; User ID=sa;Password=rack1977";
string strSQL="select * from menu_define ";
OleDbConnection myConn=new OleDbConnection(strConnection);
OleDbDataAdapter myAdapter=new OleDbDataAdapter(strSQL,myConn);
DataSet myDataSet=new DataSet();
myAdapter.Fill(myDataSet,"menu_define");
user.DataSource=myDataSet.Tables["menu_define"].DefaultView;
user.DataBind();
lbl.Text="确定"
}
</script>
<HTML>
<HEAD><title>WebForm1</title></HEAD>
<body>
<form id="Form1" method="post" runat="server">
<asp:DataGrid ID="user" AlternatingItemStyle-BackColor="#eeeeee" HeaderStyle- BackColor="#aaaadd" AutoGenerateColumns="False" Runat="server">
<Columns>
asp:BoundColumn HeaderText="ID" DataField="menu_id"></asp:BoundColumn>
<asp:BoundColumn HeaderText="名称" DataField="menu_caption"></asp:BoundColumn>
<asp:BoundColumn HeaderText="描述" DataField="menu_description"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
<asp:Button ID="lbl" Width="100" Runat="server"></asp:Button>
</form>
</body>
</HTML>