我已经做出了效果,是VB。net 做的,你转换下就可以了
Dim Dataset2 As New DataSet()
Dim sqlstr2 As String
Dim col2 As New AutoCompleteStringCollection
Dim zhonglei As String = ComboBox1.Text.ToString.Trim
Try
sqlstr2 = "SELECT * FROM GbItem "
Dataset2 = GetDataFromDB(sqlstr2)
For I = 0 To Dataset2.Tables(0).Rows.Count - 1
ComboBox1.Items.Add(Dataset2.Tables(0).Rows(I)("GBItem").ToString)
using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
using System.Web.Script.Services;//关键程序集引用
using System.Collections.Generic;//关键程序集引用
/// <summary>
/// WebService 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[ScriptService()]//一定要添加
public class WebService : System.Web.Services.WebService {
public WebService () {
//如果使用设计的组件,请取消注释以下行
//InitializeComponent();
}
[WebMethod]
[ScriptMethod]
public string[] GetProductName(string prefixText, int count)
{
List<string> suggestions=new List<string>();//声明一泛型集合
SqlConnection con = new SqlConnection("server=.;database=NorthWind;uid=sa;pwd=;");
con.Open();
SqlCommand com = new SqlCommand("select distinct productname from Products where productname like @prefixname order by productname", con);
com.Parameters.Add("@prefixname",SqlDbType.NVarChar).Value=prefixText + "%";
SqlDataReader sdr = com.ExecuteReader();
while (sdr.Read())
{
suggestions.Add(sdr.GetString(0));
}
sdr.close();
con.close();
return suggestions.ToArray();
}
}