when you type a last name on the textbox with datagrid

[eiven_05]

when you type a last name on the textbox then on the datagrid,for example i ype letter "S" then the datagrid will show all the las names that starts with letter "S"

how it is???

[AndreRet]

In your sql statement the following -

"SELECT * FROM YourTableNameHere WHERE LastName LIKE 'S%'"

[ChrisPadgham]

You want to be careful doing this, it can put quite a strain on the database in a multiuser environment causing performance issues.

Order your table by LastName and use a find first to locate the first row that matches rather than requerying the table with each keystroke.

[eiven_05]

ok the letter "S" is done,,but how about when i click a command button or example it says ok how can it be ransfered in the textboxes,,the information of that particular last name???

[ChrisPadgham]

Andre provided you with the basic solution, if you are to learn it is necessary for a little bit of thinking and extrapolation by you.

[AndreRet]

Well said Chris.:)