I have a Datetimepicker, when i select a date it brings up in a listbox all the files created on that day but in no particular order. So i wanted it sorted by when they were created (not to fussed either ascending or descending). i tried using the code below with no luck, This adds multiple of blocks of the same files on the selected date
[Code].....
i am trying to get files name, modified date in a folder Before i get those files, can i pump a command by using vb to the folder and make them sort by modified date?
View 6 Replieshow can I sort (not filter) directoryinfo files by date (oldest to recent) ? I am using asp.net and visual studio 2008
View 2 RepliesI have a gridview that looks something like this[code]...
How can I display the file's date time created in the gridView (by that I mean what is the correct syntax for)[code]...
I've got a datatable with a DateTime field that I want to sort using a DataView. I only need the Time part of the column though, and not the date. I can't get it to show just the time and not the date as long as its a DateTime column. I know I could convert it to a string to get the time, but then it wont sort correctly.
View 1 RepliesI want to save datetimepicker value of date and time in two separate text files. Currently, when I select a date from datetimepicker and save it in a text file it saves both date and time as below:
5/11/2011 8:25:06 PM What I would like to happen is as below: Datefile.txt saves 5/11/2011 Timefile.txt saves 8:25:06 PM Alternative solution that can work for me would be, if the time (only the TIME) can be modified after saving as below: saved datetime into text file is 5/11/2011 8:25:06 PM
How can I modify the time only to say 12:00:00 PM. By doing so I would like to keep time as 12:00:00 but date can be changed by the user using the datetime picker.
In a typical session with the program I'm writing, the user needs to be able to access the data in 1 to 500 (maybe) tables (but always only one table at a time). Up to now I've been creating these single table datasets dynamically, as and when required.I've now come across the distinction between typed and untyped datasets (where typed seems to be the recommended option). It seems, though, that typed datasets are created at design time only and not dynamically. Is this correct? Are all of my dynamically created datasets therefore untyped?
View 12 RepliesHow can i make my app execute some code at specified day/time (Day/minutes/secconds)?I need to make a scheduled app that will backup(copy) some files at specified time/date.
View 4 RepliesThought I'd see if Stack overflow is quicker than me testing something while I get a thousand interruptions from other work :)
I'm updating an old VB net application and trying to refactor some of the logic as I go. The app looks for data from a single date across a few tables and writes that view to a file.
Writing the query in SQL I'd get the equivalent of
SELECT * FROM table
WHERE CAST(FLOOR(CAST(table.date AS float))AS datetime) = '15-Jul-2010'
Ideally I'd use
SELECT * FROM table WHERE date=@input
and add a date object as a parameter to a System.Data.SqlClient.SqlCommand instance
Are those two comparable? Will I get the results I expect?
I am using VB 2008 and want to record a start date and time and then the stop date and time in a rich text box, i can get the start time into the box but so far can only stop the time instead of 2 seperate times, what i have is a drop down box with a list of computers 1-10 i was trying to get it so you picked a certain computer and that went into the text box then you started the timer and that was recorded, finally you stopped the timer and that was recorded but as i am a total newbie it does not work
Here is the code i have.
Public Class Form1
Dim time2 As Date
[CODE]...................
I have an editor created invb.net that creates html files. And when i click the button run , the Internet Explorer opens my file that is inside the Richtextbox.
View 3 RepliesThis is similar to How to keep the order of elements in hashtable, except for .NET. Is there any Hashtable or Dictionary in .NET that allows you to access it's .Index property for the entry in the order in which it was added to the collection?
View 5 RepliesI am working with a date and time picker on one of my forms. I am wanting to have the user select a date and then that date will be output to one of my reports along with other information.The way i have been doing this so far is like this:edoc.Worksheets(1).cells(13, 4) = patient_frm.txt_fname.TextI need to be able to grab the date that the user selects and output it in much the same manner. However i have tried the following and i get no output at all.
View 2 RepliesTitle pretty much says it all. How do I format the date of a dateandtimepicker to insert it into the SQL date datatype?
View 20 Replieshow to get the date n time in this format? Tue, 17 Aug 2010 09:33:13 -0400
View 8 RepliesI want to display time and date in a RichTextBox, next line after a piece of writing.However, my code makes the whole text lose formatting.
My Time and Date
Rich.Text += Environment.NewLine + Now.ToString + Environment.NewLine
how to Change the System Date/Time via VB.Net?
View 1 Repliescould anybody point me in the right direction in regards to the following problem? I have some data that has time and date in form of ordinary string. The format is always the same, for instance:
[Code]...
How can I convert it to time understood by computer and check if given time is in the past of in the future in comparsion to current time on my computer? I would also like to be able to tell how much difference there is between the time from my data file and the current time. For instance to say "this time was 3 hours and 20 mintues ago".
I have a program in vb.net and with it I have an expiration Key. As an example I would like this key to be valid for 3 months .I don't want to use the users system.date in case the user changes the date.Could a public server's date time be used instead.
View 6 RepliesI'm building an application in which a certain CSV schedule is read and searched for time and date values.
I want to read each cell in the CSV file with a streamreader and have VB determine if the contents of the cell represent a date (like 31-10-2011), a time (like 22:30) or random text data which is not formatted like a date or time.
How can I make VB recognize a string as either a date, a time or neither one, so I can use this string formatted as Date, Time or discard of it?
The contents of the CSV file will look something like this:
;Schedulename;text;text;31-10-2011;text;text;6-11-2011;text;;;text
Although the CSV file will never contain much data, the position of the date and time fields in a row may vary, so I cannot tell VB which cell to read as date/time. It has to recognize the value as date, time, or unusable text.
Dim CSVReadline As New System.IO.StreamReader(schedule.csv")
Cellcheck = CSVReadline.ReadLine()
String = Cellcheck.Split(";")
For i = 0 to 10
Scheduledate = String(i) ............ etc.
Would it be possible to display todays date with a time of 23:59 in ctime in a textbox? i.e. 25/05/2012 23:59 in ctime? I use the following coding to display the current date and time
lbldate.Text = Date.Now.ToString("dd MMM yyyy HH:mm:ss")
I'm doing an error log in my code and I'm trying to output the errors to a text file with a specific date/time in the title so they can differentiate. I've tried things like
logname = "C:Documents and SettingsSeDingDesktopErrorserrorsLog " & DateTime.Now.ToString() & ".log"
But I get this msg "The given path's format is not supported." all the time.
Im having a problem passing a date and time stamp from vb to mysql. My code is as follows:ComboBox1.Text.ToUpper() & "', '" & TextBox1.Text & "', '" & Now() & "'"Where the comboBox populates the first field, the textbox populates the second and in the third I get 0000-00-00 00:00:00. I have formatted the field as date and time - which is what I am after
View 8 RepliesI 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'm having a problem with my DataGridView. When I double-click on any column, with exception to Date & Time, the grid advances by 1. As you can see the 2nd row is highlighted in blue, I actually double-clicked on the first one, under "Sent By." (See attached image)
Here is my code
VB.NET
Public Class frmPickAssignment
Dim dteStart As Date
Dim dteEnd As Date
[CODE].................................
I have created installer from Visual Studio Package and Deployment, but after successful installation, the installer files (like dlls, images and all supporting files) modified date or even creation date has been changed and all have the same date depends on the date of installation. Is there a way I can preserve or maintain it's original creation/modified date?
View 2 Repliesi use data grid view in couple of my forms, i want to sirt there by date, but the datagridview of these forms take in two dates as well, a from date and a to date., and both are displayed side by side. eg feb 01 2010 - feb09 2010 and therea are more like this. the grid takes in couple of values like this
View 2 RepliesI'm trying to pull a table from an SQL database and sort it on the "Date From" (DtFr) column, which represents the start of a lease. I thought it would be as easy as this:[code]......You were right about the string value. I added a data column called sortDtFr to the datatable and gave it System.DateTime as a datatype and iterated through the rows setting the new column's value equal to the old one casted as a Date. Here's the code for those interested:listing all drives with GetLogicalDrives()..I am getting ( A:. C:, K: )
View 1 RepliesI have VB project and I tried to use PUBLISH feature.It seems to create nicely some kind of setup program, but the setup program does not ask where to copy files (it does not seem to copy filesto target machine "PROGRAM FILES".)Is this setup program somehow different from usual installers?
NOTE: I want that app files are installed to Hard disk( from USB stick source)Is the signing recommended or necessary? My App is pretty simple, its just using access DB + printer api, should I still sign?
Using the System.Windows.Forms.DataVisualization.Charting objects/namespace, am having problems getting by chart to sort axis of dates properly.My data looks like this (dates in US format):
Product Quantity SaleDate
A -- 2 -- 5/1/2011
B -- 1 -- 5/1/2011
C -- 1 -- 1/1/2011
B -- 2 -- 2/1/2011
I'm creating a stacked column graph like this, where dv is a dataview of the datatable:
vb.net
chSales.DataBindCrossTable(dv, "Product", "SaleDate", "Quantity", "") chSales.AlignDataPointsByAxisLabel() For Each cs As Series In chSales.Series cs.ChartType = SeriesChartType.StackedColumn cs.YValueType = ChartValueType.Int32 cs.XValueType = ChartValueType.DateNext
So this produces a stacked column graph with 2 A's, 1 B in May 11, etc But the date order is Feb, Jan, May, regardless of how I sort the datatable provided to the chart.