vb.net 查询问题

[复制链接]

唏唏鉿鉿HJP

电梯直达

1^#

发表于 2009-9-14 07:52:45 | 只看该作者回帖奖励

|正序浏览 |阅读模式

管理提醒：本帖被迷失执行锁定操作(2007-07-17)Protected Sub chaxun1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim str As String
Dim num1 As Integer
str = "'" & Trim(TextBox2.Text) & "'"
用户信息.ConnectionString = "Data Source=BITI-E724BB3AC5;Initial Catalog=grxxwz;Integrated Security=True"
用户信息.SelectCommand = "select * from 用户 where 用户_ID like '" & Trim(str) & "%'"
GridView1.DataSourceID = "用户信息"
FormView1.DataSourceID = "用户信息"
GridView1.DataBind()
FormView1.DataBind()
num1 = GridView1.Rows.Count
If num1 = 0 Then
Label1.Text = "没有你想要查找的数据！"

Else
Label1.Text = ""
End If
End Sub

用户信息.SelectCommand ="" 中间怎么写?
查询TextBox2.输入为开头的所有用户信息
[ 此贴被迷失在2007-07-17 15:07重新编辑 ]

收藏0