源代码如下:<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Register Src="foot.ascx" TagName="foot" TagPrefix="uc2" %>
<%@ Register Src="top.ascx" TagName="top" TagPrefix="uc1" %>
<%@ Register Src="date_search.ascx" TagName="date_search" TagPrefix="uc3" %>
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Web.UI.WebControls" %>
<%@ Import Namespace="DATABASE" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HTML>
<HEAD runat="server">
<title>红盾网站</title>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
jdGuanZhu.DataSource=SqlClass.RunSql("select top 6 articleID,title from article order by recount desc","article");
jdGuanZhu.DataBind(); gfYaoWen.DataSource = SqlClass.RunSql("select top 6 articleID,title from article where classID=1 order by recount desc", "article");
gfYaoWen.DataBind(); hxLiangAn.DataSource = SqlClass.RunSql("select top 10 articleID,title from article where classID=2 order by recount desc", "article");
hxLiangAn.DataBind(); gfZhiShi.DataSource = SqlClass.RunSql("select top 6 articleID,title from article where classID=3 order by recount desc", "article");
gfZhiShi.DataBind(); gfKeJi.DataSource = SqlClass.RunSql("select top 6 articleID,title from article where classID=4 order by recount desc", "article");
gfKeJi.DataBind();
} protected void Top1_Load(object sender, EventArgs e)
{ } protected void gfKeJi_SelectedIndexChanged(object sender, EventArgs e)
{ }
编译错误信息如下:“/Web05”应用程序中的服务器错误。
--------------------------------------------------------------------------------编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。 编译器错误信息: CS0246: 找不到类型或命名空间名称“DATABASE”(是否缺少 using 指令或程序集引用?)源错误: 行 6: <%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
行 7: <%@ Import Namespace="System.Web.UI.WebControls" %>
行 8: <%@ Import Namespace="DATABASE" %> //就是这里出错!
行 9: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
行 10: <HTML>
源文件: D:\website\asp.net\Web05\index.aspx 行: 8 DATABASE.cs放在同级目录下的,我用的编程平台是vs2003,数据库系统是MS SQL 2000,这是怎么回事,请高手给看看,感激不尽!
<%@ Import Namespace="System.Data" %>
<%@ Register Src="foot.ascx" TagName="foot" TagPrefix="uc2" %>
<%@ Register Src="top.ascx" TagName="top" TagPrefix="uc1" %>
<%@ Register Src="date_search.ascx" TagName="date_search" TagPrefix="uc3" %>
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Web.UI.WebControls" %>
<%@ Import Namespace="DATABASE" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HTML>
<HEAD runat="server">
<title>红盾网站</title>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
jdGuanZhu.DataSource=SqlClass.RunSql("select top 6 articleID,title from article order by recount desc","article");
jdGuanZhu.DataBind(); gfYaoWen.DataSource = SqlClass.RunSql("select top 6 articleID,title from article where classID=1 order by recount desc", "article");
gfYaoWen.DataBind(); hxLiangAn.DataSource = SqlClass.RunSql("select top 10 articleID,title from article where classID=2 order by recount desc", "article");
hxLiangAn.DataBind(); gfZhiShi.DataSource = SqlClass.RunSql("select top 6 articleID,title from article where classID=3 order by recount desc", "article");
gfZhiShi.DataBind(); gfKeJi.DataSource = SqlClass.RunSql("select top 6 articleID,title from article where classID=4 order by recount desc", "article");
gfKeJi.DataBind();
} protected void Top1_Load(object sender, EventArgs e)
{ } protected void gfKeJi_SelectedIndexChanged(object sender, EventArgs e)
{ }
编译错误信息如下:“/Web05”应用程序中的服务器错误。
--------------------------------------------------------------------------------编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。 编译器错误信息: CS0246: 找不到类型或命名空间名称“DATABASE”(是否缺少 using 指令或程序集引用?)源错误: 行 6: <%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
行 7: <%@ Import Namespace="System.Web.UI.WebControls" %>
行 8: <%@ Import Namespace="DATABASE" %> //就是这里出错!
行 9: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
行 10: <HTML>
源文件: D:\website\asp.net\Web05\index.aspx 行: 8 DATABASE.cs放在同级目录下的,我用的编程平台是vs2003,数据库系统是MS SQL 2000,这是怎么回事,请高手给看看,感激不尽!
2.0要放App_Code下
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls;namespace DATABASE
{
//此类用于执行传入的SQL语句
public class SqlClass
{
//执行所给的SQL语句“sqlStr”,不返回任何值,主要用于INSERT,DELETE,UPDATE等操作
public static void RunSql(string sqlStr)
{
string cnnStr=ConfigurationSettings.AppSettings["cnnStr"];
SqlConnection cnn=new SqlConnection(cnnStr);
cnn.Open();
SqlCommand cmd=new SqlCommand(sqlStr,cnn);
cmd.ExecuteNonQuery();
cnn.Close();
}
//重载:有返回值的操作,主要是SELECT操作
//执行所给的SQL语句“SqlStr”,并将执行结果填充到DataSet对象的“tblName”表中
public static DataTable RunSql(string sqlStr, string tblName)
{
string cnnStr=ConfigurationSettings.AppSettings["ConnectStr"];
SqlConnection cnn=new SqlConnection(cnnStr);
cnn.Open();
SqlCommand cmd=new SqlCommand(sqlStr,cnn);
SqlDataAdapter dap=new SqlDataAdapter(cmd);
DataSet dst=new DataSet();
dap.Fill(dst,tblName);
cnn.Close();
return dst.Tables[tblName];
}
}
public class GridClass
{
//此方法用于把表“tblName”绑显示到DataGrid控件“grid”
public static void BindGrid(DataGrid grid, string tblName)
{
string cnnStr = ConfigurationSettings.AppSettings["ConnectStr"];
SqlConnection cnn = new SqlConnection(cnnStr);
cnn.Open();
SqlCommand cmd = new SqlCommand("select * from " + tblName + "", cnn);
cmd.CommandText = "select * from " + tblName + "";
SqlDataAdapter dap = new SqlDataAdapter(cmd);
DataSet dst = new DataSet();
dap.Fill(dst, "article");
// dgdUsers.DataSource=dst.Tables["article"];
grid.DataSource = cmd.ExecuteReader();
grid.DataBind();
cnn.Close();
}
}}
net_lover(【孟子E章】)说的“放App_Code下”,我刚试了,也不行啊!