C# Discussion Boards - CodeProject

Re: Difference between where() and where() in linq?

Scott Dorman3-Mar-10 6:47

3-Mar-10 6:47

As far as LINQ is concerned, there is no difference between either of those calls. In fact, there is only one version of that Where method which is generic and looks like Where<TSource>(Func<TSource, int, bool> predicate)).

In your first call, you are explicitly stating the type to be used in place of TSource and in the second one you are letting the compiler infer the type from the type of the collection.

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Re: Difference between where() and where() in linq?

Pete O'Hanlon3-Mar-10 9:44

Pete O'Hanlon

3-Mar-10 9:44

Welcome back Scott. I take it the book writing has gone well.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Difference between where() and where() in linq?

Scott Dorman3-Mar-10 12:41

Scott Dorman

3-Mar-10 12:41

Thanks Pete! Good to be back! Yes, the book writing has gone very well. Four chapters left to be tech reviewed and then the actual publishing process starts. Should be on the shelves in a few months!

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Re: Difference between where() and where() in linq?

Pete O'Hanlon3-Mar-10 21:41

Pete O'Hanlon

3-Mar-10 21:41

Cool. I bet you're glad to have your life back.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Difference between where() and where() in linq?

Scott Dorman4-Mar-10 4:25

Scott Dorman

4-Mar-10 4:25

Yes. The entire family is glad. Smile | :)

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Web Service web.config variables from dll in bin folder

BASONJS2-Mar-10 23:39

BASONJS

2-Mar-10 23:39

Hi all,

I have a question regarding web services and configuration files.

Platform:
.Net Framework , code behind c#.

Scenario:
I have a web service which when i publish, creates a bin folder. All normal. Now, in that bin folder i have a dll which is effectively my data access layer, CRUD for databases etc. Now i use ConfigurationManager.GetSection("AppConfig") within this dll in order to get database connection strings, which the dll brings out from the web service web.config file.

File Structure:

<My Web Service Folder>
--><AppData>
--><bin>--><My Data Access Layer DLL>
--><web.config(includes data access layer variables)>

Within my development environment, this works like a charm, using ConfigurationManager.GetSection("AppConfig") from my dll to get out the appconfig section from my web.config and then searching the nodes in order to find the right key.

Example of web.config:

<AppConfig>
<Configs use="true">
<add key="Databases" use="true" />
</Configs>


<Databases>
<ConnectionStrings>
<add key="<MY KEY NAME>" providerName="System.Data.SqlClient"
value="<MY CONNECTION STRING>" />
</ConnectionStrings>
</Databases>
</AppConfig>

So far so good.

Now i am testing a deployment of this system on a virtual pc. I copy and paste the c:\initpub\<mywebservice> folder into the c:\inetpub of the virtual pc. I try and run it and it fails. After inserting debugging into the code to see where it is failing, I found out that ConfigurationManager.GetSection("AppConfig") is actually returning null instead of the appconfig section from the web.config. Does anybody know why this is happening ?

Please excuse the length of the post but was needed to explain the situation.

James

How to send commands to a running application from the command line?

Ted On The Net2-Mar-10 22:43

Ted On The Net

2-Mar-10 22:43

Hi,

I want to be able to send commands to a running application from the command line. Is there a simple way to do this?

Thanks in advance for any help.

Ted

- Life would be so much easier if I had the source code!
- If C# had true garbage collection, most applications would delete themselves upon execution Wink | ;)

Re: How to send commands to a running application from the command line?

Eddy Vluggen2-Mar-10 23:35

Eddy Vluggen

2-Mar-10 23:35

Is the application already running on the commandline, or are you starting a console-application?

If you're starting the proces yourself (using Process) then you could redirect the Standard Input[^] device.

I are Troll Suspicious | :suss:

Re: How to send commands to a running application from the command line?

Ted On The Net2-Mar-10 23:42

Ted On The Net

2-Mar-10 23:42

Perhaps it needed a little bit more explanation.

In Delphi, I wrote a program for clients that listened to UDP. On the server I sometimes started a broadcaster (from the command line) to send a message to the clients (after sending the message the broacast app shuts down again).

Now in C# I'm gonna rebuild this program. The client will be the same, but on the server the application will keep running because of added functionality.
So, the app is a GUI app (dont know if it will be winforms or wpf yet) which will be running constantly. I just want to send some kind of command from the command line to the server and have the server app handle the messaging to the clients. Ofcourse, I could also split the server app in 2 programs (the original broadcaster) and another app to do the extra stuff. But the server app will also log the messages sent, so thats why i wanted to build one tool for the server which does all the work..

