how to pass Gridview to storedProcedure. [Resolved]

Posted by Oswaldlily under ASP.NET on 6/4/2012 | Points: 10 | Views : 1885 | Status : [Member] | Replies : 7
I need to pass Gridview to storedProcedure.

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




Responses

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

Up
0
Down

Resolved
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response