Can't Access Collections.Item Property In Sqlserver.dts.runtime With C#
Jun 20, 2012I recently implemented a solution to take an SSIS package and reconfigure the connection strings of the package using VB.net.[code]...
View 1 RepliesI recently implemented a solution to take an SSIS package and reconfigure the connection strings of the package using VB.net.[code]...
View 1 RepliesI am trying to solve an issue in my application where the following exception is occurring: there is already an open datareader associated with this command which must be closed first. I am using TableAdapters, which maintain their own DataReaders, and everything seems to work fine unless I am interacting with one of my background workers.
In my code, I shadow the Item property of my collections so that I can retrieve the actual data from the database if needed. Here is a sample:
[code]...
Now each reference to the Item get property instantiates its own DataAdapter, so I am confused as to how the same DataReader will ever be used in this scenario. Is there something I am missing? All the TableAdapters do in fact use the same connection object, but I wouldn't think that would be a problem
start with I was given a program by a friend that was created in Excel 2003 with the help of Visual Basic Editor. He said he used Visual Basic 2003, which he is not 100% sure about. Anyways he used CurLine in the program and when I try to open it in Excel 2007 and then open the Visual Basic Editor and run the program I get the following error:Run-time error '-2147418113 (8000ffff)':Could not get the CurLine property. Unexpected call to method or property access.
View 2 RepliesIs there a way for a property to access its own name and type at runtime using reflection? I want to access this info without hard coding the name or index of the property in the class.
Simple Example Code:
Private ReadOnly Property MyProperyName() As String
Get
Console.WriteLine((Get Current Property Info).Type.ToString)
Console.WriteLine((Get Current Property Info).Name)
[code]....
I have a Vb project to which an excel file is added as an item. I would like to access the property (Full path property) of this project item through my form class. The code I have tried to use is as follows:
Dim project As EnvDTE.Project
Dim projItems As EnvDTE.ProjectItems
Dim projItem As EnvDTE.ProjectItem
[Code].....
If i wish to put items into a System.Collections.Generic.Dictionary, I can either Add or set the Item.I know if you do Add it helps you check if the key already exists and if not it throws an exception.Now I'm curious, so if I'm adding a ton of items, should I prefer setting Item instead of Add since Add does unnecessary checks that may actually slow things down?
View 3 RepliesHow can I have it so that you can add items to a System.Collections.Specialized.String Collection but only if it is not there already? I have already found the code, but deleted it and cannot remember it. It is something like[code]....
View 9 RepliesI need to be able to tell if a property is of type List(of T)but am currently unable to. if i do
TypeOf (UpdateTo.GetType.GetProperty(node.Name)) Is System.Collections.Generic.List(Of Object)
I get the following error
TypeOf (UpdateTo.GetType.GetProperty(node.Name)) Is
System.Collections.Generic.List(Of Object) Expression of type
'System.Reflection.PropertyInfo' can never be of type[code]......
I am trying to change the image in a picture box using a combobox with item collections 0-8.When I run the program no matter what I choose in the combobox it selects case 0 and willnot change. code below for selected index changed.
Private
Sub ComboBox1_SelectedIndexChanged(ByVal
sender As System.Object,
ByVal e
[code]....
I have a web site that connects to a remote SQLServer, and is running just fine.I have some pretty simple 'batch' type tasks that I want to run (as a Windows application) on a scheduler (I'm more comfortable with VB so I prefer that).
Looks like VB Express won't allow me to access the remote data. Everything seems to be pointing to having to buy VS Professional for $545 (I don't have an original one to upgrade). Is there a more economical VB option?
in what situation will an item in System.Collections.Generic.List not be removed successfully?url...The way they phrase it makes me think that it is possible that a Remove operation on an item found in the List(Of T) could actually fail.
View 4 RepliesI have been developing a VB 2008 application which has been using Access as its database. The app is very far a long with about 30 forms and 45 DataSets I now must change the application to use SQLServer. Unfortunately all of the Table & Attributes names have changed in the new DB. Almost all of the data model has stay the same.
I have a few questions on the conversion.
The ConnectionString is currently pointing to the Access DB. I have entered the new ConnectionString into the Setting tab. What is the best approach to make the change?
I have done some testing to change the Table & Attributes names by using Quick Replace. It seams that sometime when I would do the rename I would lose the TableAdepter on some screens.
What is the best approach to performing the renaming task?
I am calling my packages through a master package and i am using Imports Microsoft.SqlServer.Dts.Runtime but i can't set./use Imports Microsoft.SqlServer.Dts.Runtime.IDTSLogging and the interesting thing is that i can use Dim abc As IDTSLogging but i can't use
CODE:
I don't know why i cant use?
I have a weird question and I honestly hope you understand what is happening here: I design my form (using VB.NET) and put on it a few textboxes, comboboxes and a listview. After the design, I want to adjust the TabIndexes for each control on the form. On the right-hand side of the interface is the property box.
I then select the 'TabIndex' property item and enter a number key (for instance 0) for that selected item. I then select the next textbox control and enter the next number (for instance 1) WITHOUT re-selecting the 'TabIndex' property item. As soon as I select the combobox or listview control, the currently selected property item jumps to 'Items' or 'Collections' and does NOT remain on the 'TabIndex' property item. Why is this happening? Everything worked fine and all of a sudden this starts happening. Should I reset the editor settings or how can I resolve this matter?
I have a listbox with several list items added. I want that as user click on an item, I should be able to show its property. This should change for different items. For example (hypothetical) : Listbox has numbers 1 - 10. Now when I select 1 I should be able to set property - Name, Lastname, Colour, Age.
When I select 2 I should be able to set - Age, Hair Colour (clr shows), Weight, Date. When I select 3 then - City (combo box drop down), Country, Age only. This way value changes for diff items. One way is to put them in property grid and show them. Though this looks nice but adding/removing items in that is not easy. You need to have a class that refer that to prop grid. Do I have to code for each classes for all values in listbox or is there an easier way to manage items in property grid. If you think prop grid is not the right tool for such an activity then can you suggest something else.
I have a simple user control, which is essentially just an AutoCompleteBox with some custom logic.
For a specific instance (a collection of Persons), I want it to look like this:
<sdk:AutoCompleteBox Name="myACB" ItemsSource="{Binding People}" FilterMode="StartsWith" MinimumPrefixLength="2" ValueMemberBinding={Binding LastName}>
[Code].....
I want the DisplayMember property to be the property name to display for whatever kind of custom collection (persons, cars, etc) I have bound to the AutoCompleteBox.
I don't think I can modify the datatemplate programmatically. Is there a way I can do this with binding (relative source)?
I have created multiple dropdown list at runtime and populated with data. I also have added an eventhandler to determine the selected value of the drop down list.
The code is as follows :
Dim tbl As New Table()
tbl.EnableViewState = "true"
[code].....
I wanted to create a custom control with a custom Item-Collection in it.(Similar to the ListView Items, but with other properties)I wrote a Class that holds properties of a single Item data (ClassItemData) and another class that "Inherits System.Collections.ObjectModel.Collection(Of ClassItemData)". The Collection class contains a public event (ItemCollectionChanged) which is raised when "ClearItems", "InsertItem", "RemoveItem" or "SetItem" is called. (I used "Overrides" on all these functions and added the Raise Event to them.) The event is handled in the custom control itself and causes the control to refresh/repaint itself. The collection class contains also "Default Public Overloads ReadOnly Property Item(ByVal index As Int32) As ClassItemData" which returns the Item at the speciefic index.
The control refreshes itself when I place the control on a form and use code like: ControlName.Items.Add("TestItem") Unfortunately the control does not refresh itself when I use: ControlName.Items.Item(0).Visible = False The value of the Item itself has changed after this, but the control does know about the changes and does not refresh itself. If I do a manual repaint/refresh of the control, it looks all fine, but it does not work automatically. Does anyone know, what I have to add, so I can handle an event or something in the control when a property in the ItemData class has changed? How do I recognize changes in existing items and raise an event in the custom event?
I'm having a problem with this code in the highlighted line(*); getting the error in the heading.
Dim htmlarraylist As New List(Of iTextSharp.text.IElement)
htmlarraylist = *HTMLWorker.ParseToList(New StreamReader(tempFile), New StyleSheet())*
[Code].....
Using the following code I get Identifier expected and Property access must assign property or use its value errors:
ViewState["SomeKeyValue"]
What is wrong with this code?
This code snippet was converted from the c# snippet on this link A ChildWindow management service for MVVM applications There are two classes in this snippet first is my confirmessage class
[Code]...
Now this works fine in C# , however in vb,net the line where I add the event handler generates the following error on the message.callback property : Property access must assign to the property or use its value I am tearing out my hair on this I have never used the Action of T delegate before so could i be missing something simeple ? I can provide the c# code as well.
got an ErrorProperty access must assign to the property or use its value.Here i attach the code which have an error.In this program i tried to add data into form . I also create button , textbox. i am using visual studio 2005 and sql 2005. i also have attach the imagece
Private Sub btnregister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnregister.Click
admin1.LoginDataSet.staff(Me.NAMETextBox.Text, Me.TELEPHONEMaskedTextBox.Text,
[code].....
[code]...
What's really the point in using the former?It's hard to use linq if I used the former. I have to convert that to an array first which is difficult because there is no (asarray) function.I think I would change all of my code that's using System.
Collections.Specialized.StringCollection to System.Collections.Generic.List(Of String)
Well in my vb project it has started giving me a really weird error underlining all my msgbox codes for some reason
this is the error Error 83 Property access must assign to the property or use its value. C:UsersAidanDocumentsVisual Studio 2008ProjectsXeX 360 ModzZ B0XXeX 360 ModzZ B0XForm1.vb 56 17 XeX 360 ModzZ B0X
I have a property in a class as below:
Public MustInherit Class AddOn
Public Delegate Sub UpdateProgress(ByVal fractionComplete As Double)
Private privateProgressUpdate As UpdateProgress
Public Property ProgressUpdate() As UpdateProgress
[code]....
I am getting the error that "Property access must assign to the property or use its value" in the above code.
I'm writing a debug dump for my app and need to know which Method or Property caused the error along with a trace of the last few routines.
View 3 RepliesHow to declare property which can be modified in project mode but will be read only in runtime mode?
View 3 RepliesI am relatively new to programming and have managed so far with google and a lot of patience! I am having a problem naming timer contols at runtime. This is what I am trying to achieve.
1. I connect to my dataset and to my first record
2. I create a loop for the recordset
3. I create various objects on a form and name them using the info in the dataset
I also need to create timers and name them using the first field of my dataset. It needs to be dynamic as its database driven. There could be as many as 100 timers at any one point.
[Code]...
I have a form where there's a shape and I'm trying to change the properties of the shape during runtime. For example, you press the Up button and it's supposed to move 30 units up:
[Code]...
A VB5 program I wrote years ago stopped working and is now giving me this error:
Run-time error '380':Invalid property value
I cannot figure out what has changed, since I run that program almost daily. It was working fine, then stopped (without any changes to the program). I suspect I may have uninstalled something it uses, but cannot figure out what.When I open the VB5 IDE, I get an error saying:
'c:program filesdevstudiovbComct232.ocx' could not be loaded--Continue Loading Project?
If I say no, it does not load and I cannot see the source code.If I say yes, it does load and I can see the source code but I get weird compiler errors.