I am using VB and MySQL. I have a field named xTime and the data type is TIME. I am trying to find a way to order it ASC or enable it to have the PM/AM in it. Right now my Data is as follows and I need the 3:20 and 5:50 to be after since those should be pm.
[Code]...
Is everyone know how to sort time in listbox I've done the code for time to show on the listbox
Every time the user enter the laptime is different
I need to sort time like
2:45
5:30
10:20
Here is my code:
CODE:
I have table with date/time column and person column. Each person has multiple records for each day. What I need to do is next: I need to get first record for each person for each day... Can this be done in MVC3 Visual Basic and Entity framework?
View 2 RepliesHow can I improve this bit below to make the items in the TreeView to sort faster or something totally different to sort them easier?
[Code]...
I have a MyObject; myObjects as List(Of MyObject) and a delegate Comparison(Of MyObject) that uses a lot of comparison functions (ByA, ByB, ByC etc) Ã la:
Shared Function CompareMyObjectsByName(x As MyObject, y As MyObject) As Integer
Return x.Name.CompareTo(y.Name)
End Function
[Code].....
Sub Sort()
ReDim RollsCC(NumOfPlayers - 1)
For N As Integer = 0 To (NumOfPlayers - 1)[code]....
Here I am creating a temp single dimensional array, merging my 2d array into it, and then attempting to sort it by Rolls(N,1), which is a integer 1-6, Everything seems to be working right with the exception of this.
RollsCC.Sort(RollsCC, 0, 1)
How would one specify a numeral sort based on the first character in the string? im aware that I am switching Rolls(n,1) and Rolls(n,0) information during the sort.
Currently my ListView sorts items by image.index. So 0 is at the top, then 1, 2 and so on. Think of it as an IRC chat room nick list. Ops at top then the rest are sorted alphabetically
[Code]....
I am trying to sort an arraylist using .Sort() but am not sure what to put in the () for the field/column I want to sort on. Here is the portion of my code that creates the array from a SQL Query
[Code]...
I have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
I am using the Array type .Sort function to sort my array.By default it places the result Array into Ascending order Least to Greatest How do I change that to Descending order Greatest to Least?and How do I change it to Closest to logic? or does that not exist?Assume there is an Array of Numbers 0,13,21,-2,4,5,1.34 and I want them to sort closest to 0 or some other arbitray value; the Output should look similar to:
0,1.34,-2,4,5,13,21
I have a List(Of T) storing a list of Custom classes called Advertisement. Each advertisement contains 3 properties, Year, Make and Model. I need to sort the list By Year, then by Make and then by Model. I have a property in the Advertisement class called Vehicle which returns a formatted string with the Year Make Model like 2007 Toyota Tacoma and ive been sorting on that but its not working how I thought it would. Basically I want to sort the list by Year (decending; lowest year first) then sort by the Make and Model (in alphabetical order) Is that even possible? Here is the code ive been using.
[Code]...
The idea with this form is to add the futures which is calculated when the button is pushed but I need the list to update every time and show the values each time to which the previous value is added to the new calculation, e.g. of what it should look like in listbox:
Year 1: $1,290.93
Year 2: $2,724.32
Year 3: $4,350.76
etc....
I have been working on this a while and I am at a standstill, I was given a function to clear the form everytime it calculates but I don't know how to implement it, I am new to VB. Here is what I have so far:
Public Class frmFutureValue
Private Sub btnCalculate_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnCalculate.Click
[code]....
Basically i'm trying making a task manager program for myself. I want to know how I can display a message box and or play a sound when system time = time displayed in listview. I have used a dropdown box for the user to select which option they would like to select - sound or message box to popup. The data for the task will be stored in a listview box. I want it so that when the date and the time is = to the date and time set for the reminder the action will follow.Here is my code so far:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim notext As String = ""
If TextBox1.Text = notext Then[code]....
So I currently have the following:
2 timers
2 labels
1st label is "Clock" this pulls the time from the users current time zone/local time
2nd label is "UTCClock" Which would be UTC time
Now I have this for the first label: clock.Text = Format(TimeOfDay, "hh:mm:ss tt")
Which would give the users current time zone/local time. As for the UTC.. how would I add in for the UTC time from where the user is located at? I did some searches.. but couldnt find what I was looking for.. IM pretty sure its not as easy as getting the users current time zone/local time.. So im assuming that Theres a "bit more" code into getting UTC time..
I'm using
Days = Dat2.Subtract(Dat1).Days
where
Dat2 = today
Dat1 = installed date
to trace the days of a program installed in user's computer.However, the user can changes the system time of his computer to a advancing date. How can I get a SNTP time from internet to solve this problem?
I need a start date, a Total time passed until now, an average time per step, and a estimated time to finished. How can I do that? Also, I can close the application and when start up again I want to get the time counters as the last time, so How can I store that data is normal txt file (I say txt to take advantage of the ini app file which is a txt).
View 1 RepliesI am using this line of code on form load event it is working very fine but i have to problems
1. It replaces the form name and display the date and time but i want to keep both date and time and forms caption separated by some space.
2. When form loads it load the current date and time but the time does not change it should run.
What should i do please please help me code is as follows
Me.Text = Date.Now.ToLongDateString & " - " & TimeOfDay
I used .NET Framework 1.1 in C/S project before. Now I have updated the project to use .NET Framework 3.5 without modifying source code, but I have found that : the Remoted DateTime values can not be converted to the equivalent local time of a remote computer that is in a different time zone. In .NET Framework 1.1, the DateTime values can be converted automatically.
[Code]...
There is a varchar column in the database table in this format of military time 1230 or 1750 or 1320 and that field get populated into a gridview in asp. I need to convert that string to standard time. I have tried the DateFormatString and nothing seems to work.
the asp is
<asp:BoundColumn DataField="ScanTime" SortExpression="ScanTime" ReadOnly="True"
HeaderText="Scan Time" DataFormatString="{0:hh}:{0:mm} {tt}">
<ItemStyle Width="80px"></ItemStyle>
</asp:BoundColumn>
that DateFormatString causes Input string was not in a correct format. error.
I have tried combinations of hh:mm and things like that but since its a varchar I think its failing
How to get the current date and time in textbox in IST ( Indian Standard Time) in vb.net ?
View 1 Repliesat the time of recoredset movenext out of memory error occured in run time data have 3800000 lakh recored
View 2 RepliesIs there a way of converting a unix time stamp to normal format time and date in .NET?
View 3 Repliesusing VS2008, targetting framework 3.5I have a rather complex UserConrol which does some of its own rendering.I display this UserControl on a form.Opening that form in the Designer creates an instance of the UserControl in the Designer, which tells me a NullReferenceException is occurring in one of my rendering methods.I have attempted to correct this by making alterations to the UserControl's default constructor, but have not found success.
View 1 RepliesJust getting started in VB.NET. I would like to add X-number of text boxes at run time. And then be able to address them by their index or some sequential numerical value (like an array)
This is what I have so far:
CODE:
When I turn this into a loop to create multiple toolboxes, how do I assign a name to the controls, or will all of them be named "MyTextBox" ? I'll increment their position so thats no problem.
When I run my app at first its keeps time accurately for the first minute or so there after it starts loosing seconds, and by the end of the day its minutes behind.I've created a class called ServerTimeTimer that has a timers.timer object that elapses every second and adds a second to a dateTime variable, and a property to retrieve the date time.[code]
View 5 Repliesi'm using a date time picker with format set to time. i want to be able to trigger an event at the time selected in the date time picker
View 19 RepliesI have a program that reads a file with Pacific Daylight Time, I want users to see the time and date in their local environment.
At present I have in Australia a time difference of 18 hours, so I have a list box with -24 to +24 and currently set at 18, my code is elementary as long as I have moved past day one of the month it suits me personally, but I want to distribute my app, so I need something better.
i'm using a date time picker and want an event to trigger with just the time so it will trigger every day at a certain time. can anybody help
View 1 RepliesI want to verify if the current system time falls within the specified time range between 7:30pm - 9:00pm. If it falls within the specified time range then display a message.
View 7 Repliesi have difficulties in making school schedule time and school bell? how to modify time span in comparing more than 40's variables time.
View 3 Replies