Musings and bugs of a developer

Spring.Net - Could not load type ....

2012-01-19T22:09:00.001Z

Was getting this error with Spring that came down to the fact one Dll was out of date - the Dll was Risk.dll and the config file throwing the error was Risk.xml.config but this was clouded by another config file trying to set the same object also throwing the error.

I think Spring loaded the Risk.dll assembly and stored the bad/old reference e.g. IMyMovedObject as belonging to the old library so other objects which had reference to the same type also threw this error even though their build was up to date.

NHibernate - HQL - No Persister for xxx

2011-11-17T12:01:00.000Z

Was getting strange error ' No Persister for System.String' when doing HQL query using a parameter.

Turned out it was because I was using SetEntity to assign the parameter value instead of SetString

All because of cutting and pasting!

NHibernate - Entity property is an Interface - mapping

2009-10-19T15:25:00.001Z

If you have a class that maps to a table and a property of the class is an association to another table (i.e. 1:M Property) you may get the following error if the property is defined as an interface type:

NHibernate An association from the table XYZ refers to an unmapped class

This occurs because NHibernate will not have a mapping file for the interface type and cannot instantiate it because it is an interface. To fix the problem you need to include in the mapping file the actual class the property represents.

e.g.

IAccount MainAccount;

may map to

<many-to-one name="MainAccount" column="MainAccountID" class="BankingCore.BusinessEntities.Account, BankingCore"/>

where BankingCore.BusinessEntities.Account is the actual class to be instantiated for the property.

Released: Who is to blame visual studio / subversion utility

2009-09-04T14:23:00.001Z

Released free utility application: Who is to blame which allows the user to paste in warnings and errors from Visual Studio then get a report via Subversions Blame program of who edited the line.

Released Crystal Reports user library for BM+ pick-list lookup

2009-09-04T14:21:00.001Z

Today we released for free download a user-library for substituting BM+ pick-list values into Crystal Reports.

The library can be downloaded by following the u2lBMPick link from Fairmort.com/Products

NHibernate HQL Query : could not resolve property

2009-08-24T12:01:00.001Z

If you get

could not resolve property: ID: of

error for a HQL query and you know the property exists and is spelt correctly check that the query parameters are defined correctly.

Had this problem when query text was:

..... TaskStatus:=status ....

The problem is that the colon is the wrong side of the equals, should be

..... TaskStatus=:status ....

Error is easy typo to make but had to spot.

Task Scheduler : XP & Win 2003

2009-02-20T09:41:00.001Z

WIN2003: Ensure Console is not logged in if trying to run task via Remote Console -

Following information taken from MS knowledge base: http://support.microsoft.com/kb/308558

Checking the Task Status

Periodically check the status of scheduled tasks, because sometimes you may not be aware that a scheduled task did not run. Use the Detail view in the Scheduled Task window to see the following information about each task:

Schedule - The schedule for the task.
Next Run Time - The time and date that the task is next scheduled to run.
Last Run Time - The time and date the task was last run.
Status - The current status of the task.
Last Result - Code that indicates the result of the last run.

The Status column has the following status and description information:

Blank - The task is not running, or it ran and was successful.
Running - The task is currently running.
Missed - One or more attempts to run this task was missed.
Could not start - The most recent attempt to start the task did not work.

The Last Result column displays a completion code. You can obtain a full explanation of all Windows completion codes from MSDN, but the common codes for scheduled tasks are:

0x0: The operation completed successfully.
0x1: An incorrect function was called or an unknown function was called.
0xa: The environment is incorrect.

If the result code has the "C0000XXX" format, the task did not complete successfully (the "C" indicates an error condition). The most common "C" error code is "0xC000013A: The application terminated as a result of a CTRL+C".
Also check the following data in the task's properties:

Make sure the check box that turns on the task has a check mark.
Check the path to the program and make sure that it is correct. Also check the program to see if it requires some command-line parameters that are missing.

For a full explanation of Windows completion codes, visit the following Web site:

http://msdn2.microsoft.com/en-us/library/aa364454.aspx (http://msdn2.microsoft.com/en-us/library/aa364454.aspx)

Back to the top

Checking the Scheduled Tasks Log

Scheduled tasks maintains a log file (Schedlgu.txt), in the c:\Windows folder. You can view the log from the Scheduled Tasks window by clicking View Log on the Advanced menu.
The log file size is 32 kilobytes (KB), and when the file reaches its maximum size, it automatically starts to record new information at the beginning of the log file and writes over the old log file information.

Back to the top

Checking the Task Scheduler Service

The Task Scheduler service must be running and properly configured to run tasks. If you had stopped scheduled tasks manually from the Scheduled Tasks window, the service stops and does not initialize the next time you start the computer. If the service is not configured to log on as the local system account, it may not start.
To check the settings for the service:

