大家来看看,帮忙解决一下这个问题啊!!!

huangbznet 2005-06-07 01:23:09
“/Wells”应用程序中的服务器错误。
--------------------------------------------------------------------------------

未找到列 [BigClassName]。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.EvaluateException: 未找到列 [BigClassName]。

源错误:


行 261: Dim classFilter As String = "BigClassName = '" & className & "'"
行 262: Dim sort As String = "ID"
行 263: Dim rows As DataRow() = dtProducts.Select(classFilter, sort)
行 264: For Each row As DataRow In rows
行 265: dtSort.ImportRow(row)


源文件: F:\Wells\Product.aspx.vb 行: 263

堆栈跟踪:


[EvaluateException: 未找到列 [BigClassName]。]
System.Data.NameNode.Bind(DataTable table, ArrayList list) +287
System.Data.BinaryNode.Bind(DataTable table, ArrayList list) +21
System.Data.DataExpression.Bind(DataTable table) +78
System.Data.DataExpression..ctor(String expression, DataTable table, Type type) +185
System.Data.Select..ctor(DataTable table, String filterExpression, String sort, DataViewRowState recordStates) +74
System.Data.DataTable.Select(String filterExpression, String sort) +35
Wells.Product.GetDataByClassName(String className) in F:\Wells\Product.aspx.vb:263
Wells.Product.BindDataList(String className, Int32 pageIndex, Int32 pageSize) in F:\Wells\Product.aspx.vb:272
Wells.Product.Page_Load(Object sender, EventArgs e) in F:\Wells\Product.aspx.vb:242
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731




--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:1.1.4322.573; ASP.NET 版本:1.1.4322.573




大家帮忙看看,急的哇!!!
...全文
83 8 打赏 收藏 转发到动态 举报
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
myvbnet 2005-06-07
  • 打赏
  • 举报
回复
原因是你的表里面没有BigClassName这个字段,检查你填充数据的地方。
huangbznet 2005-06-07
  • 打赏
  • 举报
回复
'dsTenProducts
'
Me.dsTenProducts.DataSetName = "DataSet1"
Me.dsTenProducts.Locale = New System.Globalization.CultureInfo("zh-CN")
'
'daBigClass
'
Me.daBigClass.DeleteCommand = Me.OleDbDeleteCommand2
Me.daBigClass.InsertCommand = Me.OleDbInsertCommand2
Me.daBigClass.SelectCommand = Me.OleDbSelectCommand2
Me.daBigClass.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "BigClass", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("BigClassID", "BigClassID"), New System.Data.Common.DataColumnMapping("BigClassName", "BigClassName")})})
Me.daBigClass.UpdateCommand = Me.OleDbUpdateCommand2
'
'OleDbDeleteCommand2
'
Me.OleDbDeleteCommand2.CommandText = "DELETE FROM BigClass WHERE (BigClassID = ?) AND (BigClassName = ? OR ? IS NULL AN" & _
"D BigClassName IS NULL)"
Me.OleDbDeleteCommand2.Connection = Me.conn
Me.OleDbDeleteCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassID", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassName", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassName", System.Data.DataRowVersion.Original, Nothing))
'
'OleDbInsertCommand2
'
Me.OleDbInsertCommand2.CommandText = "INSERT INTO BigClass(BigClassName) VALUES (?)"
Me.OleDbInsertCommand2.Connection = Me.conn
Me.OleDbInsertCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("BigClassName", System.Data.OleDb.OleDbType.VarWChar, 50, "BigClassName"))
'
'OleDbSelectCommand2
'
Me.OleDbSelectCommand2.CommandText = "SELECT BigClassID, BigClassName FROM BigClass"
Me.OleDbSelectCommand2.Connection = Me.conn
'
'OleDbUpdateCommand2
'
Me.OleDbUpdateCommand2.CommandText = "UPDATE BigClass SET BigClassName = ? WHERE (BigClassID = ?) AND (BigClassName = ?" & _
" OR ? IS NULL AND BigClassName IS NULL)"
Me.OleDbUpdateCommand2.Connection = Me.conn
Me.OleDbUpdateCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("BigClassName", System.Data.OleDb.OleDbType.VarWChar, 50, "BigClassName"))
Me.OleDbUpdateCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassID", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassName", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassName", System.Data.DataRowVersion.Original, Nothing))

Me.dsBigClass.DataSetName = "DataSet2"
Me.dsBigClass.Locale = New System.Globalization.CultureInfo("zh-CN")
CType(Me.dsTenProducts, System.ComponentModel.ISupportInitialize).EndInit()
CType(Me.dsBigClass, System.ComponentModel.ISupportInitialize).EndInit()

