I am trying to filter the first column of a listview which holds date values. If the date is less than 21 days from today it deletes the row from the listview.
[Code]...
I have a date in the future e.g. 13/10/2008 I need to subtract the current date (today is the 28/09/2010) minus 7 days, so thats 21/09/2010 minus 13/10/2008, which would equal erm, 720 something ? But the current date won't always be 28/09/2010, obviously. I need the code for this. EDIT: When i said future I mean past :)
View 3 RepliesI found these files code on CodeGuru and tried to add the code to a .net project but i got to many errors to debug.
I am not sure but i think it is VB6 perhaps.
[URL]
I have a datatable that stores information on employees. What i'm trying to do is use it to run a seniority list looping through the table using the current system date. The looping part i have no problem with, and the system date calculation also i know how to do. The problem call the date from the startDate column to do the calculation.
i have tried
dim sDate As date = "startdate"
but i get an error that it cannot be converted to date.
I have an access form that shows a data table. when the form is opened, I want to filter the data in the date column to show only the records that don't have a date entered into the field.
View 8 Replieshi..how can i select a month..and display all the days with the date of that month from month calender...
View 1 Repliesi would like to filter a datagrid thats bound.i have the value as string 11/2010 wich is datevalue [code]i want to filter the dates that contain "11/2010" this value.obviously the result will be
-01/11/2010
-05/11/2010
-4/11/2010
It is supposed to change the forecolor if the listview date in the first column is less than label 3's date.
For ii = 0 To Me.ListView1.Items.Count - 1
Dim iInvoiceDate As ListViewItem = Me.ListView1.Items(ii)
If iInvoiceDate.ToString < Me.Label3.Text Then
[Code]....
No errors and all the variables are returning what i am expecting but it doesn't change the forecolor.
I've been trying to add a database to my interface, and i can't seem to filter the data, i want to search based on last name and only display people with the that last name (the last name will be entered in a search form).I've tried writing SQL Queries but I can't seem to pass the variable that that holds the last name into the SQL Query, to filter the data.
View 3 RepliesI have a listview and i want to make one column's font smaller than the other column to fit form design. How will i do that?
View 1 RepliesI have a combox and a datagridview on a form, the combox filters the datagridview but doesnt have Distinct values. I found this on one of your post. I have a Products DB Table with ProductID, Series, Description and UnitPrice, I am trying to filter the the datagrid using the column Series with the combobox but i get multiple values of the same thing in the combobox, where i would like to make it Distinct.[code]
View 6 RepliesI have a datagridview in a form in windows application in which I have a column which accepts date values. In this column I want user to enter numeric values alone and when the user moves to next cell the value should get formatted to date type value(ex: 05/09/09). Similarly I have another column which must accept alphabets alone.
View 4 RepliesI have a ListView control as below
[Code]...
I have a 3 column listview. Column 1 and 2 has few integer. How can I subtract Column 1 and column and show the result in column 3. Below is a sample data for columns.
View 5 RepliesI am trying to filter the results of a datagridviw using the bindingsource.filter method.
Dim filters(2) As String
...
If Me.txtPartIDFilter.Text = "" Then
[code]....
The issue is in the last line. ID_Part is an Int64 data type filters(0) is a string so the system returns a "Can't perform 'Like' operation on System.Int64 and System.String" error message.As you can see I tried converting the data type, but that failed since it is encased in String.Format()- it's going to be a string no matter what, I suppose.It's almost 1:00 a.m. so I'm not firing on all cylinders.
I have a DGV.It has some columns.The columns are in the correct order e.g. 1,2,3,4 at design time.When I start debugging and then come back to VS, the order of the columns have changed and I have to put them back in the correct order everytime.After some testing I have realised it only occurs if
1) I make a change on the form that holds the DGV
2)Leave the form open in VS while I play the application ie. debug.
How can I iterate through a listview that has checkedboxes and get the value of the first column? The listview has 3 columns, "ID" "Survey" "County". I want to get the value of the "ID" column for the items that are checked. I've been using the following code, but can't figure out how to proceed. am I on the right track?
[Code]...
i have to check duplicate rows with same two columns..if column 1 and 2 are same then delete the all row and keep only one...but one column is carrying datetime..so i want to check only the date not the time part..it's ok with other two varchar columns..i want to check only the date not the time..but date and time are in the same column
If itemI.SubItems(0).Text = itemJ.SubItems(0).Text AndAlso _
itemI.SubItems(1).Text = itemJ.SubItems(1).Text Then
ListView1.Items.Remove(itemJ)
[code].....
Lets say i had a label with 9/6/2010 11:59:99 that was selected from the month calendar control, is there anyway to determine how many days are from the present days date to the selected end date?
so 9/4 to 9/6 = 2 days
The "2" days is the value im seeking
i want to filter date and also time (shortime) for example if Datum.hour="8:15" andalso Datum.day of week "Saturday"or "Monday" now i can only filter date ... this is my filterline objbindingsource.Filter = "Datum > = '" & Dtp1.Value.Date & "'"
View 5 RepliesI have a column of data in my text file datafile coming over as a string value 06/05/2011 12:00:00 AM opened in notepad all my fields are in quotes. "06/05/2011 12:00:00 AM"If I open the file in excel it displays 06/05/2011 0:00 If i then save that file back into excel it removes the quotes 06/05/2011 0:00 If I open the excel saved version my schema file will read the date as a date But If I open the version that has the quotes "06/05/2011 12:00:00 AM" and manipulate the string to "06/05/2011 0:00" and try to parse the column I get error string not recognized as valid date time
HTML
For i As Integer = 0 To dtsold.Rows.Count - 1
Dim DateSold As Date
DateSold = New Date
DateSold = Date.Parse(CStr(dtsold.Rows(i).Item("DateSold")))
I have one hour format datetimepicker and other short format datetimepicker. When I select an hour from 1:00 AM to 5:00 AM want to change the current day to the day before. I tryed to - 1 day but doesn't work or maybe isn't the correct way to do it.my error says operator '-' is not defined for types 'Date' and integer
here's my
Dim hora As Date
Dim fecha As Date
hora = Me.dtpHora.Value
fecha = CStr(Me.dtpFecha.Value)
[code]....
I found this from a Google search and I need the VB.NET equivalent to Martin Liss' code
Dim lngIndex As Long
Dim lngTot As Long
For lngIndex = 1 To lv.ListItems.Count
lngTot = lngTot + lv.ListItems(lngIndex).SubItems(1)
Next
[Code]...
Value of type 'System.Windows.Forms.ListViewItem.ListViewSubItem' can not be converted to 'Integer'Basically, I need to total up a number column in a ListView.
Steps-1) Drag the Imagelist.2) Insert the iamges into the imagelist.3)Associate the SmallImageList Property of Listview to Imagelist Name.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim lCount As Integer
[code].....
I am having trouble understanding how ado.net works with proposed / current values of data. Can someone please explain the process of a new dataset with data in; a new row added and updated to the live database and then that row modified and updated back to the live database?
This would help me out a lot as I can't seem to get my head around it.PS. Sorry for being a novice. I have googled and I also have the Murach's VB.NET database programming ADO.NET but just can't seem to follow it. Could be because I am an old school developer.
I am traying to use the DateTimePicker to extract days diff from a date selected on DateTimePicker1 to a date selected on DateTimePicker2. I have no problem substracting the daydiff in numbers of days. The problem I have is that I need the DateTimePicker to tell me how many of those days are weekends (friday, saturday) and how many are weekdays.
View 2 RepliesI'm trying the fetch only the date within the current and return how many rows Dim dc as new dataclassesdatacontext dim q=from p in dc.worktime where p.name.equals(session("name") and p.date ).count what I should I put after "p.date" ? And if I want to search for the record which there are record that are insert five days earlier, how to do that ? use (datetime.now - 5) ?
View 3 RepliesThe date is actually a string being read in from a text file in the format
MM/dd/yyyy
how can i add 7 days onto the date?
If I know that today is 236th day of the year, how can I get what date is for 236 + 10 = 246th day of the year?
View 3 RepliesI have a DateTimePicker (dtBBDate) and a textbox(txtDBBDate) object in my form....but what i want when user change the date of dtBBDate my text box should show show the date 10 days minus from that selected date i.e. if user select 10 may text box should show me 1st may?
View 2 Replies