Click Start, click Control Panel, and then double-click Administrative Tools.
Click Computer Management.
Expand Services and Applications, and then click Services.
Right-click the Task Scheduler service, and then click Properties.
On the General tab, make sure that the startup type is set to automatic, and that the service status is Started. If the service is not running, click Start.
On the Log On tab, make sure that the local system account is selected, and that the Allow service to interact with desktop check box has a check mark.
Click OK, and then quit Computer Management.

Log4Net - moving config out to separate file with auto-refresh

2009-02-12T10:36:00.001Z

http://geekswithblogs.net/bsherwin/archive/2008/02/15/119657.aspx

Asp.Net to PDF export

2009-01-28T11:58:00.001Z

Interesting article on exporting a GridView to PDF:

http://csharpdotnetfreak.blogspot.com/2008/12/export-gridview-to-pdf-using-itextsharp.html

Uses open-source project iTextSharp

Asp.Net encrypt connection string in web config

2009-01-16T11:37:00.001Z

Quick note on how to encrypt the Connection string in the web.config for future reference
Encrypt the Connection string :
aspnet_regiis -pef "ConnectionString" "c:\path\to\website"

Grant Access to IIS to the key
aspnet_regiis -pa "NetFrameworkConfigurationKey" "NT Authority\Network Service"

note aspnet_regiis is in the .net framework directory for the version of .net that you are using

Rhino mocks - partial mock calling real method not mocked expectation

2008-10-15T13:19:00.001Z

Had a few occasions where a Partial mock was calling the real method even though an expectation had been defined.

The reason was that the method being called was not marked as Virtual and so not being overridden by the mock repository.

Encrypt / Decrypt Web.Config sections

2008-09-25T12:24:00.001Z

See article here to encrypt or decrypt section of web.config file.

VS2005 XML Comments not shown

2008-09-18T11:51:00.001Z

XML Method comments are not being displayed by intellisense for methods of classes other than those in the same project.

Any referenced DLL must have the XML file which contains the comments in the same directory as the DLL itself.

Asp.Net - Simulate a windows service

2008-09-16T12:34:00.001Z

Very interesting article here: CodeProject:AspNetService detailing how to simulate a windows service running completely within Aps.Net using cache item call backs.

.Net Setting up Intranet as Full Trust Zone

2008-07-01T09:11:00.001Z

If the PC does not have the .NET SDK installed then the configuration tool will not be available via Control Panel -> Admin. Tools. Instead a command line tool CasPol.exe must be used:

The command line tool exists in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
The command for setting Intranet as full trust is:
CasPol.exe -q -m -ag All_Code -zone Intranet FullTrust

DataGridView - wrong row edited

2008-05-28T09:05:00.001Z

When using the Edit functionality of a DataGridView it is easy to fall into the trap of selecting the wrong row to edit when running in a multi-user environment.

When user clicks row to edit you must store the ID of the row (not its index), then just prior to data-bind find the index of the selected ID in the data-source and set the EditIndex, this means if another user adds or removes rows in between the the current user clicking edit the correct row will be selected.

SQL Left Join with Criteria

2008-05-13T16:22:00.001Z

Query to get job title of staff or null if staff not assign a job-title:

SELECT     CORE_Staff.ID, CORE_Staff.JobTitleID, CORE_JobTitle.Name
FROM        CORE_Staff LEFT JOIN CORE_JobTitle
                       ON CORE_JobTitle.ID = CORE_Staff.JobTitleID
where (CORE_JobTitle.Name='Driver') or (CORE_JobTitle.Name is null)

Rhino Mocks - Partial mock not calling base method

2008-05-13T11:19:00.001Z

Had a problem where I was creating a partial mock then calling a method of the partial mock which was returning 0 (zero).

The base method was not being called even though no expectations had been setup.

The reason for this was that the ReplayAll (and VerifyAll) methods of Rhino Mocks was not being called.

Original code:

            _interestBiz = _mocks.PartialMock<InterestBiz>();
            int baseDay = _interestBiz.GetBaseDaysFromAccount(account);
            Assert.AreEqual(365, baseDay, "Incorrect base days");

