Re: Is it possible to query a unix server (SAN) with c sharp? - C# Discussion Boards

Re: OleDb Exception Displays Only Table Name

AnnieMacD15-Jun-11 13:30

AnnieMacD

15-Jun-11 13:30

You don't seem to be joining the two tables, so try this:

SELECT TOP 1 Count(*) AS Expr1, ScrapCodeID
FROM ScrapCodes 
INNER JOIN Repairs ON ScrapCodes.ID = Repairs.ScrapCodeID
WHERE FailureCode = 13
GROUP BY Repairs.ScrapCodeID
ORDER BY Count(*) DESC;

The Scrap Codes to Repairs tables above assume a one-to-many relationship - I presume that is what you have.

It’s not because things are difficult that we do not dare, it’s because we do not dare that things are difficult. ~Seneca

Re: OleDb Exception Displays Only Table Name

Matt U.15-Jun-11 15:47

Matt U.

15-Jun-11 15:47

I could give this a try. But I have other fields in the Repairs table which are linked to other tables (the "Failure Code" field, for example, links to the table "Failure Codes"). And I can work with that data without any issue.

I'm not very strong at all on JOIN's yet. It's a subject which I have been reading a lot into lately though. Smile | :)

Is it possible to query a unix server (SAN) with c sharp? [modified]

turbosupramk315-Jun-11 10:09

turbosupramk3

15-Jun-11 10:09

Reading through here, the only way I can programatically return data values is in Solaris/Unix, of which I am not familiar with either.

Can this be done in .net in anyway and have a string returned with the values?

Thanks for reading Smile | :)

http://filedownloads.qlogic.com/files/Manual/72911/Users_Guide_-_SANsurfer_FC_HBA_CLI_[K].pdf[^]

modified on Thursday, June 16, 2011 8:45 AM

Re: Is it possible to query a unix server (SAN) with c sharp?

Not Active15-Jun-11 10:16

Not Active

15-Jun-11 10:16

It is customary and courteous to use a clicky link when posting a URL so people don't have copy and paste the URL, which most will not do and thus you will not receive any positive responses.

Please edit your post and use the link[^] toolbar item.

I know the language. I've read a book. - _Madmatt

Re: Is it possible to query a unix server (SAN) with c sharp?

turbosupramk316-Jun-11 2:46

turbosupramk3

16-Jun-11 2:46

Thanks, all fixed.

Re: Is it possible to query a unix server (SAN) with c sharp?

BobJanova16-Jun-11 2:55

BobJanova

16-Jun-11 2:55

It's a command line interface, so you can start the program with Process.Start and talk to it through its redirected stdin/stdout streams (they are available from Process). Obviously to do that it needs to be on the same machine as you are – if it is a *nix-only app then that will mean you will have to run your C# app under Mono.

I didn't investigate in any detail but assuming the app has a sensible command line interface you should be able to write code to talk to it.

Re: Is it possible to query a unix server (SAN) with c sharp?

turbosupramk316-Jun-11 3:16

turbosupramk3

16-Jun-11 3:16

Hi, thank you for the response.

Which program would I want to start, a bash client, in a hidden window?

I will be local on the box, they link gives command lines to return values, but the unix portion of it is what has me confused.

Re: Is it possible to query a unix server (SAN) with c sharp?

BobJanova16-Jun-11 8:59

BobJanova

16-Jun-11 8:59

If it is a tool which takes a command line, executes and closes, then for each 'command' you should start a new process, with the command line you want to send, and capture the output. You can do that with Process.Start (set the ProcessStartInfo up to redirect the console streams). The fact it's on Unix shouldn't matter as long as Mono supports that part of the framework, and I'd be astonished if it doesn't.

Re: Is it possible to query a unix server (SAN) with c sharp?

PIEBALDconsult16-Jun-11 16:07

PIEBALDconsult

16-Jun-11 16:07

Can you telnet into it?

If so, you can do what I've done in the past: CommScript[^] and TelnetSocket[^].

Re: Is it possible to query a unix server (SAN) with c sharp?

turbosupramk316-Jun-11 16:54

turbosupramk3

16-Jun-11 16:54

I'm not sure, I will have to see if that is possible.

It is a Unix/Solaris SAN server connected to a fiber card of the windows server.

Convert string to datetime

treuveni15-Jun-11 9:16

treuveni

15-Jun-11 9:16

Hi,

I have a string with the format yyyymmdd.
I'm trying to convert it to date time by DateTime.Parse(myString),
but i'm getting an error.

How can i convert it?

Re: Convert string to datetime

Ennis Ray Lynch, Jr.15-Jun-11 9:23

Ennis Ray Lynch, Jr.

15-Jun-11 9:23

DateTime.ParseExact("20011215", "yyyyMMdd"); //note the capital M's

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS.

"And they, since they Were not the one dead, turned to their affairs" -- Robert Frost

Re: Convert string to datetime [modified]

treuveni15-Jun-11 9:30

treuveni

15-Jun-11 9:30

Ennis Ray Lynch, Jr. wrote:
DateTime.ParseExact("20011215", "yyyyMMdd"); //note the capital M's

What about the IFormatProvider at the constructor?
There is no constructor at the ParseExact that takes 2 parameters

modified on Wednesday, June 15, 2011 3:37 PM

Re: Convert string to datetime

AspDotNetDev15-Jun-11 9:41

