Set Value Of PARAM Object When It Can Be NULL?
Oct 26, 2010
If I have a variable, X, of type SqlDecimal, that was instantiated without providing a decimal value parameter to the constructor, then the .IsNull property is True: Dim X As New SqlDecimal '.Value = Null..If I have a Stored Procedure that acepts a single parameter, @SqlDecimalParameter, of type Decimal, the value of this this parameter could be NULL or a decimal value. This is how I would normally call the stored procedure:[code]It seems like the 1st example should work. Am I missing something? after all, the Sql datatypes are designed to work with SQL Server, I thought.[code]I get the following error:Failed to convert parameter value from a SqlDecimal to a Decimal.It works when X.IsNull is True.How do you set the value of the PARAM object when it can be NULL?
View 1 Replies
ADVERTISEMENT
Jun 24, 2010
I have some code which gets child items for a menu via the GetChildren function which takes a list of menuData: Dim builtMenu As New List(Of MenuData)(_rawData.FindAll(Function(item) item.GroupingID = 0))
For Each menuData As MenuData In builtMenu
If menuData.Children IsNot Nothing Then
menuData.Children.AddRange(GetChildren(menuData))
End If
Next
If I check if menudata.children isnot nothing, it always is nothing because the GetChildren function is yet to run (providing the child items, which do exist). If I remove this check and just have this code:
Dim builtMenu As New List(Of MenuData)(_rawData.FindAll(Function(item) item.GroupingID = 0))
For Each menuData As MenuData In builtMenu
menuData.Children.AddRange(GetChildren(menuData))
Next
Then I am presented with a Object reference not set to an instance of an object error on menuData.Children.AddRange(GetChildren(menuData))
View 1 Replies
Dec 8, 2009
I am making use of a 3rd party dll and am encountering some strange behavior in VB, which doesn't occur in C# Perhaps someone can explain what is going on. Anyhow, I am making use of a method in this 3rd party library which accepts an array parameter ByRef. The end result is the variable should remain null after the method call, but it is returning initialized for some reason.
[Code]...
View 2 Replies
Dec 14, 2010
Currently working on the status bar for application. I would like the status bar to display message errors if a user makes an invalid entry. I have a module which contains the main procedure and procedures to change the text property of my status bar. A Call is made to the procedures from one of the forms that requires the user input. The application compliles but I get an unhandled exception of type 'System.Null ReferenceException' Object reference not set to an instance of an object. [Code]
View 4 Replies
Mar 25, 2011
Is there simple way to SyncLock an object that can be null? And before you ask for it, yes, I know that it isn't logical to perform a SyncLock on a null variable. However, that would simplify my code because right now, I have no choice but to perform a null check all over the place before calling a SyncLock.
[Code]...
View 3 Replies
Jun 29, 2009
I just want to check and see if this object is null. if i do not and it is my applications closes.I have also looked into a null reference exception. I will do whatever as long as it handles "null".[code]
View 2 Replies
Aug 5, 2011
I am not sure what I'm doing wrong, but I need some guidance from people smarter than me...
View 1 Replies
Nov 15, 2011
MVC 3. VB.NET I have the following controller action in my application to send generated PDF files to the User by download. The function works fine when the controller itself has been invoked. But when I call to the function from outside the controller it returns a " Object reference not set to an instance of an object " error as soon as it hits the response.contenttype line. I have verified that all of the variables are in fact making it to the below action.[code]any ideas why this is only working when called explicitly from inside its containing controller???
View 2 Replies
Feb 10, 2010
write know i am gettin null reference exception due to followin code
Imports System.Xml
Imports System.IO
[code].....
View 3 Replies
Sep 20, 2010
I have created a query off a dataset with a where = @param. This poulates a dgv.
I then have created the parameter by using the Parameter collection editor.
Then on my form I have Textbox1.Text that has the value I want to pass to the parameter @param.
How do I get that value in to the @param?
View 5 Replies
Jul 12, 2010
Currently, whenever I pass a string to the db, if that string is empty, then i set that object to NULL by doing the following:
IIf(DescriptionTxt.Text.length > 0, DescriptionTxt.Text, DBNull.Value)
I was thinking about writing a function to reduce the length of this code, and make it more consistent.However, I was wondering, is there already a way of doing this in .NET 3.5?
View 3 Replies
Feb 17, 2010
Is there any sense to set custom object to null(Nothing in VB.NET) in the Dispose() method?Could this prevent memory leaks or it's useless?!Let's consider two examples:
public class Foo : IDisposable
{
private Bar bar; // standard custom .NET object
public Foo(Bar bar) {
[code]....
View 9 Replies
Dec 30, 2009
i've got a Class like this public Class Cart(Of Item) Public Sub New(ByVal a As Integer, ByVal ParamArray items As Item())but i do not see how to create an instance of it: Dim block_names As New Cart(Of String, 5I)i get something like "type expected" o.O
View 2 Replies
Mar 22, 2011
I've a HTML page and i need to pass some value to my aspx page.
Since the url got a maximum length 256, i need to use <param /> tag to help me pass values and also get values from aspx.
(the numbers of param is not fix)
I've been searching days for the example how to get this done.
View 5 Replies
Jul 28, 2009
I'm using FileHelper to generate object's property. Here is an example of one property:
<FieldOptional(), _
FieldTrim(TrimMode.Both)> _
<FieldNullValue(GetType(String), " ")> _
Public StoreNo As String
As you can see the StoreNo will either have a value or " ", one of the business policy is to check if the StoreNo is empty or nothing if the object's StoreNo is empty or null then the record will not create.
I though about creating an HasValue Function in the class to check the StoreNo and other properties in the object but I feel like it is a hack.
Public Function HasValue() As Boolean
Dim _HasValue As Boolean = True
If StringHelper.IsNullOrBlank(Me.StoreNo) Then
[Code]....
I don't think this approach is an ideal solution. what if the StoreNo is remove or change to something else. What's the best approach to check object's property?
View 3 Replies
Jul 8, 2009
i have the following code but when i select button1 i get the following error: Null Reference Exception was unhandled-object reference not set to an instance of an object. - any idea's how to fix it ?i have underlined the line of code that is highlighted when the error occurs
Imports System.Data
Public Class Form1
Dim Ping As Net.NetworkInformation.Ping
[code].....
View 4 Replies
May 31, 2012
I have a VB.NET application which runs perfectly with local host. But when I upload it to my server the session objects throw null reference exception.
Sessions is not working in a single page. If I use session on any other page it is working perfectly.
I have enabled session in that page using the EnableSessionState property. Also in web.config I enabled the use of session variables.
View 1 Replies
Dec 14, 2006
I have the following VB.NET function, for example:Public Function MyFunction (Of TData) (ByVal InParam As Integer) As TDataEnd Sub
View 5 Replies
Oct 16, 2011
I have a Javascript function for my select box, but after I included runat="server" to it, the script debugger highlights on this line below:
' for (i = 0; i < sourceTo.options.length; i++) { ' and says:
SCRIPT5007: Unable to get value of the property 'length': object is null or undefined
I included it because I wanted to loop through it in code behind and perform some other stuffs?
Code:
<select multiple size="8" style="width: 135px" runat="server" id="outletFromBox">
<option value="JP">Jurong Point</option>
<option value="IMM">IMM</option>
[code]...
View 1 Replies
Sep 8, 2011
I am getting a javascript error when I attempt to click on my calendar control.
The html code is:
<td align="left" style="width:50%;"><asp:Label runat="server" CssClass="TextFontBold" ID="lblStartDate" Text="Start Date:"></asp:Label>
[code].....
View 2 Replies
Oct 21, 2010
I'm converting some RDO code to ODBC Provider code in .NET.The problem is parameter names were not specified in the orignal code, but param values were retrieved by parameter name after the command was executed.Is there anyway to have parameter names populated by the provider once the command is executed so calling code can access params by name.Let me show you an example of the declaration of param and accessing of it.
[Code]...
You can now see how this "used to work in RDO/VB". For some reason it would accept this and know what the param names were after execution. I imagine it had to do another round trip to the db to get this info.
Is there anyway to mimic this behaviour in .NET for ODBC Provider (using Oracle)? Or am I stuck manually specifying the param names in the code (I understand this is the better option, but wondering what the alternative is to match the original code as closely as possible).
View 1 Replies
Aug 17, 2011
I am getting this error when I call a javascript function to display a modal window:
Microsoft JScript runtime error: 'document.getElementById(...)' is null or not an object
The code block is:
else if (action=="officeview") {
document.getElementById("OfficeContent").src="ChangeView.aspx";
ShowFeatureModal('AppView','OfficeContent')
The object is this situation, does exist. Error is caused at: document.getElementById line.What else could be causing the error?
Update:Index.aspx is calling the javascript function which is located in sysUtilities.js file. The source file is yet a seperate page (ChangeView.aspx)
View 4 Replies
Jan 8, 2010
I am using the ModalPopupExtender control to display a modal popup dialog when a button is click. The problem is that dragging the dialog results in an 'scrollleft is null or not an object' error. Here's a video demo and here is ALL the code: If possible, I'd like to resolve this problem w/o resorting to modifying the AjaxToolkit scripts themselves.
[Code]...
View 1 Replies
Sep 26, 2010
Use the "new" keyword to create an object instance & Check to determine if the object is null before calling the method. I'm reading text from a text file using the following [Code]
View 9 Replies
Jan 27, 2011
I have a class and method exposed to a client asp.net app. The class looks like
<DataContract()> _
Public Class Class1
Private v_string As String
Private v_integer As Integer
[code]....
The method is declared as
<OperationContract()> _
Function GetStuff(ByVal bar As Class1) As String
In the client code I create an instance of Class1 and set the values for v_string and v_integer, but using Wireshark to look at the xml being sent to the server only a value for v_string is being sent as part of Class1. I'm guessing this is because it considers the value of v_integer to be null/not set. Here is an example of the client code.
Dim MyService as New Service1.ServiceClient
Dim test as New Service1.Class1
test.P_integer = 1
[code]....
how different types are passed/used since Integer is a intergral type and String is a class, but can't seem to work out what to do to fix the problem.
View 4 Replies
Jun 26, 2009
We're in a strange situation with a legacy winforms VB.NET 1.1 application using ASMX web services. Trying to send a user Token from a WindowsIdentity object as a parameter to a WebMethod. I will be adding a 'HACK: comment. System.Security.Principal.WindowsIdentity.GetCurrent().Token
The token is of type IntPtr, the first problem is the WSDL being generated doesn't support IntPtr with the error of 'unsupported type'I'm aware this is a big WTF question and sounds insecure, so any simple helpful alternatives are welcome but there are a lot of constraints on how we can change this system, including complications with the hosting environment. So I would just like to get our piece of data over to the web service to save a lot of other headaches.
[Code]...
View 1 Replies
Aug 27, 2009
I have an RDLC report that I am rendering directly to the Response Stream as PDF (rather than using the ReportViewer). In the code that renders the report, it's DataSource is bound to a List(Of ClassA) objects defined in a custom assembly. This seems to work for the most part. My problem is that I can't seem to handle the situation where a nested object is null. For example, given ClassA and ClassB (the nested object) defined as follows:
Public Class ClassA
Public Id As Integer
Public Name As String
[Code]....
the report displays "#Error" if TheNestedObject is null. If TheNestedObject is not null, it correctly displays the Name.
View 3 Replies
Mar 8, 2010
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].............
View 3 Replies
Apr 29, 2009
I've seen plenty of examples of transactions in the actual store procedure's SQL. But I'm wanting to do the transaction and keep track of it in code. I tried this but it says that my insertcommand's transaction object is null. How can I fix this?
vb Dim conn As SqlConnection = DBConnections.SQLServerConnection
conn.Open()
Dim params(1) As SqlParameter
[CODE]....
View 3 Replies
Jan 14, 2010
[Code]...
VS 2008 Null error "NullReference object was unhandled"
View 3 Replies
