If I send a String set to Nothing as an input parameter to a SQL stored procedure, and in the sproc it's like this @MyString Char(9) = NULL, what does it turn NULL into? Because I'm firing the sproc and it's not firing the statement that says IF @MyString = NULL... So I don't know what it is... Or how can I pass the string as a NULL if nothing is passed as a parameter to my calling function?
View 4 RepliesSo strings are reference types right? My understanding is a reference to the string in the heap is passed even when you pass the string ByVal to a method.
String myTestValue = "NotModified";
TestMethod(myTestValue);
System.Diagnostics.Debug.Write(myTestValue); /* myTestValue = "NotModified" WTF? *[code].....
And what is going on under the hood? I would have bet my life that the value would have changed....
CStr in VB script throws error when NULL value is passed to it, whereas CStr in VB.NET ignores null value and doesn't throw error.
Is there any other function which does same function as CStr in VB script.
Try
Dim str As String
str = Nothing
'assuming above line will set str to null.
[CODE]...
I've been looking at accessing shared folders, read and write, via the network without being prompted by the OS for the username and password.
On this forum, and googling, I can find many things about accessing network shares, but none using code which also passes the username and password required.
What I'm basically looking for is to not have to map a drive on the users computer. Then using code, write or read files from a network share and at the same time pass the username / password required for that network share.
I see this asked many times on hereI'm copying this question that I found on here.Is there any way to pass a null value (I mean a value that the sql will interpret as null) to a stored procedure when using:tableAdapter.Fill(dataSet.table_name, param1 (as string),param2 (as string) etc...Which is the most painless way to do this(assuming that the sp stays inside the database!!)
View 4 Repliesi need to pass null value but error dim drf as date
[Code]....
Dim Upd As String ="UPDATE sakit set tanggalsakit'" & drf & "' WHERE orang= '" & id& "'
I want to pass a List of T where T is an object I've created that has about ten properties (strings, dates and integers).The lst passes to the function successfully. I am also passing an New T of the Object (itm as T).I can see all the values (see image below), but because it's generic I cannot seem to retrieve the property values and I cannot figure out how to iterate through the properties of each itm as they are retrieved in the For Each.[code]
View 10 RepliesI need to pass in parameters to my sub/function. When the parameter is passed, the value in the string, I would like to get the value evaluated and sent as:
Dim strParams As String = drRow(0)
' drRow is a row from DB Table. the value in drRow(0) =
' "@FromDate=""" & Now.AddDays(-10).ToShortDateString & """&@ToDate=""" &
[code].....
I'm sure there are better ways to do this and i am open to suggestions. I'm not worried about speed i figured get it to work then i could improve it but my problem is mynewstr2 is not being set to the last value of mynewstr for some reason.(probably something silly im overlooking right now). at this point just converting the image to a string i can work with for my very basic ocr.
Public mynewstr2 As String
Public Sub pictostr(ByVal image As System.Drawing.Bitmap, Optional ByVal Mode As BWMode = BWMode.By_Lightness, Optional ByVal tolerance As Single = 0)
[Code]....
My application is asp.net with vb. In my page I have a textbox for passing date. If I didn't enter date and on clicking submit, I have to pass null value to the stored procedure. I tried following codes such as DBNull.Value and DateTime.MinValue. In that case instead of null ,"#12:00:00#" is passing. I have to pass Null.
View 3 RepliesI am hardcoding an insert statement to a database, based on certain details a user enters into a windows form. The form has a few textbox and datetimepicker controls for the purpose. This form enters a single row in a single table in the database.The table has a few possible null columns defined, in those cases where the user does not have any data for those columns at that particular time.
I have to provide controls for passing data to those null columns nevertheless. In my case, I have two such columns that accept null values, and two corresponding controls - a textbox and a datetimepicker. The datetimepicker has a checkbox added to it so that if it is supposed to be null it doesn't pass the default current date value, and remains unchecked to explicitly specify that it is supposed to be null. By default it is unchecked.
My code is structured as follows:
Form1:
'the sub referenced here resides in a dll file in my dataaccesslayer code, and in my actual example is referenced properly.
'I have shortened the code here for simplicity
[code]....
Now it gives me an error whenever the code comes to the executenonquery(), and says something to the tune of "SqlDateTimeOverflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."
I think the value of 'Nothing' from the subprocedure's paramter is not being assigned to the sqlcommand's parameter as a database NULL, which is what I need to pass to the database.I know instead of using optional parameters I can easily create overloaded subprocedures where one sub allows not passing values where the column(s) is supposed to null and other overloaded subs permit combinations of which column(s) are null or not. But it is simple as long as there is just one, or at the most two null columns in a table. If I have dozens of null values in a table that the user can choose to enter or not in a data entry form?
I have already defined in my SELECT statement in TableAdapter to tell it what to do if the parameters are Null:
SELECT a.ID, a.NameID, b.BNameID
FROM a INNER JOIN b
ON a.ID = b.ID
WHERE ((@NameID IS NULL) OR (a.NameID = @NameID))
AND ((@BNameID IS NULL) OR (b.BNameID = @BNameID))
sir i m working on a project and i want to pass a value in query string and redirect it to next page .....ok now on next page i want to make a check on this if the value of querystring is equal to a particular value then a message show.... i have done upto here now the prob comes if the values is not matched the code written in else is not working i m writting my code:-----
if(request.param.count>0) then
label1.visible="true"
label1.text="hello"
else
label1.visible=false
I have a stored procedure which updates a database using the parameters I supply but I'm having trouble passing a NULL to the stored procedure
The field I need to make NULL is a DateTime field
DB.Parameters.AddWithValue("@date", NULL)
This gives me the error 'NULL' is not declared. 'Null' constant is no longer supported; use 'System.DBNull' instead
[Code]...
You pull the value out of the Request object
Request.Querystring()
Then set the ImageUrl property of your image
Is there any way to convert null terminated string to normal string.I mean I can easily make a program to find the location of vbnull but there has to be a built in function for that.
View 1 RepliesI am trying to use string.format on a url to pass several values into the string. It's probably a simple error but I cannot get the following code to work. It doesn't even build the string.
Public Sub getStockData()
Dim client As New WebClient()
Dim url As String
[code]....
I have a class library that contains a number of classes. I would like to dynamically create an instance of one of these classes, set its properties, and call a method.
Example:
Public Interface IExample
Sub DoSomething()
End Interface
Public Class ExampleClass
[Code].....
[URL] That way if the string that is not recognised that is passed to Color.FromName it returns a SolidColor of
Color.Black = Color.FromARGB(255,0,0,0)
That way, Forms and controls that only support SolidColors are supported.Installing VB6 on Windows 7?
I doing a project for my office. In that I am showing the values and strings from a particular table based on the date range and vendor selection. It is working fine with the date range. Except within the date range if the particular reader has no data it throws an error message like dbnull string.
[Code]...
foreach (PropertyInfo PropertyItem in this.GetType().GetProperties()) {
PropertyItem.SetValue(this, objDataTable.Rows[0][PropertyItem.Name.ToString()], null);
}
In one of the loops i get this exceptional error:
Object of type 'System.DBNull' cannot be converted to type 'System.String'.
The error occurs because one of the fields in the database has no value (null), so the string property could not handle it. How can I convert this null to string? I'm trying to avoid checking on every loop is current value is null or not.
This should be simple but apparently it's not. I have a text file, 694 bytes. At byte 500 there's a null in the file. I've tried reading it as text and binary and I end up with a string, 694 bytes long. But anyting I do with this string fails because it appears to stop at character 500. I can do a ? asc(mystring.substring(549,1)) and I get 9 (tab). Print character 550 and I get 0. Print character 551 and I get 32 (space). How do I get rid of this null?
View 5 RepliesThe user will select an entry in a gridview, which then redirects them to a form that is populated with the data from the selected row (thus making the gridview editable in a more user friendly way). Null values are accepted by the DB and I would like to show null date values as blank (or " ") in the corresponding text boxes. Instead I get the error:
Conversion from type 'DBNull' to type 'Date' is not valid.
Here is my code:
'preceded by connection code
Dim sqlcmd As String = "SELECT * from Master WHERE RecNum = @recnum"
'Dim sqlCmd As New OleDb.OleDbCommand("SELECT * from Master WHERE RecNum = @recnum", connection)
Dim FileCommand3 As New OleDb.OleDbCommand(sqlcmd, connection)
[code]....
How can I assign a variable which may contain a null value to a variable which is declared as Dim var1 as String and then use that variable to insert into access database table?
View 3 RepliesI tried this
Dim value As
String
Dim returnValue As
[code]....
Is there any way to convert null terminated string to normal string.I mean I can easily make a program to find the location of vbnull but there has to be a built in function for that.
View 15 RepliesI get the following exception for the code shown below. The error occurs when i request access token.I downloaded the latest dll(2.3.1) from the twitterizer website.
{"Value cannot be null. Parameter name: String"}
Dim OAuthTokens As New OAuthTokens
Dim accessToken As New Twitterizer.OAuthTokenResponse
accessToken = OAuthUtility.GetAccessToken(ConsumerKey, ConsumerSecretkey, "oauth_token", "oauth_verifier")
I have the following code below which has an error. When the checkbox is set to true and for example change the "role", and click save the following error is given;
"Index was outside the bonds of the array".
I know the reason of the error but don't know the solution..
The TxtPayCont is a concatenation of title, fname, and lname in an array. Therefore, if all the fields have values, then it works fine. So if it is Mr Jones Tim, this works, but, if it is Mr Jones it does not. It has to have 2 spaces to work. Is there anyway round this...
(see code below)..
Code:
In my project i need to sign every end of a string with Binary NULL, how do I write Binary NULL?
View 6 RepliesI want get a string from excel cell by vba and pass that string to vb.net function
View 1 Replies