VS.net2003中不报错,也不显示任何东西。
代码如下:先说VS.net中
=========================================
WebForm1.aspx
========================================
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="test1.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 102; LEFT: 312px; POSITION: absolute; TOP: 152px"
runat="server" Height="136px" Width="328px"></asp:DataGrid></FONT>
</form>
</body>
</HTML>
==========================================
WebForm1.aspx.cs
==========================================
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;namespace test1
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1; private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load); } private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection MyConnection;
SqlCommand MyCommand;
MyConnection = new SqlConnection("server=127.0.0.1;user id=sa;password=;database=guestbook;");
MyCommand =new SqlCommand("SELECT * from liuyan",MyConnection);
MyConnection.Open();
SqlDataReader dr = MyCommand.ExecuteReader();
DataGrid1.DataSource=dr;
DataGrid1.DataBind();
dr.Close();
MyConnection.Close(); } }
}
========================================================
记事本直接写的test1.aspx
========================================================
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<script runat="server" language="c#">
void Page_Load()
{
SqlConnection MyConnection;
SqlCommand MyCommand;
MyConnection = new SqlConnection("server=127.0.0.1;user id=sa;password=;database=guestbook;");
MyCommand =new SqlCommand("SELECT * from liuyan",MyConnection);
MyConnection.Open();
SqlDataReader dr = MyCommand.ExecuteReader();
DataGrid1.DataSource=dr;
DataGrid1.DataBind();
dr.Close();
MyConnection.Close();
}
</script>
<html>
<body>
<asp:DataGrid
id="DataGrid1"
cellpadding="1"
showheader="true"
borderwidth="0"
runat="server"
/>
</body>
</html>
代码如下:先说VS.net中
=========================================
WebForm1.aspx
========================================
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="test1.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 102; LEFT: 312px; POSITION: absolute; TOP: 152px"
runat="server" Height="136px" Width="328px"></asp:DataGrid></FONT>
</form>
</body>
</HTML>
==========================================
WebForm1.aspx.cs
==========================================
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;namespace test1
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1; private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load); } private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection MyConnection;
SqlCommand MyCommand;
MyConnection = new SqlConnection("server=127.0.0.1;user id=sa;password=;database=guestbook;");
MyCommand =new SqlCommand("SELECT * from liuyan",MyConnection);
MyConnection.Open();
SqlDataReader dr = MyCommand.ExecuteReader();
DataGrid1.DataSource=dr;
DataGrid1.DataBind();
dr.Close();
MyConnection.Close(); } }
}
========================================================
记事本直接写的test1.aspx
========================================================
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<script runat="server" language="c#">
void Page_Load()
{
SqlConnection MyConnection;
SqlCommand MyCommand;
MyConnection = new SqlConnection("server=127.0.0.1;user id=sa;password=;database=guestbook;");
MyCommand =new SqlCommand("SELECT * from liuyan",MyConnection);
MyConnection.Open();
SqlDataReader dr = MyCommand.ExecuteReader();
DataGrid1.DataSource=dr;
DataGrid1.DataBind();
dr.Close();
MyConnection.Close();
}
</script>
<html>
<body>
<asp:DataGrid
id="DataGrid1"
cellpadding="1"
showheader="true"
borderwidth="0"
runat="server"
/>
</body>
</html>
另外在下面两句中加一条dr.Read(); SqlDataReader dr = MyCommand.ExecuteReader();
DataGrid1.DataSource=dr; 如果还有问题,给我发消息,明天看,睡觉去也!
<%@ Page Language="C#" AutoEventWireup="True" %>
表示自动启用页事件,就可以了。
可以显示信息的。
楼主的GUESTBOOK数据库中的liuyan表中有数据吗?
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="test1.WebForm1" %>
应该是:
<%@ Page language="c#" Codebehind="test1.aspx.cs" AutoEventWireup="true" Inherits="test1.WebForm1" %>2、
把AutoEventWireup设置为"True" 触发Page_Load事件。
是不是安装的时候要先安装SQL Server,再安装VS.net
安装的时候是不分先后的
记事本写的中,少了<%@ page %>指令