searching and sorting a datagridview

[choknut]

I had a datagridview which contains all the last name of a certain database.the data was displaying properly .I want to accomplished two tasks,first I want it that upon loading on the datagrid, data are sorted alphabetically already even without pressing the column header.Second I want to search the datagrid using a text box. I want like an autocomplete manner, if I type a single letter, say "B", the datagridcolumn will automatically point to the the name say "Bal" and so on...thanks....

 

[choknut]

anyone please....

 

[q1w2e3r4t7]

datagridview

if im not mistaken, your looking for datagridview or dataview, something like that. you can filter with it.

dont have time atm to prepare an example, however hopefully that points you in the right direction.

 

[hairixe]

you can use SQL command..

SELECT * FROM DATABASE1 WHERE FIELD1 LIKE B* ORDER BY FIELD1