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 am using Vb.net. I have a counter variable Dim rc as Integer This is a class level variable. loading the page for the 1st time, its value should be 0.But later I manipulate its value in various methods.My page reloads after most methods & the value of rc is re-initialized to 0. how can I avoid this. I need the page to reload but the counter should keep incrementing.
View 1 RepliesI have this code.
'//////////////////////////
If TextBox1.Text = Form2.TextBox1.Text Then
TextBox1.BackColor = Color.Green
[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 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 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.
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 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 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].......
The issue is in a windows based client-server application.In the GUI, the system date value is converted to string and is stored in a text box, which is displayed while the dialog gets loaded.How to change the format of date so that when the form loads the date is displayed in en-US culture irrespective of the regional setting of the system(for eg: regional setting of the system is "fr-FR").
View 1 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 RepliesI'm searching for a way to change the font size of selected text in a RichTextBox (rtf) having different font families (e.g. Arial and MS SansSerif) and font styles (underline, bold...) using the FontDialog, but without changing the families and styles. The following code resets all the font attributes, which is not what I want:
[Code]...
Is there any way to avoid UnauthorizedAccessException, i get it every time when I try to do this:[code]Is there any way to make that script read-write?
View 10 RepliesUntil asking a question on here I never considered (enums) to be a "bad thing." For those out there that consider them not to be best practice, what are some approachs/patterns for avoiding their use in code?
Edit:
public Enum SomeStatus
Approved = 1
Denied = 2
Pending =3
end Enum
how I can ensure that conversion of a date to a string and a string to a date will give me the same date format.
For example:
Code:
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim d As Date = Date.Now
[code].....
I'm actually only interested in the date part as the label text shows so f is more than I want.But also, the day and month are reversed.
Is it possible to re-use a DataTable in .net? Here's an example from code-behind:
[Code]...
i have a list of items in a listbox:-
A
B
C
and i have a button that adds these items by selecting them to a datagrid how can i avoid adding A or B or C twice to the datagrid?
I can cheack another instance running r not then i closed the newly created instance
but nw my problem is i need to show the previously running instance if the previous instance minimized or hided
i m using the foolowing code to find the previous instance[code]...
My [code]...
But how i avoid when you selected nothing, you can delete.
I have following code that is generating random no. between 1 to 10. This is working fine. But, I do not want doubling in combobox (cmbRnd is my combo box). How can I avoid it?
Private Sub cmdRnd_Click(ByVal sender As Object, ByVal e As EventArgs) Handles cmdRnd.Click
Dim random As New Random(), i As Integer = 1
[Code]....
How can I Avoid Duplicate values In datagrideview. IF found dublicate values in will change the row backcolour and show me the rows.
View 1 RepliesI am trying to check whether file exists or not. if not create and write something into it.The file is getting created but not updating and getting error message says it is being used by another processCode snippet:
Public shared sub MyXml()
If Not System.IO.File.Exists("configfile.xml") Then
Dim writer As New System.Xml.XmlTextWriter(fullPath.ToString + "configfile.xml", Nothing)
[code].....
I am doing an activation server which will enable users to activate their software. The problem is that they own the public key.. the verification method needs the public key to check signature of the license file. My concern is that someone could generate their own license file using two key (public and private) and then change the public key on the client which would spoof his current license.
Is there any way of avoiding this ? Where should the public key be stored ? You have to take into consideration that the checkup is done on client and the signature is created on server.
how to avoid rounding off numbers
Code below
Dim acc = 0
Dim i
Dim x() = {699.68, 632.70}
[Code].....
I'm trying to introduce delay to my code so that it would read in the noise or garbage data.
I'm receiving the data from RFID to pic thru RS232.Is there any simple delay that i can use? I seriously don't understand threading.
I have been trying to use sockets in VB.NET and once I cannot understand how to avoid a null reference. [code] I have tried introducing sock as 'New Socket', but this gives me 'Overload resolution failed because no accessible New can accept this number of arguments'.I also cannot simply add '= Nothing' onto the end of my declaration since this still gives a null reference.
View 6 Repliesi have coded as below but once the record deleted and when the application write to text file again it gives an error says index was outside the bounds of the array any solution?
Dim stream As New IO.StreamWriter("C:Documents and SettingsAdministratorDesktopBill PaymentBillPaymentRecords.txt", False)
stream.WriteLine("")
stream.Close()