Fixed code:

            _interestBiz = _mocks.PartialMock<InterestBiz>();
            using (_mocks.Record())
            {

            }

            using (_mocks.Playback())
            {
                int baseDay = _interestBiz.GetBaseDaysFromAccount(account);
                Assert.AreEqual(365, baseDay, "Incorrect base days");

So even though no expectations were set Rhino Mocks needs to no this.

Good Rhino.Mocks introduction / tutorial

2008-05-01T12:40:00.001Z

Good Rhino.Mocks introduction / tutorial here

C# Threading : Workers processing list

2008-05-01T09:53:00.001Z

Using ThreadSafeQueue class as list of items to process.

Class used as a worker, takes list as parameter, creates a thread to run in.

public class MyWorker
    {
        private Thread _myThread;
        public Thread WorkerThread
        {
            get { return _myThread; }
            set { _myThread = value; }
        }

        ThreadSafeQueue<int> _listOfNumbers;
        public string NumbersProcess = string.Empty;
        int total=0;

        public MyWorker(ThreadSafeQueue<int> listOfNumbers)
        {
            _listOfNumbers = listOfNumbers;
            _myThread = new Thread(new ThreadStart(this.DoProcess));
        }

        public void DoProcess()
        {
            int _localInt=0;
            do
            {
                if (_listOfNumbers.TryDequeue(out _localInt))
                {
                    total = total + _localInt;
                    NumbersProcess = NumbersProcess + _localInt.ToString() + ", ";
                }                
            } while ((!_listOfNumbers.NoMoreItems) ||
                     (_listOfNumbers.NoMoreItems) && (_listOfNumbers.Count > 0));
        }
    }

Calling process creates 5 workers then populates list, then waits for workers to finish processing:

//Queue to hold numbers to process
            ThreadSafeQueue<int> listOfInts = new ThreadSafeQueue<int>();
            
            //5 worker objects (threads)
            MyWorker[] workers = new MyWorker[5];
            for (int i = 0; i < workers.Length; i++)
            {
                workers[i] = new MyWorker(listOfInts);
                workers[i].WorkerThread.Start();
            }

            //Populate list to process
            for (int i = 0; i < 1000; i++)
            {
                listOfInts.Enqueue(i);
            }

            //Flag that no more items will be added to queue
            listOfInts.NoMoreItems = true;
            
            //Wait for workers to finish then display details
            foreach (MyWorker worker in workers)
            {
                worker.WorkerThread.Join(); //Wait for worker to finish processing.
                tbxDetail.Text=tbxDetail.Text+string.Format("Numbers processsed {0} \n",worker.NumbersProcess);
            }
            tbxDetail.Text = tbxDetail.Text + string.Format("\n\n");

C# Constructors

2008-04-29T08:22:00.001Z

See full discussion here

Base

public myClass() : base()

Overload

class myClass
    {
        public myClass()
        {
            //No parameters
        }

        public myClass(string param1) : this()
        {
            //No parameters will be called before me!
        }
    }

Asp.Net : "A first chance exception"

2008-04-28T13:12:00.001Z

Getting huge amount of "A first chance exception" messages when running web-site under IDE for first time (after a rebuild).

These were being reported because programmer had turned off 'Just my code' within Tools->Options->Debugging->General

SQL Server : Query on date and HQL

2008-04-22T14:30:00.002Z

Date format is 'YYYY-MM-DD'

e.g.

select * from orders where Date='2008-04-22'

HQL (as literal)

from Activity a where a.Date between '2008-01-01' and '2008-02-29'

Bind Dictionary to WinForm ComboBox

2008-04-03T14:03:00.001Z

To bind a dictionary to a combo box:

            cmbTable.DisplayMember = "Key";
            cmbTable.ValueMember = "Value";
            cmbTable.DataSource = new BindingSource(myDictionary, null);

Validators and hidden fields

2008-03-07T15:09:00.002Z

It seems that there is a strange bug with validators.

If the field that is being validated is hidden in some circumstances a Java error " 'null' is null or not a object"

This doesn't happen on all servers / clients, the problem on site was produced on the clients IIS but on our one wasn't showing, this is with the same code running.
It also didn't happen with a previous version that had one less validator.

The solution was to move the validators next to the actual fields that were being validated. The validation messages were being shown in a validator summary.

The only way I could reproduce it in the office, was to move the post buttons off the Update panel and to do a full postback. This error continued to happen on site, even if I disabled the validators for the hidden control.s

IIS Asp.Net (Apparently) Bizzarro (turns out) lack of understanding

2008-02-12T12:57:00.001Z

Had apparently strange goings on with IIS & Asp.Net.

Delivered new mylibrary.dll. User renamed mylibrary.dll to "old mylibrary.dll", copied in new mylibrary.dll. Got error saying 'old mylibrary.dll' could not be loaded into manifest.

After deleting the 'old mylibrary.dll' files the web site loaded ok.

After a discussion we came to the conclusion that IIS loads all the DLL files in the BIN directory irrespective of references within Web.Config.

The site then throws exception when two dlls contain the same Assembly-name - this also makes sense.

So what appeared to be strange behaviour came down to not thinking logically!

Asp.Net Ajax Calendar Extender

2008-02-04T11:04:00.001Z

There is a bug with the AJAX calendar extender in that the style of the popup calendar are not applied if the text-box /calendar extender are hidden when a page first loads.

e.g. Panel with Details on is only shown once valid record found; if the first calendar extender on the page is within this hidden Details panel the calendar will not be displayed correctly when Details does become visible:

To fix this have a hidden calendar extender at top of the page:

<!-- Workaround for Calendar not displaying correctly - if hidden when page first loads -->
<div style="display: none"><asp:TextBox runat="server" ID="textbox1" /><cc1:CalendarExtender ID="ceTextBox1" runat="server" TargetControlID="textbox1" /></div>

Calendar is then displayed correctly:

Crystal Reports Asp.Net issues

2008-01-28T17:15:00.000Z

Deployed Crystal Reports to server by:

Run CRRedist2005_x86.msi (taken from C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports\)

Icons did not display in CR Toolbar:

Copy C:\Inetpub\wwwroot\aspnet_client to root of website)

