Congratulations to all monthly winners of May 2013 !!! They have won INR 2900 cash and INR 27497 worth prize.
DotNetFunda.Com Logo
Twitter TwitterLinkedIn
YouTubeGoogle
 Online : 7984 |  Welcome, Guest!   Register  Login
 Home > Forums > ASP.NET > how to pass Gridview to storedProcedure. ...
Oswaldlily

how to pass Gridview to storedProcedure.

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


I need to pass Gridview to storedProcedure.

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


Reply | Reply with attachment | Alert Moderator

 Responses below this adGet hundreds of .NET Tips and Tricks videos

 Replies

Lacy
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
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
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
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
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
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
Perfect.Chourasia@Gmail.Com  
Posted on: 6/8/2012 2:43:14 AM
Level: Starter | Status: [Member] | Points: 50

Resolved

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 

Reply - Please login to reply


Click here to login & reply

Found interesting? Add this to:


 Latest Posts

Write New Post | More ...

About Us | Contact Us | The Team | Advertise | Software Development | Write for us | Testimonials | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 6/18/2013 12:40:10 AM