我想textbox输入前面几个字,就能在数据库查询出相关的给用户选择,请问怎么实现?谢谢
我以前vb.net做的代码如下,但在asp不能用
DS1 = New DataSet
Sqlstr = "select * from table"
MyCommand = New System.Data.SqlClient.SqlDataAdapter(Sqlstr, MyConnection)
MyCommand.Fill(DS1)
Dim strings As New AutoCompleteStringCollection()
If DS1.Tables(0).Rows.Count > 0 Then
For i = 0 To DS1.Tables(0).Rows.Count - 1
strings.Add(DS1.Tables(0).Rows(i).Item(2).ToString)
Next
End If txt_pm1.AutoCompleteCustomSource = strings
txt_pm1.AutoCompleteSource = AutoCompleteSource.CustomSource
txt_pm1.AutoCompleteMode = AutoCompleteMode.Suggest
我以前vb.net做的代码如下,但在asp不能用
DS1 = New DataSet
Sqlstr = "select * from table"
MyCommand = New System.Data.SqlClient.SqlDataAdapter(Sqlstr, MyConnection)
MyCommand.Fill(DS1)
Dim strings As New AutoCompleteStringCollection()
If DS1.Tables(0).Rows.Count > 0 Then
For i = 0 To DS1.Tables(0).Rows.Count - 1
strings.Add(DS1.Tables(0).Rows(i).Item(2).ToString)
Next
End If txt_pm1.AutoCompleteCustomSource = strings
txt_pm1.AutoCompleteSource = AutoCompleteSource.CustomSource
txt_pm1.AutoCompleteMode = AutoCompleteMode.Suggest
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货