Visual Basic

Dave Kreskowiak23-Mar-05 11:18

23-Mar-05 11:18

You're kidding, right? Another grade school math problem ... Twice in one day? There's got to be something wrong with the universe.

Multiply the English currency by the exchange rate for the foreign currency. How hard is that?

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

J4amieC23-Mar-05 11:51

J4amieC

23-Mar-05 11:51

god forbid someone wants the average exchange rate for the week Hmmm | :|

Dave Kreskowiak23-Mar-05 12:19

23-Mar-05 12:19

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

Moving itmes in a windows application

Christian Graus23-Mar-05 17:53

Christian Graus

23-Mar-05 17:53

If you don't know how to do this, then you should seriously buy a book, preferably a 'for dummies' book ( because you obviously know literally nothing about programming ). While you're a total beginner, you have time to move to a real language, like C#.

Issues with this question

1. Multiplying a number by another is about the simplest thing you could ever do in code. You obviously are not writing any applications if you can't do that. First piece of homework, more like

2. Exchange rates change daily. If this were a real world application ( as opposed to homework ), it would be useless without some way of updating rates.

We don't do homework here. We help people who are willing to try themselves first. You're thinking of rentacoder.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

Mr Dabbah23-Mar-05 1:47

Mr Dabbah

23-Mar-05 1:47

hello, in windows application using vb.net,how can i make an item movable in the run time?(change the position of the item on the screen)

Re: Moving itmes in a windows application

Anonymous23-Mar-05 18:41

Anonymous

23-Mar-05 18:41

hello,
did u mean controls or what item ask exactly that could undersatand

TimeSpan Average

Sumit Domyan23-Mar-05 0:58

Sumit Domyan

23-Mar-05 0:58

Hi All

I am using two TimeSpan varibales, suppose

Dim tt As TimeSpan
Dim tt1 As TimeSpan
Dim start_date As Date = Now.Date
Dim end_date As Date = Now.Date.AddMilliseconds(67)
Dim max As TimeSpan

tt = end_date.Subtract(start_date)
end_date = end_date.AddYears(1)
tt1 = end_date.Subtract(start_date)

Now, i want to calculate the average of tt & tt1.
Can anybody tell me how to do it?

Thanks

Sumit Domyan

J4amieC23-Mar-05 5:53

J4amieC

23-Mar-05 5:53

Im just amazed that someone can understand programming enought to obtain a timespan, but the process of getting an average has eluded them.

for future reference, an average is obtained by summing all values and dividing the result by the number of values.

ie, with 2 values
20
40

20+40 = 60
60/2 = 30

30 is the average of 20 & 40

So to get the average of your 2 timespan's add them together and divide by 2.

Sumit Domyan23-Mar-05 17:54

Sumit Domyan

23-Mar-05 17:54

Its not like that dear we cannot divide a time span directly. I have written a function for getting timespan average now. You just need to pass a timespan value which will be the sum of two values.

Friend Function AverageTimeSpan(ByVal time_span As TimeSpan) As TimeSpan
Dim temp_op As Int32
Dim seconds As Int32
Dim milli_seconds As Int32

'1 Day = 86400 Seconds
'1 Hour = 3600 Seconds
'1 Minute = 60 Seconds
seconds = 0
If time_span.Days > 0 Then
temp_op = time_span.Days
seconds += temp_op * 86400
End If

If time_span.Hours > 0 Then
temp_op = time_span.Hours
seconds += temp_op * 3600
End If

If time_span.Minutes > 0 Then
temp_op = time_span.Minutes
seconds += temp_op * 60
End If

If time_span.Seconds > 0 Then
temp_op = time_span.Seconds
seconds += temp_op
End If

milli_seconds = 0
If seconds > 0 Then
If seconds Mod 2 = 0 Then
seconds = CInt(seconds / 2)
Else
milli_seconds = 500
seconds -= 1
seconds = CInt(seconds / 2)
End If
End If

If time_span.Milliseconds > 0 Then
temp_op = time_span.Milliseconds
temp_op = CInt(temp_op / 2)
milli_seconds += temp_op
End If

AverageTimeSpan = CalculateTimeSpan(seconds, milli_seconds)
End Function

Friend Function CalculateTimeSpan(ByVal seconds As Integer, ByVal milliseconds As Int32) As TimeSpan
Dim days As Int32
Dim hours As Int32
Dim minutes As Int32
Dim temp_time_span As TimeSpan

'1 Day = 86400 Seconds
'1 Hour = 3600 Seconds
'1 Minute = 60 Seconds
days = CInt(Math.Floor(seconds / 86400))
seconds = seconds Mod 86400
If seconds > 0 Then
hours = CInt(Math.Floor(seconds / 3600))
seconds = seconds Mod 3600
Else
hours = 0
End If

If seconds > 0 Then
minutes = CInt(Math.Floor(seconds / 60))
seconds = seconds Mod 60
Else
minutes = 0
seconds = 0
End If

