Re: Problem with making Outlook appointments - C# Discussion Boards

Re: WPF Transparent Window - can it still detect events?

24-Jan-08 8:39

Member 4294062 wrote:
WHY CAN'T MS GIVE US MANAGED CODE ACCESS TO LOW LEVEL GLOBAL SYSTEM EVENTS?

You can. Google around.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

DaveyM6924-Jan-08 11:01

DaveyM69

24-Jan-08 11:01

This[^] was posted earlier today - it's VERY cool!

Should I do MCSD certification for Framework 2.0 or wait for 3.0?

i_want_to_learn_c#24-Jan-08 7:23

i_want_to_learn_c#

24-Jan-08 7:23

Hi my company mostly usesd 2.0 framework and i need to do certification for better career .
I know 3.0 would be the in thing in a while in my firm.
But I am in dilemma that should I go for 2.0 or wait for 3.0.
Please advise.

C# Tool Kit for studio 2008

bigjoe11a24-Jan-08 6:15

bigjoe11a

24-Jan-08 6:15

I been looking for a Socket Tool Kit thats free for C# Sharp on studio 2008

Some thing that will have doc's and help with. Creating Servers in a Windows Application.

Re: C# Tool Kit for studio 2008

Ed.Poore24-Jan-08 8:46

Ed.Poore

24-Jan-08 8:46

Um, how about System.Net and http://msdn2.microsoft.com/en-us/library/system.net.aspx[^]? Good enough for you? Wink | ;)

Problem with making Outlook appointments

NewToAspDotNet24-Jan-08 6:06

24-Jan-08 6:06

Hi guys,
im using foreach to load some data from sqlserver and make appointmens from them in MS Outlook.
Something like this:

<br />
foreach (DataRow dr in dt.Rows)<br />
//make appointem(s)     <br />

Bud the problem is that wen there are for example 2 rows in my DataTable, it most create 2 appointments, bud i see that the Seconde appointment always re-writes or removes the First one and then i see only 1 appointment in outlook.

Can somebody help me with this???
thanx

Paul Conrad24-Jan-08 7:01

24-Jan-08 7:01

Can you provide a bit more code to what you are trying to do?

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

NewToAspDotNet24-Jan-08 8:05

24-Jan-08 8:05

Hi Paul Conrad,
Thanx for your response. Here some code of how it is looking like :

Outlook.Application outlookApp = new Outlook.Application();<br />
                Outlook.AppointmentItem oAppointment = (Outlook.AppointmentItem)outlookApp.CreateItem(Outlook.OlItemType.olAppointmentItem);<br />
                <br />
<br />
SqlCommand start = new SqlCommand("SELECT Act_actualstart,Act_actualstarttime FROM Activities WHERE Act_imp_nr='" + nr + "'and Act_Hoofdactiviteit_index='" + hfdnr + "'and Act_nr='001'", myconn);<br />
                    SqlDataAdapter da_start = new SqlDataAdapter(start);<br />
                    DataTable dt_start = new DataTable();<br />
                    da_start.Fill(dt_start);<br />
<br />
                    foreach (DataRow drstart in dt_start.Rows)<br />
                    {<br />
                        subject = "Communicatie naar; " +nr +"; " + omschrijving ;<br />
                        outStart = new DateTime();<br />
                        outStart = Convert.ToDateTime(drstart[0].ToString());<br />
                        oAppointment.Start = outStart;<br />
<br />
                        outEnd = new DateTime();<br />
                        outEnd = Convert.ToDateTime(drstart[1].ToString());<br />
<br />
                        oAppointment.End = outEnd;<br />
                        oAppointment.Subject = subject;<br />
                        oAppointment.Body = body.ToString();<br />
                        oAppointment.Location = " ";<br />
                    <br />
                        oAppointment.ReminderSet = true;<br />
                        oAppointment.ReminderMinutesBeforeStart = 5;<br />
                        oAppointment.Importance = Outlook.OlImportance.olImportanceHigh;<br />
                        oAppointment.BusyStatus = Outlook.OlBusyStatus.olBusy;<br />
                        oAppointment.Save();<br />
                }

Paul Conrad24-Jan-08 8:23

24-Jan-08 8:23

