Visual Basic

Noctris18-Jun-08 22:58

Noctris

18-Jun-08 22:58

You want this automatically or want to do it manually ? You want incremental or just replace all the data on the hosted server ?

If you want to go automatic.. One of the best tools i've seen (opensource) in a long while is Jitterbit (http://www.jitterbit.com/[^]).

This is a piece of software that let's you do database integration on a drag-drop basis. You can go pretty advanced with it, and it connects to just about any database and "transforms" your data, based on a query to just about any other. It can handle webservices, txt or other files, etc .. etc.. and can be schedules to do inserts/updates ever x times ...

Might be worth taking a look at.

Ashfield18-Jun-08 23:18

Ashfield

18-Jun-08 23:18

Nice one. Never heard of it before, but it looks impressive. I think I'll try it out on a few systems I have.

Bob
Ashfield Consultants Ltd

Noctris19-Jun-08 0:01

Noctris

19-Jun-08 0:01

Well.. i got 2 of them running in production (on Windows 2003 Server) doing data transformation between ms-sql, MySql , XML and a couple of webservices. Never failed me once so i highly suggest it.

Currently testing the same functionality on a Linux Box in our testenviroment.

Enjoy !

jacko87319-Jun-08 9:38

jacko873

19-Jun-08 9:38

automatically & incremental

Regarding Outlook progrmamming using .net

Noctris21-Jun-08 23:42

Noctris

21-Jun-08 23:42

Well.. then it is definately worth taking a look at.. if you don't trust applications like this, i'm afraid you'll be writing your own data transformation tools....

Do Or Don't, there is no "try catch ex as exception end try"

Ansari Mohammad Aamir18-Jun-08 19:37

Ansari Mohammad Aamir

18-Jun-08 19:37

I am sending appointment to outlook 2003 using vb.net, i am able to send appointments but the problem is that on my local machine appointment comes with reminder checkbox checked but to reciepents the reminder checkbox remain uncheck. how to get that checkbox checked.
plz suggest a solution.

below is my code:
Dim oApp As Outlook.Application = New Outlook.Application()

Dim oAppt As Outlook._AppointmentItem = oApp.CreateItem(Outlook.OlItemType.olAppointmentItem)
oAppt.MeetingStatus = Outlook.OlMeetingStatus.olMeeting

oAppt.Subject = "Call Follow Up"
oAppt.Body = "Call Report"
oAppt.Location = "Mumbai"

oAppt.Start = Convert.ToDateTime(mdate & " 3:15:00 PM")
oAppt.End = Convert.ToDateTime(mdate & " 6:30:00 PM")

oAppt.ReminderSet = True
oAppt.ReminderMinutesBeforeStart = 5
oAppt.BusyStatus = Outlook.OlBusyStatus.olTentative
oAppt.IsOnlineMeeting = False
oAppt.AllDayEvent = False

Dim oRecipts As Outlook.Recipients = oAppt.Recipients

Dim oRecipt As Outlook.Recipient
oRecipt = oRecipts.Add(email)
oRecipt.Type = Outlook.OlMeetingRecipientType.olRequired

oRecipts.ResolveAll()

oAppt.Save()
oAppt.Send()

oApp = Nothing
oAppt = Nothing
oRecipts = Nothing
oRecipt = Nothing

Thanks and Regards
Aamir

Lock controls in a form

Sebastian T Xavier18-Jun-08 19:01

18-Jun-08 19:01

All,

In my application there is a form with multiple tabs. Each tab contains textboxes, buttons & grids. I want to lock all the controls (else make readonly) in that form. How i can achieve that? Any inputs would be appreciated.

Thanks in advance

Sebastian

Tom Deketelaere18-Jun-08 20:55

18-Jun-08 20:55

run thru all the controls using me.controls

check if the controls are container controls using control.haschildren
TRUE: run thru those controls and do the same check
FALSE: set enable / lock / readonly (according to what you want) based on the type of control it is (a select case with a gettype(control).tostring (case gettype(textbox).tostring) should do it)

in the true part I sugest you call a second function (since the check there has to be able to call itself again)

so in code it would look something like this
for each c as control in me.controls
if c.haschildren = true then
subfunction(c)
else
c.enable= false
end if
next

subfunction (subc as control)
for each c as control in subc.controls
if c.haschildren = true then
subfunction(c)
else
c.enable= false
end if
next

(this is out of my head and not tested mearly as an illustration)

or you could just lock the containers controls (this will lock all controls in it) but that's not as nice

hope this helps

Sebastian T Xavier20-Jun-08 4:24

20-Jun-08 4:24

Thanks for your reply...

Now the problem is , this code will disable the form also(i.e. the minimze, maximize & restore buttons of the form); How i can resolve this issue...

Please suggest...thanks in advance...

Sebastian

Tom Deketelaere23-Jun-08 1:09

23-Jun-08 1:09

can you post the code you used so I can have a better picture of what is going on

from what you said I think you locked the first iteration aswel (this is the form)

see if you past the form to the subfunction or not

first step is to iterate thru all the controls in me.controls
second step is to check if those controls have children
thirth step is to lock the control