Better explained this way? or even more vague? Big Grin | :-D

Ted

- Life would be so much easier if I had the source code!
- If C# had true garbage collection, most applications would delete themselves upon execution Wink | ;)

Re: How to send commands to a running application from the command line?

Som Shekhar2-Mar-10 23:53

Som Shekhar

2-Mar-10 23:53

What you say is really difficult to achieve. Probably you should consider the approach of DataBase Servers like MySql. There is a service running and you can still run commands on those servers from command line. But in this case, there is a new instance of program that sends the data through port to the running service.

Hence, what you can do :

1. Instead of accepting the input from commandline, accept it through port. You already have a port handler in your server.

2. Create a CommandLine application to accept data from keyboard, send it through port to the service.

Now the user can simply type the command in the commandline, it gets routed through the port and goes to the server.

Added benefit is that this can be userful for remote monitoring as well.

Re: How to send commands to a running application from the command line?

Eddy Vluggen3-Mar-10 0:00

Eddy Vluggen

3-Mar-10 0:00

Ted On The Net wrote:
Better explained this way? or even more vague?

Bit of both; I fail to see from where you want to send commands to the command-line application. You mentioned that the broadcaster (the server) is a console-app.

Am I right in understanding that the broadcaster tells the client "what" to start, or is it the broadcaster itself that needs to be steered?

I are Troll Suspicious | :suss:

Re: How to send commands to a running application from the command line?

Ted On The Net3-Mar-10 0:13

Ted On The Net

3-Mar-10 0:13

ok, I need to be more clear Big Grin | :-D

Our release build process (compile, build, create iso, etc) is run multiple times a day with the use of 4NT batch files on a server. During the process, notifications about the progress are sent to all developers informing them about new compiler errors, files being locked etc. This way the people who need to fix something know they have to and the build process can be fired up again ASAP. They receive these messages in a small receiver app using UDP. The messages are sent with a broadcaster app using command line parameters. In the batch files we just execute the broadcast tool with some parameters, it sends the message and shuts down again. (like: broadcast <message type=""> <message to="" send=""> / broadcast error file not found: aFile.exe). The broadcaster and receiver tools are all built in Delphi. I want to rebuild it using C# as my first project (i'm currently making the transition from Delphi to C# guru (inhouse) :P)

Do you get the idea now? Smile | :)

(hope so!)

- Life would be so much easier if I had the source code!
- If C# had true garbage collection, most applications would delete themselves upon execution Wink | ;)

Re: How to send commands to a running application from the command line?

Eddy Vluggen3-Mar-10 0:30

Eddy Vluggen

3-Mar-10 0:30

Ted On The Net wrote:
(like: broadcast / broadcast error file not found: aFile.exe). The broadcaster and receiver tools are all built in Delphi. I want to rebuild it using C# as my first project

Two applications to migrate, starting with the broadcaster. As soon as you create a new console-application you'll see where to get the command-line arguments from. Are all options specified as arguments, or will you be reading user-input directly from the console?

Coming from Delphi, I guessed that it's now based on the Indy-components? You might be interested in the example on the UdpClient[^] class.

I are Troll Suspicious | :suss:

Re: How to send commands to a running application from the command line?

OriginalGriff2-Mar-10 23:42

OriginalGriff

2-Mar-10 23:42

There is no simple way to do this. You would have to write a command line application that communicated to the running application, either via Remoting or via a common text file or database. I would recommend Remoting[^] as it will be more flexible and less processor / disk intensive.

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

Re: How to send commands to a running application from the command line?

Ted On The Net2-Mar-10 23:44

Ted On The Net

2-Mar-10 23:44

the command sent from commandline is part of a batchfile running. perhaps I should split the tool like i said in the reply to Eddy on the other thread.

- Life would be so much easier if I had the source code!
- If C# had true garbage collection, most applications would delete themselves upon execution Wink | ;)

Re: How to send commands to a running application from the command line?

PIEBALDconsult3-Mar-10 3:51

PIEBALDconsult

3-Mar-10 3:51

The program would have to have that capability built in. One simple way would be having the application check a database for actions to take. Then you just deposit your instructions there.

Another way is to use a Windows Service and send custom actions to it.

create word file

Milind Panchal2-Mar-10 22:33

Milind Panchal

2-Mar-10 22:33

I have developed window application in C#.net. I am creating word file from this. But if I am going to save changes in word file I got the below error.

a.doc may contain features that are not compatible with plain text format. Do you want to save tha document in this format ?

How to save file in word format

