I am using llblgen version 2.5 with adapter and visual studio 2005 with sql server 2005.

i had created a stored procedure and then viewing portion of its data in the webform with a gridview. Now i want when the user selects that row the its detail should be shown for editing. How can i filter a stored procedure. At the moment iam doing this:

gridunupdated.DataSource = RetrievalProcedures.ManualInvoice(); gridunupdated.DataBind();

now i want to filter that stored procedure... create a function ......somethg like that sort.

sugesstions please

Do you want to-fetch data (filtered) from the database?

Otherwise it's just .NET coding, since a SP returns a dataTable, grab the selected indexd and extract the corresponding DataRow from the DataTable, by casting the gridunupdated.DataSource.