ADO provider not found (SQL Server 2000):

Report (design-time) connection was SQL-Native changed to be SQLOLEDB.

Change connection information at run-time

                CrystalDecisions.Shared.TableLogOnInfo tliCurrent;
                foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in crSource.ReportDocument.Database.Tables)
                {
                    tliCurrent = tbCurrent.LogOnInfo;
                    tliCurrent.ConnectionInfo.ServerName = server;
                    tliCurrent.ConnectionInfo.UserID = username;
                    tliCurrent.ConnectionInfo.Password = password;
                    tliCurrent.ConnectionInfo.DatabaseName = dbname;

tbCurrent.ApplyLogOnInfo(tliCurrent);
}

Toolbar Not working

The toolbar options were not working because a post-back was being generated that performs the functionality - the assigning of the report was within a !IsPostBack block. As the report is not held in state it must be reloaded during post back.

NHibernate transaction locking oops!

2008-01-21T15:56:00.001Z

Was testing catching NHibernate.StaleObjectStateException (exception where one user updates a record which another user then attempts to update without getting newer version).

Was getting 'Failed to initialise lazy..." when reloading record on associated collection due to a timeout and also appeared to be locking the server (no queries could be run on tables involved in failed update)

It came down to the transaction not being Rolled-back when exception thrown - so obviously DB still in transaction.

Databinding NHibernate

2007-11-26T17:30:00.001Z

Had a few problems data-binding lists returned from NHibernate (queries or collections) where the first object in the list was a proxy. We previously 'fixed' this by clearing the session prior to running the query. This then caused further problems as objects were detached and the lazy-lists threw exceptions.

The solution we came to is based on : This posting by Ayende

A TypeDescriptor was created for EntityBase (all our objects returned from NHibernate inherit from EntityBase) which was registered with the web-site in the Global.asax Application_StartUp.

Configuration Error: FairmortRoleProvider

2007-11-22T14:52:00.001Z

When creating a new site we kept getting spurious errors which seemed to relate to "add name=FairmortRoleProvider...." line of Web.Config.

This was a red herring and the actual error related to Spring Config files and references. The Salecore assemblies that are to be referenced must be added as a reference AND the relevant config files also added. Either missing reference or config file can cause this spurious error.

VS2005 not rebuilding project

2007-10-25T10:41:00.001Z

Had an issue with a specific project not being rebuilt when changes made to it and web site being run. The solution contained multiple projects and none of the other projects exhibited this behavior.

Appears due to Project being marked as not rebuild for Solution, although this setting was not turned on manually.

Setting access via: Solution (right-click) Properties -> Configuration.

NHibernate Criteria aggregate (Sum,Max etc)

2007-09-24T11:57:00.001Z

It is possible to get NHibernate criteria to perform aggregations using the Projections class:

public double SumHours(out double chargeable, out double nonchargeable)
        {
            IList results;
            ICriteria crit = _session.CreateCriteria(typeof(Activity));
            ProjectionList projList = Projections.ProjectionList();
            projList.Add(Projections.Sum("ChargeableHours"));
            projList.Add(Projections.Sum("NonChargeableHours"));

            crit.SetProjection(projList);
            results=crit.List();
            if (results.Count == 0)
            {
                chargeable = 0;
                nonchargeable = 0;
            }
            else
            {
                chargeable = (double)(results[0] as object[])[0];
                nonchargeable = (double)(results[0] as object[])[1];
            }

return chargeable + nonchargeable;
}

FileUpload not working ~ no state information on postback

2007-09-13T12:25:00.001Z

Had a problem where the 'selected file' information was not coming through for a dynamically created FileUpload control. The problem was due to the FileUpload control being inluded on a Ajax UpdatePanel.

FileUpload control will not work with an async postback (Ajax UpdatePanel) because the details of the file to upload are included in the Web Request of a full postback.

See Eilons Liptons Blog for more details.

Solution was to have a dedicated upload page.

Instantiating arrays

2007-09-06T15:15:00.001Z

Always seem to forget the syntax for instantiating arrays in code:

int [] numbers = new int[] {3,1,4};
string [] names = new string[] {"Tom", "Dick", "Harry"};

Validation of viewstate MAC failed... using AJAX UpdatePanel

2007-09-03T10:11:00.000Z

Was getting the following error after a partial update of a component on an AJAX UpdatePanel:

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster

It seems the problem occurs because after the partial update the component include a GridView that used DataKeyNames. The use of DataKeyNames requires that view state is encrypted.
I think the error occurred because this encryption was only taking place after the partial postback.

