刚刚写了一个小程序来实现C#文本框的自动提示功能 感觉挺好的 和大家分享一下
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 文本框智能提示
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string str = "";
//SqlConnection conn = new SqlConnection();
//conn.ConnectionString = "server = 10.68.69.203,81;database=cpudata;user id = sa;password = 19790601";
//conn.Open();
//SqlCommand cmd = new SqlCommand();
//cmd.CommandText = "select user_china_name from user_info";
//cmd.Connection = conn;
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataSet ds = new DataSet();
//da.Fill(ds);
//foreach (DataRow dr in ds.Tables[0].Rows)
//{
// str += "," + dr["user_china_name"];
//}
//conn.Close();
//str = str.Substring(1);
//this.textBox1.AutoCompleteCustomSource.AddRange(str.Split(','));
AutoCompleteStringCollection acsc = new AutoCompleteStringCollection();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server = 10.68.69.203,81;database=cpudata;user id = sa;password = 19790601";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select user_china_name from user_info";
cmd.Connection = conn;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
acsc.Add(dr[0].ToString());
}
dr.Close();
conn.Close();
this.textBox1.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest;
this.textBox1.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.CustomSource;
this.textBox1.AutoCompleteCustomSource = acsc;
}
}
}