I have tried several versions of this with no luck. The casting of the worksheet works as my data is entered in other parts, but I have a section where I need to add data 1 column right of the cell containing the 'str(0)' value. Most of these parameters are optional. I have even tried the System.Reflection.Missing object.
[Code]...
following error message:
Method not found: Void Excel.Range.set_Value(System.Object,System.Object)
I am getting following error whenever I want to use IIf function inside entity framework query.
LINQ to Entities does not recognize the method 'System.Object IIf(Boolean, System.Object, System.Object)' method, and this method cannot be translated into a store expression.
I have had several occasions recently to access a specific class several times over a relatively small time frame.So I've been storing the value of the class in Session and trying to access it on page load, if it's not available creating a new instance and storing that in session.
So instead of constantly replicating the same code for different classes on different pages I'm trying to create an extension method to do this for me.
[Code]...
I'm stuck on what to do when I make my new instance of my class (it would have to have a New() sub)
I'm not sure where to go from here... or even if this is the best way to do it.
What do I need to convert?
Dim CEESearchByAppNo = From CEEsearch In dbCEE.tblScanneds _
Where CEEsearch.AppNo = iAppNo
[code].....
I am loading an assembly dynamically and invoking a static method from it. The problem arises when the method uses a reference which is not trivial (e.g. mscorlib or System.Core) - I get System.MissingMethodException. I have tried going through the references assemblies of the loaded assembly and manually loading them all, thus forcing them to be loaded onto the AppDomain. I have checked CurrentDomain.GetAssemblies, the assemblies are loaded.
View 1 RepliesOur company has an app that load their components by System.Reflection.Load (By the way, an awesome technique )But, we start to monitorate the application and detect a extrange grow up of memory (actually when our application still all day on air, their allocate memory on task manager is 200 MB plus memory) And all of our components (60 plus DLLs) is load by this technique.My doubt is how to deallocate this assemblies or how the best way to deallocate any assemblies loaded by the System.Reflection.Assemblie.Load method?
View 10 Replies#1 is C# Class Library, where I have my EF model defined (3.5 sp1) and some public methods.#2 is a VB winforms app.In the winforms app, I have referenced the C# library and added the connection string for the EF model. The problem I am having is that I have a form where the user selected a .txt file to import. On the VB side, I create a byte() from the file, then pass it to a public method cleverly called Process. In Process(), everything runs smoothly until I instantiate the EF model.
using (WorkersCompImportEntities context = new WorkersCompImportEntities()) { ....
Where I receive this error:
Could not load file or assembly 'System.Drawing, Version=1.0.3300.0,
[code]....
I searched on the forum / Internet for the solution how a PropetryInfo object (of a Public property) can reveal if it has a Private Protected Setter ... it was all in vain .... all help I found was about how to "Set" value of a public property having a Private Setter.I would like to know if I have a PropertyInfo object of a public property, how would I know if its Setter is Non Public?
I tried, in a exception handling block, where I did a GetValue of the PropertyInfo object and then called SetValue by setting the same value back... but to my surprise it worked well and didn error out.
[Code]...
I decided to to convert my excel macro in a exe file using visual studio 2010. In excel macro method find is present like this:
[Code]...
This is driving me crazy. I keep getting an exception with the below code trying to usethe Find method. he error is "Unable to cast COM object of type Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because theQueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))".I have confirmed LastRow = 845
Imports System.IO
Imports Excel = Microsoft.Office.Interop.Excel
' open a read-only version of the data file
[code].....
Basically, I've got this plugin-based application I've used all the time in VS2008 flawlessly. In my current project (VS2010 by the way) I wrote a plugin for the application and whenever I try to use an instance of a particular class (in an external dll) from my plugin, I get an error.
I tried watching the instance and I got the message:
"Cannot find the method on the object instance."
in the watch window. This has never happened before! I also found that some of the extension methods in the plugin does not work.
I want to search particular item in Binding Source for which i use BindingSource.Find() method, but it throws an exception "This operation requires an IBindingList". My binding source is bind to a .net class object.. I searched over the internet, but could not find the clear solution to achieve this task. The sample class code is given below:
Imports System.ComponentModel
Public Class Department
Private _code As Long
[Code].....
Well, I've searched numerous threads and I'm stumped. Though my VB.net experience is newb status.I'm interacting with Excel Workbooks/worksheets with:
Imports Excel = Microsoft.Office.Interop.Excel
Now I'm fairly adept with getting data from the excel sheet with no problem.But each and every time I quit my widows form, or execute a new command_button click to repeat an operation, in the task manager, excel.exe then opens up a new instance.Releasing the the Excel COM object seems to offer a bit of head scratching.I realize that you can get your form to activate and retrieve data from whatever spreadsheet has been directed to be opened, but I can't seem to put it back and close it correctly.I have read about the Marshal. release object methods and garbage collection with no luck so far.Do I need to import another liberary that completes this operation? I would asssume this would be taken care of as apart of the:
Imports Excel = Microsoft.Office.Interop.Excel
close excel instances opened up by my windows form? Somethig like this:
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
[code]....
(so that it is no longer looked at as "read only" when the spread sheet is opened up from directly from excel)As A minor work around, I've teminated it from the task Bar with proc.kill() but this does not help because my ultimate goal is to just simply realease the excel sheet when my windows form is finished getting its data.This following code does not seem to work.
releaseObject(xlApp)
releaseObject(xlWorkBook)
releaseObject(xlWorkSheet)
Can I make an Extension method for all the subclasses of System.Object (everything)?
Example:
<Extension>
Public Function MyExtension(value As Object) As Object
Return value
End Function
The above functions won't work for object instance:UPDATE The problem seems to occur only in VB, where members of object are looked-up by reflection (late-bound).UPDATE AFTER ANSWERED.FYI, as vb has an advantage that C# lacks that is, members of imported Modules are imported to the global scope so you can still use this functions without their wrapper:Dim myObj2 = MyExtension(myObj1)
I have an interface ITest with a method GetResult(). I have a class Test which implements ITest and thereby defines private method GetResult().
Next I create an instance of Test in a different class. The code is as below:
Module NewClass
Public Sub New()
Dim i As ITest = New Test()
[Code]....
I am migrating existing code from VB 6 to VB.NET and hence I'm not supposed to change the access modifier of GetResult. Leaving it Private will throw InvalidCastException Unable to cast object of type 'System.Object' to type 'ITest'
Object type variable o is used in many places and hence I don't want to change that. And yes, Test implements ITest.GetMember with a different name.
When I execute the code below I receive the error message: 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.It seems to be occurring on the line For Each row2 in PCstudent.
[Code]...
I know it's a stupid question but I cannot find info about it.
Public Function TestFunc() As String
Dim lMapper = cRouter.StaticPortMappingCollection
Dim lMappedPort As NATUPNPLib.IStaticPortMapping
Dim Test As String
[Code]...
How to get this value? By my way I get *System.__ComObject*
I am working on a card game, and i get this werid error:
A first chance exception of type 'System.Reflection.TargetParameterCountException' occurred in System.Windows.Forms.dll
The code that is cousing this error is:
Private Delegate Sub ShowcardDelegate(ByVal test As String, ByVal objtest As Object, ByVal value As Boolean)
Private Sub Showcard(ByVal test As String, ByVal objtest As Object, ByVal value As Boolean)
If objtest.InvokeRequired Then
[code].....
I've created a MyFunc extension (in Module Extensions) for all the base types as well as generic arrays, ICollection(Of T) and Dictionary(Of String,T):
Function MyFunc(Of T)(a() As T) As String
Function MyFunc(Of T)(collection As ICollection(Of T)) As String
Function MyFunc(Of T)(dict As Dictionary(Of String,T)) As String
[code].....
I'm trying to make this code with reflection since I want it to manage Technician and other types too.
[Code]....
I am getting some wierd errors when using the ReportViewer control in Visual Studio 2008. When I try to access the LocalReport property, it displays with this error: "Cannot find the method on the object instance.". Also, I am getting invalid cast errors saying I cannot cast from Microsoft.Reporting.Winforms.ReportViewer to Microsoft.Reporting.Winforms.ReportViewer. I am getting this using either CType or DirectCast. This is really frustrating as I can find almost no documentation on this error.
View 1 RepliesI'm making a little program in where i'm trying to invoke a method from a class dynamically with so called Reflection.The class I'm trying to call is called ContactList and i try to invoke the method in this class called count. The assembly itself is called Contact.ExeNow I have the following code:
Public Function InvokeContacts() As Integer
Dim ContactsAssembly As Assembly = Assembly.LoadFrom("Contacts.exe")
Dim Mycontactlist As Type = ContactsAssembly.GetType("ContactList")
[code]....
I'm designing a .NET-Type at runtime by using the Reflection.Emit-Namespace. Currently, I'm about to generate a method which invokes an already existing method in the generating class:
[Code]...
I'm wondering if there's a way to use Reflection to inspect properties of a COM object? GetType() doesn't want to return the actual type.
View 3 RepliesI am currently using reflection to retrieve all properties of a class. I return a collection of PropertyInfo objects and all is working fine.
My problem is, I want to check if a property has been defined in a base class implementation and is therefore inherited in the current class.
Im using system.reflection to inject a managed (.net) file directly into memory.This injection works with other managed files, but this file has data in the EOF and it wont run without that data.
View 1 RepliesI know how to get the properties using reflection but how would you get the function name and type of a property:
For Example: Combobox.Items.Add
I would like to get the info. for "Add" with reflection. Is this possible in .Net?
I am trying to create an object browser similar to what VS2010 uses for the quick watch window. I can use reflection to iterate through the properties and display their names and values until I get to the point in an object where the property is an object of my own creation and not a system type. I can't seem to find the correct approach to be able to iterate the properties of these "sub objects".
Below is the just of what I am trying to do
Public class myClass
property myprop a string
[code].....
I am trying to determine every single reference inside a dll with System.Reflection. However, GetReferencedAssemblies only lists the ones in the "References" (visible in solution explorer).
I would like to determine references from within the code itself, such as an imports statement. Even things like if/then statements, try/catch, absolutely everything.
Is this possible to do using System.Reflection? If so, how?
I would definitely prefer to do this without p/invoke.