Make The Function Accept DBNull As A Parameter?
Apr 23, 2012
I've got a little function that just changes empty and null strings to "null":
Public Function CatchString(ByVal stringValue As String) As String
If stringValue = "" Or stringValue Is Nothing Or stringValue Is DBNull.Value Then
Return "null"[code].....
I added the bit about DBNull because sometimes it gets null values from a database. This doesn't work, though, because it won't take DBNull as a parameter.I tried changing the stringValue parameter from a string to an object, but then the If statement gives this error:
Quote: Object reference not set to an instance of an object.How do I make the function accept DBNull as a parameter?
View 3 Replies
ADVERTISEMENT
Feb 17, 2011
I'm currently working with a client's VB.Net code, which was developed for them by a small development shop a few years ago and which they purchased and have been maintaining and uprgrading since. This client's primary developer is out on indefinite (likely permanent) medical leave and I'm now filling in until they bring in a full timer (as I'm a contractor here). My current task is to add some functionality to a the VB.Net code they purchased. I'm finding practices and techniques in the code that absolutely baffle me and can't make the code do what I want. I'm starting to wonder if it's me and was hoping to get some thoughts on the code I've encountered.
For example: Setting a variable to accept the result of a function by calling the function with many parameters, clearing the parameters in the function, setting them to some value, calling another function with those new values, then never using the values returned by the functions. I'll add a code snippet in the first comment since this is already getting long.
View 9 Replies
Jul 30, 2011
I'm trying to execute a sub with multiple parameters on a separate thread, but I just can't get it to work, Here's my code
[Code]...
View 2 Replies
Mar 9, 2011
I want to have a "template" function that can receive different parameter and a type parameter, like:[code]But Vb told me that tupeList is not defined... is there a way I can do that?
View 2 Replies
Nov 9, 2011
I am having problems with my code, where I get the "Object cannot be cast from DBNull to other types" message when Insert(). I get the message on every Insert to this table, even though the data is successfully inserted. If I Update the same data after Insert(), it does so without error. I have checked my values and none of them are DBNull. Even when the same values are passed on Insert that are passed on Update.
My code is :
Private Sub Save()
Dim bo As tbl_GL
bo = New tbl_GL()
bo.ConnectionString = AppConfig.ConnectString
[Code] .....
View 4 Replies
May 7, 2011
[[code] 1) Is this violating the phrase static classes should not have state?
2) How can I modify the functions such that they can accept any function (instead of my above situation which only works with F(TResult) and F(T, TResult). [code]
View 1 Replies
Dec 13, 2011
I need to execute a stored function in oracle or sql through vb.net. I created a command object. Depending on the database type(oracle or SQL) i am preparing the Command text as Select functionName(?,?,?,?,?,?,?,?) from dual; (For Oracle) Adding the parameter values of the function. Now performing the ExecuteScalar which is not working saying invalid parameter. This works with ODBC connection string. But ODBC doesn't with 64bit. My Requirement: Code should execute a user defined stored procedure by taking the values at runtime.
View 1 Replies
May 28, 2012
I want to make a GetAllContacts method which takes a sort parameter of type Func(Of Contact, TKey) which is the same type that the OrderBy method for an IEnumerable(Of Contact) takes.[code]"Too many arguments to extension method 'Public Function ElementAtOrDefault(index As Integer) As Contact' defined in 'System.Linq.Enumerable'." on the second parameter.
View 2 Replies
Aug 18, 2011
I have buttons generated through code (dynamically). I have to associate an event (the same) to them. I use AddHandler button.click, AddressOf mysub.The issue is that mysub gets a string (mysub(string)), but AddressOf doesn't accept a parameter inside the routine. How can I do this? Using also an alternative to AddressOf.
EDIT:
Public Class Form1
...
Private Sub mysub(ByVal sender As Object, ByVal e As System.EventArgs, ByVal str As String)[code]......
View 2 Replies
Dec 31, 2009
This function doesn't work if I change the input argument 'pdu' from a string to an int.Would someone please help me figure out what to do here so that the checksum does not add the ascii value of the int argument but rather the actual integer value?I took out a few lines of the actual function but it adds the input argument to a packet sent out via TCP protocol.This function shows the integer value just fine in the string that gets encoded as a byte array. the checksum is wrong.!
''Public Function buildpacket(pdu As Integer) is what I want.
Public Function buildpacket(pdu As String)
Dim packet As String
[code]....
View 1 Replies
Sep 24, 2010
I am trying to figure out how to make a program which can accept switches like cmd.exe /k or /c basically i want it to accept commands by myapp.exe /c mycommand.i tried searching and googling but no luck. Also is there a way to run a function like that? And if anyone is wondering why then basically i am copying a script to my domain computer and executing it. This i already have done but problem is its just getting too much copyin multiple scripts and executing i would put everything in on and run em by switches.
View 2 Replies
Jun 7, 2010
How should i make a textbox to accept only string? And if there is error to appear the Error Provider. I have fixed it for the integer, but it doesnt work in string.
View 1 Replies
Oct 17, 2011
Command line programs like ffmpeg.exe accept a parameter like so: c:> ffmpeg.exe -i img%03d.png img.gif This will grab all these images in the directory and use them inside the program:
[Code]....
Is there a clever way to implement this in my VB.net command line project, or do I have to parse the argument for the %0?
View 1 Replies
Oct 5, 2009
I am trying to make a textbox accept on the numbers 1-4 & the backspace key. The numbers part is working fine, but it will not delete the number once it's inputted into the box using backspace. Here's my existing code:
Private Sub txtCode_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtCode.KeyPress 'allows the textbox to only accept 1-4 & backspace If (e.KeyChar < "1" OrElse e.KeyChar > "4" _ AndAlso e.KeyChar = vbBack) Then e.Handled = True End
View 4 Replies
Nov 10, 2008
hows to make a textbox accept only numbers? and ".". i tried looking in the Help, couldnt find something relating to it. i guess it's something to do with the keys pressed on the keyboard so if i could determine and reject certain keys (anything thats not a number) it could work.
View 6 Replies
Oct 15, 2011
I Want to make a class accept string variable like this
Dim mystring as custstring
mystring = "test var"
like how we declare string classes I tried to use property as such
Public class cust
dim inputstr as string = ""
Public Property cust() As String
Get
[code]....
But it doesn't seem to work?
View 14 Replies
Jan 11, 2010
On Form Level, I use following codes to make textboxes to accept only numbers,How to add these codes in main module, instead of of writing these codes on every form.
If TypeName(Me.ActiveControl) = "TextBox" Then
With Me.ActiveControl
If Not IsNumeric(.Text) And .Text <> vbNullString Then
[code]...
View 6 Replies
Mar 12, 2010
I need help with making a textbox only accept numeric values only, as in setting a timer interval.
View 2 Replies
Apr 28, 2011
How to make a text-box accept only numeric characters (0-9) ? and give an error Message if it contains any alphabets or symbols.
View 4 Replies
Feb 3, 2012
How do I make a textbox control to accept dates only and convert to a valid date format? I don't want to use the calander control. e.g. if I enter 2/17 or 2-17 or 02/17 or 2/17/2012; it will convert to 2/17/2012
View 4 Replies
Jul 29, 2010
How would I make my web browser accept only file paths? It's a little import manager for a program that I am making, allowing the user to import files, but I dont want but reports that say that they can access google or something through it.
View 8 Replies
Jun 22, 2010
I am in ethiopia and we have 13 monthes. 12 of them with 30 days each and 13th month with 5 or 6 days. I want to sort my data by date using the bindingsource sort method. But to do that I need to set my date field a date data type. When i set the datatype to date, i can't enter some values like 13 for the month value and 30 for day value of 2nd month.
What I want is just to make my application accept 13 as a month and 30 as a day for all monthes, so that i can sort my data by date. Is it possible to do so by setting culture for my application or by some other means?
View 1 Replies
May 30, 2010
I have a field called PODate & TextBox txtPODate.text. It saves/updates fine when the txtPODate is filled. But when the txtPODate is blank, it throws an error. The problem is that I can't enter date for each record unless I got Purchase requisition converted into Purchase Order. Once it is converted to PO, I need to enter the date to update that filed. So, how can I make my program to accept blank date field.
View 6 Replies
Dec 11, 2011
How Can I make TextBox accept only Latin characters and numbers.?
View 9 Replies
Aug 17, 2009
I am having a problem on setting the SQL CE table column a field type. What field type does a column that only accepts only two inputs..
Example: If a table has a column named Gender..it should only accepts two types of input...like Make or Female.
View 6 Replies
Sep 19, 2011
Using a DataGridViewComboBoxColumn, the goal is to make the ComboBoxes accept user's new items and also the possibility of choosing items that are already present.I'm aware of using EditingControlShowing event of the DataGridView to change the DropDownStyle of the DataGridViewComboBoxEditingControl at run time to allow this, but I'm wondering if this can be done at a lower level.
What I'm doing now is extending DataGridViewComboBoxColumn, DataGridViewComboBoxCell and DataGridViewComboBoxEditingControl, hoping to change the EditingControl's DropDownStyle in the moment I instantiate it. So far, no luck.The debugger shows the right assignment is being executed, but nonetheless, the DropDownStyle is popping at the EditingControlShowing (using the event for debugging purposes) as DropBoxList, not DropBox, which is the intent.
Here follow the classes:
Public Class DataGridViewComboBoxColumnALT
Inherits System.Windows.Forms.DataGridViewComboBoxColumn
Public Sub New()
[code]....
View 1 Replies
Feb 3, 2010
I am in ethiopia and we have 13 monthes. 12 of them with 30 days each and 13th month with 5 or 6 days. I want to sort my data by date using the bindingsource sort method. But to do that I need to set my date field a date data type. When i set the datatype to date, i can't enter some values like 13 for the month value and 30 for day value of 2nd month.
What I want is just to make my application accept 13 as a month and 30 as a day for all monthes, so that i can sort my data by date. Is it possible to do so by setting culture for my application or by some other means?
View 6 Replies
Nov 15, 2011
I'm having trouble with the Try...Catch code. I'm trying to make the textboxes only accept letters A, B, C, or D as answers from the user. I'm also having trouble matching the two arrays. I wanted it to be like if textbox1 is A then it is correct but in a loop. Please take a look at my code.
This is the programming challenge instruction for reference: The local Registry of Motor Vehicles office has asked you to create an application that grades the written portion of the driver's license exam. The exam has 20 multiple choice questions. Here are the correct answers to the questions:
[Code]...
View 9 Replies
Oct 14, 2009
I have an assignment that requires me to edit some code, I already did most of it but I need to make txtState control to only accept letters and the backspace key. I was never taught how to do this and I only know how to do it with numbers. Here is my code with everything done, including the format I was taught to do keypress in with numbers and backspace. Can someone show me how to replace those numbers pr whatever to work with letters?
[Code]...
View 3 Replies
May 9, 2011
I would like to upload files using the ASP FileUpload control. However, if I try and increase the limit to about 10000 kB, it doesn't work and accepts files only upto 4 MB in size and I get an error saying that the connection to the server was reset. I referred: [URL]..but when I modified the web.config.comments file, nothing happened. Where am I going wrong?
Also, I wanted to know how this would work when I deploy it on the web server. I'm asking because in the code behind, I'm still giving a hard coded value for the path where the file is to be uploaded. How does this work?
View 1 Replies
