I am trying to write a generic function that will check each database parameter to see if it is null, and if so, return DBNull; if not, return the object.So here is my function:
Public Shared Function CheckForNull(ByVal obj As Object) As Object
If obj <> Nothing Then Return obj Else Return DBNull.Value
End Function
[code].....
I am trying to implement a function for my SSRS report which will return a color value depending on the values of three dates.
[Code]...
I am using following code in rowdatabound fn.
Protected Sub gvwMileStone_RowDataBound(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
[code]...
ddlEProjectLevels is dropdownlist in edititemtemplate.Whwn i click edit in 1st row ddlEProjectLevels gets loaded with data from database.But in 2nd row dropdownlist does not contain values.Again in 3rd it gets loaded from db.Means in alternate rows,when i click edit dropdownlist(ddlEProjectLevels) doesnot load values.Can anybody help?
I have a fairly simple piece of code:
Private _PurchaseDelivery as PurchaseDelivery
Protected Overrides Sub InsertItem(ByVal index As Integer, ByVal item As PurchaseDeliveryItem)
[Code]....
Which is inside a class which overrides a custom list base. The code is occassionaly throwing an unhandled exception, System.NullReferenceException, on this line when used in production:
If _PurchaseDelivery IsNot Nothing AndAlso _PurchaseDelivery.DefaultSKUBinID.HasValue Then
DeafultSKUBinID is declared as an Integer? (Nullable Int) in the PurchaseDelivery class. I cannot see what might be causing this error, why would this be returning an error?
checking im my textbox contains null valuefor example i have ten textbox how do i know if a textbox has no text in it?then gotfocus to that specific textbox?
View 3 RepliesI'm using Visual Basic .NET to work with a USB HID device.Most of the time, I can receive data from it perfectly... but one out of every thousand transfers or so, my code will think it has received data when it actually hasn't.The device writes to an array of bytes. I wanted to check to see if the received packet is empty, by doing something like this:
If myDevice.dataPacket(1) <> Nothing then
myDevice.rxDataReady = False
[code].....
ve a simple vb code similar to the below,
Function getvalue (ByVal Val as double) As string
Dim Num as Integer
Dim Prd as double
[code].....
Is there anyway to check for a null here before it reaches this part of the code? tmpLabelData(0) = m_node.Item("CONTAINER_NAME").InnerText. Some XML has it while others do not. I cant seem to find a nice way to handle a null on these?
View 1 RepliesI'm querying a SQL DB and sometimes the result is Null, so I thought I would test this but my code results in an error "Data is Null. This method or property cannot be called on Null values."
Here is a snipet of my code:
For i = 5 To 6
cmd = New MySqlCommand(query2t & i, db)
rdr = cmd.ExecuteReader()
rdr.Read()
If Not IsDBNull(rdr.GetUInt32(0)) Then
[Code] ......
I have some code that is meant to check the length of the values in the text boxes, and if any of the boxes has no content the length of the string is 0 (or null). Here is the code:
If (Len(Form_MainScreen.Ctl48.Value) Or Len(Form_MainScreen.Ctl49.Value) Or _
Len(Form_MainScreen.Ctl50.Value) Or Len(Form_MainScreen.Ctl51.Value) Or _
[code]....
When one string is blank, the length check becomes "null" and so does the whole statement.But if the length checks are all not null, the if statement becomes a "1" and then procedes to execute the Do X procedure again.
I have an ASP.NET application that crashes when a null date value is returned.
The code line is:
excelWorksheet.Cells("A" & xlRowCounter).Value = IIf(IsDBNull(dRow("sysdate")), "", Format(dRow("sysdate"), "MM/dd/yyyy"))
Error message:
ERROR: System.ArgumentException: Argument 'Expression' is not a valid value.
How would I check for a null date, and replace it with "" in my app ?
I keep getting the error "Object reference not set to an instance of an Object" on the below highlighted line of code and I understand why. It's because I'm checking for something that hasn't even been initialized yet. My question is, what's the best way to check a DataTables row count without getting that error before refilling it?
If Not ds.Tables("tblNotes").Rows(0).IsNull(0) Then
ds.Tables("tblNotes").Rows.Clear()
End If
adp.Fill(ds, "tblNotes")
I'm working with a database application and i want to check if there is a null value in a specific column but it works only when its not null but if its null it throws an exception automatically. I tried to change the null value property of this column but I'm not able it shows a message that its not a valid property. I tried to change the source code in the code editor but it changes back automatically. Is there a way that I can work around this?
View 5 RepliesI constantly find myself having to do code similar to the following.[code]Is there anyway to check for both on a single line? When i'm checking a condition for a great number of answers, I sometimes end up with conditionals 6-sets deep. If i check for null first, an error still pops up, even though VB shouldn't check since the first condition failed. i.e.[code]
View 8 Replieshow to check null excel worksheet?
View 2 RepliesI have a DataGridView1 populated by sql searches. On the rare occasion that nothing is returned, my app cannot make use of data so I'm trying to check for null values. My code below is not correct because IsDBNull is not a member of the of the DataGridView1.
If DataGridView1.SelectedRows(0).IsDBNull Then
MsgBox("Nothing to display")
Exit Sub
End If
I need to check if a value from a date column is equal to null. I can't find how to do it.
Wat I got now is:
if ds.tblBooking(row).CancelledOn.compareTo(dbnull.value) = true then
But this doesn't seem to work, I think it's because I'm using a strongly typed database.
I'm trying to search a generic list of 'User' business objects which has a property called 'Username': If (From u In colUsers Select u.Username Where Username.Equals(strUsername)).Count > 0 ThenI keep getting:Delegate to an instance method cannot have null 'this'.
View 16 RepliesI'm implementing a State Machine in WF 4.0. In some transitions, I have added a condition where I check that some variables have the expected values. The variables are enums and booleans, and everything is fine.
However, now I tried to evaluate when a property is null. I have and argument in my workflow, let's say, 'MyArgument'. In a transition, I try to put a condition like 'MyArgument.MyProperty = Nothing'. I never developed in VB.NET, I don't know if I'm missing something here...
VS2010 gives the following error: "Error 4 Compiler error(s) encountered processing expression "MyArg.MyProp = Nothing".
Operator '=' is not defined for types 'XXXX' and 'XXXX'
The type names are exactly the same, and I have debugged VS2010 to ensure that my assembly is not loaded from 2 different locations.
How can I check if the property is null or not?
BTW, I'm using VS2010 SP 1, with .NET Platform Update 1 installed, on W7 64 bits.
Anyone want to try converting this to VB?
[Code]...
It is supposed to sort any type of object. Taken from here
Question: I want to call a generic function, defined as:
Public Shared Function DeserializeFromXML(Of T)(Optional ByRef strFileNameAndPath As String = Nothing) As T
Now when I call it, I wanted to do it with any of the variants below:
Dim x As New XMLserialization.cConfiguration
x = XMLserialization.XMLserializeLDAPconfig.DeserializeFromXML(Of x)()
x = XMLserialization.XMLserializeLDAPconfig.DeserializeFromXML(GetType(x))()
x = XMLserialization.XMLserializeLDAPconfig.DeserializeFromXML(Of GetType(x))()
But it doesn't work.I find it very annoying and unreadable having to type
x = XMLserialization.XMLserializeLDAPconfig.DeserializeFromXML(Of XMLserialization.cConfiguration)()
Is there a way to call a generic function by getting the type from the instance ?
I have a grid view with a lot of columns, all need to be sorted on. I have seen a few snippets out there, but I cannot get any of them to work with my example. Here is what I have so far.
Protected Sub gvSearch_OnSorting(ByVal sender As Object, _
ByVal e As GridViewSortEventArgs)
If Not Session("sort") Is Nothing Then
[code].....
written a generic "LaunchForm" function? For all the menu items I have that open a form, I would like to write one function that will launch the form as opposed to writing the same code several times.
View 2 RepliesI have an abstract class in VB.NET. I want all classes that inherit from this class to return whatever value makes sense. For example, it could be an Decimal, Integer, String. How can I delcare the function in the abstract base class to allow for this? Is this even possible?
[Code]...
I have created a couple of simple functions in VB.NET that simply return a control of a certain type that I already know, such as HtmlInputHidden, Label, etc. That means that each of the functions is created only for that special purpose. What I'd like to do is combine all those functions into one function using generics. The common things shared by each of the functions is a control Id and a control type.What I have got so far is:
Public Function GetControl(Of T)(ByVal ctrlId As String) As T
Dim ctrl As Control = Me.FindControl(ctrlId)
If (Not ctrl Is Nothing) Then
[code]....
But the line " GetControl = CType(ctrl, T)" is giving me a compile error:
Value of type 'System.Web.UI.Control' cannot be converted to 'T'
This is in .NET Framework 2.0.
I am attempting to create a generic function that the students in my introductory VB .NET course can use to search a single dimension array of a structure.[code]...
My question is: Is there a way to reference the individual structure fields in the array from inside the function? I was trying to make it generic so that the student could simply pass their array into the function - their structure may be named differently than mine and the field names may be different.
I suspect there are other ways to deal with this situation, but I was trying to keep it to just a simple single-dimension array of a structure. I don't think it is possible to do what I want, but I wondered what others thought.
I must be doing something wrong here (because really, what are the chances of me tripping over another bug in the Vb.net compiler?)I have a static generic function in .net 2.0 Vb code, I thought it was time to "upgrade" it to be an extension method, but the compiler complains with Extension method 'AddIfUnqiue' has type constraints that can never be satisfied.
Here's a trivial example that displays the same problem. The old static version (which works fine) followed by the extension method
Public Class MyStaticClass
Public Shared Sub AddIfUnqiue(Of T, L As {List(Of T)})(ByVal this As L, ByVal item As T)
If this.IndexOf(item) < 0 Then
[code].....
I can create classes that use generics, however I was wondering if it is possible to apply this to a shared method rather than rely on the caller casting to the correct type.This is the method:
Public Shared Function DeserializeObject(ByVal serializedXml As String, ByVal givenType As System.Type) As Object
Dim serializer As New XmlSerializer(givenType)
Return serializer.Deserialize(New IO.StringReader(serializedXml))
End Function
I'm pretty sure this can't be done, but thought I'd check (if so Extra points will be awarded if someone can technically explain why the compiler can't do this)..
My question here is, what are the negative effects of using a generic function such as this? Calling this function does work, and in a test console module, it compiles perfectly fine. I do know this is not a strongly typed function, and is %100 bad practice. But it works perfectly. The purpose of a function like this, would be to handle string input that needs to be inserted in a particular format depending on the type. I also read some other questions on this here on stackoverflow, and suggestions pointed to using (Of T) functions, and variations like that. Why not do it this way? or is there another simple way of accomplishing this without creating a whole nothing class or larger amounts of code.[code]
View 1 RepliesI like to turn Option Strict On I cant figure out how to write the generic version of this function?
Public
Shared
Sub UpdateItem(ByRef
oldValue As
[code]....