how to connect autocomplete textbox with database values in windowsforms(particular coloum values i need to return))

Hello ,

try this way ..

take one TextBox named as "txtinvoice" in windows application and set

AutoCompleteSource=CustomSource 

and

AutoCompleteMode=Suggest

.

Now in Codebehind take one AutoCompleteStringCollection by this way .

AutoCompleteStringCollection autocomplete = new AutoCompleteStringCollection();

and fill that collection in winform_load event .

foreach (DataRow dr in ds.Tables[0].Rows)
 {
     autocomplete.Add(dr[0].ToString());
 }
txtinvoice. AutoCompleteCustomSource = autocomplete;

here ds is Dataset , where you have to filled data from databaseand Textbox will be populated with first column of that dataset .

thanks

So, you just need to add that column to the SQL Query, which you are using to retrieve the data from database.