Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 stored procedure and view

Author  Topic 

pritibadami
Starting Member

1 Post

Posted - 2010-12-29 : 10:09:33
hi,

i am using VS 2010 with c sharp and sql server 2008.
i wanna set paging facility in DataGridview control.

i have my stored procedure with few input parameter. and i have one another query for paging facility. my question is:

how can i use stored procedure's records in view?

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-12-29 : 12:11:52
I'm not sure what you are actually doing here. You state that you have a stored procedure and that you have another query for paging. How are the stored procedure and the query related are they related?

Again, I'm not sure what you want to do, but you could populate a table either within the stored procedure or from the results of the stored procedure and the view could use that table.

I'm not sure if sample data will help here, but can you describe your scenario in more detail? If you'd like to use sample data in your example, maybe this link will help:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -