Click here to Skip to main content
15,893,594 members
Home / Discussions / C#
   

C#

 
GeneralRe: Enabling and Disabling Speech Recognition using Speech Recognition Pin
Coder199916-Jul-15 3:13
Coder199916-Jul-15 3:13 
GeneralRe: Enabling and Disabling Speech Recognition using Speech Recognition Pin
Pete O'Hanlon16-Jul-15 3:25
mvePete O'Hanlon16-Jul-15 3:25 
GeneralRe: Enabling and Disabling Speech Recognition using Speech Recognition Pin
Richard MacCutchan16-Jul-15 4:55
mveRichard MacCutchan16-Jul-15 4:55 
AnswerRe: Enabling and Disabling Speech Recognition using Speech Recognition Pin
Dave Kreskowiak15-Jul-15 13:58
mveDave Kreskowiak15-Jul-15 13:58 
QuestionSplit a string into values Pin
Farhad Eft15-Jul-15 5:48
Farhad Eft15-Jul-15 5:48 
AnswerRe: Split a string into values Pin
Abhipal Singh15-Jul-15 6:06
professionalAbhipal Singh15-Jul-15 6:06 
AnswerRe: Split a string into values Pin
User 418025417-Jul-15 2:47
User 418025417-Jul-15 2:47 
Questioncant run access query Through C# Pin
goldsoft14-Jul-15 21:20
goldsoft14-Jul-15 21:20 
hi
i have this query in access that run's excellent ! ,I called her MyQUERY
C#
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:
C#
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
AnswerRe: cant run access query Through C# Pin
Wendelius14-Jul-15 21:36
mentorWendelius14-Jul-15 21:36 
QuestionTask Exception Handling Pin
Member 1183731414-Jul-15 10:03
Member 1183731414-Jul-15 10:03 
AnswerRe: Task Exception Handling Pin
Eddy Vluggen14-Jul-15 10:34
professionalEddy Vluggen14-Jul-15 10:34 
AnswerRe: Task Exception Handling Pin
Pete O'Hanlon14-Jul-15 23:24
mvePete O'Hanlon14-Jul-15 23:24 
SuggestionRe: Task Exception Handling Pin
Richard Deeming15-Jul-15 1:00
mveRichard Deeming15-Jul-15 1:00 
GeneralRe: Task Exception Handling Pin
Member 1183731415-Jul-15 8:52
Member 1183731415-Jul-15 8:52 
QuestionA New Task Scheduler Class Library for .NET Pin
jwc jwc14-Jul-15 9:54
jwc jwc14-Jul-15 9:54 
AnswerRe: A New Task Scheduler Class Library for .NET Pin
Richard Andrew x6414-Jul-15 10:00
professionalRichard Andrew x6414-Jul-15 10:00 
GeneralRe: A New Task Scheduler Class Library for .NET Pin
jwc jwc14-Jul-15 10:13
jwc jwc14-Jul-15 10:13 
AnswerRe: A New Task Scheduler Class Library for .NET Pin
Richard Andrew x6414-Jul-15 10:18
professionalRichard Andrew x6414-Jul-15 10:18 
QuestionC# Pin
Member 1183662614-Jul-15 4:12
Member 1183662614-Jul-15 4:12 
AnswerRe: C# Pin
OriginalGriff14-Jul-15 4:17
mveOriginalGriff14-Jul-15 4:17 
AnswerRe: C# Pin
Eddy Vluggen14-Jul-15 4:59
professionalEddy Vluggen14-Jul-15 4:59 
GeneralRe: C# Pin
OriginalGriff14-Jul-15 5:06
mveOriginalGriff14-Jul-15 5:06 
GeneralRe: C# Pin
Richard Deeming14-Jul-15 5:15
mveRichard Deeming14-Jul-15 5:15 
GeneralRe: C# Pin
OriginalGriff14-Jul-15 5:41
mveOriginalGriff14-Jul-15 5:41 
GeneralRe: C# Pin
Eddy Vluggen14-Jul-15 5:18
professionalEddy Vluggen14-Jul-15 5:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.