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 have an ftp routine which gets various files from a server and puts them on a client PC.My problem is it loses the original Last Modified Date on the client PC. I can get the last datetime modified from the server but don't know how to assign this to the file on the client PC. Is there away to alter the last modified datetime?
View 3 RepliesI have a grid bound to a datatable. The grid has two boolean fields. What I want to happen is, when the user checks one field (or perhaps I change that field's value in code), I want to automatically uncheck the other field. I tried the following code, and it gives me the results I'm looking for, but only after the user leaves the row. I want it to happen when the user clicks on the cell.
Private Sub ComparisonGrid_CellValueChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles ComparisonGrid.CellValueChanged
If e.RowIndex > -1 Then
If e.ColumnIndex = Me.FirstUseColumn.Index Then
[Code]...
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 am using ASP.NET with SQL Server 2005.
My date get saved in the database with data type = "smalldatetime".
I am displaying the date value into a text box called txtDate with a Reader......
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[Code]....
But currently my date get displayed as "2008/06/30 12:00:00 AM" and i want to display it as "30 June 2008".
I have a bunch of events with values (how many people went through a doorway). Each event is associated with a Date. There is no fixed period to the events .If no one comes through the door, no event is generated, but often multiple people can go through at once, so the value can be greater than one.
Sometimes events are minutes apart for a time, sometimes there is gaps of a few hours,
Using the Date class, is there an easy way to average my values over periods of time?
I would like to ask about how to code datetime in CONSOLE vb.net. I already got the format but my problem is after I inputted another data today to the database. In this image,my data retrieval was error. The ID (1,2,3,4,5,6)should be jan 2. Unfortunately, the output was today after Ive put new data to the database. I was confused on how to code to avoid changing the date.
[Code]...
I have an Sql server 2005 table called Emploeefl with 2 fields, EmployeeCode and Date of Birth. The data type for the date of birth is Datetime. I have a Date time picker on a vb.net 2005 form called dtDateOfbirth. When I click on the save button I get the error message "Conversion from string 'yyyy/MM/dd' is not valid. Below is the code
Dim newQE_Date As Date
newQE_Date = Format(Me.dtDateOfBirth.ToString, "yyyy/MM/dd")
'newQE_Date = String.Format("2008/09/10", "yyyy/MM/dd")
[Code]....
I would like to know how to apply code for a date that will expire 5 days after whatever the current date would be and it needs to be a "constant".For example: When the user loads a form, the current date is assigned, and the expiration date always needs to be 5 days after the current date.
View 4 RepliesCan I change a bolded date's color of a MonthCalendar control without creating a new custom control? Should I override OnPaint event, or something for this? If so, how?
View 5 RepliesI have a datagridview populated using a csv file. I have a column named Date. The csv file has mixup of different date formats. So I need the date column in datagridview to be in standard "MM-dd-yyyy" format. I used below code
Me.dataGridView1.Columns("Date").DefaultCellStyle.Format = "d"It didnot have any impact.
So I used the below shown code Me.dataGridView1.Columns("Date").DefaultCellStyle.Format = "MM-dd-yyyy"Still no effect.
In my datagridview, I want to be able to change the value of comboBox1 depending on what the user selects in comboBox2 I had this working correctly, however if I move onto a new line in my gridview and select a different value in the second row it changes the previous row also.In the below code the correct values are generated in the combo boxs, however when I move onto a new line in my datagridview and choose a different value from my comboBox I get this error:
"The Following exception occurred in the DataGridView System.ArgumentException: DataGridViewComboBoxCell value is not valid To replace this default dialog please handle the DataError event."
Private Sub Expenses_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.TblCompanyTypeTableAdapter1.Fill(Me.Exp_testDataSet10.tblCompanyType)
[code]....
there, im doing a leave management system with vb 2005..and here's my problem -how do i 'find' the expiry date?? eg: from the datetimepicker in my form, if the date i select is 1st january 2009.....how do i type the code to find the expiry date 1 year later (which is 1st january 2010) and display the date in a textbox in my form???
View 1 RepliesI have a form with a datagridview, 2 datetimepicker(dtp) controls, combobox, textbox, 3 buttons and a bindingsource. All my controls are bound to the datasource and seem to work fine when the form loads. One of my datetimepicker controls losses the bindings when I add a new row to the datagridview and save the changes. I validate the date entered in this dtp.
View 3 RepliesPublic Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If My.Settings.registered = True Then
Form3.Show()
[code]....
This is my code for a trial application. The code is pretty basic but what i couldn't figure out was how i would be able to prevent users from changing the date to extend the trial ("error" i would be getting).
I have simple columns and their respective sums. However, I exclude 1 particular value from each sum, like so [code]...
Now I need to exclude another value ("Awaiting Progression") from a second column called "PROGRESSION".
Since I already exclude value based on 1 column called CATEGORY, how do I change my =Sum(Code.ExcludeOthers(Fields!CATEGORY.Value,Fields!ACTION_PLAN_NEW.Value)) to exclude a value from the PROGRESSION column if it's = ("Awaiting Progression") ?
i.e. How do I exclude multiple values, depending on values in 2 columns in SSRS 2005?
All variables and Arrays have been declared properly the problem Is when the user enters a new number using a scroll bar
LottoNumber = HScrollBar1.Value
Label2.Text = "Number Selected: " & LottoNumber
The out put of the variable count stays at 1 so the output stays at (Pick # 1 of 6) and doesnt increment at all and does not build the OutPut string
'IF The LottoNumber Location Value is 0 in the Array selectedLotto THEN mark it by making the Loacation Value to 1
If selectedLotto(LottoNumber) = 0 Then
[Code]....
I want to loop through a databale and change the values of a specific column in that datatable.eg: the database returns Request_ID, Desc, Date and Status_Ind. The Status_Ind column contains integer values. I dont want to show the integer values to the user. I want to convert that to a string value based on the integer values returned in that columns.
View 2 RepliesIm trying to check to see if a value of a label changes over time. however I can't seem to get it right.
dim val1 as string
dim val2 as string
private sub form1_load()
dim val1 = label1.text
end sub
[Code]...
problem is it will only check it once after ten seconds when the timer is set to 10 seconds i need to to check it every 10 seconds becuase these values display altitude, and if the server freezes the altitudes dont change. I need to make sure they are updated and not frozen.
I'm writing a program to help me understand 3d points and how computers manipulate them to 2d. Every time I run the conversion routine in my program the value I passed to it get's manipulated even though I use the ByVal key word. Here is the code in process order , tell me if I missed something here ?
[Code]...
There is a status box for me to check one of the values :> This is the flow of what I have put together so far. The problem is once I run the program everytime I press the up key to make a call to the GetPoints method the value in MyPoint is changed to reflect the forumula in the getpoints method. I explicitly used ByVal in my variables on the method call so the values in the variable would not be manipulated. I've changed it many times but I can't seem to get the method to run where it does the conversion without manipulating the values in MyPoint. I've done similar things in visual basic .net 2003 , Now I am using the visual basic .net 2008 express edition. I don't if there is a difference in the two or some unknown bug.
My first time and first post here.I am trying to change specific registry key values (to enable fast user shutdown), but I get an error message when I try this. I will hopefully be implementing a number of the TweakUI functions, but in my own representation.
[Code]...
and I get the following error message:
"The specified RegistryKeyPermissionCheck value is invalid. Parameter name: mode"
(I've changed the Security.AccessControl options but none of them are suitable)
I've only been using VB 2008 for about 4 months now, and had no coding expereince prior to this
I have an array of structs and each struct contains values for the checkboxes. I am trying to display the checkbox values contained within a particular struct.
MyStruct is an array of structs which has a values for the checkboxes
ChkBoxCol is the collection of check boxes for the form.
I am iterating through the collection as follows:
[Code]...
What I am noticing is that if the check boxes are checked in order (checkbox 1, 2, 3, 4...etc) the code works fine and the values are displayed correctly in the form. However, if the check boxes are not checked in order (4, 5, 7...etc) the code does not write the values of the check boxes and instead keeps them blank. I just need to display the values for the check boxes for a specific struct.
I am working on a way to change either the x or y value of a point and am getting an error while doing so. the code i am using to do this is the following:pts(currentNo - 2).X = pts(currentNo - 2).X - 10pts is a list of Points and currentNo is merely a count that im using to track where i am in the list. I am getting the following error
View 2 RepliesI have a project due tonight and suddenly 2 of my datagridviews are acting funky while the others are fine.
I have 2 tables in an sqlce db. the first is books(id, title, copyright) and the next is publisher(id, name, bookid). I'm writing a vb.net frontend to access the data.
I have data bound datagridviews for both tables. Both have their respective ID columns hidden. The publisher dgv uses a combobox cell style to display the book title in the bookid column. So far so good.
I have suddenly run into a problem where if I have clicked in a cell on the books dgv and then click a cell on another row, the title changes to the id value. The publisher dgv also updates to show the id instead of the title.
It sounds to me like there may be a problem with the booktableadapter or bookbindingsource, but I don't know where to start looking for it. I have a 3rd dgv referencing an unrelated table, and it has no problems. The code for both the working and problematic dgvs are the same (only the control names are different).
There are 2 subs. First one populates a DataGridView with data from a SQL table:
Dim SQLCom As SqlCommand
Dim myDA As New SqlDataAdapter
Dim myDS As DataSet = New DataSet()
[Code].....
I have a select statement which was returning the required values but when I changed the OS date from English(US) to English(UK), it now returns null. I believe the problem is concerned with date since in the query am selecting values where the date from the database is the same as the date in a combobox but I don't know what else I can do. It almost looks like the dates in the combox and in the database are not the same and yet the date in the combobox is actually retrieved from the database and has been returning values fine until I changed the system date format.Here's my select command:
cmd4.CommandText = _
"SELECT sum(brought_qtty), recieved_qtty from brought_coffee, centre_weigh where brought_date=#" & _
dtComb.Text.Trim & "#" & _[code].......
I have a web.config file on my computer.There are alot of things i need to change and add in the file. (I am actually working with my SharePoint web.config file)Can i do this with a Batch file, if so how would i do it. Or how would i do it using VB.NET or C# code? Edit: i need to create a program to alter a web.config of lets say i web.config laying on my deskop and not the actual web.config of my project
View 7 RepliesHow to set up a Chart using the new MS Chart control. I want to be able to populate the data via SQL because the user will be able to dynamically change the values via drop downs. The format of the data will be the same (Qty, Time Period) but the Focus of that data will change. I'm honestly not sure where to start, I can draw the chart but I have no idea how to populate it with data via code so it can be changed dynamically.
VBE 2010, and I'm hitting an AccessDB
I have been dabbling in VB before and i played around wiht linq to sql back then but im wondering what i should go with here.I need to have a list of people.. They should all have their own id nr.
The people in the list are supposed to keep a record of values changing over time with a datetime stamp. (In my case its numbers from a test outcome of blood)You have to be able to add people and delete people. All records will be deleted too.A Chart will read information from the records and display changes over time in chart.I was thinking of doing it with linq to sql and i was kinda aiming at Creating datatables with id names from the script
Havent found a way of creating datatables from a script though..I was hoping for a solution like that.. And i was hoping id be able to search databasetable names.
I have a form which has a user control in it added dynamically. How can I change the values in that dynamically generated user control? All my functions are in a module and I will just call them in main form. So in module how can I find that user control and change its values? I tried writing a function in user control form. Like it has 10 txt box and I tried to pass a structure as argument in that user control form but I am unable to do so. when I tried to declare the structure outside function parameter in user control form it works well but not as function parameter..
View 6 Replies