All TableAdapters managed by a TableAdapterManager must use the same connection string

All TableAdapters managed by a TableAdapterManager must use the same connection string

http://social.msdn.microsoft.com/Forums/en/adodotnetdataset/thread/f172a9f6-e59a-49b5-818e-bd86f5a3bfa2

Can happen because one connection string has Persist Security Info=True and one does not
Make sure each connection string is the same.

Advertisements

Cannot bind to the property or column .. on the datasource.

VB.Net Window Forms databinding

Cannot bind to the property or column .. on the datasource.
Parameter name: dataMember

  1. Check to see if you have used the same binding source for two or more combo boxes.
  2. or alternatively because dataMember is not strongly typed, possible that the name of a field has changed in the data set, but not in the form

Setup and Deployment Project

Project 1 requires a setup project
Add New Project > Other Project Types > Setup and Deployment > Visual Studio Installer > Setup Project

See File System Editor > Application Folder > Properties for Default Location which will start as [ProgramFilesFolder][Manufacturer]\[ProductName]

The Manufacturer is set on Setup project properties. Probably change this from Microsoft. Many other properties here also.

Next problem was :

“error reading from file … verify that the file exists and that you can access it”

Following resolved this:

http://devsac.blogspot.com/2009/02/error-reading-from-file-msi-verify-that.html

This says add permission to System for the folder with the msi file in it.

Add an assembly to the GAC

> File System on Target Machine > Right-click Add Special Folder > Global Assembly Cache Folder > Browse and add assembly here. In this case EntityFramework.dll version 4.1.0.0

This worked and program then ran on target machine. However it did not appear in the C:\Windows\Assembly as I may have expected. I guess the assembly is in the file system though. To Register it I am going to try > Select assembly > Properties > Register > vsdraCOM

Distrbuting Prerequistes

> Select Setup Project > Right-click Properties > Prerequisites

‘Assembly.Namespace(s).ClassName.Private Sub MethodName’ is not accessible in this context because it is ‘Private’

 If when coding a new test you get the following error:

‘Assembly.Namespace(s).ClassName.Private Sub MethodName’ is not accessible in this context because it is ‘Private’

  • Go to Method Name for which you wish to create test
  • Create a private accessor
  • Go to test method you are creating
  • Change the type of the object you are creating to ..ClassName_Accessor
  • You should now be OK. May need to change some to ..ClassName_Accessory and not others

Good when you know how

Parent and Child new row on windows forms details

Problem is that
Me.ParentBindingSource.AddNew
Me.ChildBindingSource.AddNew

then when saving:
Me.ParentBindingSource.EndEdit
will destroy child row.

My workaround is:
Store a variable stating is NewRow and/or child row data IsMissing
Then on SaveData use:
If NewRow OrElse IsChildRowMissing Then
  StoreData
End If
Me.ParentBindingSource.EndEdit
If NewRow OrElse IsChildRowMissing Then
  Using taP as New dsTableAdapters.ParentTableAdapter
     taP.Update(ds)
  End Using
  DisplayStoredData – which includes re-adding child row
End If
Continue with normal save

This link describes problem but is not much help to solution:
http://www.vbdotnetforums.com/database-general-discussion/13058-calling-endedit-causes-datarelations-fail.html

ISP for companies

A leased line is a service contract between a provider and a customer, whereby the provider agrees to deliver a symmetric telecommunications line connecting two or more locations in exchange for a monthly rent (hence the term lease). It is sometimes known as a ‘Private Circuit’ or ‘Data Line’ in the UK
http://en.wikipedia.org/wiki/Leased_line#Leased_line_alternatives

Leased lines are more expensive than alternative connectivity services including (ADSL, SDSL, etc.) because they are reserved exclusively to the leaseholder. Some internet service providers have therefore developed alternative products that aim to deliver leased-line type services (Carrier Ethernet-based, zero contention, guaranteed availability), with more moderate bandwidth, over the standard UK national broadband network. While a leased line is full-duplex, most leased line alternatives provide only half-duplex or in many cases asymmetrical service.