how to pass Gridview to storedProcedure. [Resolved]

Posted by Oswaldlily under ASP.NET on 6/4/2012 | Points: 10 | Views : 2720 | Status : [Member] | Replies : 7

I need to pass Gridview to storedProcedure.

What is the datatype of gridview i need to use in SP?

[Resolved]

Reply | Reply with Attachment

Posted by: perfectchourasia-9163 on: 6/8/2012 [Member] Starter | Points: 50

0	Keep it in Viewstate["Gridview"] pass it in sp easily on same page... ER sandeep chourasia sandeepchrs@yahoo.com (on facebook) http://www.aspnetcodes.com/ Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Lacy on: 6/4/2012 [Member] Starter | Points: 25

0	Hi, I do not know your situation clearly and I only know Draw Grid in PDF, please look at the below method: http://www.e-iceblue.com/Knowledgebase/Spire.PDF/Demos/Grid.html May be it can help you! Lacy Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ashoknalam on: 6/4/2012 [Member] Starter | Points: 25

0	could you please explain us your requirement in detail. Ashok Nalam Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Oswaldlily on: 6/4/2012 [Member] Starter | Points: 25

0	Atleast i need to pass Session["gridview"] into storedprocedure..is it possible>? Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ndebata on: 6/4/2012 [Member] Starter | Points: 25

0	No it is not possible. Instead you pass a datatable to stored procedure if you are using sql server 2008 or above. Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Oswaldlily on: 6/4/2012 [Member] Starter | Points: 25

0	oh thn how to pass datatable to storedprocedure.. what is the datatype of datatable in SP Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ajay.Kalol on: 6/4/2012 [Member] Starter | Points: 25

0	as per My Knowledge You can't Pass whole DataTable in SP as Parameter But You can make Bulk Insert in Database Using DataTable. You can Pass Table in Sql Server 2008 & above as You have to define Table value Datatype for that then you can use it. Ajay ajaypatelfromsanthal.blogspot.in Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts