Visual Basic

Re: Calculating avarge time ??

3-Oct-09 9:56

There is no such thing as averaging string together, so I'm not surprised this didn't work.

Convert each string in your textboxes to TimeSpan objects. You can then easily get the number of milliseconds in each TimeSpan, average those together and create a new TimeSpan object with the result. This will give you the ability to easily convert the result to a String you can display in the correct format.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Bob Beaubien3-Oct-09 15:39

Bob Beaubien

3-Oct-09 15:39

Hi Dave

i looked it up and tryed a few thing but i cant get it to work
can i have a example please ???

Thanks
Bob

Re: Calculating avarge time ??

Dave Kreskowiak4-Oct-09 2:20

Button more then one click

4-Oct-09 2:20

You convert a string in a TextBox to a TimeSpan using:

Dim timeIntervals(5) As TimeSpan
' 5 hours, 21 minutes, 40 seconds
TimeSpan.TryParse("5:21:40", timeIntervals(0))

You can add all of the time intervals together like this:

Dim avgTime As New TimeSpan
For i As Integer = 0 to 4
    avgTime = avgTime.Add(time(i))
Next

And then average the times:

avgTime = New TimeSpan(avgTime.Ticks / 5)

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Bob Beaubien2-Oct-09 18:45

Bob Beaubien

2-Oct-09 18:45

Hello everyone

how can i make a button do one thing when click and when you click it agine it will somting else and so on

somting like this
click once = code1
click twice = code2
click three time = code3
click a forth time = code4
on and on

Thanks
Bob

Re: Button more then one click

dan!sh 2-Oct-09 19:26

dan!sh

2-Oct-09 19:26

Two ways. One is to have a class level variable that will hold the click count. Checking that, you can execute the appropriate code. Or you can use the Tag property of the button serving the same purpose. Although you will need to cast that to integer every time you use it.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Re: Button more then one click

Abhishek Sur3-Oct-09 6:58

Abhishek Sur

3-Oct-09 6:58

There is another option.
You can create methods that handles each of the clicks and just within each handler write this below so that once the code gets executed it will remove its handler and attach another handler to it.

RemoveHandler btn.click, addressof btn_click
AddHandler btn.click, addressof btn2nd_click

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Microsoft Bing MAP using Javascript
CLR objects in SQL Server 2005
Uncommon C# Keywords/xml>

Date Value into the Database!!!

jeshra2792-Oct-09 9:06

jeshra279

2-Oct-09 9:06

Hi everyone,
I am inserting date into y sql database from DateTimePicker Control. The code is as follows:

Dim joindatetime As String, joindate As String

joindatetime = DateTimePicker.Value.ToString
joindate = Format(joindatetime, "Short Date")

for example, the output "joindate" is "12/02/2009".
Now, when I am inserting this "joindate" value into my database, I found that in database column, the entry is not Date i.e. "12/02/2009" but it is both date and time i.e. "12/02/2009 12:40 PM".

What I want is to enter the "12/02/2009" only into the database without the time value.

Hope my query is clear,Can someone help me out on this?

Thanks

drinkmasters2-Oct-09 9:18

drinkmasters

2-Oct-09 9:18

First try: DateTimePicker1.Value.ToShortDateString

Regards:
Robert

Luc Pattyn2-Oct-09 9:34

Luc Pattyn

2-Oct-09 9:34

you don't store numbers as strings, do you?

so you shouldn't store dates and times as strings, both programming languages and SQL-like languages have special types for date and time information. Using them offers extra functionality (e.g. comparing dates, picking date parts) and shield you from formatting issues (regional settings, dd/mm/yy versus mm-dd-yyyy and many more).

Smile | :)

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Henry Minute2-Oct-09 10:15

Henry Minute

2-Oct-09 10:15

If you are using SqlServer 2008 there are Date, Time, DateTime, SmallDateTime, DateTime2 and DateTimeOffset datatypes. Pick the one which fits your use.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Christian Graus2-Oct-09 11:18

Christian Graus

2-Oct-09 11:18

You should spend some time thinking about what it is you're doing. What happens if you want to display the date in a different format later ? What if you want to search for all objects within a date range ? These are the reasons you store a date as a date and let the presentation layer worry about how a date should be presented.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Reading a file on a network drive

