连接到SQLserver2000的问题,急!!!
snwxf 2003-11-25 04:32:06 我要从asp.net连接到SQL2000,关键是用到的SQL语句要用程序中的变量,可是我连接后总是提示变量没有定义,请问,倒底在用有变量的SQL语句查询SQLserver时该怎么做,我的程序如下:
Sub Button1_Click(sender As Object, e As EventArgs)
Dim Conn As SqlConnection
Dim Adpt As SqlDataAdapter
'Dim Ds As DataSet
Dim Cmd As SqlCommand
Conn = New SqlConnection("server=(local);" & "database=xj;" & "user id=yh;password=snwxf1")
Conn.open()
Dim SQL = "Select password From teacher where name=@Tname"
Cmd.Parameters.Add(New SqlParameter("@Tname",SqlDbType.char))
Cmd.Parameters("@Tname").Value=Trim(name.Text)
Cmd = New SqlCommand(SQL,Conn)
其中的@Tname运行时总提示“变量没有定义”
请问如何解决?
非常感谢!