|
1. Don't crosspost.
2. Don't use Urgent in your message titles.
3. Please read the forum guidelines if you have questions about these requests.
______________________
stuff + cats = awesome
|
|
|
|
|
hello to all good afternoon,
i am in doubt with the below
date amount quantity tax
===== ======== =========== =========
19jun07 15 5 .2
19jun07 20 6 .2
19jun07 50 10 .25
19jun07 10 4 .2
thi is my table.. i need its summary report as
date amount quantity tax
===== ======== =========== =========
19jun07 95 25 .85
(summary of a particular day for all fields)
and even how can we get weekly,monthly summary reports as the same above ?
i need ur help !!!
self confidence+hard work=SUCCESS
|
|
|
|
|
SELECT Date, SUM(amount), SUM(quantity), SUM(tax)
FROM MyTable
GROUP BY Date
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
how is for the weekly and monthly,,,?
should i fine the 1st day of a week/month and calculate up to the last date?
self confidence+hard work=SUCCESS
|
|
|
|
|
GROUP BY DATEPART(WEEK, Date)
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
Description:
I Created an C# windows application to copy local folder to shared folder in intranet PC with a fixed user, the aplication will be set up on a server that will be logon by different administrators, however, it can not effect the program to run
normally.
Development OS: Windows XP 2P
TooL: VS 2003
Fromework: 1.1
Server OS: Windows 2000 Terminal Server SP4
Fromework: 1.1
Fromework: 2.0
Question:
The application can run on the server but can not copy file, What should I do ?
Notice:
The application can run on WinXP and copy file to remote PC.
|
|
|
|
|
Hello All,
I used Process and ProcessStartInfo classes to start the process but it is not working properly,
i used,
ProcessStartInfo psi = mew ProcessStartInfo();
psi.WorkingDirectory = strMyWorkingDirPath;
psi.FileName = strMyWorkingDirPath + HtmlAsText.exe;
psi.Arguments = " /run "+ strMyWorkingDirPath + "\" config.cfg\""
psi.WindowStyle = ProcessWindowStyle.Hidden;
psi.UseShellExecute = false;
Process.Start(psi);
if i remove switch "/run" then the application starts with its form based window, from where we can give file name and location using button clicks. But i want it to be run on command line as i stated before that it has provision of running on command-line. Can please tell me that where i'm doing mistake and how can we feed command line with our own input automatically at the start of propcess???
Note: strMyWorkingDirPath is a string that contains the path of aplcation to start and the path of config.cfg
|
|
|
|
|
mjamilanwar wrote: psi.FileName = strMyWorkingDirPath + HtmlAsText.exe;
Is exe really a property of an object called HtmlAsText? Or did you forget to put quotes around it. In fact, did you really copy this code from VS, or did you retype in into codeproject. If it was the latter, then there might be pertinent missing information.
mjamilanwar wrote: psi.Arguments = " /run "+ strMyWorkingDirPath + "\" config.cfg\""
From your earlier example, in a different thread (and you should really continue the discussion in the original thread), the quotes went around the whole path, not just the last part of the path.
So, try
psi.Arguments = "/run \""+strMyWorkingDirPath + " config.cfg\""
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
Please - don't start new posts with questions you asked in the last hour.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hello All,
I used Process and ProcessStartInfo classes to start the process but it is not working properly,
i used,
ProcessStartInfo psi = mew ProcessStartInfo();
psi.WorkingDirectory = strMyWorkingDirPath;
psi.FileName = strMyWorkingDirPath + HtmlAsText.exe;
psi.Arguments = " /run "+ strMyWorkingDirPath + "\" config.cfg\""
psi.WindowStyle = ProcessWindowStyle.Hidden;
psi.UseShellExecute = false;
Process.Start(psi);
if i remove switch "/run" then the application starts with its form based window, from where we can give file name and location using button clicks. But i want it to be run on command line as i stated before that it has provision of running on command-line. Can please tell me that where i'm doing mistake and how can we feed command line with our own input automatically at the start of propcess???
Note: strMyWorkingDirPath is a string that contains the path of aplcation to start and the path of config.cfg
|
|
|
|
|
If strMyWorkingDirPath contains the path to config.cfg then your command line will look something like this:
myapp.exe /run C:\this\ismy\path\" config.cfg"
Are you sure you want to include those quotations in the string?
If I were to take a stab at what's happening I would say that the GUI portion of your app ignores the badly formed command line, while the Console portion bombs.
I'm largely language agnostic
After a while they all bug me 
|
|
|
|
|
Hi
What is the method and class to class to get a serial input from like COM1
Thanks
Samuel
|
|
|
|
|
|
Hello all,
I'm stuck with the problem of starting a command line process in C#. There is an application called "HtmlAsText.exe" that converts HTML file into Text file. It is a window based application that can be run on command line as well like,
C:> E:\HtmlAsText.exe /run "E:\Application\config.cfg"
This is the option provided with this application to run on command line, otherwise bydefault it is window based application. "config.cfg" is configuration file that is used to tell the application about the location and name of the file. It works fine if we run it on command line but i dont know how to write in C#. these are the steps
1) start a comand-line process
2) feed file path
3) feed switch i.e /run and
4) then provide configuaratiuon file path
i want every thing to be done in hidden form and just require output file generated to use it further in my application
Jamil Anwar
|
|
|
|
|
Have a look at the Process class.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
Hi,.,
i wan to create an object spy , which can capture all the properties of all HTML of any website.
i want to get text value of all HTML Tag of website.. by draging mouse on that..
rohituappu82@gmail.com
|
|
|
|
|
You can get the HTML of any site you want, in code. It's pretty trivial. To click on an HTML element and get it's text value, is more complex, but it can be done, because firebug does it. It does it within the browser however, that could be how it does it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi
could u please send me.. any link which is similar to this..
i need this.. so please send me some link..and some code related to it
thanks
rohit
|
|
|
|
|
Hi all,
I'm using datepicker (I name it dt1 and dt2)to get the value of date range. Here's the SQL String :
string StrSql = "SELECT Purch.PurchID, Purch.PurchDate, Purch.PurchType, Purch.PurchTotal, FROM Purch WHERE Purch.PurchDate BETWEEN '" + dt1 + "' AND '" + dt2 + "' ORDER BY Purch.PurchID ASC";
When I execute that to fill my ListView, it gives me an error message :
" Syntax Error Converting datetime from character string."
If anyone has been through this or get a better idea, pls help me .
Learn from yesterday, live for today, hope for tomorrow
|
|
|
|
|
I thing what would help, or how I did it was like this:
You write a # infront then the value of the Month, the Day and the year.
I hope this should be!
So you have to format the output of the two Datapicker.toString().
I hope that does it.
Cheers
You have the thought that modern physics just relay on assumptions, that somehow depends on a smile of a cat, which isn’t there.( Albert Einstein)
|
|
|
|
|
Fatbuddha 1 wrote: I thing what would help, or how I did it was like this
I would be better to get in to the habit of using parameterised queries so you didn't accidentally fall victim to a SQL Injection Attack.
Use parameters, then pass DateTime objects to them.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
Thanx Fatbuddha  ,
But there's no need to change the code at all.
There's only need to change the settings Format
for datepicker control and turned it into "Short".
Because MS SQL recognize short format like this
"MM/dd/YYYY"
Keep share the knowledge
Regards,
Daniel
Learn from yesterday, live for today, hope for tomorrow
|
|
|
|
|
I see.
I had do to this once for homework so I had to use Access. 
Cheers!
You have the thought that modern physics just relay on assumptions, that somehow depends on a smile of a cat, which isn’t there.( Albert Einstein)
|
|
|
|
|
You should never use a format like MM/dd/YYYY as this is ambigious (you can't tell it apart from dd/MM/YYYY for any day in the 1-12 range). If you are so unfortunate you have to store a date in text format always use ISO format (YYYY-MM-dd). Luckily in this case there is no need to use strings. Use parameters in the SQL statement instead.
|
|
|
|
|
Yes, complete waste of time/resources to convert a DateTime to a String and then back to a DateTime. Learn it the right way now, so you won't have a bad habit later when it really counts.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