The solution seems to be to always have view state encrypted ~ a page directive.

viewStateEncryptionMode ="Always"

Databind: Object does not match target type

2007-08-30T13:30:00.000Z

This error sometimes occurs when trying to bind a result from a NHibernate query. It is caused by the first item in the list being a proxy value which causes the DataBind to use reflection of the proxy rather than the real target.

Details and solution taken from Alkampfer's Place.

Possible solution, requires object implements ICloneable:

public IList<T> SafeList<T>(IList<T> input) where T : class, ICloneable {
//Symply check the type of the first element.
if (input.Count > 0) input[0] = (T) input[0].Clone();
return input;
}

If object does not implement IClonable then need to turn off Lazy loading in mapping file.

Final Solution
As it was not pratical to make all objects ICloneable or to turn off lazy loading we finally settled on clearing the cache (Session.Clear) prior to executing queries or criterias.

LoginStatus - Login page URL

2007-08-29T10:13:00.001Z

When using LoginStatus control the Login link goes to the page identified in the web.config:

system.web
authentication mode="Forms"
forms loginurl="~/Default.aspx"

Problems with Properties showing in Property Editor with custom web server controls

2007-06-15T14:25:00.001Z

I was creating a custom web sever control which was inherited from CompositeControl, I had removed a couple of editor properties, I then noticed that some properties were not being shown in the property editor after you switched between source and design view of a web page. To fix this I had to add in a new property, compile and use it, then take the new property back out again.
I also had to take the reference of the object out of the web page and stick it back in again.
All in all a pain in the bottom, and a waste of time!

Dear MS why did you make the development of web controls so annoying, like having to put a new control on the screen everytime you make a change, and debugging the component in design mode what were you thinking!

NHibernate:object references an unsaved transient instance

2007-06-07T15:00:00.000Z

"object references an unsaved transient instance" recieved when performing a save (and transactional commit).
Caused by a related (parent) record not being saved and the entity not set up for cascading save.
e.g. User record has link to Person record but when user is saved the linked person is not saved.
Solution is either to turn on cascading saves for related entity or to explicity save the related record by creating a business object method.

Ajax Extender Properties Gotchas

2007-06-05T10:26:00.000Z

When you want to add a property to an Ajax Extender you need to do the following.

Make sure you have installed the Ajax Extender Templates, run AjaxControlExtender.vsi from the AjaxControlExtender directory of your toolkit install.

Create a new item using the ASP.NET Ajax Extender Control Template from my templates.

Note : If you set the namespace to have a . in it e.g. Company.AjaxControls then the Javascript will not be able to find the script as a webresource. If you want to do this then you have to manually change the ClientScriptResource attribute of the extender.

1) Create the C# Property in the controlExtender.cs file

[ExtenderControlProperty]
[RequiredProperty]
public string ExampleControl
{
get { return GetPropertyValue("ExampleControl", ""); }
set { SetPropertyValue("ExampleControl", value); }
}

2) Create the JavaScript Property in the controlBehaviour.js file

In the function(element) section, at the top of the page by the todo 1 to declare the property on the JavaScript side

this._ExampleControl = null;
Add the property getter and setters at the bottom of the file

get_ExampleControl : function() {
return this._ExampleControl;
},

set_ExampleControl : function(value) {
this._ExampleControl = value;
},

Note : The getter and setters are named get_(propertyname) and set_(propertyname). the asp.net Ajax controls expect the names in this form.

NHibernate, GetType on Proxy

2007-05-21T09:47:00.000Z

When lazy loading is true the returned type from a db call will be a proxy, so if you call GetType() you will get the proxy type not the underlying class.
To overcome this use NHibernateUtil.GetClass(object-instance).

C# Date encoding / parse

2007-05-11T09:52:00.000Z

DateTime.Parse requires a Culture to be set to use a specific format.
If the format is known then a better alternative is to use new DateTime(year,month,day).

C# Windows dock overlap

2007-05-11T08:41:00.000Z

Where panels etc are 'docked' in a windows form they can sometimes overlap (eg Left dock overlaps the Fill dock panel). To overcome this the overlapping panel must be 'Sent to Back'

Windows 2003 POP3 CatchAll

2007-04-23T16:45:00.000Z

To facilitate a catch-all address on Windows 2003 you need to run the scripts downloaded from here:

http://isorecorder.alexfeinman.com/catchall.htm

These have been downloaded to Sever1\\Install\Microsoft\Windows2003\MailCatchAll

PageRequestManagerParserErrorException exporting grid

2007-04-11T11:00:00.000Z

Had code to export grid but was receiving the error PageRequestManagerParserErrorException.
This appears to be due to the Export button being on a Ajax UpdatePanel and the ScriptManager having PartialUpdates set to false.
There doesn't currently appear to be any work around to fix this other than the button being removed from the UpdatePanel.

NHibernate:Unknown entity class:

