C# Discussion Boards - CodeProject

Nagy Vilmos12-Jun-09 5:34

12-Jun-09 5:34

Don't listen to them, there just grumpy because they don't like answering gradeschool theory.

Here's the code[^] and it's gratis.

Panic, Chaos, Destruction.
My work here is done.

Re: vsto problem

EliottA12-Jun-09 5:40

EliottA

12-Jun-09 5:40

You just wasted 3 minutes of my life. But, I can say I know everything I didn't know about currency codes now.

Check out the CodeProject forum Guidelines[^]

Re: vsto problem

Nagy Vilmos12-Jun-09 5:43

Nagy Vilmos

12-Jun-09 5:43

Come on clever pants! If the time was WASTED how come you KNOW something NEW?

Panic, Chaos, Destruction.
My work here is done.

Re: vsto problem

Randor 12-Jun-09 9:08

Randor

12-Jun-09 9:08

Hi Mogaambo,

Ignore the hostile members. I think its perfectly fine to ask for code snippits from fellow software engineers.

If you want just the signature you can follow the instructions provided [^]by Tim Li over at the Microsoft forums.

Best Wishes,
-David Delaune

TimeSpan equivalent for the working week

hairy_hats12-Jun-09 4:04

hairy_hats

12-Jun-09 4:04

Hi all, I'm looking for a class that works like TimeSpan but only takes account of a specifiable working week, so that if you add 12 hours onto 9AM Monday it returns 1PM Tuesday, or if you add 12 hours onto 9AM Friday you get 1PM Monday for a 5-day week, 9-5 working day.

Does such a thing exist?

TIA Beer | [beer]

Re: TimeSpan equivalent for the working week

Luc Pattyn12-Jun-09 4:11

Luc Pattyn

12-Jun-09 4:11

Haven't seen one yet.

BTW: It would be similar to DateTime, not TimeSpan, as TimeSpan does not know what the current day is. (That is why it has TotalDays but no TotalMonths).

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

Re: TimeSpan equivalent for the working week

hairy_hats12-Jun-09 4:23

hairy_hats

12-Jun-09 4:23

It's more like a TimeSpan whose duration varies according to the DateTime it's being added to! Cool | :cool:

(or possibly Dead | X|

)

Re: TimeSpan equivalent for the working week

Luc Pattyn12-Jun-09 4:27

Luc Pattyn

12-Jun-09 4:27

I suggest you make an extension method DateTime.AddWorkingHours(int hours) which throws a BadArgumentException on negative values, and iteratively calls AddHours(x) and AddDays(1) until all the hours have been exhauted. That should take no more than 20 lines of code.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

Re: TimeSpan equivalent for the working week

hairy_hats12-Jun-09 4:49

hairy_hats

12-Jun-09 4:49

Thanks for the suggestion. Smile | :)

I'm thinking of storing the working week data in SQL with work breaks etc., and writing a whole new class to do the calculations iteratively as you suggest, which an extension method could call.

Oh...VS2005 doesn't support extension methods. *sigh* Just a class then.

MCE Remote Controller

ryan11712-Jun-09 2:46

ryan117

12-Jun-09 2:46

Hello everyone,

I need to develop a C# application which can read command inputs from a remote controller through a USB receiver, like the first picture on this link: http://twhtpc.com/index.php/hpremote

It does read certain commands such as the numpads, volume controls. However even I use override WndProc on NativeWindow, the application can't read some commands such as "My Music" and "My Videoes" these WM_INPUT.

Any help is deeply appreciated. Thank You in advance.

WMI

arkiboys12-Jun-09 2:36

arkiboys

12-Jun-09 2:36

Hi,
The code below is a summary of what I have developed which returns 0 or 1 for intResult to indicate a success or failure.
How do I obtain the returned value from within the script when the script is executed?
I think this is to do with altaring the "Create" word in the code below.
Any thoughts please?

Thanks

System.Management.ManagementPath path = new System.Management.ManagementPath("Win32_Process");
object[] methodArgs = { "cscript.exe \\machinename\c$\scriptname.vbs", null, null, 0 };

intResult = (uint)processClass.InvokeMethod("Create", methodArgs);

Re: WMI

Dave Kreskowiak12-Jun-09 5:18

Dave Kreskowiak

12-Jun-09 5:18

The Win32_Process class doesn't return an Exit Code for a process. You'll hhave to use the .NET Process class to get an Exit Code, but, you'll have to get the process object before the script terminates on the target machine. Even then, I can't guarantee it's going to work to get the exit code.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: WMI

arkiboys12-Jun-09 8:08

arkiboys

12-Jun-09 8:08

Thanks but not sure how to get C# to do this.

Re: WMI

Dave Kreskowiak12-Jun-09 11:15

Dave Kreskowiak

12-Jun-09 11:15

You haven't read the documentation on the Process class yet, have you? The GetProcessesByName(processName, machineName)[^] method looks promising.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: WMI [modified]

arkiboys14-Jun-09 20:31

arkiboys

14-Jun-09 20:31

Hi,
I have read it but does not seem to help me.
Let's say I have a simple vbscript called vbscript.vbs which has something like:
wscript.echo "hello"
In the c# code I would like to run this script and return the word "hello".
How do I do this please?
Thanks

modified on Monday, June 15, 2009 2:40 AM

cannot insert into database 2005 using visual c# 2008

Adekolurejo12-Jun-09 2:01

Adekolurejo

12-Jun-09 2:01

Pleas I need help on this code.

onclick on the save button this problem will prevent it from carry out the operation.
on geting to myCommand.ExecuteNonQuery();
it give me this error below.
{"Must declare the scalar variable \"@Telephone_NoParam\"."}

