Retrieve DataGrid data
Posted on 2004-10-08
I have import Excel (.xls) data records into DataGrid, eg;
2222 CDS321 -----------> in 1st DataGrid
Let say if I have 2nd DataGrid, if user use the barcode scanner scan the Cin# last 4 digits number are match to the 1111, then the 2nd DataGrid will automatically display the data, eg;
if the user scan this Cin# 'XABNC1111' then the 2nd Datagrid in the 1st row will display this;
Cin# Batch# Chassis#
XABNC1111 1111 ABC123 -----> 2nd DataGrid
My questions is;
1. How do I retrieve the data from 1st DataGrid when the user scan the Cin#? A row of record must immediately display in the 2nd DataGrid when finished scan. How do I write a code? SQL? This is possible? Can sent me a sample code?
2. Bacause the Cin# is XABNC1111 and it need to match the Batch# 1111, only match the last 4 digits, if use sql to call, is possible? how?