Tommi's solution archive - C#, ASP.Net, Biztalk

.NET Framework 4: Unable to cast object of type 'system.string' to type

2011-09-16T10:37:00.006+03:00

Problem

For example you are binding pricelist-objects to a combobox in WinForms application like this


cmbPricelist.DataSource = BL.GetPricelists();
cmbPricelist.ValueMember = "PricelistCode";
cmbPricelist.DisplayMember = "PricelistName";

and later you trying to get selected item from combobox like this

Pricelist p = (Pricelist)cmbPricelist.SelectedValue;

you might get an error "Unable to cast object of type 'system.string' to type..."

Solution

If you are using .NET Framework 4 Client profile ComboBox.SelectedValue method returns object (in this example Pricelist).

But if you are using .NET Framework 4 Full profile ComboBox.SelectedValue method returns ValueMember as String

ASP.NET: Prevent button double-click

2011-07-04T13:52:00.003+03:00

Problem

How to prevent button double-click on ASP.NET page

Solution

Add following code to Page_load. This code prevents button double-click on client-side but still executes code at server-side:

btnSave.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(btnSave, Nothing) + ";")

CRM Adapter 4.0 installation to Biztalk Server 2010

2010-11-25T09:42:00.003+02:00

Problem

You might receive an error "Microsoft Biztalk Server 2006 is not installed. You must install Microsoft Biztalk Server 2006. Then, try running Setup Again" when running CRM Adapter 4.0 setup

Solution

Edit ProductName value at HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\BizTalk Server\3.0 to Microsoft BizTalk Server 2006 and then run setup again. After setup is complete you can change ProductName back to Microsoft BizTalk Server 2010

There was a failure executing the receive pipeline: Verify the schema for this document specification is deployed and is in the Global Assembly Cache

2010-11-18T11:35:00.003+02:00

Problem

You might receive this error "There was a failure executing the receive pipeline: Verify the schema for this document specification is deployed and is in the Global Assembly Cache" in Biztalk 2010 while trying to submit a message to the receive location which is published with the WCF Service Publishing Wizard.

Solution

By default WCF service is running inside AppPool which is configured to use .Net Framework 2.0. Change WCF service AppPool to one which uses .Net Framework 4.0

Workaround: Running ASP.NET 1.1 on Windows 64-bit

2010-08-11T09:27:00.002+03:00

Problem

IIS manager crashes when modifying ASP.NET 1.1 sites on 64-bit Windows

Solution

Here is a long and good explanation how to solve the problem: http://blogs.iis.net/wonyoo/archive/2009/06/18/workaround-running-asp-net-1-1-on-vista-sp2-ws08-sp2.aspx

Short explanation:
1. Create the Framework64 directory for 1.1 \windows\microsoft.net\framework64\v1.1.4322\config\
2. Copy the 32bit config to 64bit config location created in step 1.
Copy file from \windows\microsoft.net\framework\v1.1.4322\config\machine.config to \windows\microsoft.net\framework64\v1.1.4322\config\

WCF: Error in deserializing body of reply message

2010-03-24T11:20:00.008+02:00

Problem

You got an error "Error in deserializing body of reply message" when calling WCF service.

Solution

If your response message size is huge then check the reader quota settings in client app/web.config-file at bindings section and change them. For example:

<readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647" maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647"/>

Note that you must have same binding, which settings you are changing, in server side also!

More about reader quota: http://msdn.microsoft.com/en-us/library/ms731325.aspx

WCF Oracle adapter: Field xxx has a value with time zone information set. Specify a value without time zone

2010-03-16T10:25:00.004+02:00

Problem

I tried to call a Oracle stored procedure from orchestration with WCF Oracle Adapter.

My source message contains a date element like this <deliveryDate>2010-03-17T16:20:34.252125+02:00</deliveryDate> and when I put that value to destination message which is sent to Oracle: <DELIVERYDATE>2010-03-15T16:20:34.2365000Z</DELIVERYDATE>

I got an error "Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: Field DELIVERYDATE has a value with time zone information set. Specify a value without time zone.

Solution
Destination messsage date value should be modified to XML date format without timezone:

DateTime date = XmlConvert.ToDateTime(xmldate, XmlDateTimeSerializationMode.Unspecified);
DestinationElementValue = date.ToString("yyyy-MM-ddThh:mm:ss"));

Looping in stored procedure

2009-12-30T14:38:00.003+02:00

Problem
How to loop through the select result in a stored procedure

Solution
DECLARE @MyId int
DECLARE Scroller SCROLL CURSOR
FOR SELECT MyId FROM MyTable

OPEN Scroller
FETCH NEXT FROM Scroller INTO @MyId
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO MyTable2 (ReferenceId) VALUES (@MyId)
FETCH NEXT FROM Scroller INTO @MyId
END

CLOSE Scroller
DEALLOCATE Scroller

