怎么样才能使vb 传变量@userid = Textbox1.text

[liyingzi]

Dim @userid As String
@userid = Textbox1.text

Dim conn As New SqlConnection("data source=liming;initial catalog=zls;uid=sa;pwd=;")
Dim asapter As New SqlDataAdapter("select * whereuserid=@userid order by w.id", conn)
Dim mydataset As New DataSet()

[liyingzi]

"+Textbox1.text+"

[hc8112_boy]

你用的什么，这一句不报错？？
Dim @userid As String


---------------
dim userid as string
userid=textbox1.text

然后找一下sqlcommand.parameters.Add的资料

[ConanKid]

@useid是T-SQL的声明方法,你用在VB.NET中?你把两种语言混淆了.建议你直接用:("select * whereuserid=" textbox1.text "order by w.id", conn)

[steven_srl]

"select * whereuserid=@userid order by w.id"
里面是字符串,@userid怎么可能传递过去

"select * whereuserid="+ textbox1.text +"order by w.id"
字符串的连接,这样可以保证得到textbox1里的数据.最好是用textbox1.text.trim

[chuxue1342]

Dim @userid As String
@userid = Textbox1.text
------------------------------------------
申明变量都有错!@在C#里面是一个转义符号,在VB.NET不用
还有,变量连接,vb.net中用&,也可以用+,你改一下:

        Dim userid As String  
        userid = Textbox1.text 
        Dim conn As New SqlConnection("data source=liming;initial catalog=zls;uid=sa;pwd=;") 
        Dim asapter As New SqlDataAdapter("select * whereuserid=" & userid &" order by w.id", conn) 
        Dim mydataset As New DataSet()

[rangeon]

就算你的代码不报错，这样也不对啊
Dim asapter As New SqlDataAdapter("select * whereuserid=@userid order by w.id", conn)
至少得这样
Dim asapter As New SqlDataAdapter("select * whereuserid=" + @userid + " order by w.id", conn)

[lucky749]

Dim asapter As New SqlDataAdapter("select * whereuserid='"& @userid &"' order by w.id", conn)

[HimeTale]

Dim daSelect As New SqlDataAdapter() 
daSelect.SelectCommand = New SqlCommand() 
daSelect.SelectCommand.Connection = Me.Connection 
daSelect.SelectCommand.CommandText = "Select * from table1 where Keyid=@pTYPE" 
daSelect.SelectCommand.Parameters.Clear() 
daSelect.SelectCommand.Parameters.Add("@pTYPE", SqlDbType.VarChar).Value = Textbox1.text 
'Fill 
daSelect.Fill(xxxxxx) 

千万别用daSelect.SelectCommand.CommandText="Select * from table1 where Keyid="+Textbox1.text 这种方法

[zheninchangjiang]

不是不能用
用 textbox1.text.replace("'","''")

[liyingzi]

感谢大家怎么热情