hi,
It can be done in 2 ways.
Method 1:
Get the corresponding data from DB on click of the text box grid view.
Which might be slow.
or
Method 2:
1.Get the dataset from the db.
2.Store it as a datatable.
3.After you enter the product code ,
i) call a method that accepts the text as parameter.
ii)search the corresponding product name in the datatable like
datatable.select(YOUR QUERY) .
iii)Return the product name
4.display the product name returned in the textbox in grid.
Example of datatable select
DataTable table = new DataTable("Players");
table.Columns.Add(new DataColumn("Size", typeof(int)));
table.Columns.Add(new DataColumn("Sex", typeof(char)));
table.Rows.Add(100, 'f');
table.Rows.Add(235, 'f');
table.Rows.Add(250, 'm');
table.Rows.Add(310, 'm');
table.Rows.Add(150, 'm');
DataRow[] result = table.Select("Size >= 230 AND Sex = 'm'");
Hope this helps.