ORA-03114: not connected to ORACLE and Biztalk Oracle Adapter

2009-09-22T09:15:00.004+03:00

Problem

You receive an error "ORA-03114: not connected to ORACLE" when you are trying to connect to the Oracle database with Biztalk Oracle Adapter. This error can occur even if you was connected to the database just few seconds ago.

Solution

Problem relates to the connection pool.

If the connection pooler detect that the connection with the server has been broken it will remove the broken connection from the connection pool. This doesn't happen all the time and you actually get a bad connection from the pool.

Workaround is to change Send port settings: Change useOracleConnectionPool to false at Bindings tab

Biztalk: Specified value has invalid CRLF characters

2009-03-24T11:34:00.004+02:00

Problem

You may receive an error "System.ArgumentException: Specified value has invalid CRLF characters" when sending message to the WCF send port

Solution

Remove all linebreaks and spaces from send port's "Soap Action Header" action box

ASP.NET: UpdatePanel and Response.Write()

2009-02-18T21:31:00.004+02:00

Problem

When you are modifying Response with Response.Write() from control which is inside UpdatePanel you may receive an error "Message received from the server could not be parsed"

Solution

Solution is to add a trigger to UpdatePanel like this:

</ContentTemplate>
  <Triggers>
    <asp:PostBackTrigger ControlID="btnExportToExcel" />
  </Triggers>
</asp:UpdatePanel>

This causes an UpdatePanel to refresh the page only in control specified in Triggers section

ASP.NET: UpdatePanel and popup with javascript

2008-12-09T11:18:00.005+02:00

Problem

How to open popup-window with javascript when there is a UpdatePanel control in the page

Solution

You must use ScriptManager.RegisterStartupScript() instead of ClientScript.RegisterStartupScript(). That's because ScriptManager enables partial page update what AJAX needs but ClientScript doesn't enable partial page updates.

ASP.NET: Response.Redirect throws an exception

2008-11-25T13:16:00.004+02:00

Problem

Response.Redirect throws an exception when trying redirect to the another page

Solution

Use Response.Redirect(url, false) instead of Response.Redirect(url)

Gacutil: Failure adding assembly to the cache: Unknown Error

2008-10-31T15:05:00.002+02:00

Problem

Gacutil gives an error: "Failure adding assembly to the cache: Unknown Error" when adding assembly to the cache

Solution

Each version of .Net Framework contains own gacutil. If you are trying to add .net 2.0 assembly to the cache you must use .net Framework 2.0 gacutil, not 1.1 or 3.0 gacutil.

You can also manually copy assembly file to the cache. Cache is located at Windows\Assembly

Biztalk 2006: How to use Biztalk message in C# code

2008-10-28T14:24:00.004+02:00

Problem

How to use a Biztalk message in C# code

Solution

1. Add reference to Microsoft.XLANGs.BaseTypes.dll which is inside Biztalk installation directory
2. Add using Microsoft.XLANGs.BaseTypes; to your class
3. Declare variable like this: XLANGMessage BiztalkMessage

C#: How to sort list of objects by multiple columns

2008-10-24T10:25:00.016+03:00

Problem

How to sort list of objects by multiple columns in C#

Solution

Solution is to create a comparer class for objects. Comparer class can take multiple columns as parameter. If you want to use the list of objects as a DataSource for GridView in ASP.Net page you can store the list in ViewState and sort it as many times you want without asking data again from database

Here is the Product class I want to sort by multiple columns:


    public class Product
    {
        private string code;
        private string description;
        private double price;

        public double Price
        {
            get { return price; }
            set { price = value; }
        }

        public string Code
        {
            get { return code; }
            set { code = value; }
        }

        public string Description
        {
            get { return description; }
            set { description = value; }
        }

        public Product(string CodeValue, string DescriptionValue, double PriceValue)
        {
            Price = PriceValue;
            Code = CodeValue;
            Description = DescriptionValue;
        }

    }

And here is a SortColumn class which stores sort fields and what is used with comparer class:


   public class SortColumn
    {
        public enum sortOrderEnum
        {
            Descending = 0,
            Ascending = 1
        }

        private sortOrderEnum order;
        private string name;

        public string Name
        {
            get { return name; }
            set { name = value; }
        }

        public sortOrderEnum Order
        {
            get { return order; }
            set { order = value; }
        }

        public SortColumn(string NameValue, sortOrderEnum OrderValue)
        {
            Name = NameValue;
            Order = OrderValue;
        }

    }

