I have the following line of code:
CType(IIf(CBool(product.IsDiscontinued Is Nothing Or product.IsDiscontinued = True), False, True), Boolean?)
What does the Boolean? mean at the end. I have seen it used on other data types as well.
[Code]...
When x is nullable I get an error 'Overload resolution failed because no accessible ToString accepts this number of arguments'. I suppose I could copy the nullable variable into a non-nullable variable, then format it, but that seems extremely clumsy for something that should be fairly simply. Isn't there a better way?
Arghh! Copying the Date? variable into a Date variable doesn't work-Option Strict is On & that sees the two variables as being of different types. Is it really necessary to to an explicit CDate conversion on a nullable date variable?
[Code]...
anything wrong with using datatype object and determine datatype in class property? I have a typed dataset and it has several integers columns that are null in the db. and when I make a call it throws exception.is there anythign wrong with setting it as object in my dataset.. changing the throw exception property to Nothing and passing it to my property as integer?
for each row in myDS.DataTable
cRate.CustID = row.CustID
next row
and in my class
Public Property CustID() As Integer
Get
Return _custID[code].............
I'm using a 3rd party chart COM object (National Instruments CW graph) to plot data versus elapsed time.The x value needs to be a VB6 equivalent Date type which is a .NET DateTime datatype.What I need is a way to convert a TimeSpan datatype to a DateTime datatype.
Dim testTime as System.DateTime 'date
Dim plotTime as System.DateTime 'date
Dim elapsedTime as System.TimeSpan[code].....
I have a database in mysql. The column in table is of datatype time(0)
Similarly I have a control datetimepicker in vb.net I have assigned format property as custom to the control and the CustomFormat property as HH:mm:ss tt so that it can just provide the time. I dont want the date to be in it.
Issue comes when I try to retrieve the value from database I get an error as Converion of type 'Timespan' to type 'Date' is not valid
Try
Dim myCommand As SqlCommand
myCommand = New SqlCommand("select * from [HMS].[dbo].[DoctorSchedule] where DoctorID='" & txtDoctorID.Text & "'", Connection)
[Code].....
I am working on a produce inventory database in my VB Express program.I have a form on the bottom and a spreadsheet at the top. I want to enter all the data in the form and have that data automatically transferred as a group to the spreadshet in the upper part of the page when I press a button.I know that there's an insert function.I set it up correctly. The problem is that I have to convert the textbox, which contain string data, to the datatype used in the database spreadsheet.HOw do I use CAST or do this?Here's the function I am using:
Me.TableAdapterManager.InventoryTableAdapter.Insert(IDTextBox.Text, fruitName, unitprice, unitsize, unitIn, unitTransit, unitOut)
Evernything is a string cause the data is coming from a textbox, I need to convert it to the datatypes used in the database.Also how do I use the CAST and Convert functions
I accidently wrote some code today that was like this[code]...
I immediately noticed the issue, but I had already hit the run button. It compiled successfully, I ran it through to the section and it threw an exception.
You can't do this in C#, it gives a compile error "cannot convert from 'int?' to 'int'".
Is there an 'Option Explicit' type switch that I can turn on to ensure that this sort of error does not occur again?
how can i use value (23,32) in sql column datatype int how can i use comma in column data type int
View 8 RepliesI have a bigger code block which I have recreated in this simpler example:
[Code]...
I have: Dim nVar1 As Long?Dim nVar2 As Long?Dim nVarSum As Long?nVar1 = Nothing nVar2 = 5 nVarSum = nVar1 + nVar2 I would prefer the result to end with nVarSum being 5, instead of Nothing. I understand if you add something to an unknown value, you will end up with "somthing + unknown" or x+5 will always equal "x+5" not "5" because you are still carrying around that unknown "x". However, how can I effectively treat an unknown or Nothing as a zero for the purposes of addition in this case?(What is basically happening is that the end user is sending us a data file, this code parses that file and then sums together about 15 fields. If the user leaves those fields blank instead of assigning a zero to them, I need to treat it as if it was a zero for this one addition operation, but all the rest of the code needs to continue seeing it as a Nothing value since the user did not ACTUALLY submit zero... they submitted blank or nothing)
View 3 RepliesCan Nullable Types be used in VB.NET? If so, is it possible to have a Nullable Integer that I can use with a field that accepts NULL in SQL Server?
View 4 RepliesI'm converting an Access VBA app to VB.NET. It has dates defined as variants or objects to handle null values. I thought this would be a great chance to use the Nullable type. But I can't get it to work. Either it is inappropriate for what I am trying to use it for, or I am doing it wrong. Anyone know how to use it? Reader is a SqlDataReader.
[Code]...
I was hoping I didn't have to put a lot of If .. Null statements throughtout the code, but that is my only option unless someone has any other idea.
I have a Nullable DateTimePicker but it lacks a vital property, that is to be able to change its ForeColor, anyone who has some suggestion on how can this be done? Or perhaps a free nullable DateTimePicker out there that supports changing of backcolor and forecolor?This is C# but it should not be different with .Net, and I prefer posting it here since there is more traffic here over the C# section.
using System;
using System.Collections.Generic;
using System.ComponentModel;[code].....
Okay, none of the previous questions I have seen with this error seem to apply in this situation.tEmp is a class that contains (among other things) two nullable date fields.[code]During a routine on my form, I am attempting to see if the following conditions are true[code]I get the above error (the title of question), but when I hover over the debugger, NextReview and InsuranceEligibleDate are both Nothing (which is correct for the employee I am looking at).I am using VB2010, and the Properties in the Employee class are using the new way of declaring Properties (i.e. no set/get)
View 4 Repliesdim str as nullable(of string) is this syntax incorrect?
View 1 RepliesC#'s 'as' keyword will let you do this: int? input = value as int? Here's what I would assume the vb.net equivalent would be: Dim input As Integer? = TryCast(value, Integer?) There's an intellisense error in the TryCast stating the operand must be a reference type but Integer? is a value type.
Intellisense on Nullable(Of Integer) says 'Represents an object whose underlying type is a value type that can also be assigned null like a reference type.' It seems C#'s 'as' handles this like a reference type where TryCast doesn't have this built in. In VB10 I was able to take advantage of the new CTypeDynamic function to do the casting. Conversion.CTypeDynamic Method
Dim input As Integer? = CTypeDynamic(Of Integer?)(value)
Or:
Dim input As Integer? = CTypeDynamic(Value, GetType(Integer?))
There's a cost here as CTypeDynamic examines the type at runtime.
My question is what is the elegant way to handle this without CTypeDynamic?
Dim input As Integer? = TryCast(value, Integer?)There's an intellisense error in the TryCast stating the operand must be a reference type but Integer? is a value type.Intellisense on Nullable(Of Integer) says 'Represents an object whose underlying type is a value type that can also be assigned null like a reference type.'It seems C#'s 'as' handles this like a reference type where TryCast doesn't have this built in.
View 1 RepliesI am a c#/asp.net developer and I am having to work on a VB/asp.net. I have two variables
Dim originalDate as DateTime?
Dim newDate as DateTime?
Both nullable datetimes, originalDate is a nullable date I am getting from the database and newDate time is set in code, I need to compare them, they can either both have dates, neither have dates or one have and one not.
I have a bit of code as follows:
if origEndDate = origEndDate then
When both origEndDate and origEndDate are "nothing" this statement is false (well when I run it in the watch window it comes back as nothing)!I don't understand why this is the case because I was under the impression doing an "=" compares the two values and as they are the same surely it should be true? What syntax should I be using as in C# I can do the above as so:
if (origEndDate == origEndDate) { }
and it will come back as true.
assuming v is a nullable, I'm wondering what are the implications / differences between these usages:
VB:
If v Is Nothing Then
If v.HasValue Then
C#:
if (v == null)
if (!v.HasValue)
I've picked up some code from a colleague, and in one of his methods he has a boolean parameter: ByVal showProactiveChases As Boolean?. I had to look up the ? operator yesterday to see that it denotes a Nullable type. My question is, if I change it to: ByVal showProactiveChases As Nullable(Of Boolean), does the meaning remain the same? I think provided it doesn't change the meaning the second way is much more readable.
View 4 RepliesI am creating a setup project for my VB application. Everything seems to look fine. However when I tell it to build the solution I get the following error:Property 'keycode' is non-nullable. I have never seen this before in other setup projects and I can't find any help from MS.
View 8 RepliesIn the below sample code, I have tried to use Nullable(of T) for DateTime and I want to use it same of the Dimensions property which is List(of Dimension).
CODE:
I am getting an unusual error "Nullable object must have a value" when running the code below.
[Code].....
Interestingly the Stored proc used by the table adapter still runs and does the insert but the function returns the error.
For a project I need to convert a date field in my SQL Server 2008 Database into a VB.net ListOf. Most of the records in StartDate field are NULL. VB.net doesn't recognize null values for DateTime.I need the NULL values to be dismissed, as they will be returned in a ListOf for a web service that I'm creating.
Here is my syntax and a sample of the current returned values in the XML message of the ListOf:
Class Property StartDate() As System.Nullable(Of DateTime) = Nothing
asmx.vb myUserRoleAppInfo.StartDate = myPermissionUser.StartDate
XML Message (Listof)
[Code]...
I don;t know what datatype while storing the data of datetimepicker in vb.net. The tools i use is sql server.
View 1 RepliesIn VB.NET, why can't I see a member of a structure when I make it a nullable type?
Example:
Public Structure myNullable
Dim myNullVar As Integer
End Structure
Sub Main()
[Code]...
I am trying to understand why the two code samples behave differently. I always believed the If() function to mimic the If language feature. Or am I looking at a behavior of Nullable(Of Integer) that is causing this?
Sample #1:
If Not String.IsNullOrWhiteSpace(PC.SelectedValue) Then
Dim pcFilter1 As Integer? = CInt(PC.SelectedValue)
Else
[Code]....
I'm struggling to implement a maybe monad - which I've called Nullable in this example.
The Nullable Class is implemented as follows: Public NotInheritable Class Nullable(Of TClass)
Private _value As TClass
Private _hasValue As Boolean
Public Shared Function Create(ByVal value As TClass) As Nullable(Of TClass)
Return New Nullable(Of TClass)(value)
End Function
[Code]...
The way the monad is implemented at the moment I would need to issue the following to access a property on the nested child class dim id = MyParentClass.ChildClass.Value.ID
but ideally what I'd like to be able to do is to have the following statement dim id = MyParentClass.ChildClass.Id and if the ChildClass is null then just return a default value for the property type.
I tried implementing this using Default Properties and setting the Value as default via an attribute but it wouldn't compile. Is that going to be possible or perhaps there is a better way of architecting it - or maybe I just haven't 'got' the maybe monad?
I would expect the following vb.net function to return a value of Nothing, but instead its returning a value of 0.
[Code]...
I have the following POCO:
Public Class T1
<Required()>
<MaxLength(128)>
<Key(), Column(Order:=0)>
Property K1 As String
[Code]...
I would expect C2 to be created as Nullable, but both C1 and C2 are Not Null. Adding
<Required(AllowEmptyStrings:=True)>
Does not make a difference, as it seems the decoration is aimed at data validation, not DB creation.
So how do i get a nullable column with Code First?
