TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
cs cs
NA
4
0
Ado.net Century Problem for All Can you return 10 result set and show it in one table ? Answer : ??
Jul 27 2008 2:54 AM
hi Everyone :
i have 2 problems :
1- Returing Multiple Result to one table
2- calling stored procedure multiple time with differernt value
both problem connected to each other i will show yo how >>>
developing tool : VS2005 C#
database tool : sql server 2005
database has :
entry : table name
( all below cols in one table entry )
main_name : sold item
cost : cost of item
daydate : the date of selling
What i want ?
i want my datagridview to reutrn this results from store procedure :
Year Year Year
item 2007 2006 2008
------------------------------------------
cds 430$ 500$ 100$
Dvds 1000$ 200$ 600$
i am able to show one result at a time using this query :
select main_item , sum (cost ) form entry where datepart(yyyy,daydate) = @passyear
group by main_item
but if i try to show multiple selecte quere only one result is shown in datagrideview :
i tryed all possiblity like to solve this issus :
-dataReader.NextRow(); useless
-Union ; freak
-dataset with different table ugly way if i have 12 result then createing 12 table is painfull ; true
12 hours of searching no use no one give even 10 % of the soultion could you please help me
Hope to hear form you soon ...
thanks in advance guys ...
cszaidan
Reply
Answers (
3
)
What is silverlight
Display a Splash Screen ahead of Installation