请大家帮忙解决一下啊!我实在找不出该怎么做了?运行时出现以下错误:(在错误中‘Nindex’是我在数据表中输入的Nodeid数据)
System.Data.SqlClient.SqlException: 列名 'Nindex' 无效。 46error:System.Data.SqlClient.SqlException: 将 varchar 值 'Nindex ' 转换为数据类型为 int 的列时发生语法错误。 其中我的数据库表中,id int 自动编号
Nodeid char(30) 节点名称
Nodetext varchar(50) 节点文字
parentNodeid char(30) 父节点名称相关代码如下:
Sub BindNode(ByVal nds As Microsoft.Web.UI.WebControls.TreeNodeCollection, ByVal parentnodeid As String) Dim conn As New SqlConnection("user id=sa;password=123456;data source=(local);persist security info=False;initial catalog=niit")
Dim strsql As String = "select * from bookinfo where parentNodeid=" & parentNodeid
Dim cmd As New SqlCommand(strsql, conn)
conn.Open() Try
Dim dr As SqlDataReader = cmd.ExecuteReader Do While dr.Read Dim tempNode As New Microsoft.Web.UI.WebControls.TreeNode
tempNode.ID = Trim(dr.Item("Nodeid"))
tempNode.Text = Trim(dr.Item("Nodetext")) nds.Add(tempNode) Call BindNode(tempNode.Nodes, Trim(dr.Item("Nodeid"))) Loop Catch ex As Exception
Response.Write("error:" + ex.ToString)
End Try conn.Close()
End Sub
System.Data.SqlClient.SqlException: 列名 'Nindex' 无效。 46error:System.Data.SqlClient.SqlException: 将 varchar 值 'Nindex ' 转换为数据类型为 int 的列时发生语法错误。 其中我的数据库表中,id int 自动编号
Nodeid char(30) 节点名称
Nodetext varchar(50) 节点文字
parentNodeid char(30) 父节点名称相关代码如下:
Sub BindNode(ByVal nds As Microsoft.Web.UI.WebControls.TreeNodeCollection, ByVal parentnodeid As String) Dim conn As New SqlConnection("user id=sa;password=123456;data source=(local);persist security info=False;initial catalog=niit")
Dim strsql As String = "select * from bookinfo where parentNodeid=" & parentNodeid
Dim cmd As New SqlCommand(strsql, conn)
conn.Open() Try
Dim dr As SqlDataReader = cmd.ExecuteReader Do While dr.Read Dim tempNode As New Microsoft.Web.UI.WebControls.TreeNode
tempNode.ID = Trim(dr.Item("Nodeid"))
tempNode.Text = Trim(dr.Item("Nodetext")) nds.Add(tempNode) Call BindNode(tempNode.Nodes, Trim(dr.Item("Nodeid"))) Loop Catch ex As Exception
Response.Write("error:" + ex.ToString)
End Try conn.Close()
End Sub
解决方案 »
- vs2010中文版开发环境,对象浏览器描述注释都变成英文啦?
- 如何在屏幕正中间弹出一个网页对话框?
- |zyciis| 如何用正则将 "/Product/ProductView/1235.shtml" 转为 "/Product/ProductView.aspx?ID=1235"
- 关于梅花雨日历控件的问题???????
- 连不上oracle9i,急啊!
- asp.net打包部署中对用户界面的控制?
- gridview中添加,运行时可输入文字的textbox,后台判断textbox change时做一些操作
- 如何控制datagrid钟某一列显示的数据只有两位小数?
- javascript脚本乱码?
- 跪求电子版的《过河卒》《JAVA夜未眠》
- PDF 文件格式想在网页上显示什么应该怎么做谢谢??
- asp.net2.0连接配置
Dim strsql As String = "select * from bookinfo where parentNodeid=" & parentNodeid
Dim cmd As New SqlCommand(strsql, conn)
conn.Open() Try
Dim dr As SqlDataReader = cmd.ExecuteReader Do While dr.Read Dim tempNode As New Microsoft.Web.UI.WebControls.TreeNode
tempNode.ID = Trim(dr.Item("Nodeid"))
tempNode.Text = Trim(dr.Item("Nodetext")) nds.Nodes.Add(tempNode) Call BindNode(tempNode.Nodes, Trim(dr.Item("Nodeid"))) Loop Catch ex As Exception
Response.Write("error:" + ex.ToString)
End Try conn.Close()
End Sub