2007-04-05T12:43:00.000Z

Error "Unknown entity class: " occurs when either no mapping file exists for specifed or the mapping file is not flagged as embedded resource.

AJax Calendar extender date format

2007-04-03T15:46:00.000Z

The date format of the Calendar extender seesm to be mm/dd/yyyy.
To change it to culture specific:

Set Page Culture="auto"
Set Page UICulture="auto"
Set ScriptManager EnableScriptGlobalization="true"
Set ScriptManager EnableScriptLocalization="true"

GridView : Getting updated cell values

2007-03-28T08:50:00.000Z

When using a gridview the RowUpdating event arguments has a property (e.)NewValues.
There is a problem if the GridView datasource is not set to s DataSourceObject, these NewValues remain blank.
To populate use the following code:

GridView gv = (GridView)sender;
for (int i = 0; i < gridView.Columns.Count; i++)
{
DataControlFieldCell cell = gv.Rows[e.RowIndex].Cells[i] as DataControlFieldCell;
gv.Columns[i].ExtractValuesFromCell(e.NewValues, cell, DataControlRowState.Edit, true);
}

Nhibernate: Date time field null on insert

2007-03-26T11:10:00.000Z

Receiving exception when trying to save a record the stack tarce identified theproblem as a null value for a DateTime field.
This is caused by either:

Property not marked as nullable (? after Type in property declaration)
Existing record being flushed that contains an invalid null value for datetime.

NHibernate: Object not set to instance on save

2007-03-26T11:06:00.000Z

When saving I received 'Object not set to instance', from the stack trace the object in question was identified as the VerisionNo.
This was correctly defined for the table in question, after investigation it was identifeid as being a link table that was being flushed which had an existing record with a Null value for the VersionNo.
This record had been either manually entered or entered prior to the versionNo field being defined as NotNull.

RowDataBound checking if row is in edit mode

2007-03-23T11:38:00.000Z

The RowState property of a grid row can hold more than one value using bitwise logic.
If you want to test if a row is in edit mode then use:

if ((e.Row.RowState & DataControlRowState.Edit) > 0)

The RowState will also have a value of DataControlRowState.Alternate for every other row.

GridView : DIsplaying results of function using DataItem as parameter

2007-03-22T15:50:00.000Z