End Sub
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
InitializeComponent()
End Sub

#End Region
huangbznet 2005-06-07
  • 打赏
  • 举报
回复
Me.conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & HttpContext.Current.Server.MapPath("Database/DataShop.mdb")
'
'OleDbInsertCommand1
'
Me.OleDbInsertCommand1.CommandText = "INSERT INTO TenProduct(BigClassName, Name, Num, PicURL) VALUES (?, ?, ?, ?)"
Me.OleDbInsertCommand1.Connection = Me.conn
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("BigClassName", System.Data.OleDb.OleDbType.VarWChar, 200, "BigClassName"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 200, "Name"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Num", System.Data.OleDb.OleDbType.VarWChar, 100, "Num"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("PicURL", System.Data.OleDb.OleDbType.VarWChar, 225, "PicURL"))
'
'OleDbSelectCommand1
'
Me.OleDbSelectCommand1.CommandText = "SELECT ID, BigClassName, Name, Num, PicURL FROM TenProduct ORDER BY ID"
Me.OleDbSelectCommand1.Connection = Me.conn
'
'OleDbUpdateCommand1
'
Me.OleDbUpdateCommand1.CommandText = "UPDATE TenProduct SET BigClassName = ?, Name = ?, Num = ?, PicURL = ? WHERE (ID =" & _
" ?) AND (BigClassName = ? OR ? IS NULL AND BigClassName IS NULL) AND (Name = ? O" & _
"R ? IS NULL AND Name IS NULL) AND (Num = ? OR ? IS NULL AND Num IS NULL) AND (Pi" & _
"cURL = ? OR ? IS NULL AND PicURL IS NULL)"
Me.OleDbUpdateCommand1.Connection = Me.conn
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("BigClassName", System.Data.OleDb.OleDbType.VarWChar, 200, "BigClassName"))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 200, "Name"))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Num", System.Data.OleDb.OleDbType.VarWChar, 100, "Num"))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("PicURL", System.Data.OleDb.OleDbType.VarWChar, 225, "PicURL"))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassName", System.Data.OleDb.OleDbType.VarWChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassName", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassName1", System.Data.OleDb.OleDbType.VarWChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassName", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Name", System.Data.OleDb.OleDbType.VarWChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Name", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Name1", System.Data.OleDb.OleDbType.VarWChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Name", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Num", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Num", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Num1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Num", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_PicURL", System.Data.OleDb.OleDbType.VarWChar, 225, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PicURL", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_PicURL1", System.Data.OleDb.OleDbType.VarWChar, 225, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PicURL", System.Data.DataRowVersion.Original, Nothing))
'
huangbznet 2005-06-07
  • 打赏
  • 举报
回复
Public Class Product
Inherits System.Web.UI.Page
Protected WithEvents LblName As System.Web.UI.WebControls.Label
Protected WithEvents DLDesign As System.Web.UI.WebControls.DataList
Protected WithEvents UserName As System.Web.UI.HtmlControls.HtmlInputText
Protected WithEvents PassWord As System.Web.UI.HtmlControls.HtmlInputText
Protected WithEvents LabNoRecord As System.Web.UI.WebControls.Label
Protected WithEvents LabPage As System.Web.UI.WebControls.Label
Protected WithEvents DLProduct As System.Web.UI.WebControls.DataList
'Protected WithEvents DLProduct As System.Web.UI.WebControls.DataGrid
Protected WithEvents LabPage2 As System.Web.UI.WebControls.Label
Protected WithEvents selectType As System.Web.UI.WebControls.DropDownList
Protected WithEvents DataList1 As System.Web.UI.WebControls.DataList
Protected WithEvents btnPrev As System.Web.UI.WebControls.LinkButton
Protected WithEvents dlPageSize As System.Web.UI.WebControls.DataList
Protected WithEvents btnNext As System.Web.UI.WebControls.LinkButton
Protected WithEvents drListClass As System.Web.UI.WebControls.DropDownList
Protected WithEvents lblResult As System.Web.UI.WebControls.Label
Protected WithEvents lblPageNO As System.Web.UI.WebControls.Label
Protected WithEvents OleDbSelectCommand1 As System.Data.OleDb.OleDbCommand
Protected WithEvents OleDbInsertCommand1 As System.Data.OleDb.OleDbCommand
Protected WithEvents OleDbUpdateCommand1 As System.Data.OleDb.OleDbCommand
Protected WithEvents OleDbDeleteCommand1 As System.Data.OleDb.OleDbCommand
Protected WithEvents dsTenProducts As Wells.DataSet1
Protected WithEvents daBigClass As System.Data.OleDb.OleDbDataAdapter
Protected WithEvents OleDbSelectCommand2 As System.Data.OleDb.OleDbCommand
Protected WithEvents OleDbInsertCommand2 As System.Data.OleDb.OleDbCommand
Protected WithEvents OleDbUpdateCommand2 As System.Data.OleDb.OleDbCommand
Protected WithEvents OleDbDeleteCommand2 As System.Data.OleDb.OleDbCommand
Protected WithEvents dsBigClass As Wells.DataSet2
Protected WithEvents conn As System.Data.OleDb.OleDbConnection
Protected WithEvents daTenProduct As System.Data.OleDb.OleDbDataAdapter
'Protected WithEvents selectType As System.Web.UI.HtmlControls.HtmlSelect
Public StrType As String


