I'm having this dataadapter and its select command. In my application I create a reference to the assembly and via fieldinfo and bindingflags I even am able to retrive the command text of that dataadapter but what i need is to retrieve the sqlparametercollection of the following assembly.[code]...
View 7 RepliesI have created several DLL (.NET) libraries that are used in several projects. In these DLL libraries I want to know/retrieve which assembly (EXE) calls/uses the library, so if possible I want to know info like assembly name (EXE), strong name, version number, etc.
NB: Examples may be in C# or VB. I use both languages.
I have a web application running written on ASP .Net.We have a class accessing the back end written in VB .net which has shared functions for DB interactions.The above error comes up when ever two users are in the same page... tying to do the same thing.Couldn't find a reason why this would happen.The scope of the SQL command is limited and parameters are cleared at the end.
View 2 RepliesI keep getting a strange error message when I try to call my stored procedure. Possibly I have a syntax error? Not my store procedure does not return a value. Also the error message is included at the end of this post.
--VB .NET Code
Dim connString As String = ConfigurationManager.ConnectionStrings("EMRConnectionString").ConnectionString
Dim conn As New SqlConnection(connString)
' Create a new sql command, and reference the stored procedure by name
[code]....
I am developing a VB.NET application with SQL Server 2008 and I get the above error when I try to run this ASPX file. What is the cause?
[Code]...
When running setup to install published program, the following message occurs: System Update Required: Unable to install or run the applicaiton. The application requires that asssembly CrystalDecisions.CrystalReports.Engine Version 10.2.3600.0 be install in the Global Assembly Cache (GAC) first. This version is listed in the references of the program and in my mind, be included in build. How do I get by this error?
View 23 RepliesWhen running setup to install published program, the following message occurs: System Update Required: Unable to install or run the applicaiton. The application requires that asssembly CrystalDecisions.CrystalReports.Engine Version 10.2.3600.0 be install in the Global Assembly Cache (GAC) first. This version is listed in the references of the program and in my mind, be included in build. How do I get by this error?
View 2 RepliesI have recently upgraded an VB6 project to vs2008. I was almost finished when the following error occured. Unable to emit assembly: Referenced assembly AxInterop.MSFlexGridLib does not have a strong name Prior to this error appering, I tested my app several times and it was fine. Only after publishing it did the error appear. I have tried all solutions I could find, but nothing helps. I have read [URL]
View 1 RepliesI receive this error as "Assembly Load Error" whenever adding a form or other object that has to be inherited.
"Unable to load assembly. Ensure that the file is a valid .net Framwork assembly"
I am loading an Assembly using Assembly.LoadFrom() as the assemblies are located in a different path from Application Base directory.
Dim oAssembly As Assembly = _
Assembly.LoadFrom("C:\MyFolder\" + ddlXlate.SelectedItem.ToString() + ".dll")
And I consume a Type from that assembly without any problem:
oXML = CType(oAssembly.CreateInstance(sBaseType + ".XlateContainer"), _
XlateBase.XlateContainer)
However, the problem occurs when I try to use a Type from this assembly from within another method like the one below:
oComboBox.DataSource = _
[Enum].GetValues(Type.GetType(sType + "+ItemEnum," + sAssemblyName))
sAssemblyName is the one I loaded using LoadFrom() actually. After it said it cannot find the assembly, I used AssemblyResolve event which solved my problem :Subscribing AssemblyResolve event :
AddHandler AppDomain.CurrentDomain.AssemblyResolve, _
AddressOf MyResolveEventHandler
Event Handler Method:
Private Shared Function MyResolveEventHandler(ByVal sender As Object, _
ByVal args As ResolveEventArgs) As Assembly
Return Assembly.LoadFrom("C:\PSIOBJ\" + args.Name + ".dll")
End Function
And I thought maybe the error occurs because it cannot find a dependent assembly defined in assembly manifest file I loaded using LoadFrom() already but when I checked the args.Name, I saw it was trying to load same assembly and after that it worked without any problem. So basically a type in the loaded assembly cannot be found before the event adding change.
My old code was using AppDomain.CurrentDomain.Load() and Assembly.Load() methods and they were working fine without the AssemblyResolve event. I was able to reach types in dynamically loaded Assembly from every where within the same AppDomain.
LoadFrom() can find dependencies automatically within the same requested assembly path and that couldn't be problem as everything this dll needs was there. So at first it looked like a AppDomain problem to me as it looks like it seems it can reach assemblies from Load context instead of LoadFrom context and I am now using LoadFrom context.But now it seems I should pass oAssembly instance evertwhere to use any type from the loaded assembly?Doesn't it load the assembly where I can reach it everywhere (same AppDomain) using simple Type.GetType(...) method?
I'm wanting to include a system tray icon in my WPF project, and found this resource:[URL]..which looks like it will work beautifully, but it's written for C# and I'm using VB.net for this project. I downloaded his project and built the notifyicon as a DLL, then added as a reference to my project.
It throws up an error: Unable to emit assembly: Referenced assembly 'Hardcodet.Wpf.TaskbarNotification' does not have a strong name So I'm trying to figure out the best way to proceed. Do I need to strong name it, or is there a better way to do this?
I've got an exception when I deployed my application: "the located assembly's manifest does not match the assembly reference" What I remember is changing the project name from the previous source code, does it affect that much?
View 1 RepliesI have written a .net assembly which plugs into to a third party COM application. The .net assembly is COM visible to the third party application. However this .net assembly references other regular assemblies. If I put these assemblies in the GAC the COM visibile assembly sees them without a problem. However for various reasons I do not want to put them into the GAC but I cannot get my COM visible assembly to see the other assemblies when they are in other locations. I have tried putting them in the same directory as the COM visible assembly. I have tried putting them in the same directory as the third party app's exe but neither of these work.
View 5 RepliesI am getting this error, Not sure why it is happening "Error The SqlParameterCollection only accepts non-null SqlParameter type objects, not Int32 objects."I have tried with all sorts of possibilties, now try to enter default data as dummy data,
Using connection As New SqlConnection
connection.ConnectionString = ConfigurationManager.ConnectionStrings("DentalDeviceConnectionString").ConnectionString
connection.Open()[code].....
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using conn As New SqlConnection("Database=Clinic_Management_System;Data Source=.SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|Clinic Management System.mdf")
Dim cmdRecord As SqlCommand
[code]....
When ever I finish simple programs no matter what it is and i click to debug it it comes up"Error while trying to run project:could not load file or assembly"project name" or one of its dependencies.the module was expected to contain an assembly manifest"
View 4 Repliessorry for my English, I don't speek well... I need to compile assembly in memory, that can compile another one. There is a form with one button. Here is a code of the form
Imports System
Imports System.Threading
Imports System.CodeDom
Imports System.CodeDom.Compiler
Imports System.Collections
[Code]...
Since, it's possible for anyone to name an assembly starting with 'System', checking for 'System' is not a satisfactory solution.
Alternatively, if that's not possible, how about checking the modules in an assembly?
I am building a dll-Assemby A which references another Assembly B. Assembly B is strongly named and installed in the GAC of my development computer. An other computer will not have assembly B installed in the GAC.
Question: If i handle strongly named assembly B like a private assembly and copying it into the bin-directory by specifying local copy = true in the properties-window, will the programm run on the other computer?
One of them is giving us trouble in only 1 spot out of the 4 spots we use it at:The trouble spot is a windows form project that uses reflection to dynamically load some DLLs that run long running processes. One of these long running processes is an agent that relies on one of our vender DLLsWe're getting the missing assembly exception at the point where we first enter a function that references the library. I already checked the silly things such as if we had forgotten to move a reference from the old version to the new version, but that's not the case. I also checked the bin directory of the project and the assembly is there.
View 3 RepliesProbably a dumb question, but can you write a unit test project in one language to test against another project in a different language?I'd like to translate one of our VB assemblies into C#, but want to build unit tests to verify the results. I've tried to set a unit test project up to do this, but I can't seem to access the VB code within a unit test... I can't figure out if I'm just missing/doing something stupid, or it really isn't allowed.
View 2 RepliesWhat does [String] mean in VB.NET?
Dim assem As [Assembly] = [Assembly].GetExecutingAssembly()
Dim assem As Assembly = Assembly.GetExecutingAssembly()
Code to add a new row to my datagrid on click of add button. I am not binding my grid to a datasource.I m fetching values from the database through a datatable n then through a lood inserting t values to my datagrid. i m not binding the entire datatable as my datasource for the grid.
View 2 RepliesI have 2 datagrids. One to show Product information and another for Product purchase details entry.Both share the same dataset. The dataset (ds) is filled up with columns from 2 table
ProductMstrTbl : ProductID, ProductName..
ProductDetailsTbl: ProductID, PurchaseDate, Amt, BalanceQty..
[code].....
I'm having a hard time on using Transaction then after that I need to use sqldataadapter. When I tried the code below I'm having an error "ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized." Pointing to this block.[code...]
View 1 RepliesI am using a sql server database and i am storing the time value in the datetime variable. I am developing a booking system application in vb.net. When I want to view already made bookings using datagridview and by implementing dataadapter and dataset...When the table is shown in the datagridview I want custom column names to be shown so tell me that how can i use alias in the query given in datadapter initialization part?
View 1 Repliesim added a dataset inside my project, and inside the dataset i added a DataAdapter with the steps like below:Use SQLStatement --> select A,B from tb_example --> Fill a datatable.And then i bind one of my combobox datasource's display member = Avalue member = BAnd its work properly!After few weeks, im reopen the project and i try to add another new dataadapter in the previous dataset and a new combobox like steps i did before. When i come to the combobox and try to find the datasource in combobox's properties and i cant find the dataadapter i jz added.
View 7 RepliesI am trying to add a parameter to a sqlDataAdapter. I have tried to use parameters.add() but the adapter is not a sqlCommand. Here is some of my code.
Private Sub convertToCSV(ByVal SqlQuery As String)
Dim Dt As New DataTable()
Dim SqlCon As New SqlConnection("Data Source=db;Initial Catalog=productionservicereminder;User Id=id;Password=pass;")
[Code]....
Basically I am trying to do something like this:
Ada.Parameters.Add(New SqlParameter("@pgid", pgid))
This should be a fairly simple one. I am creating a dataset which will contain a description field which I would like to sort by. The reason I want to sort the dataadapter and not in my SQL is that I am already ordering by the results that have a particular value.My SQL looks like this:
SELECT pif_desc, pif_fund, psf_end, (CASE WHEN SUM(pmi_units) IS Null THEN 0 ELSE SUM(pmi_units) END) As fundunits
FROM tbl_mem INNER JOIN tbl_sfunds[code]....
I want to sort the datarows is ds.tables(0) by pif_desc but still have the rows with fundunits > 0 listed first. how I can achieve the correct ordering.
I have been researching all that is related to DataSources, DataReaders, DataAdapters, etc, with an Access 2010 DB bound to a DataGridView.
Everything is fine, just one line fails and is driving me nuts Here is the code:
[Code]...
The line that fails, actually updates my database, but somehow, the update is not performed on the line that belongs to the first row of the grid. What is more, if I change the value manually, the same update method works fine. What is going on here?