Instead of just displaying the actual value of a field in a column (<%# Bind("Hours") %>) you can also call a function that uses the value to get another value.
e.g.
If we have ClientID but we want to display ClientName (another tabel in the db) we can assign:
Text='<%# GetClientName(DataBinder.Eval(Container.DataItem, "ClientID")) %>'

We then have a function in the page code:

protected string GetClientName(object iD)
{
return GetClientNameById(iD);
}

Note. the parameter must be defined as object because the actual type is unknown until binding.

Spring: Error instantiating context spring.root

2007-03-22T12:06:00.000Z

Had the exception "Error instantiating context spring.root" when attempting to create an object.
This was caused by not including the assembly reference that the object belonged to in the web site.

Updatepanel : Making other panels visble/invisible

2007-03-13T10:13:00.000Z

Had a problem making multiple panels visible / invisible inside an UpdatePanel. The problem was occurring when I wanted to display different panels based on wether a user was logged in or not.
As an example I created the following user control with two panels which should alternatively be displayed.
When the Top button is clicked the code was storing in a session object that the user is logged in.When the Top button is clicked the code was storing in a session object that the user is logged out. During the Render method of the contorl if the seesion object was set to Logged In then the bottom panel was set visible=true and the top panel set to visible=false (and vice versa when logged out)
This worked, until another UpdatePanel on the page performed a partial postback, then both panels were being displayed.

Assumption of what was happening: The problem seems to be that the setting of the visible=true|false was being made in the wrong place. Setting the values in the Render method mean that they are not then stored on the control state; when a different updatepanel performs a partial postback it appears the control state is used to identify what elements of the page need updating. In the above case both panels has visible=true set in the control state.
Fix: To fix the problem the setting of the panel visibilty was moved to the PreRender method (after PreRender, SaveState is called, the Render).

Validators not working in UpdatePanel after partial postback

2007-03-13T10:08:00.000Z

There is a problem with Validator controls not being displayed in (Ajax) UpdatePanel after another updatepanel performs a partial postback.

i.e. Validators work fine when page is first loaded; then another UpdatePanel control performs a partial postback; the original validator is no longer displayed.

This is dues to a problem with release v1 of Asp Ajax. A patch is to be released to fix this, alternatively compatible controls can be downloaded

See this link for more details

Validators & Multi-view

2007-03-12T16:45:00.000Z

Validators don't (seem to) work in MultiView view.

May be due to Ajax v1 & validators see above.

NHibernate Flush before Query

2007-03-08T14:54:00.000Z

Was having a problem with following:

Start Session
Read object/record (presentation layer)
Update record/object im memory (presentation layer)
Run query to check changes valid (biz layer).
If 4 ok commit changes inside transaction (biz layer)
End session

Step 4 was identifying a problem and so steps 5 was not completed (i.e. no explicit Commit was called), the problem was that the record changes were still being written to the database.

This is caused by the FlushMode of the session be set to Auto. When set to auto NHibernate will sometimes flush the persistent obejct prior to performing a query.

There are a few solutions to this:

Perform updates to object after query (not applicable in this case due to layers)
Disconnect object prior to updating (Evict)
Change FlushMode to Commit

The solution decided upon was to change FlushMode to Commit and to also clear the session if a transaction fails and rollback is called.

Error on DataBind() of DropDownList:, invalid SelectedValue

2007-03-06T15:28:00.000Z

Getting error:

has a SelectedValue which is invalid because it does not exist in the list of item

The SelectedValue before the databind is set to "" (i.e. blank string)
The error occurs because the data being bound does not include a value of "" (blank string).

To fix it:

Set AppendDataBoundItems=true for control
Clear the list prior to databind; .Items.Clear();
Add a blank item: .Items.Add(new ListItem("", ""));
Call .DataBind();

How to map to a Generic IDictionary

2007-03-05T16:11:00.000Z

Say you have a standard nHibernate Bag that maps to a IList

C# Definition

public virtual IList<UserGroup> Groups;

nHibernate Mapping

You can change this to a IDictionary by changing the IList to a IDictionary in the Business Entity, then change the bag to a map,and adding a index setting to the nHibernate mapping.

So the above would be changed to

C# Definition

public virtual IDictionary<int,UserGroup> Groups;

nHibernate Mapping

Where of course the index column is the column that you will search on, and the type is the type of the column.

NOTE - The Key Column and the Index column cannot be the same, but then thinking about that it would be pointless because the key value would be the same on all the keys of the dictionary.

NHibernate error loading class

2007-03-05T12:08:00.000Z

Got the error:

Could not load type '...Page, SalecoreContent', check that type and assembly names are correct

Was caused by an incorrect class="Page" reference in one of the object mapping files.

nHibernate Get or Load?

2007-03-02T16:07:00.000Z

Session.Get and Session.Load do very similar things, the difference is.

.Get will return null if a record is not found.
.Save will return an exception if a record is not found, and if it can use a proxy, it will return a proxy, so you won't get the exception until you try to actually use the object.

If you are not sure that a record exists then use .Get and check that the object isn't null.

NHibernate:How do I know a field is dirty?

2007-03-02T15:30:00.000Z

The problem arose that I needed to know if a field had changed just prior to saving:

Presentation layer reads object/record
Presentation layer changes object field value
Presentation layer calls business layer to update the object/record
Business layer needs to know if a certain field has changed to perform extra processing

When the record is read (in step 4) from the database it actually comes from the (session) cache and therefore holds the values of the changed (but not yet persisted) fields.

The solution seems to be either clear the cache or tell the business object that the field has changed. The clear-the-cache solution was not tried, would have been along the lines of Session.Evict(object).

HQL Query - as, in errors

2007-02-27T17:04:00.000Z

Tried to do a simple query:

from Page page

returned error ..expected in...

Tried

from Page as page

return error ..unexpected token:as..

After an hour of frustration realised that the object in C# was not called Page (I had renamed this to SalecorePage as it classed with the asp.net class:page).

The use of the wrong name stemmed from performing the query in SQL Server then porting to HQL.

Configuration - unknown class

2007-02-27T10:13:00.000Z

Tripped me up a couple of times, the System.Configuration must be manually added as a reference to a project otherwise the Configuration class is unknown.
For some reason I always assume this reference is added by default then spend a while wondering why VS claims Configuration class is not part of System.Configuration!

Asp.Net Adding a javascript confimation message box to button click

2007-02-26T10:00:00.000Z

To add a javascript confimation (message) box to the click of a button add the following to the Page_Load():

btnDelete.Attributes["onclick"] = "return confirm('Are you sure you want to delete this record?');";

NHibernate - Record re-read not showing server updates

2007-02-26T09:50:00.000Z

Has an issue where re-reading a record the record did not include updates that had happened on the server:
1. Read USER record (e.g. Name=JOHN).
2. Update USER record on server (e.g. set Name=MIKE).
3. Read USER record again. Name is still JOHN.

This implied the record is being read from the cache.
The problem came down to the fact that the Data-access-object was being created as a Singleton which meant the Hibernate Session was not being opened and closed.
The record will only be re-read from the server outside of Session (i.e. Hibernate will read the record from the cache if inside the same session).

Solution was to change the Spring object mapping to not create the DAO as a singleton, this meant the session was being open/closed during page life cycle.

C# Enum, enumerated types

2007-02-22T09:39:00.000Z

C# Enumerated type info

Declaration:

enum MyType
{
One=1,
Two=2
};

Assignment:

int myVar = (int) MyType.One;
MyType myVar2 = MyType.Two;

Getting name of value:

string enumName = MyType.One.ToString();

Getting all values as string:

string[] enumNames = Enum.GetNames(typeof(MyType));

Getting an Enum value from a string:

MyType myVar = (MyType)Enum.Parse(typeof(MyType),"One",true)

C# Lazy or full boolean evaluation?

2007-02-21T11:21:00.000Z

C# allows for both full and lazy evaluation. For full evaluation use the single operators for And/Or (|/&), for lazy evaluation use the double operators for And/Or (&amp;amp;&/||).
e.g.
Full Evaluation

if ((sName==null) | (sName="~empty~"))
...do something

will cause an exception if sName is null as the second comparions (="~empty~") will be performed.

Lazy Evaluation

if ((sName==null) || (sName="~empty~"))
...do something

will not cause an exception if sName is null because as the rest of the expression is an OR the result will be true irrespective of the rest of the expression, and so the rest of the expression is ignored.

Grid-View : Select a row without "Select link"

2007-02-19T15:57:00.000Z

You can use javascript to select a row in a grid-view by setting the rows onMouse and onCLick events:

protected void gvSettings_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes["onmouseover"] = "this.style.cursor='hand';this.style.textDecoration='underline';";
e.Row.Attributes["onmouseout"] = "this.style.textDecoration='none';";
e.Row.Attributes["onclick"] = ClientScript.GetPostBackClientHyperlink(this.gvSettings, "Select$" + e.Row.RowIndex);
}
}

