Comments by heyitsPJ - CodeProject

heyitsPJ 7-Jun-19 20:08pm View

Yeah, I know Windows 7 will be dead. I'm working in a 24/7 company with a lot of employees. We can't upgrade all PC to Windows 10 at once, but they already need the app I created to make their work efficient. So for now (until I don't know when), I need to make it run to Windows 7.

heyitsPJ 7-Jun-19 1:27am View

Will do. Thanks!

heyitsPJ 24-May-19 20:06pm View

Thanks for this! I have other question, if I make my program into installer type, do I still need to install the runtime on every machine? It means I need to install two app: My program and the Crystal Runtime, right?

heyitsPJ 24-May-19 20:06pm View

Deleted

Thanks for this! I have other question, if I make my program into installer type, do I still need to install the runtime on every machine? It means I need to install two app: My program and the Crystal Runtime, right?

heyitsPJ 24-May-19 20:06pm View

Deleted

Thanks for this! I have other question, if I make my program into installer type, do I still need to install the runtime on every machine? It means I need to install two app: My program and the Crystal Runtime, right?

heyitsPJ 10-May-19 20:59pm View

I'm making another datagrid and I will try to use this one. It's actually an old project, half of it is created by another person, I'm just continuing it now. Thanks for your time and answers.

heyitsPJ 10-May-19 20:55pm View

Don't worry, I don't use concatenated strings :D The difference is the way I past my parameters because in the original code I have a lot of parameters. And also, I click the Accept Solution and up-vote. Thanks again :)

heyitsPJ 9-May-19 21:37pm View

Hi. As i have said, my original query is not like the one I posted, it is almost similar to yours but mine is a bit longer so probably I might use your version. And also instead of FOR EACH-NEXT I use WHILE-END WHILE. I don't know why it won't work so I replaced it. Thanks for giving me an idea.

heyitsPJ 9-May-19 3:13am View

Hi, yes I know this, that query is for sample only. My original query is longer and safe from SQL injection. But my problem here is about displaying the data from my query to datagrid without changing the header names/properties. Well, thanks for this anyway, will help others also.

heyitsPJ 4-Jun-18 3:12am View

Database name: PROCESSDB
This is on my local server. I'm using MS SQL 2008

heyitsPJ 4-Jun-18 1:23am View

see image here: https://pasteboard.co/HohQ7fR.png
that is sample data, but in my database I got thousands.

heyitsPJ 4-Jun-18 1:12am View

A thousand rows, especially in tbl_Process. As of now, tbl_Process has 97,158 and it will grow everyday because there's a lot of process transacted.
I only have one database and it has 30 tables, but for this specific query I only used 5 tables. The query will only return data from past 7 days including the current date.

Comments by heyitsPJ (Top 12 by date)