List View Help needed. - Visual Basic Discussion Boards

Addition Operation with Access DB Column

Jason Baggett13-Feb-07 4:34

13-Feb-07 4:34

I’ve got a need to “add” an entire column of times (2 hrs, 30 min, etc.) and curious as to what the best starting point is. I want to calculate the total time of a column by means of a Button Click. I will need to do this per three different criteria for testing time.

I appreciate the advice.

Re: Addition Operation with Access DB Column

Kschuler13-Feb-07 5:30

Kschuler

13-Feb-07 5:30

You could just store the data in the column as an numeric value. For example, you can format the current time like this:
CInt(Now.ToString("hhmm"))
and now you have an integer value. There are also many other options for formating the time (You will want to research that, because I can't remember if hh or HH is military time and that will make a difference when you are converting the integer back into a DateTime object)

But I don't understand what you mean by calculating the total time of a column. You must mean that you want to get the time spans between the times right? Remember that there is a difference between a TimeSpan and a DateTime object.

Please provide more information if you need further help.

I hope this helps.

Re: Addition Operation with Access DB Column

Jason Baggett13-Feb-07 6:26

Jason Baggett

13-Feb-07 6:26

I knew what "I" was talking about and wanted; I didn't convey the actuals. Sorry.
I'm thinking time as in duration or test period. I apologize for the confusion on my part.

I have a column in an Access Db that states how long a test is running, 2 hours or 30 minutes and so on for 3 three different tests. Test A,B,C are in column 1 with the test duration in column 6.

Example:
Test 1
TestA 2.5 Hrs
TestA 30 Min

Test 2
TestB 20 Min
TestB 1.5 Hrs

Test 3
TestC 1 Hr
TestC 45 min

I need a way to calculate the entire testing times for Test 1, Test 2 and Test 3 individually. I am planning on having a ComboBox with these Tests 1,2,3 and a Button to Calculate the times associated with each test that is driven from the Access Db, per test.

Hope that makes better sense.

Re: Addition Operation with Access DB Column

Kschuler13-Feb-07 7:44

Kschuler

13-Feb-07 7:44

I'm still a bit confused. What is the data in your table going to look like?

I think I would suggest to store the testing durations as an integer value of minutes. So 2.5 hours would be stored as 150. Then you can convert them to display in whatever format you want later.

So, your initial question is still escaping me. If you are asking how to get the sum of the durations for each Test...it would be like this:
SELECT testField, SUM(duration) FROM table GROUP BY testField

If you are asking how to get the individual durations for a specific test it would be like this:
SELECT durationField FROM table WHERE testField='Test1'

If this is not what you are asking for, could you please explain the situation a little better. What is the difference between Test 1,2,3 and Test A,B,C?...what will your table look like with data in it?...what is it that your program is actually supposed to accomplish?

Hope this helps.

Re: Addition Operation with Access DB Column

Jason Baggett13-Feb-07 8:01

Jason Baggett

13-Feb-07 8:01

Sorry if I’m not explaining this very well.

I have under TestA, several test variations that each have a certain duration allotted to them. My need is to somehow calculate the entire time or duration for all tests in Test A and so on.

Example:
Test A - #1 takes 1 hr.
Test A - #2 takes 2 hrs.
Test A - #3 takes 3 hrs.

Button Click to add the entire Test A test times would equal 6 hrs.

The differences in Test A,B,C are all different tests. The 1,2,3 are tests performed for each Test A,B,C. Does that make sense?

This app is supposed to calculate the total duration of all testing to allocate personnel and resources effectively. Doesn’t seem logical to me, but evidently there’s a need for it.

Re: Addition Operation with Access DB Column

Kschuler13-Feb-07 8:07

Kschuler

13-Feb-07 8:07

That's okay...It's always hard to know what information is important when asking a question. But it seems to make more sense to me now. I think this is what you are looking for:

SELECT SUM(durationField) FROM table WHERE testField='TestA'

This will return the sum of durations for TestA.

Hope this works for you!

Re: Addition Operation with Access DB Column

Jason Baggett13-Feb-07 8:20

Jason Baggett

13-Feb-07 8:20

I'll give that a try and post a verdict. Thanks again for helping me and working through my information. I appreciate the help.

Thanks again.

List View Help needed.

sandipan.neogi@gmail.com13-Feb-07 4:30

sandipan.neogi@gmail.com

13-Feb-07 4:30

Hi I am creating a listview dynamically.But the list view columns are not fixed .on runtime I can change the column by mouse like excel.I want to stop it.how can I do it.
Thanks in Advance
Sandy

Updating Live

Situnes13-Feb-07 3:59

Situnes

13-Feb-07 3:59

Hello I am a visual basic starting developer for VWD. I was wondering how to make my website chat service "Live", I just need one page to be updated without a user having to press a button

Seanph

Updating Live

Situnes13-Feb-07 3:59

Situnes

13-Feb-07 3:59

Hello I am a visual basic starting developer for VWD. I was wondering how to make my website chat service "Live", I just need one page to be updated without a user having to press a button

Seanph

Event Handling of drop down lists inside a Datagrid Problem

Huvandhuma13-Feb-07 3:46

Huvandhuma

13-Feb-07 3:46

Hi..

I am having a problem with understanding how to catch the selected index changed event of a drop down list when placed inside a datagrid..

I have two drop down lists inside a datagrid.. i.e. DDLA and DDLB.. I have set DDLA on Autopost back and I want DDLB to be populated from the

database once DDLA's selected index changes..

Can anybody give any ideas on how to get this done.. Thanks Sniff | :^)