Thanks in advance

Re: create word file

Eddy Vluggen2-Mar-10 23:41

Eddy Vluggen

2-Mar-10 23:41

A Word-document contains special tokens to identify tables, lines, pictures and stuff. A plain text-file doesn't contain these things, as a plain text-file can only contain text.

You can use the Visual Studio for Office[^]-extensions if you're going to work with Word.

As an alternative; Microsoft Word can also read the "Rich Text File" format (RTF) and HTML files Smile | :)

I are Troll Suspicious | :suss:

Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

pankaj.calm2-Mar-10 22:17

pankaj.calm

2-Mar-10 22:17

Hi,

I am updating a Excel Worksheet cell value to 2009.03 and it become change to 2009.3.

I tried may ways to solve the issue but value always changed to "2009.3" instead of "2009.03" on Server. It is working on my system but not on Win XP 2003 Server System.

I used to set excel cell NumberFormat to "@", "0.00", "####.##"
and even tried to concatenated "'" before value but result not come.
The excel file is of 2007 format(.xlsx).
<u>>My Code is</u>
Microsoft.Office.Interop.Excel.Workbook WorkBook = null;
Microsoft.Office.Interop.Excel.Worksheet Sheet = null;
WorkBook = Utility.GetWorkbook2007(templateFileWPath);
Sheet = (Microsoft.Office.Interop.Excel.Worksheet)WorkBook.Worksheets[1];
Microsoft.Office.Interop.Excel.Range TPCellRange = (Microsoft.Office.Interop.Excel.Range)Sheet.Cells[this.GetRowIndex(Sheet, this.CellAddress), this.GetColumnIndex(Sheet, this.CellAddress)];
TPCellRange.set_Value(Microsoft.Office.Interop.Excel.XlRangeValueDataType.xlRangeValueDefault,"2009.03");

or also tried
CellValueRange.NumberFormat = "@";
CellValueRange.set_Value(Microsoft.Office.Interop.Excel.XlRangeValueDataType.xlRangeValueDefault, "2009.03");

plz reply me if any solution is possible

Thanks @ regards

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

Eddy Vluggen3-Mar-10 0:55

Eddy Vluggen

3-Mar-10 0:55

Could it be that the "." (the decimalseparator) is interpreted as a thousand-separator?

I are Troll Suspicious | :suss:

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

pankaj.calm3-Mar-10 0:59

pankaj.calm

3-Mar-10 0:59

"." is not a thousandseperator
its like a date value seperator or date is in yyyy.mm format
but i need actual value like "2009.03" where 2009 is year and 03 is month.

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

Eddy Vluggen3-Mar-10 1:39

Eddy Vluggen

3-Mar-10 1:39

Have you tried setting the numberformat to "yyyy.mm"?

I are Troll Suspicious | :suss:

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

pankaj.calm3-Mar-10 2:02

pankaj.calm

3-Mar-10 2:02

yes i tried

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

Eddy Vluggen3-Mar-10 3:03

Eddy Vluggen

3-Mar-10 3:03

I've created a test-sheet in Excel (2007) and succesfully changed the NumberFormat using an adapted version of your code;

using XL = Microsoft.Office.Interop.Excel;

[...].
object oMissing = System.Reflection.Missing.Value;
XL.Application App = new XL.ApplicationClass();			
XL.Workbook WorkBook = App.Workbooks.Open("C:\\Book1.xlsx", 
	oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
	oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, 
	oMissing, oMissing);
XL.Worksheet Sheet = (XL.Worksheet)WorkBook.Worksheets[1];
XL.Range thisRange = (XL.Range)(Sheet.Cells[1, 1]);
thisRange.NumberFormat = "yyyy.mm";
WorkBook.Save();
WorkBook.Close(false, oMissing, oMissing);

Some points to keep in mind;

You'll need the correct Office Interop assemblies
The value that you're formatting needs to be a "real" date. (Not a string that contains month & year)

Hope this helps Smile | :)

I are Troll Suspicious | :suss:

Remote administration

kebedetesema2-Mar-10 22:10

kebedetesema

2-Mar-10 22:10

Hi, all,
My application involves installation of different parts of the project in different computers on a local network. I want the administrator to check and/or start/stop different services on different PC's remotely using command line. I use C#. I don't know what technology to use. Should I use telnet/ssh or is use of WMI(System.Management Name Space) enough?.Or is there another method?. I don't want to use remote desktop or window's built-in telnet client. Nor do I want to use remote admin software like pcAnywhere. If it is possible to use both telnet/ssh and WMI, which one is better?.

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