if I create a variable like
dim DT as new Datetime
automatically the date is set to 01/01/0001
is there a better way to check that no value has been assigned to the variable a part to compare the datatevalue?
[Code]...
I prefer to solve this problem at application rather than db level. NOTE: DueDate in database is of type datetime. I'm coding in C# interacting with Sql-Server. I hope my question is clear enough.
So, let's say I have this code (VB.Net)[code]...
What I don't like is:
- relies upon reflection
- loosely typed (no compile time checking)
- I'd rather store the binding information somewhere other than ID, but don't know where else it could go within the aspx definition. Moving the binding declaration to the code behind would be better in some ways, but worse in others.
I am using OleDb, trying to do this:
Dim d as Date = DateSerial(Year(rptDate), Month(rptDate), 1 - 1)
Dim conn as OleDbConnection = new OleDbConnection(connStr)
Dim cm as OleDbCommand = new OleDbCommand()
[code]....
I know that d is the same date as the one in SQL server, specifically 3/31/2011 12:00:00 AM.
[code] "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.The statement has been terminated." [code]
View 6 RepliesI try to compare Datetime.Now with a Datetime variable I set, using the Datetime.CompareTo() method. I use a timer to compare these every second and display the result, but as the current time approaches the time I set, the result changes from 1 to -1, but never 0, which means these two are never equal. I'm suspecting the Datetime structure contains milliseconds?
View 7 RepliesI have this function:
Public Sub DoStuff(ByVal type as System.Type, ByVal value as Object)
End Sub
The 'value' argument is always an array of the same type as 'type'. How can I loop through the values of the array?
I'd like to be able to do something like this:
DoStuff(GetType(Integer), New Integer(){1,2,3})
Public Sub DoStuff(ByVal type as System.Type, ByVal value as Object)
//Strongly types arr as Integer()
[Code].....
I'm aware that questions like this have been asked before and I doubt it's possible, but I just wanted to make 100% sure that it isn't.In VB.net or C# (either language, it doesn't matter), I want to cast a variable to a type represented by another Type variable. Here's an example of the kind of code that would be needed in C#:
Object castMe = new Foo();
Type castTo = typeof(Foo);
Foo beenCast = (castTo.GetRepresentedType())castMe;
[code].....
I'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by trns_dt DateTime.Now.DateBut when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
daleDbDataAdapter("SelectDaily_Transactiondtp_from_dt.value dtp_To.value con)
dsDataSet
[code].....
how to change datetime variable in sql? I nee only time without date in textbox?
There's code:
Dim
connetionString As String
[code].....
Need to change datetime with time variable in this code, i tried bu it gets error
Public Sub SetWakeUpTime(ByVal time As DateTime)
bgWorker.RunWorkerAsync(time.ToFileTime())
End Sub
[Code].....
I have a datetime variable (00:00:00) and I like to increment with a timer every seconds...minutes.. hours...etc...
View 7 RepliesI need to obtain time values from a SQL DB. However, I was able to set the datatype for the respective column in the SQL table only to "datetime" as there is no "time" option in the dropdown list in the Visual Web Developer. Namely, I want to bind a Listbox control only to the time data (i.e. not to "dd-mm-yyyy hh:mm:ss"). I tried to convert the datetime values to string and then extract the last 9 chars that refer to time.Unfortunately, my attempts to do that with SubString have failed:
weekDays.DataTextField=Convert.ToString("Start").SubString(length("Start")-10,9)
where:
weekDays - ListBox
[code].....
I have two datetime variables in VB.Net [code]I want to add both these variable in single DateTime variable , i didn't find any .Net function to do that.Is there any other way to do it?
View 2 RepliesHow can I "truncate" a DateTime variable so that only e.g. the current minute remains?
Like in:
Dim myDateTime As DateTime
myDateTime = Now
.... (what would have to come here)
If Now is e.g. 15:43:21 then leave only 15:43:00 in the variable?
Public Class Form1
Dim x, c, number(0 To 19) As Integer
Dim s As Integer
[CODE]...
The variables in the brackets [example] do not actually have brackets in them in the original code. These are where the issues are. For both variables, it says, "The type for variable [variable] will not be inferred because it is bound to a field in an enclosing scope. Either change the name of [variable], or use the fully qualified name (for example, 'Me.[variable]' or 'MyBase.[variable]')." Now, I'm not entirely sure if this is a stupid question or not, as I'm used to VB '98 because that's what we use in my programming class at High School. let me know why this won't work.
-Note: The intention of this program is to continually loop the generation of numbers for this list until I tell it to stop. Button1 ends the program, Button2 generates the list one time only, Button3 is supposed to loop the generation of the list, and Button4 is supposed to end the loop, but not the program.
I am looking for a good resource on variable naming conventions to illustrate variable type and where variables are declared. So I will have public variables, Private variables, private or local variables. I also may want to declare variables with the same name in different class code (i.e. in the code behind different forms). I am assuming good coding would dicatate a prefix for declaration location.
View 4 RepliesI have the following code that I am using to parse out a test file. I am getting variable conversion error in Sub Main() when I assign file = Read(). The return value of Read() is a TextFieldParser type. How do I assign the proper variable type to "file" so I can write the output to a text file?
Function Read()
Using MyReader As New FileIO.TextFieldParser("C:UsersColinDesktopParse_Me.txt")
Dim currentRow As String
[Code].....
E.g. how do I get VB.Net to statically type a local variable to be the static type of the expression on the right had side of the assignment?
View 1 RepliesI want to use explicit conversion (CType function in VB.NET) to convert the variable d from double type to integer type and store the result as 132.
Imports System.Console
Module Module1
Sub Main()
[CODE]...
This is my code. But Visual Basic tells me an error: Error1Type 'i' is not defined.C:\Users\mihaispr\Desktop\Conversie explicita\Conversie explicita\Module1.vb1922Conversie explicita
I am using a sql server database and i am storing the time value in the datetime variable. I am developing a booking system application in vb.net. When I want to view already made bookings using datagridview and by implementing dataadapter and dataset it shows the time column with system date which was saved with time when the record was inserted. Now I want to view only time in the Time field when extracting the data....What should i do now??
View 3 Replies<VB.NET 2005+SQL server 2005>
Error has to be raised for input text by user. User will input data on datagridview. Below are examples of use input.
1. "2009/01/23 08:00:10" --> How do I know that right datatime format or not
2. "2009/15/23 08:00:10" --> How do I check the month is wrong
Writing an asp.net mvc app and i have something like this...
Public Class AA
'... has some variables...
End Class
Public Class BB
[code]....
So, now in my program, i just want to copy object of type AA to an empty variable of type BB?it makes sense to do this, as i expect all the fields in AA type object to be copied to the newly created BB type object, and the ExtraVariable in the BB type object i would (will) just assign a value to it later (after the copy) on my own time!!I know copying BB type to AA type would not be appropriate as there would be lost data!But im trying to copy AA to BB, I've used both DirectCast and CType to do this, and i keep getting "unable to cast" error!
Note: I'm using vb.net (but can read c#, no problems)
I would like write Date and Time from Now() To field fDT in Table Tbl MS Access 2007 but I can't:
msAccessConnection.Execute("INSERT INTO Tbl (fDT) VALUES ('" & DateTime.Now & "')")
I have the properties. I have the format property set to TIME. The text box on the form now shows the time. But when you click on the pull down, you get the date picker.
View 2 RepliesWhat's the C# equivalent of
<% dim name %>
so you can use it for web forms in PayPal API integration?
I'm trying to create an auction site using asp.net. My auction's start date & time and end date & time are stored in my sql server 2008 r2 database as datetime types. I'm using vb.net. I'm trying to create a select statement in which I can query the date and time portion relative to the current date and time (so as to only display current ongoing auctions). I can successfully query the date portion using the Date.Now function, but the time is giving me a hassle. DateAndTime.Now doesn't work. I've even tried to separate the time and date in the database, but I still can't get an effective query. Here are two examples of code which I've tried:
[Code]...
Error converting data type varchar to datetime.rtfI am trying to learn ASP.NET using ASP.NET 1.1 with SQL Server 2000 for the database. I have created a Stored Procedure in SQL Server 2000 and the procedure to execute the Stored Procedure is in ASP.NET 1.1. The problem is that when I try to save a record, the date field returns the above error. I have ried to use the several solutions on the web without getting one to solve the problem.I am attaching the Stored Procedure as well as the ASP.NET code for some advice. I am also attached a word document containing the two procedures.
View 5 RepliesUsing Vb.net/SQL Server 2000 updating a row via a gridview/sqldatasource
Stored proc:
@ISTag varchar(10),
@PCISTag varchar(10),
[Code]......
I don't understand where else it could be screwing up. I'd love to be able to keep it to a null value if it is one already, I'm just trying to get it to take anything right now and this is where I'm at.
I'm trying to detect if a value is a decimal type and insert it into a DB. If the value is a decimal, I want to continue with the inserting. If the value is not a decimal I want to insert "0" as a value to the DB.
For this I created a function seen below... What is wrong with it?
Function IfNotDeci(ByVal Arvo) As String
If Arvo is Decimal = True Then
Return Arvo
[Code]....
The problem is on the first "If". How to know if the value is a decimal?
(I need this code because my values are read from different excel-files that are not always correct. So if a human didn't write a decimal value to a cell, the program should not respond with an error, but just insert a "0".)