ASP.NET - Can we send class object to Stored Procedure

Asked By balaji mogadali on 07-May-12 07:45 AM
hi frds

can we send class object to Stored Procedure

pls help 
Ramendra Kumar replied to balaji mogadali on 07-May-12 07:52 AM
no, sp can take a value of type int string and whatever data types available in sqlserver
Venkat K replied to balaji mogadali on 07-May-12 07:57 AM
Yes, I would suggest you to serialize the object to an XML string pass it to the stored procedure. From within your stored procedure you can extract the information from the XML parameters.

Thanks

Suchit shah replied to balaji mogadali on 07-May-12 08:35 AM
Yes you can be able to do it i would suggest you to do by

pass it as string to stored procedure and leave it as windows identity type in asp.net, then it works.

Try it and let me know