Right here is my sql statement that i have for the gridview.
SELECT JOBNO, Title, MAILDATE, ActMgr, PRTY FROM dbo.tblTaskJobdtl ORDER BY PRTY
How do i have in my gridview do i attache the select statement for the rows. This will populate with all the rows for that particualar jobno
Select (Column1 + Column2) As Joblist
Where Jobno='The current row in gridview'
How i do this on the fly in otherwords how do i pull the primary key when i use gridview. I have set DataKeyNames="JOBNO" which i my primary key