Djavid j wrote:
SqlCommand start = new SqlCommand("SELECT Act_actualstart,Act_actualstarttime FROM Activities WHERE Act_imp_nr='" + nr + "'and Act_Hoofdactiviteit_index='" + hfdnr + "'and Act_nr='001'", myconn);

Off topic, string concatenation for queries is very dangerous. Look up Colin Mackay' article on this site about SQL Injection Attacks and why parameterized queries are a good idea.

How many records is the dataset filling?

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

NewToAspDotNet24-Jan-08 8:32

24-Jan-08 8:32

Hi,
There is one dataset. Bud i think that in this case the sqlcommand is not the problem, because i did a check:
everytimne that a appointment is made, i get a message: appointment made succfully.
And in this case i have to datarows, so i get two times the message, and e checked that ofter the first time i got the 'appointment made succesfully' i saw the first appointment in Outlook. bud wen i click on ok on the messagebox i get the second message:'appointment made succesfully', then i see in Outlook that the first appointment is gone, there is only the second one.
(sorry for my english Smile | :)

)

Paul Conrad24-Jan-08 8:36

24-Jan-08 8:36

Djavid j wrote:
i have to datarows, so i get two times the message

It looks as if maybe your oAppointment.Save(); should be outside the foreach loop.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

NewToAspDotNet24-Jan-08 11:52

24-Jan-08 11:52

this way it diffenatly wil make just one appointment

Jimmanuel24-Jan-08 12:18

Jimmanuel

24-Jan-08 12:18

Shouldn't

Outlook.AppointmentItem oAppointment = (Outlook.AppointmentItem)outlookApp.CreateItem(Outlook.OlItemType.olAppointmentItem);

be inside the foreach loop? That way the loop creates a new appointment and saves it instead of overwriting the same object and saving it each time.

NewToAspDotNet24-Jan-08 13:53

Datagrid - Real time databinding (WinForms)

24-Jan-08 13:53

Yes that's the solution, thank you all, great help Smile | :)

J a a n s24-Jan-08 5:10

J a a n s

24-Jan-08 5:10

I am having a data source containing millions of records. Is there any data controls (like datagrid/listview) which will bind the data acoording to the region visible to end user i.e. when the grid is scrolled, the data will be loaded & displayed

If you can suggest me any idea on developing a new component also will be helpful. I am thinking about overriding the WndProc method for the message WM_VSCOLL in a grid.

Thanks

*jaans

Re: Datagrid - Real time databinding (WinForms)

Alan Balkany24-Jan-08 5:18

Re: Datagrid - Real time databinding (WinForms)

24-Jan-08 5:18

As Led Mike explained in the topic just below this, a virtual ListView will do exactly that. Here's a link: [^]

J a a n s24-Jan-08 5:23

J a a n s

24-Jan-08 5:23

Thanks Alan.
I have posted my query without reading the latest thread Smile | :)

*jaans

"On-demand" ListBox

Alan Balkany24-Jan-08 4:43

Re: "On-demand" ListBox [modified]

24-Jan-08 4:43

Hi,

I'm trying to create a ListBox that will only get the items that are currently visible. There could be up to millions of items, so storing them all simultaneously is slow and inefficient.

I tried setting the ListBox's DataSource to a custom object that implements IList, but when I do this, it immediately requests ALL the items.

I tried changing the DrawMode to OwnerDrawFixed, but it exhibits the same behavior.

Can anyone suggest a way of making the ListBox only request the items it's drawing, short of reimplementing it myself? Thanks!

Re: "On-demand" ListBox

DavidNohejl24-Jan-08 4:53

DavidNohejl

24-Jan-08 4:53

Why don't you use paging?

Ah and, are you having milions of items in ListBox?

[My Blog]
"Visual studio desperately needs some performance improvements. It is sometimes almost as slow as eclipse." - Rüdiger Klaehn
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe

Re: "On-demand" ListBox

led mike24-Jan-08 4:59

led mike

24-Jan-08 4:59

That is called Virtual Mode. I don't think ListBox has that but you should be able to satisfy your requirements by using the ListView which does have a Virtual Mode.

led mike

Alan Balkany24-Jan-08 5:16

24-Jan-08 5:16

Thanks Led Mike! That's just what I needed. In case anyone else has a similar problem, I found this article which explains how to use a virtual ListView: [^]

modified on Thursday, January 24, 2008 11:22:37 AM

Re: "On-demand" ListBox

Alan Balkany24-Jan-08 5:56