Md. Marufuzzaman4-Oct-09 4:13

Md. Marufuzzaman

4-Oct-09 4:13

Try the following transact-sql..

SELECT CONVERT(CHAR(10), GETDATE(), 103)

convert a DateTime ('2004-06-24 06:01:40.000') to a simple date format ('dd/mm/yyyy' )

Thanks
Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

rbc10252-Oct-09 4:05

rbc1025

2-Oct-09 4:05

I'm a newbie to VB.NET and I' m trying to write a small Windows forms app that searches a network drive for a folder and reads the specified file. It seems like the best approach would be to use the System.IO classes to search the directory and open the files. My question is do I need to open a socket and use the Network Stream object to access this network file? If the computer is just a terminal already connected to the network is this required or do I simply need file permissions on that machine to access the file?
Any advice would be greatly appreciated!!

Ian Shlasko2-Oct-09 4:17

Ian Shlasko

2-Oct-09 4:17

rbc1025 wrote:
do I simply need file permissions on that machine to access the file?

Correct.

If it's just a regular network share, you can access it just like a local file.

Proud to have finally moved to the A-Ark. Which one are you in?
Developer, Author (Guardians of Xen)

rbc10252-Oct-09 16:13

rbc1025

2-Oct-09 16:13

Thanks Ian. I didn't have all the details of the network when I was posting. I feel a bit ignorant as I realized it would obviously appaer as virtual drive to the networked machine. Thanks for your response!

Md. Marufuzzaman4-Oct-09 4:17

Md. Marufuzzaman

4-Oct-09 4:17

I agree with you.. But i think it will cover on local environment not remote...

Thanks
Md. Marufuzzaman

Dave Kreskowiak2-Oct-09 4:25

2-Oct-09 4:25

If you can already see the directory the files are in using standard Directory and File methods, why would you need to open a socket to the server to read the file?? You just open the file like you would any other local file on your machine.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

How can I list a directory into a listBox and view its content OnClick inside the listBox?

rbc10252-Oct-09 16:10

rbc1025

2-Oct-09 16:10

Thanks Dave! I realized shortly after I posted this that it would appear as a simple drive on the networked machine. I didn;t have all the details before I posted but I thank you all the same.

waner michaud2-Oct-09 3:35

waner michaud

2-Oct-09 3:35

Hi,
Can anyone guide me on a simple code to load a directory into a listBox and When I click a file it loads in its respective format.

I look all over the place, what I found is confusing and not compatable with visual studio 2005

thanks,

Re: How can I list a directory into a listBox and view its content OnClick inside the listBox?

Dave Kreskowiak2-Oct-09 4:22

Re: How can I list a directory into a listBox and view its content OnClick inside the listBox?

2-Oct-09 4:22

Look at the Directory.GetFiles() method. It'll return an array of filenames in the directory you specify. You can then add those names to the ListBox.

When the user clicks the file, you can use the Process class to launch the file. You don't need to know what application opens the file.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

waner michaud2-Oct-09 8:25

waner michaud

2-Oct-09 8:25

Thanks,

I did something like this below but i cannot get it to list the file in a listbox:

Dim Files As String()
Dim FileName As String
Files = directory.Getfiles("C:\", "*")

for each fileName in Files

listbox.text=FileName
next

the file will not list in the listBox

thanks again

Re: How can I list a directory into a listBox and view its content OnClick inside the listBox?

Luc Pattyn2-Oct-09 8:30

Luc Pattyn

2-Oct-09 8:30

Hi,

every Control has a Text property; for simple Controls, such as a Label, that sets the content.
For listing Controls (ListBox, ListView, ...) the content is a collection, often called Items.

If all this is new to you, I strongly suggest you pick up a book on Windows programming, then use MSDN or google to refresh your memory on specific details.

Smile | :)

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: How can I list a directory into a listBox and view its content OnClick inside the listBox?

waner michaud2-Oct-09 8:38

waner michaud

2-Oct-09 8:38

You are right but listbox.items is READONLY property..

so how can i achieve my goal here?

Re: How can I list a directory into a listBox and view its content OnClick inside the listBox?

Dave Kreskowiak2-Oct-09 8:43