
As previous discussions you have to bind data with Gridview.
In this articles I am using 2 tables, Bank Table and Cheque Table
Bank Table
---------------
b_code int
b_name nchar(50)
Cheque Table
-----------------
ch_no nchar(10)
ch_bank int
For data binding to Gridview use below SQL query
SELECT Cheques.ch_no, Banks.b_name FROM Banks INNER JOIN Cheques ON Banks.b_code = Cheques.ch_bank ORDER BY Banks.b_name
After data bind...