C# Discussion Boards - CodeProject

Andy Moore19-Jan-06 6:41

19-Jan-06 6:41

You can do this by using the interop layer to call Win32 functions. The function GetLocalTime will give you the local system time. Calling GetSystemTime will give you the current GMT time. You then can use SystemTimeToTzSpecificLocalTime to convert GMT to Eastern Standard Time.

Andy

Human beings were not meant to sit in little cubicles staring at computer screens all day, filling out useless forms and listening to eight different bosses drone on about about mission statements. -- Peter Gibbons

how create multi Selection reusult

Sasuko19-Jan-06 4:47

Sasuko

19-Jan-06 4:47

i want to create a DataSet with 2 Tables, and i would to popolate these tables with this selection string:
Select * FROM TableInfo Where User = "Sasuko"; Select DISTINCT Number FROM TableInfo;

but it is not supported in Microsoft Access? How can i do it?
Futhermore if i have a table like this

|Name|Number|
Sasuko 09
Nichol 07
Joy 07
Michael 09
Simon 09

i want as result 2 becouse 09 and 07 are the only two number inside the table; Select DISTINCT Number FROM TableInfo; return me two rows with 09 and 07. if i do Select Count('DISTINCT Number') FROM TableInfo; i get 5 that is the number of all the rows Frown | :(

Re: how create multi Selection reusult

Dario Solera19-Jan-06 6:53

Dario Solera

19-Jan-06 6:53

This is not the correct forum.
Use the SQL / ADO / ADO.NET messageboard.

___________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA]

Re: how create multi Selection reusult

Dave Kreskowiak19-Jan-06 10:23

Dave Kreskowiak

19-Jan-06 10:23

Jet/Access doesn't support multiple statements in a query, otherwise known at a batch in the SQL world. Only single statements are allowed. You'll have to break this up into two seperate queries and run them seperately.

I think your second query should look like this:

SELECT COUNT(DISTINCT Number) FROM TableInfo

No quotes around the DISTINCT Number part.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: how create multi Selection reusult

Sasuko19-Jan-06 13:32

Sasuko

19-Jan-06 13:32

not it doesn't work

Re: how create multi Selection reusult

Dave Kreskowiak19-Jan-06 14:53

Dave Kreskowiak

19-Jan-06 14:53

OK. It works perfectly in SQL Server. I knew I hated Access for some reason. The equivelent in Jet T-SQL is:

SELECT Count(*) AS DistinctNumberCount FROM
(SELECT DISTINCT Number AS DistinctNumbers FROM TableInfo);

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

SSLStream and Alert Message

elapid19-Jan-06 4:39

elapid

19-Jan-06 4:39

As for SSL/TLS, sending a notify is important. However it doesn't seem like SSLStream support that.
Please correct me if I am wrong, and what is the solution for this issue?

Thanks Smile | :)

Elapid For The Win

Re: SSLStream and Alert Message

elapid19-Jan-06 8:28

elapid

19-Jan-06 8:28

Need some help here pls Wink | ;)

Elapid For The Win

Re: SSLStream and Alert Message

Dave Kreskowiak19-Jan-06 10:05

Dave Kreskowiak

19-Jan-06 10:05

First, we don't get paid to do this. This is an all-volunteer effort, not a job.

Second, putting this little "I REALLY NEED HELP!" note up 4 hours after you posted the "question" probably got your post ignored even more.

Third, and probably what really got your question ignored, is your question really doesn't make any sense. Why would a stream class concern itself with putting up an Alert messagebox or anything else User Interface related? It's not what a Stream object is concerned with!

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

-- modified at 16:08 Thursday 19th January, 2006

Re: SSLStream and Alert Message

Dave Kreskowiak19-Jan-06 10:02

Dave Kreskowiak

19-Jan-06 10:02

Of course it doesn't support putting up an Alert Message. It supplies a Stream! Why would SSLStream concern itself with anything about a user interface element?

Sending a notification for what? That's going to be up to you and whatever you want to tell the user based on some condition...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: SSLStream and Alert Message

elapid19-Jan-06 10:50

elapid

19-Jan-06 10:50

Sorry for the lack of my courtesy Smile | :)

Okay let me verify my question.
In SSL/TLS, there are a struct called Alert Message. Now what it does is to notify the server/client a few things according to what it is going on.
Now with the SSLStream in .NET 2, it doesnt seem to have an option of handling that alert (notification).

So now my question is .. do i need to implement it? because if there is something that I am missing and can handle that, then i dont have to do it Smile | :)

THANK YOU.

Elapid For The Win

Re: SSLStream and Alert Message

Dave Kreskowiak19-Jan-06 11:54

Dave Kreskowiak

19-Jan-06 11:54

Thanks for the clarification.

No, the SSL Alert protocol has not been implemented in the .NET Framework, ... yet anyway.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: SSLStream and Alert Message

elapid19-Jan-06 12:54

elapid

19-Jan-06 12:54

you are the man!
Thanks

Elapid For The Win

How to do media streaming?

Divyang Mithaiwala19-Jan-06 4:13

Divyang Mithaiwala

19-Jan-06 4:13

Hello all,

I have to develop a project which can generate/capture a media streaming of different protocol(e.g. RTP,Microsoft multimedia server(MMS), ...).

So, is there any thing by which i can handle differet protocol?

Also mention that all stream are captured by media player/My own.So, I hava to handle different Encodeing/decoding(e.g. mp3,wav) techniques.

