UC知道懂ASP.net请进!
来源：百度知道 编辑：UC知道 时间：2024/06/09 10:18:27
看看下面哪错了，
运行后，提示：编译器错误信息: BC30451: 未声明名称“sqldbtype”。
<%@import Namespace="syste.data" %>
<%@import Namespace="system.data.sqlclient" %>
<%
Dim myconnection As SqlConnection
Dim mycommand As SqlCommand
Dim firstname As String = "robert"
Dim lastname As String = "john"
myconnection = New SqlConnection("server=localhost;uid=sa;pwd=wantgirl;database=xxsxk")
myconnection.Open()
mycommand = New SqlCommand("insert xxsxk,(firstname,lastname) values(@firstname,@lastname)", myconnection)
mycommand.CommandType = Data.CommandType.StoredProcedure
mycommand.Parameters.Add(New SqlParameter("@firstname", sqldbtype.varchar, 30))
mycommand.Parameters("@firstname").Value = firstname
mycommand.Parameters.Add(New Sql
运行后，提示：编译器错误信息: BC30451: 未声明名称“sqldbtype”。
<%@import Namespace="syste.data" %>
<%@import Namespace="system.data.sqlclient" %>
<%
Dim myconnection As SqlConnection
Dim mycommand As SqlCommand
Dim firstname As String = "robert"
Dim lastname As String = "john"
myconnection = New SqlConnection("server=localhost;uid=sa;pwd=wantgirl;database=xxsxk")
myconnection.Open()
mycommand = New SqlCommand("insert xxsxk,(firstname,lastname) values(@firstname,@lastname)", myconnection)
mycommand.CommandType = Data.CommandType.StoredProcedure
mycommand.Parameters.Add(New SqlParameter("@firstname", sqldbtype.varchar, 30))
mycommand.Parameters("@firstname").Value = firstname
mycommand.Parameters.Add(New Sql
mycommand.Parameters.Add(New SqlParameter("@firstname", sqldbtype.varchar, 30))
mycommand.Parameters("@firstname").Value = firstname
mycommand.Parameters.Add(New SqlParameter("@lastname", sqldbtype.varchar, 30))
中的sqldbtype没有声明或无对象
把sqldbtype.varchar改成System.Data.SqlDbType.VarChar
网友专家 vrhero 是对的