I have a variable defined as Object(,) that was read in from excel. Without getting into a for/next, is there a simple way to read the c-th column or r-th rown from that array into a single variable?
View 2 RepliesI want to create an in-memory object in VB.Net with multiple columns. What I am trying to do is create an index of some data. It will look like:
Row 1: 23 1
Row 2: 5 1
Row 3: 3 38
...
I know I can use a rectangular array to do this, but I want to be able to use indexOf opearations on this object.
How do I Change the variable strLettersGuessed into a single-element array
View 4 RepliesI have a very large number of tables with data in the following format:
A X Y Z
1 0-2 0-13 0-1
2 3-5 14 2-4
3 6-9 15-16 5-10
In other words, there is a variable (call it A) with a single value that corresponds to a range of values in the other variables (call them X, Y, and Z).My program needs to accept user text input of values of X, Y, Z, etc. and then match each to the corresponding value of A.Example: User enters 4 in the X text box; program determines that if X=4, A=2.Again, we're talking about tables and tables of data in this format. Unaware of a better method, I have been using arrays.
Example:
Dim a() as double = {1,1,1,2,2,2,3,3,3,3...}
Dim x() as double = {0,1,2,3,4,5,6,7,8,9,10...}
Note how I had to artificially deal with variable A so that the index of each score corresponds to the index of the matching X variable.It is this modification of the variables that is taking forever. There has to be a better way! Hypothetically, what I need is the ability to do something like this:
Dim a() as double = {1,2,3,4...}
dim x() as double = {0 to 2, 3 to 5, 6 to 9...}
Is there a way to represent a range of values at a single index of an array, such as my hypothetical example above? This would save me hours of re-shaping the data to make the arrays work.
How you might construct an array like the following: one column or entry would be a single integer, like 0, 1, 2, 3, 4... - i need this as an index of each one's position in the list the second would be 0 or 1, or true or false the third would itself be a list of integers 0,4,5,2,7,2,5,2...
So all together one entry would be {0; 0; 0,4,5,2,7,2,5,2} while the next might be {1; 0; 6,8,2,5,2,3}
I'm having a terrible time wrapping my head around this. It's mostly the third column which is actually a list in itself, that is giving me trouble
I'm working on a piece of software to read a comma separated text files with thousands of lines each line has around 32 word separated with a comma What my code does at the moment it reads the file line by line choose 11 words out of the 32 and outputs them into a new file. This is actually time consuming although i used threads and a progress bar my manager still not happy. So i was thinking if i can read the whole text file into a 2 dimensional array and then choose certain Colums to output on the new file that will make it work much faster. But i don't know how to read a whole colum from a 2 dimensional array. And let's say for example the array is gonna be like array(9500)(32) where the first argument representing the number of lines and the second represents the number of fields in each line. Is there any way to access it like this array(all lines)(15) I'm using vb.net 2008
View 2 Replieswhat's the difference between variable array and object array?
View 7 RepliesDoes anyone know how to read a single column array from bottom up, then back down, filled with decimal data, into one line seperated by comma's?
a = 0
Do Until a > decArray.Length - 1
test = decArray(a)
[code]....
I have this function:
Public Sub DoStuff(ByVal type as System.Type, ByVal value as Object)
End Sub
The 'value' argument is always an array of the same type as 'type'. How can I loop through the values of the array?
I'd like to be able to do something like this:
DoStuff(GetType(Integer), New Integer(){1,2,3})
Public Sub DoStuff(ByVal type as System.Type, ByVal value as Object)
//Strongly types arr as Integer()
[Code].....
I am trying to make a list, separated by a comma, of entries from a single column in a SQL database. I have been spending the last several days searching for a way to do this, but every thing I found either didn't work, or wasn't exactly what I was looking for.
The query will pull all the email address that are not null. What I need to know is how to take the result of that query and make it look like this:
email0@address.com, email1@address.com, email2@address.com, etc, etc, ...
I feel like I should know this, but for the life of me, I can't remember nor can I find it in any of the textbooks I have.
I am using Visual Basic 2010 and SQL Server 2005. I also have access to Visual Basic 2005 if needed.
problem that i am facing is i want to add array of object as a single item in listbox. in vb6 i was using this Label1.Caption = Label1.Caption & Mid$ (strInput, intI, 1) & " " List1.AddItem (Label1.Caption) i was using label. caption to store object but not work in vs2008 because label.text only take text and left other values
View 18 Replieshere any algorithms/pseudocode for reading/parsing 3-column csv data and determining unique objects/attributes/values?
example data:
john,height,1.75
george,age,21
[Code]....
i have already implemented a solution of my own but it's too slow and i can't find any relevant literature on the internet.
Can this be rewritten any better using LINQ? I'm a C#er trying to think in VB.NET for this current project. It's in an ASP.NET Web Forms .vb codebehind:
Public ReadOnly Property AllowedCategoryIds As Integer()
Get
Dim ids = New List(Of Integer)
[Code]....
i have this error in the line of with xl.active......Object variable or With block variable not set.
Dim xl As Object
xl = CreateObject("Excel.Application")
With xl.ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:Documents and SettingsUserDesktop429MEDICA2.TXT", _ Destination:=xl.Range("$A$1"))
[code]....
Now I have the need to get a current value from a bindingsource in a property of a user control.In a previous thread I had tracked down the "Object variable or With block variable not set" to the return in the Get block of a property. At the time I was only using the Set so I just commented out the offending code until I needed it.
[Code]...
The error does not occur during a system compile, only upon saving the container object of the user control. As I said the Set works correctly, only the Get causes the error.I would like to know what I am missing/misunderstanding and am open to other suggestions of handling retrieving the current value of a bindingsource in a user control.
i had a class called Tag with a structure like:
public class Tag
private _members
public properties
public shared database_methods
end class
this class was tailored for mysql database. i'm currently adding access 2007 support so i split tag into tag and tagdata with structures like:
[Code]...
I'm having trouble tracking down what is wrong and causing the above error. This only occurs when saving the design view in VS 2012. The code builds and runs fine.Full error text:Code generation for property 'CompanyValue' failed. Error was: 'Property accessor 'CompanyValue' on object 'ContactViewUC1' threw the following exception: 'Object variable or With block variable not set."
CompanyValue definition in ContactViewUC:
Public Property CompanyValue
Get
[code].....
Been getting this error with my program. Using framework 2.0
[Code]...
I'm trying to enter automatically todays date in a number of records in the Table 'Applications' into the field 'Date_refund_request'.
However it is giving me the error 'object variable or withblock variable not set' in the line "Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)".
The code is as follows:
Private Sub Command16_Click()
On Error GoTo Err_Command16_Click
Dim db As DAO.Database
[Code].....
I am trying to use this block of code to save attachemnts from Outlook into a folder on my harddrive.
VB
Imports Microsoft.Office.Interop
''' <summary>
[code].....
In the Session_Start of the Global.asax i have
Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs)
Session("login") = False
[code]....
Why i am getting error the error Object reference not set to an instance of an object. at line
If Current.Session("login") Is Nothing Then
while checking for the login state as follows?
If GetLogin = False Then
'Do something
End if
I mean i have already created the instance on the Session_Start... Haven't i?
I have a variable as a single. what is the value of second byte of my variable.or what is the value of third byte of my variable value in memory.?in c language we use at like this *(char(&x)+1)which method do the same thing in vb.net
View 1 RepliesI want to reading in a excel file and extract the sCodenumber sDescription ans the sStatus and store them in a array : StatusComposeArray(5200) As MyCompose. After this I need this array for comparing outside this class. But as can you see the array is defined inside the sub: ReadingIn_ExcelFilesCompose [Code]
View 2 RepliesI'm writing in ASP.NET 4 / VB.NET. I am querying an MSSQL database and sometimes have records come back with no results...so I enclosed the call I was making upon the results in an If..Else clause to set a default value if the database comes back with no results...but now I am getting this "Object variable or With block variable not set error". Here is the relevant code:
Dim clcfirst
Dim rhcfirst
Dim clcdate As Date
Code].....
I am populating combo box from database. In debug i can see that the combo box has been populated . here is the code
[Code]...
dim myCollection as new Specialized.StringCollection
dim myFoundThings as new ArrayList
dim index as Integer
dim newResultMemberName as String
[code]....
This is part of some code that will run without user interaction once it's spinning away, and I need to create a unique object from some items found in a StringCollection, naming the objects using information found in the strings stored in that StringCollection.
I'm a newbie in VB.NET, I am trying to directly set the bits of a single variable. For example - dim afloat as single afloat = &h0000000c afloat will then be set to to '12'. However, I wish to actually set the bits of afloat to &h0000000c, which will give a different value.
View 1 Replieshow to store multiple variables in a single one to be stored in string?I have some 5 linq variables which am trying to store in a single string...Can you tell me how should i do so?
View 3 RepliesSince I like to use the ReadAllBytes and WriteAllBytes methods to save my variables to disk, I have had no troubles thus far with Integers.It has been easy to convert a short integer into a string of two bytes to save them using WriteAllBytes as following example:-
ReDimxji(0 To 601)
For I% = 0 To 300
J% = hbs(I%)
[code].....
But now I want to store some Single variables using WriteAllBytes, so I need to convert my single variables to a string of four bytes for each.
Limited to using v2.0 of .Net framework (we use VB.net) due to environmental constraints on our servers.I've got an ASP.net webpage which pulls data from a webservice that performs checks on user accounts in active directory. Operators can check multiple accounts at one time using the web interface. The webservice returns a list(of AccountCheck) objects which themselves contain single properties like username, email address, and List(of AccountError) objects which contain multiple properties.[code]What I want to do is using some kind of repeater, create multiple panels or divs which contain labels showing the username, email etc, and a gridview which has the accounterror list bound to it to show all the errors. The users could be checking 2, 5, 7 accounts at once, and is dynamic.
View 2 Replies