Comparing dates - C# Discussion Boards

Re: How to joint two wmv files (same framerate, resolution..)

Sam Xavier17-Jan-08 23:45

17-Jan-08 23:45

Hello,

I would suggest you to please browse to the following link which gives more information on the same:

http://www.codeproject.com/KB/graphics/ConvertVideoFileFormats.aspx?print=true

Best Regards,
Sam Xavier
www.componentone.com

Re: How to joint two wmv files (same framerate, resolution..)

Stumproot18-Jan-08 7:30

Stumproot

18-Jan-08 7:30

Thanks.
I'll take a look at it.

Clipboard and the DeviceIndependentBitmap format

Mike Hankey23-Dec-07 8:59

Mike Hankey

23-Dec-07 8:59

Hey ya'll,

I want to retrieve an image from a web page using the clipboard.
The question: I am trying to use the MemoryStream returned by GetData("DeviceIndependentBitmap") and create a bitmap for viewing from this.

I've googled and can't find squat so am asking the pros...I'm currently trying to do it this way;

MemoryStream stream = (MemoryStream)data.GetData("DeviceIndependentBitmap");
Bitmap bmp = new Bitmap(stream);

and I get the following exception: "Parameter is not valid"

Thanks,
Mike

Life is not measured by the number of breaths we take, but by the
moments that take our breath away. "George Carlin"

Find color in pixel.

jafingi23-Dec-07 4:05

jafingi

23-Dec-07 4:05

Hi,

I got a code where I move the mouse around the screen... Everytime the mouse moves a pixel, i have an action.

In that action, i want to find the color of the pixel there are in the screen position: 395,247...

