IT and business subjects
28-May-1111 Leave a comment
Error: on opening Project > Settings
“An error occurred while reading the app.config file. The file might be corrupted or contain invalid XML”
However all functionality works
Occurs when using
<connectionStrings configSource=“SharedApp.config“></connectionStrings>
Solution: Unknown
28-May-1111 Leave a comment
Error:
Test method TestProjectBusiness.dsBusinessHelperTest.FillAdviceNoteTest threw exception:
System.Configuration.ConfigurationErrorsException: Unable to open configSource file ‘SharedApp.config’. (…Visual Studio 2010\Projects\…\TestResults\…\Out\TestProject.DLL.config line 8)
Quote
“If you edit the test run configuration (by double clicking the .testrunconfig file that gets put into the ‘Solution Items’ solution folder when you add a new unit test), you get a test run configuration dialog. There’s a section there called ‘Deployment’ where you can specifiy files or whole folders from anywhere in the solution that can be copied out with the compiled assemblies at run time to the correct folder.
In this way, I can now actually just define most of my configuration in one set of external .config files and have them automatically copied out at the run of each test.”
My Notes:
This works. You may have to close and re-open the test run – test list editor .vsmdi for the appropriate test-settings to take affect.
25-May-1111 Leave a comment
Visual Studio when opening a solution.
“One or more projects were not loaded correctly”
“Some of the properties associated with the solution could not be read”
Following did not work really, but does discuss the corrupt solution file, which may have a different number of projects to those attached to this solution.
http://blogs.msdn.com/b/rjohri/archive/2010/03/11/some-of-the-properties-associated-with-the-solution-could-not-be-read.aspx
Alternative is to create a new solution and add the projects to it.
Also am finding that Windows 7 machine, moving to XP machine, is making XP machine files read-only. This may be part of the problem.
24-Apr-1111 Leave a comment
Error message
Deleted row information cannot be accessed through the row.
This may occur when using Lambda functions and in other scenarios as well.
Problem
Dim dtTotal = dsBusiness1.InvoiceDetail.Where(Function(r1) r1.InvoiceNo = cInvoice.InvoiceNo AndAlso r1.RowState <> DataRowState.Deleted)
Solution 1
Dim dtTotal = dsBusiness1.InvoiceDetail.Where(Function(r1) r1.RowState <> DataRowState.Deleted AndAlso r1.InvoiceNo = cInvoice.InvoiceNo)
Solution 2
Use AcceptChanges on datatable to force deletions to clear
Try
Me.MyBindingSource.RemoveCurrent()
Me.MyBindingSource.EndEdit()
Me.ds1.MyTable.AcceptChanges()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
24-Apr-1111 Leave a comment
See http://support.microsoft.com/kb/932491
I got this when i was repeatedly updating totals in databound text boxes from Detail rows into the Header table on every move or listchanged. Then bindingsource.addnew, then fill in data, then try and save giving error:- Datatable internal index is corrupted ‘5’
If e.ListChangedType <> System.ComponentModel.ListChangedType.Reset Then
GetSumFromDetail()
End If
04-Apr-1111 Leave a comment
If get error:
“Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding”
Setting the connection string timeout does not work.
Following links led me to my own visual basic translation. I found i had to add the check for the commandCollection Is Nothing
http://www.velocityreviews.com/forums/t123478-how-to-set-commandtimeout-for-getdata-method-of-tableadapter-asp-net-2-0-a.html
http://www.pcreview.co.uk/forums/tableadapter-and-commandtimeout-t2354775.html
Because the DatasetName.Designer.vb is a partial class, it is possible to create a second partial class which will not be overwritten on changes to the dataset. Remember to use
Namespace xxxTableAdapters
Partial Public Class xxxTableAdapter
Public WriteOnly Property SetSelectCommandTimeout() As Integer
Set(ByVal value As Integer)
If Me._commandCollection Is Nothing Then
Me.InitCommandCollection()
End If
Me.CommandCollection(0).CommandTimeout = value
‘For Each cmd In Me._commandCollection ‘To do all
‘ cmd.CommandTimeout = value
‘Next
End Set
End Property
End Class
End Namespace
25-Feb-1111 Leave a comment
SOLVED
Try adding the namespace, so:
My.Settings.conAName
becomes
[Namespace].Settings.conAName
24-Feb-1111 Leave a comment
Warning : “Found conflicts between different versions of the same dependent assembly”
Not enough information
The verbosity of builds may be changed in Visual Studio > Tools > Options > Projects and Solutions > Build and Run > MSBuild Project output verbosity. May need to go to at least detailed. Then use the output window to get more information.
The verbosity may also be changed in the VS-TFS build.
Then search in the Output for “conflict”, and underneath it states:
“References which depend on “… new version
“References which depend on “… old version
Make them match.
Optionally check-in the file containing the app.config.
If you double click on the warning then you may get a message:
“One or more dependent assemblies have version conflicts.
Do you want to fix these conflicts by adding binding redirect records in the app.config file?”
If you click OK, then use source code control to compare the app.config you will get a change in the newVersion setting
<runtime>
<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>
<dependentAssembly>
<assemblyIdentity name=”EntityFramework” publicKeyToken=”B77A5C561934E089″ culture=”neutral” />
<bindingRedirect oldVersion=”0.0.0.0-4.4.0.0″ newVersion=”6.0.0.0″ />
</dependentAssembly>
</assemblyBinding>
</runtime>
VS-TFS Build was reporting this error for a long time, but not indicating precisely which file was causing the problem
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets (1360): Found conflicts between different versions of the same dependent assembly
Generally have found the problem to be on a project which references another project, where both projects use the same references. One may get out of sync with the project being built.
Found the problem difficult to find. Not entirely sure what the problem was:
The build server had a copy of version 9 of Microsoft.VisualBasic.PowerPacks.Vs in c:\Program Files\Common Files\Microsoft Shared\…
instead of version 10.0 listed in some projects.
I checked that version 10 was installed on the build server, then removed the version 9 from this pc.
Could have perhaps considered making the PowerPack reference copy local.
Also try working out any references listed in the problem project which are also used by referenced projects and include a reference to the problem project. I have found that where Visual Studio builds projects without the referenced project references, MSBuild seems to need them in the target project as well. This was not in fact the case in my resolution here.
Example solved 15-Mar-2011 was System.Windows.Forms.DataVisualization was version 3.5.0.0 in a user control. Upgraded all to 4.0.0.0.
09-Feb-1111 Leave a comment
How do I … work with Guid in ADO.Net?
( in this case to support SQL Server replication using dataset )
26-Dec-2011
Hypothesis: That DataSet could act unaware of replication column (do not import it on datatable creation) (or delete it after). Then use default in SQL Server (newsequentialid())
Experiment: Worked out of the box – straight away
During creation of SQL Replication, SQL Server will add a rowGuid column which is a uniqueidentifier and places a default of (newsequentialid()) onto this column
Insert statements for replication must include all columns, except the rowGuid column.
ERROR
However if you then add a new row to this table in ADO.Net then program will give error message ‘Column rowGuid does not allow nulls’
SOLUTION
[MyDataTable].rowguidColumn.DefaultValue = Guid.NewGuid
EXPLANATION
SQL will have inserted a Unique index on rowGuid. However when the table is dropped onto the dataset the unique key is not there. Therefore although the above default set once will give each new row the same Guid, the ADO.net sees no errors. Because the insert statement does not insert the Guid, SQL does, then ADO.Net immediately returns the correct newly applied Guid from the database. This is because the Dataset insert statement also has a SELECT statement on it to get table updates immediately after the INSERT.
Updating ERROR
Updating columns with the rowguidcol property is not allowed.
The transaction ended in the trigger. The batch has been aborted.
Removed the rowguid column from the dataset update sql and it worked. Found no online instruction for this in short search.
07-Feb-1111 Leave a comment
If unit tests are testing against the database using Integrated Security then when these automated tests are put onto the build machine authentication may fail.
SOLUTION. Create a SQL login for a machine which is possible.
CREATE LOGIN [MyDomain\MyComputer$] FROM WINDOWS;
http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/315b5780-c131-4867-88b9-ebac82e68d77
Stephen Shakespeare 