|
hi
i have this query in access that run's excellent ! ,I called her MyQUERY
SELECT BK_LEVEL9.Aitur AS Aitur, Sum(BK_LEVEL9.M_NewQty) AS M_NewQty, Sum(BK_LEVEL9.ErrorCount) AS ErrorCount, (IIf([M_NewQty]<>0,Round(([ErrorCount]*100)/[M_NewQty],2),0)) AS ErrorProcc
FROM BK_LEVEL9
GROUP BY BK_LEVEL9.Aitur;
in my C# program i try to run her like this:
SQL = "SELECT Aitur,M_NewQty,ErrorCount,ErrorProcc from MyQUERY";
dsWorkKabat = new DataSet();
adp = new OleDbDataAdapter(SQL, Conn);
adp.Fill(dsWorkKabat, "MyQUERY");
adp.Dispose();
and i got this error:
You tried to execute a query that does not include the specified expression 'IIf(Not [M_NewQty]=0,Round([ErrorCount]*100/[M_NewQty],2),0)' as part of an aggregate function.
What could be the problem ?
thanks
|
|
|
|
|
You seem to be missing the formula from your GROUP BY clause. So try something like:
SELECT BK_LEVEL9.Aitur AS Aitur,
Sum(BK_LEVEL9.M_NewQty) AS M_NewQty,
Sum(BK_LEVEL9.ErrorCount) AS ErrorCount,
(IIf([M_NewQty]<>0,Round(([ErrorCount]*100)/[M_NewQty],2),0)) AS ErrorProcc
FROM BK_LEVEL9
GROUP BY BK_LEVEL9.Aitur,
(IIf([M_NewQty]<>0,Round(([ErrorCount]*100)/[M_NewQty],2),0));
|
|
|
|
|
GrabMemberAndProductInformation - This method is adatabase call and returns a DataTable.
SetupAccountListForMember - This method takes in a dataTable, does some calculation on each record and then adds the record to a listbox.
try
{
Task fetchMemberAccounts = Task.Factory.StartNew<DataTable>(GrabMemberAndProductInformation)
.ContinueWith(antecedent => SetupAccountListForMember(antecedent.Result),
TaskScheduler.FromCurrentSynchronizationContext());
catch (AggregateException err)
{
...log error
}
Now when an exception is thrown the exception seems to be swallowed by the CLR and does not trigger the exception handling I have in place. Can someone explain to me why the catch block is not being triggered? Any help is appreciated.
Thanks
Matt
|
|
|
|
|
You are creating a new thread. Exceptions occuring on the thread will not propagate to your catch-clause. The code on the thread ("task") needs its own exception handling.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Matt - in order to work out what errors are being thrown, you need to add an exception continuation to your task, so you would end up with the following:
Task errorTask = fetchMemberAccounts.ContinueWith(ex => { }, TaskContinuationOptions.OnlyOnFaulted);
|
|
|
|
|
If you can upgrade to .NET 4.5, async / await makes this type of code much easier to write.
try
{
DataTable data = await Task.Run(GrabMemberAndProductInformation);
SetupAccountListForMember(data);
}
catch (DbException err)
{
...
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
This worked nicely. Thanks for your help.
Matt
|
|
|
|
|
In this example, the taskscheduler.dll only displays tasks from c:\windows\task folder. Win 7, 2008 and 2012 store the tasks in the c:\windows\system32\task folder. Also, the object type has to be a "Task Scheduler Object".
How can I get this to be compatible with 2008 and 2012?
|
|
|
|
|
jwc jwc wrote: In this example,
In WHAT example?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
http://www.codeproject.com/Articles/2407/A-New-Task-Scheduler-Class-Library-for-NET?msg=5091641
|
|
|
|
|
You're supposed to post questions like this at the bottoms of the article pages. That way the author will see them and be able to respond.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
The exercise consists in creating a fully functional method/function to sort a set of squares one next to the other in increasing size order along the X axis.
The project has to be developed using C#, no other language is allowed. Try to make the method/function as professional as possible (proper comments, perfect indentation, meaningful variable names...) as it’s not a lab practical, it’s a professional development. Pay extreme attention to the details and the readability and simplicity of the code. Use auxiliary methods as required or deemed appropriate for a better structure and isolation and less coupling.
The method/function has to be developed in a file called metalcam_exercise.txt, add no other code than the required method/function in this file. The method name and parameters are as follows:
public static void OrganiseSquares(ref List<Square> pio_Squares)
Method description:
The method OrganiseSquares gets a list of squares and modifies each square position so the squares are placed one next to the other in increasing size order along the X axis.
Parameter description:
pio_Squares: The list of squares as input and output. For the output the squares should be sorted from smaller to bigger and in the right position. All the squares are in position 0,0 initially.
return: The return value will be void as the imputed Square objects will be modified to set their position according to the algorithm.
The class Square is as follows:
using System.Collections.Generic;
internal class Square
{
private double m_Lenght;
private double m_PositionX;
private double m_PositionY;
public Square(double p_Length)
{
m_Lenght = p_Length;
m_PositionX = 0;
m_PositionY = 0;
}
public void SetPosition(double p_PositionX, double p_PositionY)
{
m_PositionX = p_PositionX;
m_PositionY = p_PositionY;
}
public double GetLenght()
{
return m_Lenght;
}
public static void OrganiseSquares(ref List<Square> pio_Squares)
{
}
}
modified 14-Jul-15 11:34am.
|
|
|
|
|
We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.
Try it yourself, you may find it is not as difficult as you think!
If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
(ref List pio_Squares)
That code came from the teacher?
There's already rectangle class.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
"Those who can, do; those who can't, teach."
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
And those who can't teach, teach PE.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
They weren't exactly bright, were they?
I worked out at the end of the first year that the best approach was never turn up. That way, I got an "average" or "above average" report each term because they couldn't remember who I was and I could do something rather more useful than running a cross country race in all weathers...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Yes, and someone is *paying* for it.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
hi im using visual studios 2015 RC
how do i create a installer/setup for a .sln(windows form )program
coz i dont have the option for it under projects>templates>other.....(system) something like that thanx in advance
|
|
|
|
|
AFAIK, install support was removed from VS starting with VS2010. You would need to get yourself a 3rd party package to create your install with. WIX is free, innosetup is free, nsis is free, InstallShield is expensive, bloated and way overpriced although they used to include a "lite" version that was very crippled.
You can lead a developer to CodeProject, but you can't make them think.
The Theory of Gravity was invented for the sole purpose of distracting you from investigating the scientific fact that the Earth sucks.
|
|
|
|
|
aah i see thanx
|
|
|
|
|
I've been using the free version of Advanced Installer[^] to build the installer for this[^] app for several years. It meets my needs and the price is hard to beat.
/ravi
|
|
|
|
|
<mmppf:MediaPlayer x:Name="YoutubePlayer" Visibility="Visible" IsFullScreenVisible="True"
IsFullScreenChanged="YoutubePlayer_IsFullScreenChanged"
Stretch="UniformToFill" MediaQuality="HighDefinition"
IsResolutionIndicatorVisible="True" IsSignalStrengthVisible="False" IsAudioSelectionVisible="True" IsPlayPauseVisible="True"
IsSkipAheadVisible="True" IsSkipBackVisible="True"
MediaOpened="YoutubePlayer_MediaOpened"
MediaEnded="YoutubePlayer_MediaEnded"
MediaQualityChanged="YoutubePlayer_MediaQualityChanged" ></mmppf:MediaPlayer>
private async void YoutubePlayer_IsFullScreenChanged(object sender, RoutedPropertyChangedEventArgs<bool> e)
{
try
{
}
catch(Exception ex)
{
var dialog = new MessageDialog(ex.Message);
dialog.ShowAsync();
}
}
1.isfullwindows of on media player framework are getting true and then video plays on "fullwindow" but be lost control(play,pause...) although I had touch on screen.
2.isfullscreen ==true and it will be not play on fullwindows because of media player framework lies inside grid. that means <grid width=300 height=400> and then media player framework will play fullsreen of grid(media player framework.width=300...)
Note: On XAML are getting much "grid" tags
my ways is create new pages and just show video. but I don't want do that. It look bad.
How to solve it? I want play on fullwindow but still keep an control(play, pause...).
|
|
|
|
|
ive asked a question before this, so this is like a follow up to explain my situation better..i got a oppertunity of a lifetime. i got employed for coding yet dont have experience, but thats not the case: the guy that employed me gave me 1 month to train and get comfortable in coding , so im doing c# its a relativly easy language though but im like halve way thru my month and i feel im not as far in as ive shudve been. i can do basic coding with arraylist ect ect made acouple of programs like mp3 players pictureviewers and some random stuff i played with , my next project is a point of sales system. thats whats expected of me,and i know absolutly nothing of sQls to work with a database and all that , so my question is what should i look for ? tips? any links to quick and easy understandable tutorials / what types of pos should i use/web base/local/ why ? honestly i dont even know whats everyting on a Pos
|
|
|
|
|
When you started this month, did you do something sensible like get a book and start working your way through it, or just sit down, look at code and try to work it out?
The reason I ask is that you talk about "basic coding with arraylist ect" and the ArrayList class was superseded by the Generic Collections like List<T> and such like about ten years ago...so you shouldn't be learning how to use them at all.
I can't help feeling you have wasted your month so far, and need to start again...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|