Just need the color in HEX (#xxxxxx) or RGB (xxx,xxx,xxx).

Can anyone make an example for me to do that?

Thanks.

Re: Find color in pixel.

Kristian Sixhøj23-Dec-07 4:09

Kristian Sixhøj

23-Dec-07 4:09

The GetPixel function should be able to do that.

http://www.pinvoke.net/default.aspx/gdi32/GetPixel.html[^]

Kristian Sixhoej

"Failure is not an option" - Gene Kranz

Re: Find color in pixel.

jafingi23-Dec-07 5:49

jafingi

23-Dec-07 5:49

Thanks

works perfect..

Re: Find color in pixel.

Kristian Sixhøj23-Dec-07 6:28

Kristian Sixhøj

23-Dec-07 6:28

You're welcome Smile | :)

Kristian Sixhoej

"Failure is not an option" - Gene Kranz

Comparing dates

Demian Panello23-Dec-07 3:15

Demian Panello

23-Dec-07 3:15

Hi.

I'm writing an application that it use a SQL table for store and read data.
Sometime, I need to list all the registers between two dates, (there is a field of type datetime in the table).
So, I have to objects of type DateTime, ie, d1 and d2. Can anyone help me with the query string to list the registers between these two dates??.

Table name: Table1
Field datetime: birth

Query: "Select * from Table1 where birth > " + d1.toString() + " And birth <= " + d2.toString(); // It doesn't work.

I also tried with "#" characters between DateTime objects, but it doesn't work anyway.

Thanks.

Demian.

"I have always wished that my computer would be as easy to use as my
telephone. My wish has come true. I no longer know how to use my telephone."
-Bjarne Stroustrup, computer science professor, designer of C++
programming language (1950- )

Re: Comparing dates

Paul Conrad23-Dec-07 5:59

Paul Conrad

23-Dec-07 5:59

You should not use string concatenation since it opens you up to sql injection attacks. Use parameterized queries instead.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: Comparing dates

DannyAdler23-Dec-07 21:35

DannyAdler

23-Dec-07 21:35

Paul Conrad wrote:
You should not use string concatenation since it opens you up to sql injection attacks.

Hi there Paul,

Please explain your statement.

Thanks in advance.
Danny

Re: Comparing dates

Paul Conrad24-Dec-07 4:43

Paul Conrad

24-Dec-07 4:43

Read this article, http://www.codeproject.com/cs/database/SqlInjectionAttacks.asp[^]

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Re: Comparing dates

DannyAdler24-Dec-07 21:12

DannyAdler

24-Dec-07 21:12

Thanks man.
Good info.

Danny

Re: Comparing dates

GuyThiebaut23-Dec-07 6:03

GuyThiebaut

23-Dec-07 6:03

I'm not sure if this will work - give it a go anwyay:

<br />
"Select * from Table1 where birth > cast(""" + d1.toString() + """as datetime) And birth <= cast(""" + d2.toString()+""" as datetime)"<br />

Regards

Guy

You always pass failure on the way to success.

I can't get a property to be serialized to InitializeComponenet()

ctoma200523-Dec-07 1:39

ctoma2005

23-Dec-07 1:39

Hy there,I hava a problem..I created a control that has a public Brush property that the developer chooses from the property window. But If i change it..it doesn't get serialized to InitializeComponent() so at runtime it still has the default value

I created a UIEditor for this property and a BrushConverter : TypeConverter to let the design-time know how to convert from a InstanceDescriptor to a Brush.

Why doesn't this work? I debugged the design-time and when I change the property..the breakpoint in the method ConvertTo from the type converter doesn't hit

Thank you in advance.

How to set keyboard hook in C# ?

Yanshof23-Dec-07 0:15

Yanshof

23-Dec-07 0:15

Hi All,

In C++ i used the method "SetWindowsHookEx" to set this hook.

Is there is some easy way in .NET to do it ?

Thanks.

Re: How to set keyboard hook in C# ?

Anthony Mushrow23-Dec-07 0:29

Anthony Mushrow

23-Dec-07 0:29

Well, the easiest way, would probably be to use SetWindowsHookEx!

using System.Runtime.InteropServices;
...
public enum HookType : int
{
     WH_JOURNALRECORD = 0,
     WH_JOURNALPLAYBACK = 1,
     WH_KEYBOARD = 2,
     WH_GETMESSAGE = 3,
     WH_CALLWNDPROC = 4,
     WH_CBT = 5,
     WH_SYSMSGFILTER = 6,
     WH_MOUSE = 7,
     WH_HARDWARE = 8,
     WH_DEBUG = 9,
     WH_SHELL = 10,
     WH_FOREGROUNDIDLE = 11,
     WH_CALLWNDPROCRET = 12,    
     WH_KEYBOARD_LL = 13,
     WH_MOUSE_LL = 14
}

delegate int HookProc(int code, IntPtr wParam, IntPtr lParam);

ImprortDll["user32"]
public static extern IntPtr SetWindowsHookEx(HookType idHook, HookProc lpfn, IntPtr hMod, uint dwThreadId);

Check out: http://www.pinvoke.net/default.aspx/user32/SetWindowsHookEx.html[^] for more info.

My current favourite word is: Bauble!

-SK Genius

Re: How to set keyboard hook in C# ?

Giorgi Dalakishvili23-Dec-07 8:08

Giorgi Dalakishvili

23-Dec-07 8:08

Did you search codeproject? There are many articles here describing how to do it

#region signature
my articles
#endregion

How can i controll an email through C#

MissEng23-Dec-07 0:04

MissEng

23-Dec-07 0:04

hi
am doing a project in getting the emails from a server through local network and i've done most of the code but my problem when i get the mails from the server to display, all emails in the server display so my Qusetion is which command should i write that i can display only the last email i've recived??

Re: How can i controll an email through C#

Christian Graus23-Dec-07 11:22

Christian Graus

23-Dec-07 11:22

Well, if you're displaying them, what's hard about showing only the last one ?
'

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: How can i controll an email through C#

MissEng23-Dec-07 12:47

MissEng

23-Dec-07 12:47

i've try to do it but it not work i need a help with this plz

Re: How can i controll an email through C#

Anthony Mushrow23-Dec-07 13:31

Anthony Mushrow

23-Dec-07 13:31

If you've tried to do it, and came accross a problem, then give more detail about what you tried and the problems you encountered.

Once you've given sufficient information, people will actually be able to help.
For example, if i asked:

"I have made some code to merge two databases, how can i separate them again?"

Nobody knows how I merged the two databases, or anything about the databases themselves. How on Earth are they going to be able to help?

My current favourite word is: Bauble!

-SK Genius

Re: How can i controll an email through C#

MissEng23-Dec-07 13:47

MissEng

23-Dec-07 13:47

ok this is my first time to try to ask about help

this is my code i used to do

//Server code
private void button4_Click(object sender, EventArgs e)
{

TcpClient clientSocket = new TcpClient("10.40.145.212",110);
NetworkStream NetStrm = clientSocket.GetStream();
StreamReader RdStrm= new StreamReader(NetStrm);
tbStatus.Text += RdStrm.ReadLine();
sendPOP3cmd("USER "+ "Panel@wireless.com" + "\r\n",NetStrm);
sendPOP3cmd("PASS "+ "panel"+ "\r\n",NetStrm);
string Data = sendPOP3cmd("STAT\r\n",NetStrm);
string[] BreakDown = Data.Split(" ".ToCharArray());
int messageCount = Convert.ToInt32(BreakDown[1]);
for (int i=1;i<= messageCount;i++)
{
StringBuilder message = new StringBuilder("");
Data = "RETR " + Convert.ToString(i) + "\r\n";
byte[] szData=
System.Text.Encoding.ASCII.GetBytes(Data.ToCharArray());
NetStrm.Write(szData,0,szData.Length);
string szTemp = RdStrm.ReadLine();
while(szTemp!=".")
{
message.Append(szTemp);
tbStatus.Text += szTemp+"\r\n";
szTemp = RdStrm.ReadLine();
}
if (message.ToString().IndexOf("free money")>0)
{
sendPOP3cmd("DELE " + Convert.ToString(i) +
"\r\n",NetStrm);
}
}
clientSocket.Close();

//searchFor(ID)

//searchFor (xxx);//put the ID you have read in here);
}

private void searchFor()
{
throw new Exception("The method or operation is not implemented.");
}
public string sendPOP3cmd(string cmd,NetworkStream NetStrm)
{
byte[] szData;
string returnedData = "";
StreamReader RdStrm= new StreamReader(NetStrm);
szData =
System.Text.Encoding.ASCII.GetBytes(cmd.ToCharArray());
NetStrm.Write(szData,0,szData.Length);
returnedData = RdStrm.ReadLine();
tbStatus.Text += cmd + "\r\n" + returnedData + "\r\n";
return returnedData;
}

first i have to click on the button to connect to the server through local network, but when i display the emails all of the emails display but i need the latest one only.

another thing is how to cut the email i get into parts for example the name and the email address that i can take the email address then search the Data base i have created

thanx alot

SQlTransaction and SQlDatareader!

Navneet Hegde22-Dec-07 23:45

Navneet Hegde

22-Dec-07 23:45

Hi All,

There is problem with SQlTransaction

I have datatable filled from txt file .
Now before insert I check if the Row Exists
so I use sqlDataReder.
But I want to add the SQlTransaction , I am getting problem

Thanks,
Navneet

Develop2Program & Program2Develop

Re: SQlTransaction and SQlDatareader!

Xmen Real 23-Dec-07 15:01

Xmen Real

23-Dec-07 15:01

SqlConnection dataConnection = new SqlConnection();
SqlCommand dataCommand = new SqlCommand();
dataConnection.Open();
dataCommand.Connection = dataConnection;
dataCommand.Transaction = dataConnection.BeginTransaction();


//use dataCommand.Transaction.Commit() 
//use dataCommand.Transaction.Rollback()

hope it will help

Becoming Programmer...

Find CD-RW Drive

mina_raha9622-Dec-07 22:54

mina_raha96

22-Dec-07 22:54

hi
how to find CD-RW Drive?

tanks

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