Loading

How to Make Autocomplete from database sql?

How to Make Autocomplete from database sql?

Amrul Hakim

9y873Learn iOS Programming

This my code in class Fungsi

public void autocompele1(TextBox autotext)
{
conn = Koneksi.Conn;
conn.Open();
cmd = new SqlCommand("SELECT Nama_Barang FROM Tb_Barang ORDER BY Nama_Barang", conn);
try
{
Reader = cmd.ExecuteReader();
if(Reader.HasRows)
{
while (Reader.Read())
{
autotext.AutoCompleteCustomSource.Add(Reader["Nama_Barang"].ToString());
}
}
else
{
MessageBox.Show("Data Not Found");
}
}
catch(Exception ex)
{
MessageBox.Show("erorr" + ex.Message);
}
finally
{
conn.Close();
Reader.Close();
}
}

and i called in form like this

private void Form_Transaksi_Load(object sender, EventArgs e)
{
Fungsi auto = new Fungsi();
auto.autocompele1(txt_NamaBarang);
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Accepted answer
You need to bind autocomplete data to textbox. Please find below code:
private void Form1_Load(object sender, EventArgs e)
{
    string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
    using (SqlConnection con = new SqlConnection(ConString))
    {
        SqlCommand cmd = new SqlCommand("SELECT FirstName FROM Employees", con);
        con.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        AutoCompleteStringCollection MyCollection = new AutoCompleteStringCollection();
        while (reader.Read())
        {
            MyCollection.Add(reader.GetString(0));
        }
        txtFirstName.AutoCompleteCustomSource = MyCollection;
        con.Close();
    }
}
http://www.c-sharpcorner.com/UploadFile/deepak.sharma00/autosuggest-textbox-from-database-column-in-windows-forms/
https://msdn.microsoft.com/en-us/library/system.windows.forms.textbox.autocompletemode(v=vs.110).aspx
+2
Amrul Hakim9y ago
Thank you
0
Amrul Hakim9y ago
Not in asp.net.
c# Windows form
0
Manas Mohapatra9y ago
You can use jQuery to display autcompelete data with AJAX:

http://www.c-sharpcorner.com/UploadFile/da55bf/Asp-Net-autocomplete-textbox-using-jquery-json-and-ajax/

https://www.aspsnippets.com/Articles/Populate-jQuery-AutoComplete-TextBox-from-Database-using-Web-Service-in-ASPNet.aspx

http://dotnetmentors.com/aspnet/jquery-autocomplete-by-example.aspx
+2