id=1 name=james id=2 name=james
textBox1.AutoCompleteMode = AutoCompleteMode.Suggest; textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource; textBox1.AutoCompleteCustomSource = namesCollection; SqlDataReader dReader; SqlConnection conn = new SqlConnection("Data Source = .\\SQLEXPRESS; Initial catalog = smart_phone_book; Integrated Security = true"); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "Select distinct Name from smart_book" + " order by Name "; conn.Open(); dReader = cmd.ExecuteReader(); if (dReader.HasRows == true) { while (dReader.Read()) namesCollection.Add(dReader["Name"].ToString()); }
cmd.CommandText = "Select Name from smart_book" + " order by Name ";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)