have to show the supplierName instead of its Code in a Gridview

hi aamir, u need to JOin the tables in order to retrieve the supplierName,

u can achive this using Select Statement with Inner join

suppose there are two table
1) SupplierMaster [with fileds]
i.Inv_id
ii. sName
iii. othersfields

2) bill [with fileds]
i. billno
ii.inv_id
iii. other fields

--------------------
Your SQL select Statement will look like this

SELECT a.billno AS [Bill no], b.sName AS [Supplier] FROM bill AS a INNER JOIN SupplierMaster AS B on a.inv_id=b.inv_id

use this query to bind ur grid

and let me know u found the solution or not

dear friends,
i have made some changes in my Stored Procedure for Filling the Gridview and now its working F9.

Regards,
Aamir