without you'r code I can't really tell you more
If you post you'r code (just the 2 functions for locking) here I'll see if I can find the mistake

PS: sorry for the late answer but I was out the whole weekend

Sebastian T Xavier25-Jun-08 21:35

25-Jun-08 21:35

private void button1_Click(object sender, EventArgs e) { foreach (Control cntl in this.Controls) { if (cntl.HasChildren) { lockControls(cntl); } else { cntl.Enabled = false; } } }

private void lockControls(Control subcntl) { foreach (Control Ncntl in subcntl.Controls) { if (Ncntl.HasChildren) { lockControls(Ncntl); } else { Ncntl.Enabled = false;
} } }

Thanks

sebastian

Tom Deketelaere25-Jun-08 21:54

25-Jun-08 21:54

I can't seem to find anything wrong with this code

have you tryed to debug step by step and see when and where the form gets locked?

besides that you might want to dubble check you form property's to make shure you don't lock the form there

I'v tryed your code in a fresh project at my end and it works perfectly (form doesn't get disabled) so my suggestion would be to check if you don't disable you'r form somewhere else (in designer or code)

hope this helps

Sebastian T Xavier25-Jun-08 23:04

25-Jun-08 23:04

Here the problem is , this code will disable the form also(i.e. the minimze, maximize & restore buttons of the form); How i can resolve this issue...provided...I am not disabling the form anywhere else...

Thanks once again

Tom Deketelaere26-Jun-08 3:10

Wrong datetime will get when using Date in vb6

26-Jun-08 3:10

I can't tell you what could be wrong with it since I can't duplicate the problem

I created a new project added several controls to a form
copy - pasted your code excatly and ran the form
the form doesn't get disabled so I don't think there is anything wrong with this code

as a last resort you could always add the following code at the end of the function:

me.enable=true

cocoonwls18-Jun-08 15:39

cocoonwls

18-Jun-08 15:39

hi all,

In my vb6 application, i will use Date to get the current date and store it into my database.But sometime when i check in the database, the date will be different from what i see in my computer date. I am not sure what was happen.

Any help are welcome,Thank you.

Note:In my situation, i have 2 (A and B), which application B will map to application A's database where both of them will get the wrong date.

regards
cocoonwls

nishkarsh_k18-Jun-08 17:05

18-Jun-08 17:05

Check the Date format used in DB to store date and the format in which you are sending / displaying...

In VB6 you can use "format" command to format ur date before you send / display

Good luck

cocoonwls18-Jun-08 18:49

cocoonwls

18-Jun-08 18:49

hi nisharsh_k,

Thanks for reply. May be i am not describe my question clearly.
For example, the system date is 19-06-2008, but i will get the date 11-05-08 in my database.

So, according to your suggestion, is "format" can be apply in this situation?

Thank you in advance.

regards
cocoonwls I

nishkarsh_k18-Jun-08 22:14

18-Jun-08 22:14

i think format will help u in this situation

As you had written...

cocoonwls wrote:
For example, the system date is 19-06-2008, but i will get the date 11-05-08 in my database.

Hear ur system date format is "dd-MM-YYYY"

cocoonwls wrote:
19-06-2008

and ur DB date is "dd-MM-YY"

cocoonwls wrote:
11-05-08

this indicates that when you send date in a query it is not treated the way you expect as it is too long.... i am not sure how ur DB is looking at it (truncating or something) and storing it differently

good luck

cocoonwls22-Jun-08 16:45

cocoonwls

22-Jun-08 16:45

Thanks your reply. I will check it again.But for this problem, it is not happen frequently,but just sometime.. Confused | :confused:

Tom Deketelaere18-Jun-08 20:58

18-Jun-08 20:58

depending on the database you use, use the format function

SQL (probabaly oracle too): Format(date, "yyyyMMdd")

Access: Format(date, "yyyy/MM/dd")

Normally the sql one should be universal for all (or most) database's

hope this helps

images in vb.net

salam ellayan18-Jun-08 10:37

salam ellayan

18-Jun-08 10:37

how can i convert image exists in picturebox into bitstream using array function.

nishkarsh_k18-Jun-08 17:01

18-Jun-08 17:01

Hi...
i do not know what exactly you mean by array function... I am taking it as you want the picture to be stored in a array of bytes...

Plz look at the sample code...

'Define a memory stream
Dim ms As MemoryStream = New MemoryStream()

'Get the image into ms from picture box
pic.Image.Save(ms, pic.Image.RawFormat.Gif)

'Define a byte stream of length of memory stream and transfer the ms to it
Dim bytesA(CInt(ms.Length - 1)) As Byte

ms.Seek(0, SeekOrigin.Begin)
ms.Read(bytesA, 0, CInt(ms.Length))

ms.Dispose()

Good luck

salam ellayan18-Jun-08 22:42

salam ellayan

18-Jun-08 22:42

i need to convert the image into points .

nishkarsh_k18-Jun-08 23:53

18-Jun-08 23:53

Ok... for that you have to read every pixel of the image and store the location and color of it...

I had not tried that out... but for sure it is possible...

But why do u want to do it that ways???

If u just need the image to be recreated at destination this will solve ur purpose..

Regards
Nishkarsh