#Region " Web 窗体设计器生成的代码 "

'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.daTenProduct = New System.Data.OleDb.OleDbDataAdapter
Me.OleDbDeleteCommand1 = New System.Data.OleDb.OleDbCommand
Me.conn = New System.Data.OleDb.OleDbConnection
Me.OleDbInsertCommand1 = New System.Data.OleDb.OleDbCommand
Me.OleDbSelectCommand1 = New System.Data.OleDb.OleDbCommand
Me.OleDbUpdateCommand1 = New System.Data.OleDb.OleDbCommand
Me.dsTenProducts = New Wells.DataSet1
Me.daBigClass = New System.Data.OleDb.OleDbDataAdapter
Me.OleDbDeleteCommand2 = New System.Data.OleDb.OleDbCommand
Me.OleDbInsertCommand2 = New System.Data.OleDb.OleDbCommand
Me.OleDbSelectCommand2 = New System.Data.OleDb.OleDbCommand
Me.OleDbUpdateCommand2 = New System.Data.OleDb.OleDbCommand
Me.dsBigClass = New Wells.DataSet2
CType(Me.dsTenProducts, System.ComponentModel.ISupportInitialize).BeginInit()
CType(Me.dsBigClass, System.ComponentModel.ISupportInitialize).BeginInit()
'
'daTenProduct
'
Me.daTenProduct.DeleteCommand = Me.OleDbDeleteCommand1
Me.daTenProduct.InsertCommand = Me.OleDbInsertCommand1
Me.daTenProduct.SelectCommand = Me.OleDbSelectCommand1
Me.daTenProduct.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "TenProduct", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("BigClassName", "BigClassName"), New System.Data.Common.DataColumnMapping("Name", "Name"), New System.Data.Common.DataColumnMapping("Num", "Num"), New System.Data.Common.DataColumnMapping("PicURL", "PicURL")})})
Me.daTenProduct.UpdateCommand = Me.OleDbUpdateCommand1
'
'OleDbDeleteCommand1
'
Me.OleDbDeleteCommand1.CommandText = "DELETE FROM TenProduct WHERE (ID = ?) AND (BigClassName = ? OR ? IS NULL AND BigC" & _
"lassName IS NULL) AND (Name = ? OR ? IS NULL AND Name IS NULL) AND (Num = ? OR ?" & _
" IS NULL AND Num IS NULL) AND (PicURL = ? OR ? IS NULL AND PicURL IS NULL)"
Me.OleDbDeleteCommand1.Connection = Me.conn
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassName", System.Data.OleDb.OleDbType.VarWChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassName", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_BigClassName1", System.Data.OleDb.OleDbType.VarWChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BigClassName", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Name", System.Data.OleDb.OleDbType.VarWChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Name", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Name1", System.Data.OleDb.OleDbType.VarWChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Name", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Num", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Num", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Num1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Num", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_PicURL", System.Data.OleDb.OleDbType.VarWChar, 225, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PicURL", System.Data.DataRowVersion.Original, Nothing))
Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_PicURL1", System.Data.OleDb.OleDbType.VarWChar, 225, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PicURL", System.Data.DataRowVersion.Original, Nothing))
'
yjjandgxm 2005-06-07
  • 打赏
  • 举报
回复
VB代码看得吃力!
yjjandgxm 2005-06-07
  • 打赏
  • 举报
回复
掐B,没有找到列 [BigClassName]期 你没有设定这个列吗?
wxqq2001 2005-06-07
  • 打赏
  • 举报
回复
监视你的dtProducts
wxqq2001 2005-06-07
  • 打赏
  • 举报
回复
错误已经很清楚了:

未找到列 [BigClassName]

16,549

社区成员

发帖
与我相关
我的任务
社区描述
VB技术相关讨论,主要为经典vb,即VB6.0
社区管理员
  • VB.NET
  • 水哥阿乐
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