Set Location of ListView below DataGridView Active Row

[ahmed_one]

ools: Visual Studio 2010 Ultimate, Language C#, Database MySql

Hi,

I am searching this a while, but to date didn't find any suitable solution.

I've a form with bound DataGridView with 5 columns, ProductID, ProductName, Qty, Price and Amount. After normal data entry user can click button to save data to Mysql database, no problem there.

At present user is manually enter ProductID after which an Sql command is executed to fetch ProductName and sets it to DataGridView ProductName Column. I need a way to show a ListView below ProductID column when it got focus, so that user can select product (ProductID and ProductName) from ListView and set it to DataGridView's Row which user is currently using.

Is it possible to show listview below ProductID cell when user click or when got focus?

Thanks

Ahmed