AspDotNetDev

15-Jun-11 9:41

DateTime d = DateTime.ParseExact("20011215", "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);

Help a brotha out and vote Managing Your JavaScript Library in ASP.NET as the best ASP.NET article of May 2011.

Re: Convert string to datetime

treuveni15-Jun-11 9:43

treuveni

15-Jun-11 9:43

10x

Re: Convert string to datetime

GenJerDan15-Jun-11 11:30

GenJerDan

15-Jun-11 11:30

In addition to the other answers, there is also Convert.ToDateTime(something)

Always nice to know different methods of doing something.

Build a man a fire, and he'll be warm for a day.
Set a man on fire, and he'll be warm for the rest of his life.

My Mu[sic]
My Films
My Windows Programs, etc.

Re: Convert string to datetime

AspDotNetDev15-Jun-11 11:40

AspDotNetDev

15-Jun-11 11:40

That would not help in this case.

Help a brotha out and vote Managing Your JavaScript Library in ASP.NET as the best ASP.NET article of May 2011.

Re: Convert string to datetime

GenJerDan16-Jun-11 3:18

GenJerDan

16-Jun-11 3:18

Probably not, but I don't know all the possible Culture formats available. There might be one out there who decided to use sensible dates.

Build a man a fire, and he'll be warm for a day.
Set a man on fire, and he'll be warm for the rest of his life.

My Mu[sic]
My Films
My Windows Programs, etc.

Re: Convert string to datetime

V.15-Jun-11 20:04

15-Jun-11 20:04

1. What is the error it gives you
2. Use the TryParseExact function.
3. Read up on MSDN for the format string options[^]

Hope this helps.

Undo changes to context when using EntityFramework 4.0/4.1

MaWeRic15-Jun-11 5:59

MaWeRic

15-Jun-11 5:59

I have Invoice entity wich I change and then add InvoiceRows and then I want to cancel the whole operation.

What is the easiest way of doing this?
I can use Context.refresh() to get a fresh copy of my Entity but is this really the way to do it?

//h

Re: Undo changes to context when using EntityFramework 4.0/4.1

dasblinkenlight15-Jun-11 8:33

dasblinkenlight

15-Jun-11 8:33

I would use Context.Refresh(RefreshMode.StoreWins, obj) as my "Plan B".

My "Plan A" would be keeping changes outside of Context until they are ready to be committed, and then apply and commit them in an atomic operation. This requires more work as you need to track the state of newly added entities, but I think it is worth it, because the approach is cleaner overall.

Re: Undo changes to context when using EntityFramework 4.0/4.1

AspDotNetDev15-Jun-11 9:45

AspDotNetDev

15-Jun-11 9:45

Transaction. I've not worked with them with Entity Framework myself, but that seems like what you want.

Help a brotha out and vote Managing Your JavaScript Library in ASP.NET as the best ASP.NET article of May 2011.

[Solved] PropertyGrid with multiple SelectedObjects [modified]

lukeer15-Jun-11 4:31

lukeer

15-Jun-11 4:31

Hi experts,

there is a PropertyGrid in my application. It shows properties of an object. Some of these properties can hold values that are illegal to business logic. Those values show a warning symbol by using a custom TypeEditor. Mentioned properties are marked by an attribute.

Some of the properties are even linked. Business logic decides whether or not a combination of linked properties is illegal.

To this point all is fine.

Now the PropertyGrid has to show properties of multiple objects and the warning symbols don't work any longer.

This method should tell whether a property can, depending on its value, warn by setting the symbol

public override bool GetPaintValueSupported(System.ComponentModel.ITypeDescriptorContext context)
{
    // First chance: "Invalid" enumeration value
    if (
        context.PropertyDescriptor.PropertyType.IsEnum
        && Enum.IsDefined(context.PropertyDescriptor.PropertyType, "Invalid")
    )
        return(true);

    // Second chance: decorated with WarnableAttribute
    foreach(Attribute attribute in context.PropertyDescriptor.Attributes) //mark
        if(attribute is WarnableAttribute)
            return(true);

    // No support for drawing icon.
    return (false);
}

The marked line fails for multiple objects.context.PropertyDescriptor is a PropertyGridInternal.MergePropertyDescriptor, which is not accessible due to access levels.

How could I test for an icon to be painted?

Edit: It's working now thanks to ITypeDescriptorContext containing an object called instance, which is an Array when selecting multiple objects.
Knowing that, it's possible to check for attributes with some reflection.

Ciao,

luker

modified on Friday, June 17, 2011 3:19 AM

C# webservice

Member 401661615-Jun-11 4:09

Member 4016616

15-Jun-11 4:09

Environment – VS2010, Window 7;iis7.0

We have created a Web service (EDI_Translate) and we are consuming this webservice in C# console application. This console application calls the web service in a loop continuously in different thread. The web server handles the request sequentially (like first in first out) but we want web server to handle the request parallely to boost the performance. What should be done in webservice code or web server in order to handle the request paralley by webservice code .

Ramesh Kumar Singh
Software Engineer
Ness Technologies
India

Re: C# webservice

Not Active15-Jun-11 4:15

Not Active

15-Jun-11 4:15

Without knowing anything at all about what the webservice actually does or how it does it how do you expect anyone to accurately answer this?

I know the language. I've read a book. - _Madmatt

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