In one function I have the variable: dim StrProjectNumber = UCase("23-EXP-16284")
However in another form I want to use that same variable in a SQL query, and when I try it says the variable is not declared. Do I have to make a global variable or is there a way around it? If so, how would I go about declaring a global variable?
I have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. [code]...
View 14 RepliesI have a public variable that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. If I declare:
Public Class Form1
Public payPeriodStartDate, payPeriodEndDate As Date
How then to I declare that variable in form2 and how to I pass it to my sql query.
Here is the code I have for form1: [Code]
and when I debug this form, no data will appear. I'm sure that it's something wrong with how I'm either calling the variable in form2 or in the query. Can anyone offer any assistance on this?
Say that i have the following code that parse about 20k records from the DB.
Code #1
vb.net While reader.Read()
list.Add(If(Integer.TryParse(reader(0).ToString, 0), Integer.Parse(reader(0).ToString), 0))
End While
And then another code which does the very same thing but it seems to be a little cleaner.
Code #2
vb.net While reader.Read()
Dim storeowner As Integer = 0
Integer.TryParse(reader(0).ToString, storeowner)
list.Add(storeowner)
End While
This is what i am confused about; does the compiler creates a new variable automatically when i use the if statement without strictly declared variable? What approach is better in sense of performance?
I am looking for a good resource on variable naming conventions to illustrate variable type and where variables are declared. So I will have public variables, Private variables, private or local variables. I also may want to declare variables with the same name in different class code (i.e. in the code behind different forms). I am assuming good coding would dicatate a prefix for declaration location.
View 4 RepliesI am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient
Imports System.Linq
Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
The following is a screenshot of the problem: What can I do?
View 3 Replieswhen I was using vs2008, code below was working without defining mystudent variable.It was recognizing type automaticly because of mystudents list of object.Has anyone know the reason why compiler returns error that "It is not declared"?
View 16 RepliesIf I modify this code (written by Luis Esquivel) because I want to dimension a variable and cast it either as a polyline or a polyline2d inside a select statement...it doesn't recognize the variable outside the select statment. I can't dimension it outside (or rather) before the select statement because I don't yet know how I want to cast it.
' by Luis Esquivel on June 29 2007
' using the idea/algorithm by John F. Uhden,
' one of the masters that use to frequent the customization ng of AutoDesk
[Code]....
[code]...
Private Sub btnData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnData.Click[code]....
I'm using DAO (been asked not to use ADO.NET) to update an Access database. I'm currently thus far, however, VB2008 is telling me that the variable "daoengine" is not declared before it is used. What am I doing wrong in the following code?
Function update_db()
Dim daoengine As DAO.DBEngine
Dim dbs As DAO.Database
[Code]....
I have a simple IF THEN ELSE block which checks for the presence of a querystring and then checks if it is set. The idea is that if no querystring, the form is empty and people can enter a new form. If there is a querystring and it isn't blank, a db query for the form data occurs, fields are populated and a user can update the form.
so here is my code block.
Dim strQueryStingCheck As String
If Not (Request.QueryString("pid") Is Nothing) Then ' is there a querystring?
If Request.QueryString("pid").ToString <> "" Then ' does it have a value?
[code]....
I am getting the "Variable is not declared; it may be inaccessible due to its protection level" for strQueryStringCheck ONLY on the Else code block - that is when I set strQueryStringCheck to "e". I can't figure it out.I've looked at other posts, particularly this one. and it was helpful. I can make the error go away, but I want to understand why I am getting it in the first place. I declared it within the subroutine. And if I was doing something wrong, shouldn't it throw an error on BOTH blocks of the IF THEN ELSE block? It doesn't when I set strQueryStringCheck to "u". Why only in the ELSE block?
catch(ArgumentOutOfRangeException aooreE){}
catch(NullReferenceException nreE){}
I got the error state that The variable 'aooreE' is declared but never used.
In C#, I can declare an array variable like this: object[] Parameters;
And initialize it like this: Parameters = new object[20];
In VB, declaring and initializing an array is easy:
Dim Parameters(19) As Object
Dim Parameters As Object(19) ' Alternative Syntax
How would I initialize an array variable that has already been declared in VB.NET? Parameters = New Object(19) doesn't work.
For example, how would I translate the following to vb.net?
int value = 20;
object[] Parameters;
if (value > 10)
{
Parameters = new Object[20];
}
I have some web pages that include other pages, and I need to check if a variable (a string) has been declared in the page or not.
I was exploring try catch and finally, but im always getting a compiler error saying the variable doesnt exits.[code]...
I have a text file to read, at the first line will have a size of array, that means I cannot guess size of array, and I have to create a array in side a sub (Local Variable). Then, I want to use value of array in another sub, but I cannot use value of variable of another sub. What I have to do to make an array con be used in every sub/function in a class? Also, I've post an example file, code and error list.
[Code]...
I am trying to run this line of code: Dim OrderedFiles() As String = Directory.GetFiles(FilePath).OrderBy(x >= x.CreationTime)
I get an error on x saying x is not declared. I have my project set to Option Strict Off and Option Infer On. If I turn ON Option Strict then I get thousands of errors from the project(it is inherited) and I don't have the time to fix all of them, but x no longer gives me an error. I have googled until I want to throw my computer out the window.
I was hoping for a more elegant solution but here is what I came up with to solve this particular problem.
[Code]...
It is not particularly elegant but it does the job. I was hoping for a one liner LINQ solution and I just don't have the background in LINQ to know how to do the job, time to go buy a book.
In my xslt file I want to apply templates to the xml but only if an id of that piece of content within the xml matches an id calculated in vb.[code]...
ContentparId is the attribute parId of Content in the xml. I want to compare this with mnPageId which is defined in vb (a foreign reference is passed through and the pageId that matches that foreign reference is returned)
I know the rest of the code does what I want it to do because if I manually change mnPageId for a correct pageId then I get the xml that I want back.
So, is it possible to use a variable that has been declared in vb in xslt?
I am getting some value from another form using Request.QueryString.Get(" test") and then i need to use this value on aspx page.[code]...
View 3 Repliesrefering to a different object (in this case, a button). If somebody could explain to me the method for refering to this,
Current
(nrbRand1 and 2 are the variables on the separate button; this should be a quick fix for you guys)
[Code]....
I'm trying to debug my program on a fairly new WIN7 64 Home Premium bit machine. Whenever I try to add a variable to the Watch window, I get the message... Name 'My Variable' is not declared.or Microsoft.VisualBasic.Right(StringRow, 14)'Microsoft.VisualBasic.Right' is not declared or the module containing it is not loaded in the debugging session
View 3 RepliesI'm login to the website with WebBrowser1 The source code of the website:[code]
View 4 RepliesI'm using Microsoft Visual Basic 2008 Express Edition. In the little program I'm creating, I added a WebBrowser and a button that will make the WebBrowser navigate to a designated website when clicked. So far, it's fine.
The problem is that I want to be able to get the value of a variable declared in the website's javascript. How do I do this?
The following is a part of the source code of the website.
<script language="javascript">
var contextPath = "/websmsn";
var noSessionPath = "/websmsn
[Code]....
I want to get the value of "activeMsgSessionId" and store the value in my own variable. The value of "activeMsgSessionId" changes every time the website is loaded.
i'm sort of a n00b to VB and was wondering how to make a variable available across multiple Subs. It's just a test app to get familiar with VB.My Code:[code] "Sentences" is not declared. It may be in accessable due to it's protection level."
View 4 RepliesToday I decided to come up with a program that would be useful for me in VB.net (I have never coded in VB.net before). All is going fine up till this point but I have hit a snag with the error mentioned above. The problem is with the windowssevenexistsonsource boolean under the get get of profiles comment. I will also take any code criticism well as I would like to get out of bad practices before I start! (the sub does end but I have not included that code)
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Check that the entries required are not empty
If String.IsNullOrEmpty(sourceipaddress.Text) Or String.IsNullOrEmpty(destinationipaddress.Text) Then
[code]....
I've used this code before but only when I was serializing one array. Here I'm trying to serialize two and VB returns "local variable is already declared within the current block."Someone tell me how to do this correctly, pleases. I'm banging my head against a brick wall that I can't see.
[Code]...
Today I investigated a logical bug in our software and figured out that this is related to the way VB.NET thread variables inside a loop.Let's say I have the following code:
Dim numbers As New List(Of Integer) From {1, 2, 3, 4, 5}
For Each number As Integer In numbers
Dim isEven As Boolean
[code]....
The problem is that isEven is declared but not assigned.In this specific case, it would be correct to write dim isEven as Boolean = false but I haven't done this.In VB.NET, a variable that is declared inside a for loop keeps its value for the next itaration. This is by design: [URL]but this is also dangerous pitfall for programmers.
However, until now, I haven't been aware of this problem/behaviour. Until now.Most of our code base is C# anyway, which doesn't allow the use of an uninitialized variable, so there is no problem. But we have some legacy code that is written in VB.NET that we have to support. So the best thing would be to generate a warning or even an error in this specific case.But even with Option Explicit / Option Strict this does not generate a warning / an error.Is there a way make this a compile time error or maybe a way to check this with FxCop?
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
This webservice is almost converted form VB to C#, except I get this error shown below on the DataRow arow object when I use it in the foreach statement below to populate the Results Class with a DataSet Object...
Error: A local variable named 'arow' cannot be declared in this scope because it would give a different meaning to 'arrow', which is already used in a 'parent or current' scope to denote something else
using System;
using System.Web;
using System.Collections;
[code]....
I receive the error -
[Code]...
