how to pass Gridview to storedProcedure. ...

Replies

Lacy
Posted on: 6/4/2012 5:15:51 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

Ashoknalam
Posted on: 6/4/2012 5:18:35 AM

Level: Starter | Status: [Member] | Points: 25

could you please explain us your requirement in detail.

Ashok Nalam

Oswaldlily, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Oswaldlily
Posted on: 6/4/2012 5:36:21 AM

Level: Starter | Status: [Member] | Points: 25

Atleast i need to pass Session["gridview"] into storedprocedure..is it possible>?

Oswaldlily, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Ndebata
Posted on: 6/4/2012 6:27:17 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

Oswaldlily
Posted on: 6/4/2012 6:28:53 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

Ajay.Kalol
Posted on: 6/4/2012 6:34:01 AM

Level: Starter | Status: [Member] | Points: 25

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.

http://ajaypatelfromsanthal.blogspot.in

Oswaldlily, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Perfect.Chourasia@Gmail.Com
Posted on: 6/8/2012 2:43:14 AM

Level: Starter | Status: [Member] | Points: 50

Keep it in Viewstate["Gridview"]

pass it in sp easily on same page...

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://sandeep-chourasia.blogspot.com/

Oswaldlily, if this helps please login to Mark As Answer. | Reply | Alert Moderator

how to pass Gridview to storedProcedure.

Replies

Reply - Please login to reply

Latest Posts