pls help as I dont know what to do because am new to c#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Kay_Nylon
{
public partial class COMPANY_INFO : Form
{
public COMPANY_INFO()
{
SqlConnection myConnection = new SqlConnection("user id=sa;" +
"password=admin123;server=ADEMOLAPC;" +
"Trusted_Connection=yes;" +
"database=Kay_Nylon_Db; " +
"connection timeout=30");
myConnection.Open();
//myConnection.Close();

InitializeComponent();
}

private void COMPANY_INFO_Load(object sender, EventArgs e)
{
}

private void btnSave_Click(object sender, EventArgs e)
{

SqlConnection myConnection = new SqlConnection("user id=sa;" +
"password=admin123;server=ADEMOLAPC;" +
"Trusted_Connection=yes;" +
"database=Kay_Nylon_Db; " +
"connection timeout=30");
myConnection.Open();

//try
//{

SqlCommand myCommand = new SqlCommand("INSERT INTO Company_Info(Company_Id, Company_Name, Company_Address_Line1, Company_Address_Line2, Telephone_No, Fax, Email) " +
"Values(@Company_IdParam, @Company_NameParam, @Company_Address_Line1Param, @Company_Address_Line2Param, @Telephone_NoParam, @FaxParam, @EmailParam)", myConnection);

myCommand.Parameters.AddWithValue("@Company_IdParam", txtCompanyId.Text);
myCommand.Parameters.AddWithValue("@Company_NameParam", txtCompanyName.Text);
myCommand.Parameters.AddWithValue("@Company_Address_Line1Param", txtAddress1.Text);
myCommand.Parameters.AddWithValue("@Company_Address_Line2Param", txtAddress2.Text);
myCommand.Parameters.AddWithValue("@Telephone_NoParam", txtTelephoneNo.Text);
myCommand.Parameters.AddWithValue("@FaxParam", txtFax.Text);
myCommand.Parameters.AddWithValue("@EmailParam", txtEmail.Text);

myCommand.ExecuteNonQuery();
myConnection.Close();
// }
//catch (Exception sql)
// {
// Console.WriteLine(sql.ToString());
// }
}
}
}

Re: cannot insert into database 2005 using visual c# 2008

Nagy Vilmos12-Jun-09 2:26

Nagy Vilmos

12-Jun-09 2:26

please use <pre> and </pre> around your code to make it legible.

Panic, Chaos, Destruction.
My work here is done.

Re: cannot insert into database 2005 using visual c# 2008

Rob Philpott12-Jun-09 2:37

Rob Philpott

12-Jun-09 2:37

Well, what is the value of txtTelephoneNo.Text? If the value of a parameter is null, then it effectively doesn't get added. That said, I doubt the Text property of a textbox can ever be null, and I believe an empty string would be treated differently.

Regards,
Rob Philpott.

Re: cannot insert into database 2005 using visual c# 2008

PIEBALDconsult12-Jun-09 3:49

PIEBALDconsult

12-Jun-09 3:49

Rob Philpott wrote:
If the value of a parameter is null, then it effectively doesn't get added.

I don't think that's true.

Re: cannot insert into database 2005 using visual c# 2008

Rob Philpott12-Jun-09 4:12

Rob Philpott

12-Jun-09 4:12

I think so, unless I'm getting mad. SqlParameter has a value property, and if you want a sql null you set this to DBNull.Value, or the actual value if there is one. If null, then its like the parameter was never added.

It works well if you write a stored proc and default the value to null in Sql. You can just set the sql parameter to null in code, it doesn't get passed, and defaults to null Sql side.

Regards,
Rob Philpott.

Re: cannot insert into database 2005 using visual c# 2008

PIEBALDconsult12-Jun-09 9:21

PIEBALDconsult

12-Jun-09 9:21

It should either add the parameter or throw an Exception, not fail quietly.

I may want to set (change) the value later, and perhaps execute the statement multiple times.

Re: cannot insert into database 2005 using visual c# 2008

Rob Philpott12-Jun-09 23:17

Rob Philpott

12-Jun-09 23:17

Not at all. It's a simple means where you do not have to worry about null/DBNull conversion in code.

Regards,
Rob Philpott.

FileWather Path Error [modified][Solved]

MumbleB12-Jun-09 1:58

MumbleB

12-Jun-09 1:58

Hi Guys. I have written a Windows Service with a FileWatcher. Now, when there are new files in the directory it picks the files up fine but when it has to copy then out into a new directory I get an error of The given path's format is not supported. Below is the copy function.

try
{
    string path = fsw.Path;
    string outPath = "C:\\TestDir2\\";
    char[] trimchars = new char[] { '.', 't', 'x', 't' };
    DirectoryInfo dinfo = new DirectoryInfo(path);
    foreach (FileInfo finfo in dinfo.GetFiles("*.*"))
    {
        File.Copy(finfo.FullName, outPath + finfo.FullName, true);
    }
}

It stops on the line: FIle.Copy(finfo.FullName, outPath + finfo.FullName, true);. Anybody have any ideas?

Excellence is doing ordinary things extraordinarily well.

modified on Friday, June 12, 2009 8:26 AM

Re: FileWather Path Error

_AnsHUMAN_ 12-Jun-09 2:02

_AnsHUMAN_

12-Jun-09 2:02

Did you debug to see what is the value in the variables and are they similar to what is expected as Copy params?
By the way what is the error? do you get an exception. If yes, which one?

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: FileWather Path Error

MumbleB12-Jun-09 2:09

MumbleB

12-Jun-09 2:09

Yes, I have debugged it and low and behold, I missed it, should not have used outPath + finfo.FullName, should have used outPath + finfo.Name.

Silly mistake.

Thanks anyway.

Excellence is doing ordinary things extraordinarily well.

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