Beneath the blue blue skies..........

Re: Event Handling of drop down lists inside a Datagrid Problem

Marcus J. Smith13-Feb-07 4:06

Marcus J. Smith

13-Feb-07 4:06

I believe you will need to create a Protected Function for this purpose and in the column where you place the dropdownlist you will need to specify that function to be called when the index changes. The reason for this is that the objects inside the datagrid are created at runtime and therefore are not attached to any one function.

Cleako

Re: Event Handling of drop down lists inside a Datagrid Problem

Huvandhuma13-Feb-07 15:47

Huvandhuma

13-Feb-07 15:47

Can anyone show me an example or two perhaps so that i could get a clearer idea of how to proceed..Thanks Smile | :)

Re: Event Handling of drop down lists inside a Datagrid Problem

Marcus J. Smith14-Feb-07 3:07

Marcus J. Smith

14-Feb-07 3:07

<asp:DropDownList OnSelectedIndexChanged="TestFunction" runat="server" ID="ddlTesting"></asp:DropDownList>

After you have bound data to this then it should post back to the server after a drop down has occurred.

Cleako

Convert to a string

costavo13-Feb-07 2:58

costavo

13-Feb-07 2:58

hi,
how to convert an existing data in database to a string, in DataGrid
" i need something similar to : lstV.SubItems.Add(dt.Rows(i)("MTimeIN").ToString) which is used in list view" i need it in dataGrid
using vb2003
thank you

srour_costavo@hotmail.com

Re: Convert to a string

Dave Kreskowiak13-Feb-07 4:22

Dave Kreskowiak

13-Feb-07 4:22

I hope I'm understanding the question correctly...

You want to replace the functionality of adding items to a ListView to an equivilent of adding items to a DataGrid, correct?

A DataGrid doesn't maintain collections of objects like a list view does. It's bound to datasources that maintain those collections. So, create a DataTable object with a DataColumn, add your items to that table and bind the DataGrid to that DataTable.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Using "Me." to reference an object

Marcus J. Smith13-Feb-07 2:35

Marcus J. Smith

13-Feb-07 2:35

I know that in Java that "This." is required for accessing objects local to a form, etc. I also know that in VB.NET you CAN use "Me." for a similar purpose. I have never used it personally in my own code other than for Windows forms like "Me.Close()" but I have seen other people use it quite a bit and I noticed that in 1.1 the generated code always used "Me.". Is that just a programming style or is there more to it than that?

Thanks!
Cleako

Re: Using "Me." to reference an object

Colin Angus Mackay13-Feb-07 3:51

Colin Angus Mackay

13-Feb-07 3:51

cleako wrote:
Is that just a programming style or is there more to it than that?

I think it is just a programming style. It is equivalent to this in C#, C++ and Java. Personally, I use this (or Me) a lot because it shows intention more clearly, IMHO.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Re: Using "Me." to reference an object

Dave Kreskowiak13-Feb-07 4:13

Dave Kreskowiak

13-Feb-07 4:13

It's just a programming style. The compiler assumes Me. unless otherwise specified. Some people overuse it to death, putting Me. in front of everything, making the code painfully to read, even more so in the C# world with this.. It just makes your code easier to read in certain situations by taking away some abiguity, like in Property methods:

Public Class SomeClass
 
    Private x As Integer
 
    Public Property X() As Integer
        Get
            Return Me.x
        End Get
        Set(ByVal value As Integer)
            Me.x = value
        End Set
    End Property
End Class

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Using "Me." to reference an object

Marcus J. Smith13-Feb-07 4:22

Marcus J. Smith

13-Feb-07 4:22

Ahhhh, thanks, that's what I've seen and I've wondered.

Cleako

Re: Using "Me." to reference an object

Colin Angus Mackay13-Feb-07 4:22

Colin Angus Mackay

13-Feb-07 4:22

Dave Kreskowiak wrote:
Some people overuse it to death, putting Me. in front of everything, making the code painfully to read, even more so in the C# world with this

Dave Kreskowiak wrote:
It just makes your code easier to read in certain situations by taking away some abiguity, like in Property methods

I hope that I am sensible with where I use this and Me. However, I do use it a lot.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Re: Using "Me." to reference an object

Dave Kreskowiak13-Feb-07 5:55

Dave Kreskowiak

13-Feb-07 5:55

I'm sure you don't! :->

I've just seen C# code with this. on every single line where it's legal to put it. I can only sit back and watch as those four keys scrumble to bits of plastic as this is typed about 2,000 times per class file!

Dave Kreskowiak
Microsoft MVP - Visual Basic

paint event problem?

.NetRams13-Feb-07 1:06

.NetRams

13-Feb-07 1:06

Hi,
I have created an class which inherits button control. In that class i have created mousedown, mouseup and paint events.

In the paint event i have resized the button size. But it is not calling the paint event.

Let me know what i was wrong, and why it is not getting into paint evnet.

Rams.

Be simple and Be sample.

Re: paint event problem?

Dave Kreskowiak13-Feb-07 4:05

Dave Kreskowiak

13-Feb-07 4:05

You really shouldn't be resizing the control in the Paint event, but, whatever...

Did you call Me.Invalidate() to force the control to repaint itself?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: paint event problem?

.NetRams13-Feb-07 19:17

.NetRams

13-Feb-07 19:17

Yes, I have tried that too, I have called the mybase.invalidate() in new() constructor and also tried putting the btnobject.invalidate() while before adding this control to form.

even it is not calling paint event.

Be simple and Be sample.

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