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
Nel
NA
716
1.1m
Problem with filling the dataset with OleDBDataAdapter
Dec 1 2011 3:00 PM
Hello,
I have a dataset with three data tables. And my database is in MS Access. I fill all of them with separate OleDBDataAdapters. But when I run the windows form it returns empty crystall report. In fact when debugging, I see that the dataset is empty, all of the tables remain empty.
Here are the select strings that I use to fill the datatables:
1. For filling the first table "baraniotselect1" in the dataset I use this select
SELECT MAGACIN.GBR, [@data1] AS Datapoc, [@data2] AS Datakr, Sum(IIf([MAGACIN.SIFRA]="0992201",MAGACIN.KOL,0)) AS Addblue, Sum(IIf([MAGACIN.SIFRA]="0999001",MAGACIN.KOL,0)) AS Antifriz, Sum(IIf([MAGACIN.SIFRA]="0991000",MAGACIN.KOL,0)) AS Gorivo, Sum(IIf((([MAGACIN.SIFRA])="0993050" Or ([MAGACIN.SIFRA])="0993051"),MAGACIN.KOL,0)) AS Motmaslo, Round(((Sum(IIf(([MAGACIN.SIFRA]="0992201") And ([MAGACIN.DATA]>=[@data1]) And ([MAGACIN.DATA]<=[@data2]) And ([MAGACIN.GBR] Between [@gbr1] And [@gbr2]) And ((NOVI.AB)=[@ab1] or (NOVI.AB)=[@ab2]) ,[MAGACIN.KOL],0))/(Sum(IIf(([MAGACIN.SIFRA]="0991000") And ([MAGACIN.DATA]>=[@data1]) And ([MAGACIN.DATA]<=[@data2]) And ((NOVI.AB)=[@ab1] or (NOVI.AB)=[@ab2]),[MAGACIN.KOL],0))))*100),2) AS Addbluegor
FROM NOVI INNER JOIN MAGACIN ON NOVI.GBR = MAGACIN.GBR
WHERE (((MAGACIN.DATA) Between [@data1] And [@data2]) AND ((MAGACIN.GBR) Between [@gbr1] And [@gbr2]) AND ((NOVI.AB)=[@ab1] or (NOVI.AB)=[@ab2]) )
GROUP BY MAGACIN.GBR
HAVING ((Sum(IIf([MAGACIN.SIFRA]="0991000",[MAGACIN].[KOL],0))>0));
2. For filling the second table "PocKrajRazl" in the dataset I use:
SELECT NALOG1.GBRV, Min(IIf(([NALOG1.DATA]>=[@data1]) And ([NALOG1.DATA]<=[@data2]) And ([NALOG1].[POCKM]>0) And ([NALOG1.GBRV] Between [@gbr1] And [@gbr2]),[NALOG1.POCKM],Null)) AS pockm, Max(IIf(([NALOG1.DATA]>=[@data1]) And ([NALOG1.DATA]<=[@data2]) And ([NALOG1.GBRV] Between [@gbr1] And [@gbr2]),[NALOG1.KRAJKM],Null)) AS krajkm, (Max(IIf(([NALOG1.DATA]>=[@data1]) And ([NALOG1.DATA]<=[@data2]) And ([NALOG1.GBRV] Between [@gbr1] And [@gbr2]),[NALOG1.KRAJKM],Null))-Min(IIf(([NALOG1.DATA]>=[@data1]) And ([NALOG1.DATA]<=[@data2]) And ([NALOG1].[POCKM]>0),[NALOG1.POCKM],Null))) AS RAZLIKA, Max(NOVI.DATAP) AS Poslprov, Max(NOVI.DATAS) AS Poslserv, Sum(NALOG1.KM) AS SUMKM, IIf([SUMKM]>=(([NOVI].[KMS1]+[NOVI].[KMS2])-1000),"ZA SERVIS",
(IIf(Sum(NALOG1.KM)>=(([NOVI].[KMP1]+[NOVI].[KMP2])-1000),"PROVERKA",""))) AS Zabeleska
FROM NALOG1 INNER JOIN NOVI ON NALOG1.GBRV = NOVI.GBR
WHERE ((NOVI.AB)=[@ab1] or (NOVI.AB)=[@ab2]) AND ( (NALOG1.GBRV)>=[@gbr1] And (NALOG1.GBRV)<=[@gbr2] )
GROUP BY NALOG1.GBRV, NOVI.KMP1, NOVI.KMP2, NOVI.KMS1, NOVI.KMS2;
in my C# windows form.
And I use these selects i.e. tables to fill the third table with this select:
SELECT baraniotselect1.GBR, baraniotselect1.Datapoc, baraniotselect1.Datakr, baraniotselect1.Gorivo, PocKrajRazl.SUMKM, ROUND(((baraniotselect1.Gorivo/PocKrajRazl.SUMKM)*100),2) AS Prospotrgor, baraniotselect1.Addblue, baraniotselect1.Addbluegor, baraniotselect1.Antifriz, baraniotselect1.Motmaslo, PocKrajRazl.pockm, PocKrajRazl.krajkm, PocKrajRazl.RAZLIKA, PocKrajRazl.Poslprov, PocKrajRazl.Poslserv, PocKrajRazl.Zabeleska
FROM baraniotselect1 LEFT JOIN PocKrajRazl ON baraniotselect1.GBR = PocKrajRazl.GBRV;
Can anybody tell me please what am I doing wrong? Why the dataset remains empty?
I appreciate any help a lot
Reply
Answers (
2
)
Please help in fixing this compliation error
How to find specific record from database table in C#Net