When DataBind() is called on the grid the events will be set for each row.
Code taken from this Geekzilla article

.... further to this, if 'EnableEventValidation="true"' is on , which it is by default, the postback will cause an error: "Invalid postback or callback argument"

to overcome this you need to register each PostBack event in the Render fn of the page:

foreach (GridViewRow r in gvSettings.Rows)
{
if (r.RowType == DataControlRowType.DataRow)
{
Page.ClientScript.RegisterForEventValidation(this.gvSettings.UniqueID,"Select$" + r.RowIndex);
}
}

Getting a value from a control in the Page Init

2007-02-19T12:41:00.000Z

The value of a control (e.g. textbox) is not available in PreInit.
As the value may be required (e.g to generate dynamic controls, set theme) it can be retrieved by accessing Http Request:

string selectedValue ;
if (Request.Form["txtNoOfRooms"] != null)
selectedValue = Request.Form["txtNoOfRooms"].ToString();

Uses name of control to retrieve value. Not each control only has 1 value.

Example taken from this article in Code Project

Setting a Page Theme

2007-02-16T12:58:00.000Z

Setting a page theme programmatically can be troublesome as the theme can only be set in the Page PreInit. If the theme value is coming from a control on the page then the controls value is not available in the PreInit.
The following solution was taken from : (K.Scott Allen's) OdetoCode.Com

protected void Page_PreInit(object sender, EventArgs e)
{
if (IsPostBack)
{
string uniqueID = Request[_themeListIDKey];

if (uniqueID != null && Request[uniqueID] != null)
{
Theme = Request[uniqueID];
}
}
}

protected void Page_Load(object sender, EventArgs e)
{
ClientScript.RegisterHiddenField(
_themeListIDKey, _themeList.UniqueID
);
}

const string _themeListIDKey = "_themeListIDKey";

NHibernate - a couple of transaction related issues

2007-02-15T16:35:00.000Z

A couple of issues with transactional updates

1. Timeout expired.
A timeout expired error was occurring when attempting to update the same record (and field) twice within a single transaction.
This only occurred when the database update was being performed.
Solution: When updating a record multiple times do not perform the Update until all field values have been updated.

2. Illegal attempt to associate a collection with two open sessions
This error was returned when attempting to update child records of a parent record as well as updating the parent record, where the child record was being read independent of the parent record.
e.g

Parent record links to Child1 and Child2
Parent record read (which implicity reads Child1 & Child2 and puts in list Parent.Children)
Child1 record is read independently.
Parent record Updated.
Child1 record Updated.

There is no need to explicity read and update the Child1 instance. The instance (from Parent) should be updated (in memory) instead.

C# Generics typecasting

2007-02-15T12:02:00.000Z

Error being received:

cannot implicity convert type ilist to list

The error occurs when calling a function that returns an IList.
e.g.

IList myFunction();
....
List myVar = new List;
myVar=myFunction();

the error occurs on the assignment of myVar=myFunction.
The local var myVar should be declared as IList.
In the above instance the new List is not required because myFunction creates the instance.
Correct code:

IList myFunction();
....
IList myVar;
myVar=myFunction();

NHibernate save error.

2007-02-14T14:45:00.001Z

Error: "object references an unsaved transient instance...."

This occurred when saving a object that had a 1:M relationship that was represented by a list.

Parent --- child1

--- child2

To fix the error add cascade="all" to the that represents the 1:M relationship in the DB Mapping file.