temp_time_span = New TimeSpan(days, hours, minutes, seconds, milliseconds)
CalculateTimeSpan = temp_time_span
End Function

Thanks

Sumit Domyan

Robert Rohde23-Mar-05 20:03

Robert Rohde

23-Mar-05 20:03

You are right that the operators are not overloaded. But instead of making such a huge calculation yourself you could just make use of the Ticks property:

<br />
Dim average As TimeSpan = TimeSpan.FromTicks((tt.Ticks + tt1.Ticks) / 2)<br />

Sumit Domyan23-Mar-05 22:05

Sumit Domyan

23-Mar-05 22:05

Thanks a lot for your kind help.

Sumit Domyan

Re: XML Upload to SQL Server

J4amieC23-Mar-05 23:27

J4amieC

23-Mar-05 23:27

Did that method actually work?

Excel & VBA Userform

saorscha22-Mar-05 21:07

saorscha

22-Mar-05 21:07

Can anyone help?

I am new to programming and have created a userform containing a mix of text boxes and several option boxes which are contained within frames. I have searched textbooks and the net but cannot find anything on how to show a users progress through the form when they use the tab key. At the moment, everything works fine while the user tabs through the textbox but there is nothing to indicate where the cursor is inside the frames.

Any help would be greatly appreciated.

Sorscha

XML Upload to SQL Server

cormac12322-Mar-05 18:57

cormac123

22-Mar-05 18:57

Folks

Hope someone out there is able to shed light on something for me. . .

In a nutshell, I have a local server that has all the main info stored on it and once a day an extract is done from one of the tables to an XML file and it is FTP'd to an ISP. The data is then uploaded into SQL Server for querying over the internet. Thats the theroy. . .

Problem is that the XML file is now 75Mb and getting bigger (slowly but surely!). When the file is FTP'd to the ISP, a web service is kicked off to read the file and update the ISP SQL Server, but the connection times out and the data is never updated. The message returned is "connection forcibly closed by remote host"

First question - is this the ISP's timeout or on my own server? The ISP were happy enough to change their setting to be 30 minutes, but even still this isnt helping, probably due to the size of the file.

Second question - would it be better to have a stand alone app that updates the ISP SQL Server due to the time it takes to process this file?

and to my thrid question - being relativly new to all this, does anyone know of any good methods for updating data to SQL server using VB.NET? I've searched the web and can only find info on how to retrieve and create XML files, not upload them into SQLS erver. Tell a lie, I have found one site, but applying the code used in it, maxes out the asp worker process and it dosnt really get anywhere. Previously to get this working I was using a combination of SQL commands and ODBC connections (on the web service), and looping through the dataset updating fields.

I'm sure theres a better way and if anyone could point me in the direction I'd gladly go looksee. . .

Cheers!

Dave Kreskowiak23-Mar-05 0:31

23-Mar-05 0:31

This question really belongs in the ASP.NET and/or SQL Forums. It had nothing to do with VB.NET.

But, IMHO, I'd be looking at ways to break this massive file down into smaller chunks and process those.

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

Email issue

MyThread22-Mar-05 11:31

MyThread

22-Mar-05 11:31

Hi,

My VB.net code sends an email to three people. It seems the client doesn't receive the email but the other two people of my company who are CC'ed on the email receive it. The 'FROM' attribute in the email address is in the format "xyz.ab@qwe.com".
Is it possible that the client email security system is not accepting the xyz.ab@qwe.com type emails. Any clues??

Please let me know.

Thanks.

Re: Email issue

Dave Kreskowiak22-Mar-05 15:23

Why am I getting TypeLoadException?

22-Mar-05 15:23

Since the other people are receiving the email, it would appear that the problem is with the sending server, not with your code. But, then again, you haven't shown us any of your code and only you could possibly know if the email address is even valid.

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

RvrBndBrewer22-Mar-05 10:14

RvrBndBrewer

22-Mar-05 10:14

I have 2 applications written in VB.NET for pocket pc 2003. Neither is complicated and each one runs perfectly. Problem is, I can't run them at the same time without getting a 'TypeLoadException' when starting the second one, regardless of which it is. I have set every reference in each project to "Local Copy" and it still happens - what's going on?

Thanks.

Confused | :confused:

Re: Why am I getting TypeLoadException?

Dave Kreskowiak22-Mar-05 15:18

.Net 1.1 with Visual Studio.Net 2002

22-Mar-05 15:18

You might want to post this question in the Embedded/Mobile Forum. Unless they using a common assembly you've written, there's no reason for this unless there is something platform specific that's causing it.

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

Anonymous22-Mar-05 10:06

Anonymous

22-Mar-05 10:06

We have created a windows application using Visual Studio.Net 2002.

1. How can we force it to use .Net 1.1 ?
2. We modified the <requiredruntime> element in the app.config file but doesn't seem to help.

Re: .Net 1.1 with Visual Studio.Net 2002

Dave Kreskowiak22-Mar-05 15:14