Next thing to do is write the generic object comparer class to sort one or multiple columns:


   public class GenericComparer<ComparableObject> : IComparer<ComparableObject>
    {

        private List<SortColumn> sortByColumns;

        public List<SortColumn> SortByColumns
        {
            get { return sortByColumns; }
            set { sortByColumns = value; }
        }

        public GenericComparer()
        {
        }

        public GenericComparer(List<SortColumn> SortByColumnsValue)
        {
            SortByColumns = SortByColumnsValue;
        }

        public int Compare(ComparableObject x, ComparableObject y)
        {
            if (sortByColumns != null)
            {
                // Loop through all sort fields
                foreach (SortColumn sortItem in sortByColumns)
                {
                    // Get information about property which is used as sort field
                    PropertyInfo propertyInfo = x.GetType().GetProperty(sortItem.Name);
                   
                    // Put null values to bottom of the list
                    if (propertyInfo.GetValue(x, null) == null)
                    {
                        return 1;
                    }
                    if (propertyInfo.GetValue(y, null) == null)
                    {
                        return -1;
                    }
                    

                    int compareResult = Comparer.DefaultInvariant.Compare(propertyInfo.GetValue(x, null), propertyInfo.GetValue(y, null));
                    if (compareResult != 0)
                    {
                        if (sortItem.Order == SortColumn.sortOrderEnum.Descending)
                        {
                            return -compareResult;
                        }
                        else
                        {
                            return compareResult;
                        }
                    }
                }
                return 0;
            }
            else
            {
                return 0;
            }
        }

    }

And for last thing create a console application to test how comparer class works:


    public class Program
    {
        public static void Main(string[] args)
        {

            // Create product list with data
            List<Product> products = new List<Product>();
            products.Add(new Product("123456", "Table", 1240.99));
            products.Add(new Product("000123", "Lamp", 25.10));
            products.Add(new Product("000124", "Lamp 2", 24.55));
            products.Add(new Product(null, "Sofa", 2499.00));
            products.Add(new Product("445405", "Bed", 1399.40));
            products.Add(new Product("345405", "Bed", 1499.40));

            // List of sort fields
            List<SortColumn> sortColumns = new List<SortColumn>();

            // Not sorted
            Console.WriteLine("Products in order of appearance:");
            ListProducts(products);

            // Sort by product code
            Console.WriteLine("Products ordered by Code:");
            sortColumns.Add(new SortColumn("Code", SortColumn.sortOrderEnum.Ascending));
            products.Sort(new GenericComparer<Product>(sortColumns));
            ListProducts(products);

            // Sort by description and code
            Console.WriteLine("Products ordered by Description and Code:");
            sortColumns.Clear();
            sortColumns.Add(new SortColumn("Description", SortColumn.sortOrderEnum.Ascending));
            sortColumns.Add(new SortColumn("Code", SortColumn.sortOrderEnum.Ascending));
            products.Sort(new GenericComparer<Product>(sortColumns));
            ListProducts(products);

            // Ready
            Console.ReadLine();

        }

        public static void ListProducts(List<Product> Products)
        {
            Console.WriteLine("");
            foreach (Product item in Products)
            {
                Console.WriteLine(item.Code + "\t" + item.Description + "\t" + item.Price.ToString());
            }
            Console.WriteLine("");
        }

    }

Now you are ready to test how columns are sorted...

I used following article as a base to my solution http://
69.10.233.10/KB/recipes/Sorting_with_Objects.aspx

Biztalk 2006: Same Oracle view in multiple orchestrations

2008-10-23T15:34:00.008+03:00

Problem

I want to use a same Oracle database view in multiple Biztalk orchestrations but Biztalk can't route messages correctly with a same pipeline even if port operation name is different for each orchestration.

Solution

Solution is simple. I had to add a new pipeline and own send port for each orchestration. Just remember to set an unique operation name for SOAP action header and select created pipeline for send/receive pipeline

Biztalk 2006: Oracle adapter namespace problem

2008-10-23T14:19:00.005+03:00

Problem

I was deploying a Biztalk project from the development enviroment to the test enviroment when I encountered an error with Oracle adapter. That's because I have a different database schema name in both enviroments and database schema name is hard-coded to the schema.

This means that I can't use same SOAP header action in a send port for test and development enviroment and I didn't want to generate different schemas for different enviroments.

Solution

In a generated schema file I had namespaces with schema name on it:
http://Microsoft.LobServices.OracleDB/2007/03/NAMEOFSCHEMA/View/MYVIEWNAME

I removed schema name from the namespace:
http://Microsoft.LobServices.OracleDB/2007/03/View/MYVIEWNAME

Then I deployed project again. Next thing I did was changing the send port properties. Database schema name must be in SOAP header action even when schema name is not declared in a namespace

<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Operation Name="portOperationName" Action="http://Microsoft.LobServices.OracleDB/2007/03/NAMEOFSCHEMA/View/MYVIEWNAME/Select" />
</BtsActionMapping>

I also changed couple of send port binding-properties EnableBiztalkCompabilityMode=true and useSchemaInNamespace=false.

Now I can deploy my Biztalk project to several enviroments without generating different schemas for each enviroment