.net - SetValue/GetValue Versus Directly Accessing Array Via Arguments?
Jun 4, 2012
I have an array which originally was a Variant array in VB6. Example code in VB6:
ListBoxDrawings.List(X1, Y1) = myArray(X2, Y2)
myArray(A, B) = ListBoxDrawings.List(I, C)
After running it through ArtinSoft's VBUC, its values are handled using GetValue & SetValue.Example code in VB.NET: (ignore conversion to ListView)
ListViewDrawings.Items(X1).SubItems(Y1).Text = CStr(myArray.GetValue(X2, Y2))
myArray.SetValue(ListViewDrawings.Items(I).SubItems(C).Text, A, B)
Since VB.NET doesn't do Variants, I figured out that the array should be typed as a 2D String Array. It seems like there's no reason to use GetValue/SetValue, as the former returns an Object and the latter takes one. This means that I'd have to cast the returned object as a String (Cstr) if I wanted to assign it to a variable, which seems like a pointless extra step that might introduce errors. Also, since the method has lots of overloads, the code might not be as clear. Is there any advantage to using SetValue / GetValue, or should I just consider that an artifact of VBUC converting a Variant, and access the array directly like the original code did?
VB.NET without Get/Set methods:
ListViewDrawings.Items(X1).SubItems(Y1).Text = myArray(X2, Y2)
myArray(A, B) = ListViewDrawings.Items(I).SubItems(C).Text
View 1 Replies
ADVERTISEMENT
Oct 23, 2009
I've been tasked with redeveloping a tool that accesses mailboxes in Exchange, extracts the new emails (and their metadata) and then saves the info in DB. Even a brief perusal of the code shows that it could use some serious re-writing (no use of DirectoryServices for example).
However, from what I can make out the code loads the mailbox being accessed into Outlook and iterates through the mails. Is there a way to access the emails directly? I should point out that, unfortunately, we do not have access to the Exchange servers. They are managed by another department.
View 1 Replies
Jun 23, 2009
Is an ArrayList the same thing as a Structure (i.e. 'array of records')? If they're not the same think, what't the difference?
View 3 Replies
Oct 18, 2011
i have used in vba 3 dimensional jagged arrays where i had up to 10000 rows. i am now transferring this to vb.net and learnt that it would be better to work with lists. the dimensions are such as (30, 10000, 30). how would i structure this by using lists?
View 8 Replies
Oct 7, 2009
Can I know which is better when retrieving data?
View 3 Replies
Mar 22, 2011
I am interested in the pros and cons of data tables and arrays in VB 2010. I programmed decades ago in FORTRAN and used arrays extensively.However, I frequently see data tables in code snippets and don't know when they should be used in lieu of an array.
View 4 Replies
Apr 29, 2012
I am trying to download yahoo's csv files from the web and then reading and storing the data into an array or database (for plotting).So far this is what I have:
Dim txtRemoteFile As String = "http://ichart.finance.yahoo.com/table.csv?s=" & sStock & "&d=11&e=30&f=2009&g=d&a=10&b=18&c=1999&ignore=.csv"
Dim txtLocalFile = "C:UsersXXXDocumentsvisual studio 2010ProjectsWindowsApplication2WindowsApplication2inDebug" & sStock & ".csv"
Me.Cursor = Cursors.WaitCursor
[code]...
So basically, i'm downloading the csv to the local directory, and THEN reading it, and then storing it into an array, and outputting the data into a textbox in my VB form. want to do, is to download that URL to a database or array, where I can plot it in my VB from.So:
1) How to download directly to database or array?
2) Which one is better? to download to database or array for plotting?
3) how to plot it
View 14 Replies
Mar 11, 2010
I have been working on a number of card games. Important, of course, is shuffling the deck.I have come up with a few different ways to do this. Currently I do not shuffle, but to deal a card, I lay out the deck in order, selecting a random number between 1 and the number of cards remaining and selecting that card. I then remove that card from the deck so that another card can be picked.There are two main ways to do this, and I am trying to figure out which one is optimal.The first is to have an array of cards. When one card is dealt, a new array is formed with that card missing. I kind of like keeping the array size exactly the size of the deck, but perhaps this is not efficient. So, the first array has length n and the new array after the card is dealt has length n-1. VB.Net makes it simple to change array sizes around like this.
View 1 Replies
Aug 23, 2005
An argument exception is thrown when attempting to use PropertyInfo.SetValue to set the value of a property in my business objects.The argument is thrown because of wrong data type, even though a valid cast could be made.Is there a way to dynamically cast the object type into the underlying PropertyType of the PropertyInfo object without having to test the FullName property explicitly as show below?
Select Case prop.PropertyType.FullName
Case "System.String"
prop.SetValue(obj, tbx.Text, Nothing)
View 3 Replies
May 18, 2012
I'm working on setting up a large set of stored procedures using SQL CLR. I'm currently in debugging mode. I'm trying to write a data set back to the client using SqlPipe.
[Code]...
View 1 Replies
Jun 30, 2010
how to assign a 1-dimensional array value I get from a function directly into an element in a 2-dimensional array. An example would be
Dim Results(7)() as DoubleResults(0) = myFunction() ' returns an array with 5 doubles What is the correct syntax for this, if any? I'm still having a bit of difficulty switching over from Python arrays, which work a lot better, it seems.
View 5 Replies
Aug 31, 2009
Is it possible to get the arguments from a sub or function in vb2005 as an array?
View 4 Replies
Jan 16, 2009
just want to know what is the difference between these date values?Once some one told me that its difference is server date and client date but not sure which one he meant.Below is 3 type of date currently I'm using and don't know what is the difference between them.
DateTime.Now is from System.DateTime.Now
Now is from Microsoft.VisualBasic.DateAndTime
Today.date is also from System.DateTime
View 4 Replies
Jun 19, 2011
I was planning on using very similar code to the following to export to excel quickly[url]...
However, the data that I'm exporting is rather large and I find it unnecessary to grab a dataset from the sproc, convert it to a multidimensional array of objects and then export to Excel. There are two main reasons this is unnecessary. 1) It takes time to transfer that data from the dataset to the array. 2) There are then two instances of the data, one in the dataset and one in the array. Therefore, I would rather directly insert the sproc results into the array of objects and bypass the dataset altogether. I can't do this unless I know how many rows I'm getting back from the sproc in order to declare the array's size beforehand. [code]...
View 8 Replies
Mar 1, 2010
Any some simple examples of how arrays can be put in a Class Module? The examples should show how the array is used and accessed in a form.
View 3 Replies
May 14, 2010
I/we (my class) created a usercontrol that included a picturebox and a timer. We declared the public variable to access the timer enabled property. Placing the user control onto a Form we are able to enable the timer. However, when we went to declare an array for the control we could not access the properties... We successfully declared control arrays using base class control...
View 11 Replies
Jan 7, 2012
I have a structure which includes this...
Structure MasterStruct
<VBFixedArray(98)>
End Structure
When I create the code to initialize the Sections array like this...
Dim MasterX as MasterStruct
Dim Temp as Integer
For Temp = 0 To 98
MasterX.Sections(Temp) = 0
Next
VS 2008 tells me that MasterX.Sections "is not an array or method, and cannot have an argument list."
View 6 Replies
Aug 23, 2009
I have my app that does some complicated function and adds some values to an array, but then later I need to access the strings, I have the index number but not the string so how can I find that string again?
View 2 Replies
Jul 3, 2010
I'm trying to write some of my own linear algebra methods, and I'd like them to work independent of the number of dimensions of the array. However, there doesn't seem to be any generic method, that I can see, for looking up a particular element in an array of arbitrary size. I mean I could write code to find the rank and then use (), (,), (,,), (,,,), etc, but that seems rather cumbersome.
View 4 Replies
Sep 4, 2009
I am using vb.net language I have a dropdownlist, which is filled by below pattern
"Smith,James" so first one is surname and second after "," is firstname
I have two textboxes for surname and firstname. Now I want to fill the textbox when dropdownlist is changed.I mean when user changes the dropdownlist the selected text in dropdown will be filled in related textboxes.so my result will be like this
surname.text = "Smith"
firstname.text = "James"
View 2 Replies
Aug 9, 2011
I have the following function,
Dim results() As Object = Me.Invoke("webdirect", New Object() {Company, LocationCode, CustomerNumber, OrderNumber, OrderRef, OrderDate, WebLines})
o_Company = CType(results(1),System.Nullable(Of Integer))
o_LocationCode = CType(results(2),String)
o_CustomerNumber = CType(results(3),String)
[Code] .....
So the return type of this function is a string, but I would like to get it back to its original form so I can access the individual sections i.e. o_LocationCode,o_CustomerNumber, etc how can I do that ?
Entire functions looks like this
Public Function webdirect(<System.Xml.Serialization.XmlElementAttribute(IsNullable:=true)> ByVal Company As System.Nullable(Of Integer), <System.Xml.Serialization.XmlElementAttribute(IsNullable:=true)> ByVal LocationCode As String, <System.Xml.Serialization.XmlElementAttribute(IsNullable:=true)> ByVal CustomerNumber As String,
[Code] .....
Called like this
Dim returnArray As String
returnArray = client.webdirect(10, "123", "123", "123", "147", "2011-11-1", webLinesArray, 10, "", "", "", "", "", webRespArray)
No errors on run time but the string seems to be just blank, thats why i was wondering how I convert the string back to the array so I can access the individual elements.
View 1 Replies
May 9, 2012
i want when you click on that item so its shows in a label for etc
Imports Microsoft.Win32
Public Class Form1
Dim regBaseKey As RegistryKey = Registry.LocalMachine
[code]....
View 4 Replies
Apr 19, 2012
I am very New to Vb.net. We are using fortify software for projects when it is going to LIVE. In that process I got some cross-Site Scripting : persistent Data flow issues.
[Code]...
View 1 Replies
Dec 28, 2010
I'm triying to make a function that add a 'where' clause to a query based in a property and a value. This is a very simplefied version of my function.
Private Function simplified(ByVal query As IQueryable(Of T), ByVal PValue As Long, ByVal p As PropertyInfo) As ObjectQuery(Of T)
query = query.Where(Function(c) DirectCast(p.GetValue(c, Nothing), Long) = PValue)
Dim t = query.ToList 'this line is only for testing, and here is the error raise[code].....
The error message is: LINQ to Entities does not recognize the method 'System.Object CompareObjectEqual(System.Object, System.Object, Boolean)' method, and this method cannot be translated into a store expression.Looks like a can't use GetValue inside a linq query.
Private Function simplified2(ByVal query As IQueryable(Of T))
query = From q In query
Where q.GetType.GetProperty("Id").GetValue(q, Nothing).Equals(1)[code]....
View 2 Replies
Mar 15, 2011
I get this - fe80::5dbd:3042:c951:b187%10
Dim host As String = System.Net.Dns.GetHostName()
Dim LocalIP As String = System.Net.Dns.GetHostAddresses(host).GetValue(0).ToString
ListBox1.Items.Add(CStr(LocalIP))
View 2 Replies
Feb 3, 2010
I get this - fe80::5dbd:3042:c951:b187%10
Dim host As String = System.Net.Dns.GetHostName()
Dim LocalIP As String = System.Net.Dns.GetHostAddresses(host).GetValue(0).ToString
ListBox1.Items.Add(CStr(LocalIP))
[code]....
View 2 Replies
Oct 30, 2009
This code is not giving the msgbox value! Is the GetValue method incorrect?
[Code]...
View 6 Replies
Apr 10, 2012
I'm using EF 4.3.1 in VS 2010 (.Net 4.0) to load a number of reference tables from a database in order to bind them to controls in a WinForms app.At form load, I'm pre-fetching the data so that it's stored locally, and I'm creating a dictionary of BindingSource objects that I can use to bind the local data to the controls.The intent is to minimize the impact of the EF's self validation on a cold query in order to load forms faster and improve UI responsiveness.I've written code to create and fetch the BindingSource object for a given DbSet collection as follows:
Private _dictBindings As New Dictionary(Of String, BindingSource)
Private Sub ValidateBinding(Of T As Class)(ByRef DbCollection As DbSet(Of T))
Dim strClassName As String = DbCollection.[GetType]().GetGenericArguments(0).Name
If Not _dictBindings.ContainsKey(strClassName) Then[code].....
However, I'd like to call ValidateBinding on all DbSet collections in the Model on startup, and I'd like to use reflection to iterate through the available collections in the context because we're currently loading 66 tables and could add more later.I've written the following code:
For Each propSet As PropertyInfo In Db.GetType.GetProperties(BindingFlags.Instance Or BindingFlags.Public).Where(Function(P) P.PropertyType.IsGenericType)
ValidateBinding(propSet.GetValue(Db, Nothing))
Next
but it won't work as propSet.GetValue() returns an Object instead of DbSet(of T).I also can't cast the object to a DbSet of the appropriate type, even though I know the type through reflection.I don't have access to the C# Dynamic type,and I know it's a pain to mix generics with reflection, but is there a solution for which I can pass in a reflected DbSet to my functions?Perhaps something using Method.Invoke?
View 1 Replies
Jul 14, 2009
I have a Class MessageIndex which holds an integer. I have a custom DataGridViewComboBoxCell which has a MessageIndex variable. If the MessageIndex is not set, the cell acts as a normal DataGridViewComboBoxCell; if the MessageIndex is set, then the GetValue and SetValue methods of the DataGridViewComboBoxCell are overridden so as to return the value of the object from its DataSource at the index of the integer stored in the MessageIndex.
As far as I can tell from stepping through the code, that actually works fine. The object returned by the GetValue function is fetched from the DataSource, based on the integer stored in the MessageIndex.
The problem is that when the DataGridView is displayed, all of the cells are blank. The values of the cells can then be set using the ComboBox dropdown, which appears to work fine.
But why are the initial selections not being displayed? As I say, as far as I can tell, the correct information is being retrieved by the GetValue function of the DataGridViewComboBoxCells when the form is initially displayed. It's just not ending up on the screen.
View 1 Replies
Mar 14, 2012
I've a simple class like this:
Public Class CalculationParameter{
public Long TariffId{get;set;}
}
In a workflow activity, I've an Assign like this:
(From tariffDetail In db.Context.TariffDetails
Where tariffDetial.TariffId = calculationParameter.TariffId).FirstOrDefault()
Dto is passed to Activity as an Input Argument.It raise following error and I'm wondering how to assign Id.LINQ to Entities does not recognize the method 'Int64
GetValue[Int64](System.Activities.LocationReference)' method, and this method cannot be translated into a store expression.
How can I assign the calculationParameter.TariffId to tariffDetial.TariffId?!
UPDATE:Screen shot attached shows that how I'm trying to assign calculationParameter.TariffId to tariffDetail.TariffId (car.Id = Dto.Id) and the query result should assign to CurrentTrafficDetail object.
View 1 Replies
