How can I retrieve two column values using autosuggestion

Question

Hello,    I have to develop one simple program there I am using  autosuggestion textbox. So, I would like to display Two column Values in autosuggestion from table. It is possible? Please help me....

Bhuvanesh Mohankumar · Answer

I believe this can be achieved but the logic must be done by your own, https://dotnetdrizzles.blogspot.com/2015/02/autocomplete-textbox-search-database.html Here is the step by step for auto suggestion, where in above link they shown only for single data. When you retrieve the information from the data table and assign the values to local application object better combine the two column values and implement the same logic. da = new SqlDataAdapter("SELECT (FirstName + ' - ' + LastName) AS Name FROM User", conn);
dtt = new DataTable();
da.Fill(dtt); Mark as answer, if helpful.