I mention that I see the functionaliy of VLC Player. But I have no idea to handle the component(axVLCPlugin) by C#.Net.

Floating point compare

_eulogy_19-Jan-06 3:59

_eulogy_

19-Jan-06 3:59

Hi!
I'm working on some math routines, and I need to see if two double's are *almost* equal. I've read

http://www.cygnus-software.com/papers/comparingfloats/comparingfloats.htm

and tried to implement the same thing in C# with doubles. After a bit of fiddling I got this following code:

public static bool CheckedApproximatelyEqual(double a, double b, int maxSteps)
{
	if (double.IsInfinity(a) || double.IsInfinity(b))
		return false;

	if (double.IsNaN(a) || double.IsNaN(b))
		return false;

	ulong aInt = unchecked((ulong)BitConverter.DoubleToInt64Bits(a));
	if ((aInt & 0x8000000000000000) == 0x8000000000000000) aInt = 0x8000000000000000 - aInt;

	ulong bInt = unchecked((ulong)BitConverter.DoubleToInt64Bits(b));
	if ((bInt & 0x8000000000000000) == 0x8000000000000000) bInt = 0x8000000000000000 - bInt;

	long dif = unchecked(Math.Abs((long)aInt - (long)bInt));

	return dif <= maxSteps;
}

Now the question is how does this look? Do you have any methods you believe are better for comparing floats?

There's *AT LEAST* one problem with this implementation, and that is denormalized values. Any suggestions on how to handle them? I guess I can just round them off to either zero or the smallest normalized value depending on their value!?

Fetch variable information over multiple lines with regex

SirErugor19-Jan-06 3:42

SirErugor

19-Jan-06 3:42

Hi,

I need a way to search a file with regular expressions to find the following syntax:

somevariable = "daaata on maybe one line" +
"might even be continued on more lines" +
"and so on...";

So actually to get from 'somevariable ..' to the end of it at 'on...";'.

Now, I have been using regular expressions numerous times, but I cannot determine how to check this?

Thanks! Smile | :)

- -
Regards SirErugor

-- modified at 9:43 Thursday 19th January, 2006

Remove white space from the beginning of a rich text

Agyeman19-Jan-06 3:30

Agyeman

19-Jan-06 3:30

How do i remove white spaces from the beginning of a rich text.
thanks

Nana

Re: Remove white space from the beginning of a rich text

CWIZO19-Jan-06 3:39

CWIZO

19-Jan-06 3:39

Use the Trim method...

Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

Re: Remove white space from the beginning of a rich text

Agyeman19-Jan-06 3:44

Agyeman

19-Jan-06 3:44

Thanks. But it is not working. I used the enter key to return to the next line. I did that through a couple of lines before typing the data. Now what I need to do is remove those return characters from the beginning while keeping the format.
thx

Nana

Re: Remove white space from the beginning of a rich text

CWIZO19-Jan-06 3:47

CWIZO

19-Jan-06 3:47

Well those are not spaces, so logically it will not work, eh?
Then you will have to use the Replace method, figuring out the algoritm shouldn't be to hard...

Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

Re: Remove white space from the beginning of a rich text

Agyeman19-Jan-06 6:01

Agyeman

19-Jan-06 6:01

thanks

Nana

Libraries of functions

Roger Jane19-Jan-06 3:27

Roger Jane

19-Jan-06 3:27

Hi All,

This might stem back to 'C' days and I probably ought to change my 'mindset' and other such phrases but old habits die hard. Call me Cliché Man...

When I write an applicaton, I tend to have a source file or two put aside to put all 'those little useful functions' in. You know, generic things like formatting a postal code, validating things etc. that don't fit in with a specific class anywhere. Well, using C#, I've implementing this as follows:

In library.cs:

<br />
namespace mylib {<br />
    public class rog {<br />
        static public int DoSomething(int arg) {<br />
            return arg+1;<br />
        }<br />
    }<br />
}<br />

To call this function, I'm putting this in app1.cs:

<br />
using mylib;<br />
...<br />
    b = rog.DoSomething(3);<br />

This seems like using a class where there is really no need. I'd like to just call 'DoSomething(3)' without the 'rog.' part.

I'm new to C# so be gentle, I'm old to C and C++ so feel free to be harsh.

Am I being stupid?

Thanks for any confirmation or denial...

Rog

Re: Libraries of functions

CWIZO19-Jan-06 3:42

CWIZO

19-Jan-06 3:42

You can't have methods without a class in C#...
So considering that your aproach is ok, but maybe not so OOish Smile | :)

Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

Re: Libraries of functions

Werdna19-Jan-06 4:43

Werdna

19-Jan-06 4:43

You can't do that in C#
In latest java (1.5) you can do static import and in C# 2.0 you can have static class that will force you to have only static members and can't instentiate that class.

One possible (but not recommended) solution would be to have
class rog
{
... static methods here...
}

class myclass : rog
{
... now you can call methods of rog without rog.
}

Re: Libraries of functions

Roger Jane20-Jan-06 7:14

Roger Jane

20-Jan-06 7:14

That's sort of what I'm after - I didn't think of deriving my class from the library - seems a roundabout way of resolving the function names though.

What I'm after really is a way of defining functions in the same way as you would, for example, the 'sin()' function as I'd much rather use:

result = sin(pi*4);

then

result = rog.sin(pi*4);

The library doesn't have any actual data (or if it is, it'll be static) and I don't intend to instantiate an instance of it.

I still have this nagging feeling that I just haven't 'got the hang' of C# yet...!

Rog

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