thegman54
August 8th, 2002, 01:19 PM
I seem to be having trouble configuring a SQLDataadapter on a new form for an existing sotred procedure
when i try to configure I get to the screen that binds select , insert, update, and delete to sp's and ....
I thought since my sp_ is just a select statement returning a record set that all i need to bind is the select statement .. but when i finish it says failed to get schema for stored procedure...
if you go back to the binding screen its weird that when you put my sp_ in the select box I get no parameters next to it.. but when you put my sp_ in the insert, update, delete.. i get my parameter next to those entries.. just not in the select entry...
I dont know where im going wrong.. if there is an easier way to retrieve the record set from my stored procedure and display it in a datagrid on a new form please tell me...
Im lost and would appreciate any help...
Thanx :)
when i try to configure I get to the screen that binds select , insert, update, and delete to sp's and ....
I thought since my sp_ is just a select statement returning a record set that all i need to bind is the select statement .. but when i finish it says failed to get schema for stored procedure...
if you go back to the binding screen its weird that when you put my sp_ in the select box I get no parameters next to it.. but when you put my sp_ in the insert, update, delete.. i get my parameter next to those entries.. just not in the select entry...
I dont know where im going wrong.. if there is an easier way to retrieve the record set from my stored procedure and display it in a datagrid on a new form please tell me...
Im lost and would appreciate any help...
Thanx :)