Comments by Sherif Kamel

Sherif Kamel 26-Jul-16 11:00am View

Sure sir , I already updated the code and here's the working sql cmd "SELECT AKtype, COUNT(AKtype) AS AKcount FROM Aklashehat GROUP BY AKtype ORDER BY AKcount"

Sherif Kamel 26-Jul-16 10:53am View

Sir, I found it out , I should specify an alias for count ( COUNT(AKcount) AS COUNT ) and use it in order by ( ORDER BY AKcount ). Thanks sir for directing me to the right path , and please update your answer kindly.

Sherif Kamel 26-Jul-16 10:43am View

SqlCeCommand cm = new SqlCeCommand("SELECT AKtype, COUNT(AKtype) FROM Aklashehat GROUP BY AKtype ORDER BY COUNT(AKtype)", sqlcon);

Sherif Kamel 26-Jul-16 10:40am View

Well, I tried it with SQL CE cmd and It worked perfect, but I still can't get it to work in my application

Sherif Kamel 26-Jul-16 10:35am View

There's an error produced " Expressions in the GROUP BY list cannot contain aggregate function" ? Is this something related to SQL Compact Server or Am I doing something wrong in the listview. *Sorry for the late reply, but I was trying to figure it out on my own

Sherif Kamel 18-Jul-16 14:26pm View

aha , so it's disabled by default :D now I get. Thanks for mentioning this out.

Sherif Kamel 16-Mar-16 14:40pm View

well that was pretty handy, the problem now relies in changing the code without starting from scratch. Question is updated

Sherif Kamel 16-Mar-16 14:39pm View

thanks for your help, question is updated now

Sherif Kamel 22-Dec-15 17:16pm View

Followed these guidlines and I've a sample code now that works perfectly , I'll try to learn more to improve it later on. Thanks for the help sir :)

Sherif Kamel 22-Dec-15 13:10pm View

@BillWoodruff yes it's WinForms, and yes all the 4 pictures will always be the same size

Sherif Kamel 22-Dec-15 13:09pm View

Well I think you got me wrong on that. What I meant is that I want to PRINT it on a paper with the preview included in the question. So the problem rely in the conversion process from the application to the printer

Sherif Kamel 12-Dec-15 15:55pm View

It worked flawlessly .. Thanks very much

Sherif Kamel 12-Dec-15 15:16pm View

Well that worked smoothly, didn't know before of the stringbuilder .. Thanks
but I still have a problem of " AND "s , for example if I use a single text box , there will remain a single "AND" in the end, for example
"SELECT * FROM Cases WHERE CaseYear LIKE @S2 AND"
So it there any way to remove the extra ANDs of the final builded query?
thanks in advance <3

Sherif Kamel 2-Oct-15 7:52am View

Thanks for the guide , it's working smoothly as it should now.
I edited the main question with the final code

Sherif Kamel 13-Apr-15 13:37pm View

Sir , that's pretty brilliant. I've been introduced with some conflicts in the code itself and finally it turns out that I've conflicts in the database "DATASET" that is automatically added to the project each time I try to add or modify database which messed things up.
Now I've just deleted everything and started all over again with password protected database and it's functioning properly (I mean the auto complete function).
Thanks for the great tip :)

Sherif Kamel 13-Apr-15 12:31pm View

Well , I'm sorry but I don't know how to use breakpoints :) forgive my ignorance.

Sherif Kamel 13-Apr-15 11:56am View

@RyanDev : no error , just the auto complete text box is not working when I add a password protected database (i.e it doesn't suggest results).

Sherif Kamel 10-Apr-15 19:50pm View

I didn't start making any excel files yet so I think I'll adapt to your guide. I'm pretty sure I'll come up with pretty good ideas from these great topics. Thanks for the help :)

Sherif Kamel 10-Apr-15 19:11pm View

Well , you guided me to the way. I've searched for the HTTP requests and came up with a code that enabled the connection to the text file normally. Thanks a lot.
But what about excel file sheet ? can I read it's data the same way ?

Sherif Kamel 10-Apr-15 5:34am View

Google has too many general topics with no guides or how-to-make :( that's why I couldn't reach a starting point.

Sherif Kamel 10-Apr-15 5:33am View

Well I admit I didn't knew that , but anyway I organized the question into sub-questions so anyone could help even with a tiny piece of answer :D
and regarding normal channels , I used google + stackoverflow + codeproject . Do you recommend me any other channels ?

Sherif Kamel 8-Apr-15 10:55am View

Thanks for your help. I'll read them carefully

Sherif Kamel 8-Apr-15 10:25am View

I don't know what to say , you did me a great favour. Thanks a lot sir. It's working like charm

Comments by Sherif Kamel (Top 23 by date)