Silverlight Timeout Issues from WCF… exceeded the allotted timeout.

16. June 2010
Comments (2)

 

So you’re getting error message…

The HTTP request to <URL To WCF Service> has exceeded the allotted timeout. The time allotted to this operation may have been a portion of a longer timeout.

 

Three places to set time values to fix this issue…

 

1) Web.Config

<httpRuntime executionTimeout="600" />

(this is seconds, so here it’s 10min).   More info on httpRuntime here.

2) On your Web.Config Binding Elements

<binding name="customBinding123" 
    receiveTimeout="00:10:00" 
    sendTimeout="00:10:00" 
    openTimeout="00:10:00" 
    closeTimeout="00:10:00" />

3) On your ServerReferences.ClientConfig binding elements within the system.serviceModel

<binding name="CustomBinding" 
    receiveTimeout="00:10:00" 
    sendTimeout="00:10:00" 
    openTimeout="00:10:00" 
    closeTimeout="00:10:00" />

ASP.NET, WCF, SilverLight

Are Easter Eggs in Software a thing of the past?

12. April 2010
Comments (0)

Was reading a post that Office Easter eggs no longer exist due to the government regulating that every software feature has to be documented.   I was developing a silverlight app and wanted to place in my own Easter egg.

Basically holding down Shift-Ctrl-Windows Key and clicking on the Logo, brings up my face :)

 

image

Funny, SilverLight , ,

Silverlight & WCF Debugging and using Fiddler!

12. April 2010
Comments (0)

 

Fiddler2 Best program out there I think for debugging WCF errors in silverlight when you get “NotFound” error messages.

 

Example. I had a Silverlight application where I had to enable it work over https and change the host headers. As many of you may know, WCF on .NET 3.5 you can not bind to website with multiple headers. You have to hardcode the WCF Address in the web.config. (I’ve read that .Net 4.0 will allow this but still not for ssl).

All my setting from what I can tell in my web.config and my clientConfig were correct, and the app worked fine in http mode only, however I would get the most generic message ever.

image

This is my custom error window I use to have users send the errors to the server.  As you can see the error is “The remote server returned an error: NotFound.”  this is basically the equivalent of the old server error message “An Unexpected Error Occurred”.  Basically who knows. Something’s wrong.  The WCF service is not responding. Could be your firewall, your IIS, your service is erroring out or 100 other things. 

Download and install Fiddler2 and let the magic begin.  I did try WebDevHelper which is like FireBug for FireFox but it works in IE.  It’s pretty good, but like FireBug, doesn’t give you that WCF error.

Loading up Fiddler, I can inspect the traffic and actually see the .Net error. It even highlights it in red for me.  (Had to block out the app names).

image

From this I was able to expand the information like below to see the real error message.

image

“Cannot be process at the receiver, due to an AddressFilter mismatch at the EndpointDispatcher.  Check that the sender and receiver’s EndPointAddresses agree”

After I realized what the problem was I was able to fix my service by adding the attribute AddressFilterMode:=AddressFilterMode.Any to my WCF class.

<ServiceContract(Namespace:="")> _
<ServiceBehavior(IncludeExceptionDetailInFaults:=True, AddressFilterMode:=AddressFilterMode.Any)> _
<AspNetCompatibilityRequirements(RequirementsMode:=AspNetCompatibilityRequirementsMode.Allowed)> _
Public Class xxxxxxxxxxxService

 

Problem Solved.

 

WCF logging:

You can also log all your WCF Traffic to a Log file on your server.

  <system.diagnostics>
      <sharedListeners>
          <add name="WcfListener"
                  type="System.Diagnostics.XmlWriterTraceListener"
                    initializeData="C:\logs\wcfLog.svclog"/>
      </sharedListeners>
      <sources>
          <!-- switchValue attribute has no impact on MessageLogging -->
          <source name="System.ServiceModel.MessageLogging">
              <listeners>
                  <add name="WcfListener" />
              </listeners>
          </source>
          <source name="System.ServiceModel"
                        switchValue="Warning, ActivityTracing"
                        propagateActivity="true" >
              <listeners>
                  <add name="WcfListener" />
              </listeners>
          </source>
      </sources>
  </system.diagnostics>

 

<system.serviceModel>
    <diagnostics>
        <messageLogging
             logEntireMessage="true"
             logMalformedMessages="false"
             logMessagesAtServiceLevel="true"
             logMessagesAtTransportLevel="false"
             maxMessagesToLog="3000"
             maxSizeOfMessageToLog="2000"/>
    </diagnostics>
</system.serviceModel>

 

Other useful posts..

Silverlight and WCF – WCF Logs and Debugging

Service Trace Viewer Tool (SvcTraceViewer.exe)

Silverlight & WCF - HTTPS

WCF, SilverLight, Troubleshooting , , , ,

Shrinking Silverlight XAP Files

27. March 2010
Comments (1)

Was looking for several ways to shrink my 2mb Silverlight XAP file.

Preferences-system.svgI ran across ComponentOne’s XAPOptimzer. However, the online demo failed considerably.  I uploaded my 2mb file and then it just timed out. Tried it twice.

image

Preferences-system.svgGiving up on that I came across Delay’s XAP Shrinker.  The thing I didn’t like about this one is that it requires you to have a zip and unzip in the same folder.  This, though you can auto run after your build which is nice.

Preferences-system.svgThe third tool I came across, ReXapper, which used the same concept as Delay’s but had everything built in and you could run from visual studio. This is the source code, you can compile the etc..

“I created a very small application called ReXapper.exe which can do exactly the same as Delay describes but there is no external archiving utility necessary. It uses the SharpZipLib to re-zip the file. So there's just a tiny (124 kb) command-line executable.”  

However, upon using this my xap file actually GREW in size!! (XAP file is rexapped, old size: 2120567, new size: 2120605, time: 439) wtf lol scary.  So back to the drawing board.  I’ve read about using PNG compressors also to shrink your images down.

Nuvola apps edu languages.gifAlso found a good post on it here.

SilverLight, Web Tools , , ,

Lightweight DataTable for your Silverlight applications

16. December 2009
Comments (1)

Source: Lightweight DataTable for your Silverlight Apps

Since there is no DataTable in Silverlight I’ve created small class that can be used to generate columns and rows in runtime in similar to the real DataTable way:

DataTable table = new DataTable();

table.Columns.Add(new DataColumn() { ColumnName = "ID", DataType = typeof(int) });
table.Columns.Add(new DataColumn() { ColumnName = "Name", DataType = typeof(string) });
table.Columns.Add(new DataColumn() { ColumnName = "UnitPrice", DataType = typeof(decimal) });
table.Columns.Add(new DataColumn() { ColumnName = "Date", DataType = typeof(DateTime) });
table.Columns.Add(new DataColumn() { ColumnName = "Discontinued", DataType = typeof(bool) });

for(var i = 0; i < 1000; i++)
{
    DataRow row = new DataRow();
    row["ID"] = i;
    row["Name"] = names[rnd.Next(9)];
    row["UnitPrice"] = prizes[rnd.Next(9)];
    row["Date"] = DateTime.Now.AddDays(i);
    row["Discontinued"] = bools[rnd.Next(9)];

    table.Rows.Add(row);
}

Class File is named Data.cs, c3 Version: 


Unfortunately, there’s no VB.Net version of this, haven't gotten to it yet.

Code Snippets, SilverLight , ,

Sending Generic.List collection back to WCF ObservableCollection

16. December 2009
Comments (2)

Found a good article and helped with a problem I was having, trying to send a list of collection back to a WCF service that was set to accept Observable Collections. 

Source: http://smehrozalam.wordpress.com/2009/01/18/ienumerabletoobservablecollection/

In WPF/Silverlight, binding UI objects such as DataGrid or ListBox to collections is typically done using an ObservableCollectioninstead of the generic List object. This way, our UI is automatically synchronized since the observable collection provides event notification to WPF data binding engine whenever items are added, removed, or when the whole list is refreshed. The LINQ extension methods that return a collection actually return IEnumerable<T>. The .NET framework for Silverlight provides built-in extension methods to convert IEnumerable<T> to List<T> and Array<T> but there’s no method available to convert the collection to ObservableCollection<T>(WPF developers can simply use this constructor overload) . So here’s one you may find useful:

  1. Public Static Class CollectionExtensions
  2. {
  3.     public static ObservableCollection<T> ToObservableCollection<T>(this IEnumerable<T> enumerableList)
  4.     {
  5.         if (enumerableList != null)
  6.         {
  7.             //create an emtpy observable collection object
  8.             var observableCollection = new ObservableCollection<T>();
  9.  
  10.             //loop through all the records and add to observable collection object
  11.             foreach (var item in enumerableList)
  12.                 observableCollection.Add(item);
  13.  
  14.             //return the populated observable collection
  15.             return observableCollection;
  16.         }
  17.         return null;
  18.     }
  19. }

Extension methods are very powerful and I am planning to post an example demonstrating their potential.

I’ve converted the above example to VB.Net version for you to copy.

Public Shared Function ToObservableCollection(Of T)(ByVal enumerableList As IEnumerable(Of T)) As ObservableCollection(Of T)
    If enumerableList IsNot Nothing Then
        'create an emtpy observable collection object
        Dim observableCollection As New ObservableCollection(Of T)()

        'loop through all the records and add to observable collection object
        For Each item As T In enumerableList
            observableCollection.Add(item)
        Next

        'return the populated observable collection
        Return observableCollection
    End If
    Return Nothing
End Function

Now you can call your List and send it back as a ObservableCollection

.Net Framework, Code Snippets, Programming, VB.NET, WCF, SilverLight , , , ,

Mapping a DataTable to an Object Class. Like a homemade Linq to SQL. Send over WCF to SilverLight

8. December 2009
Comments (0)

Application Foundation

An application I work has architecture in a way where we have a Class object that represents each table. So for example we might have a “Customer” table in the database. So our class would be something like..

Customer.vb class file…

Public Class Customer

    Private _FirstName As String = String.Empty
    Public Property FirstName() As String
        Get
            Return _FirstName
        End Get
        Set(ByVal value As String)
            _FirstName = value
        End Set
    End Property

    Private _LastName As String = String.Empty
    Public Property LastName() As String
        Get
            Return _LastName
        End Get
        Set(ByVal value As String)
            _LastName = value
        End Set
    End Property

End Class

In this class is a function to say list all customers, we call this “GetList” method. You might use another way to bring back a list of data. Ideally now we’d want to bring back Enumerable Lists, but the app was already structured for DataSets and DataTables. So I was trying to reuse what we had.

Customer.vb class file

Public Function GetList() As Data.DataTable
    Dim oDS As Data.DataSet
    Try
        oDS = DataAccess.SqlHelper.ExecuteDataset(_ConnectionString, Data.CommandType.StoredProcedure, "CustomerGetList")
        Return oDS.Tables(0)
    Catch ex As Exception
        Throw ex
    Finally
        oDS = Nothing
    End Try
End Function

So on our pages we might do something like this…

Default.aspx.vb

Protected Sub Button1_ClickSave()
    Dim oCustomer As New Customer
    oCustomer.FirstName = "Fred"
    oCustomer.LastName = "Mastro"
    oCustomer.SaveToDB()

    GridView1.DataSource = oCustomer.GetList()
    GridView1.DataBind()

    oCustomer = Nothing

End Sub

 

And this returns a nice DataTable and populates the grid. Great!

Problem Areas over WCF to SliverLight

I was working on a SilverLight application that would talk to an existing business application, to pull back and list records.  I had to use a Service, so I went with WCF since RIA.Net is not in production yet.  The problem was that DataTables can not be serialized and set over WCF to SilverLight.  So I tried messing with Linq to SQL to pull data back and populate classes I already had, but LinqTables are not serializable either, and instead of modifying all the Linq classes generated in my class I wanted to find an easier solution.

DataTable to List(Of Customer) Solution

I can across these two posts: Datatable to List of Objects Mapper and Creating datarow to object mapper and was amazed. Using reflection Chris Rock (lol) was able to read the properties of the object and map each column of the datatable to the desired property of the object. This is what I’m looking to do.  This would manually mimic Linq type functionality. The Bulk of the code is this

My Helper.vb class file

  1.  
  2. Public Class Helper
  3.  
  4.     Public Function MapDatarowToObject(Of T)(ByVal dr As DataRow) As T
  5.         Try
  6.  
  7.             If dr Is Nothing Then
  8.                 Return Nothing
  9.             End If
  10.  
  11.             Dim instance As T = Activator.CreateInstance(Of T)()
  12.  
  13.             Dim properties() As Reflection.PropertyInfo = instance.GetType().GetProperties()
  14.  
  15.             If (properties.Length > 0) Then
  16.                 For Each propertyObject As Reflection.PropertyInfo In properties
  17.  
  18.                     Dim valueSet As Boolean = False
  19.  
  20.                     For Each attributeObject As Object In propertyObject.GetCustomAttributes(False)
  21.  
  22.                         If attributeObject.GetType() Is GetType(MapperColumn) Then
  23.                             Dim columnAttributeObject As MapperColumn = CType(attributeObject, MapperColumn)
  24.  
  25.                             If (columnAttributeObject.ColumnName <> String.Empty) Then
  26.  
  27.                                 If dr.Table.Columns.Contains(columnAttributeObject.ColumnName) AndAlso Not dr(columnAttributeObject.ColumnName) Is DBNull.Value Then
  28.                                     propertyObject.SetValue(instance, dr(columnAttributeObject.ColumnName), Nothing)
  29.                                     valueSet = True
  30.  
  31.                                 End If
  32.  
  33.                             End If
  34.                         End If
  35.                     Next
  36.  
  37.                     If Not valueSet Then
  38.                         If dr.Table.Columns.Contains(propertyObject.Name) AndAlso Not dr(propertyObject.Name) Is DBNull.Value Then
  39.                             propertyObject.SetValue(instance, dr(propertyObject.Name), Nothing)
  40.                         End If
  41.                     End If
  42.  
  43.                 Next
  44.             End If
  45.  
  46.             Return instance
  47.         Catch ex As Exception
  48.             Throw ex
  49.         End Try
  50.     End Function
  51.  
  52.     Public Function MapDataTableToList(Of T)(ByVal dt As DataTable) As Collections.Generic.IList(Of T)
  53.         If dt Is Nothing Then
  54.             Return Nothing
  55.         End If
  56.  
  57.         Dim list As IList(Of T) = New List(Of T)
  58.  
  59.         For Each dr As DataRow In dt.Rows
  60.             list.Add(MapDatarowToObject(Of T)(dr))
  61.         Next
  62.  
  63.         Return list
  64.     End Function
  65.  
  66. End Class
  67.  
  68. <AttributeUsage(AttributeTargets.Property)> _
  69. Public Class MapperColumn
  70.     Inherits Attribute
  71.  
  72.     Private mColumnName As String
  73.  
  74.     Public Sub New(ByVal columnName As String)
  75.         mColumnName = columnName
  76.     End Sub
  77.  
  78.     Public Property ColumnName() As String
  79.         Get
  80.             Return mColumnName
  81.         End Get
  82.         Set(ByVal value As String)
  83.             mColumnName = value
  84.         End Set
  85.     End Property
  86.  
  87. End Class

Using Mapper in WCF

Now in my WCF Service methods I can just instantiate Customers like I always do in the normal application and apply the new Mapper method to get a List of the class objects.

WCFServiceMethods.vb file (which is code-behind to WCFServiceMethods.svc)

  1. Imports System.ServiceModel
  2. Imports System.ServiceModel.Activation
  3. Imports System.Runtime.Serialization 'For DataContract
  4. Imports System.Collections.Generic
  5.  
  6. <ServiceContract(Namespace:="")> _
  7. <ServiceBehavior(IncludeExceptionDetailInFaults:=True)> _
  8. <AspNetCompatibilityRequirements(RequirementsMode:=AspNetCompatibilityRequirementsMode.Allowed)> _
  9. Public Class WCFServiceMethods
  10.     <OperationContract()> _
  11.     Public Function GetCustomers() As Collections.Generic.List(Of Customer)
  12.         Dim oCustomer As New Customer
  13.  
  14.         Dim Customers As Collections.Generic.List(Of Customer)
  15.         Customers = Helper.MapDataTableToList(Of Customer)(oCustomer.GetList())
  16.  
  17.         oCustomer = Nothing
  18.         Return Customers
  19.  
  20.     End Function
  21. End Class

You’ll see in Line 15, I can take the DataTable and now create a List(Of Customer) object, which is serializable and send it over the wire.

Applying it in SilverLight or Other Application that uses your WCF Service

Assuming you referenced your WCF Service.. Now on my SilverLight app on a button click I can get the List of Customers and show it natively in a datagrid.

MainPage.xaml code-behind

Private Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnSearch.Click
    Dim oWCFProxy As New WCFService.WCFServiceClient

    AddHandler oWCFProxy.GetCustomers, AddressOf oWCFProxy_GetCustomersCompleted
    oWCFProxy.GetCustomersAsync()

    oWCFProxy = Nothing

End Sub

Private Sub oWCFProxy_GetCustomersCompleted(ByVal sender As Object, ByVal e As WCFService.GetCustomersCompletedEventArgs)
    Dim Customers As Collections.ObjectModel.Collection(Of oWCFProxy.Customer)
    Customers = e.Result

    DataGrid1.ItemsSource = Customers
End Sub

Problem Area With Mapper Casting Types and Solution

So with all that above you should have enough to re-create all this. Read through Chris’ posts because it does a good job of explaining the mapper.  I ran into a problem with the mapper though on line 39. Problem is when it tries to map data from the database, it all comes back as a string, and you don’t know until run-time what System.Type you need, so you can’t CType or DirectCast by using System.Type.GetType(), so I had to create a crappy function to Throw ex check every possible combination. This the best way? I sure hope it isn’t. Hope to find a better solution for it but was pressed for time.

So what was my crappy solution? I don’t even want to post it haha. I swapped out line 39 and 28 with the a call to this method of 1531 lines of code.

Private Sub TryCastTypeToPropertyType(ByRef propertyObject As Reflection.PropertyInfo, ByRef instance As Object, ByRef dr As DataRow, ByRef ColumnName As String)

        Try
            'Try to Default Types
            propertyObject.SetValue(instance, dr(ColumnName), Nothing)
        Catch exDefault1 As InvalidCastException
            Try
                'Try to String
                propertyObject.SetValue(instance, CType(dr(ColumnName), String), Nothing)
            Catch exString1 As InvalidCastException
                'Try to Integer
                Try
                    propertyObject.SetValue(instance, CType(dr(ColumnName), Integer), Nothing)
                Catch exInt32a As ArgumentException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                Catch exInt32b As InvalidCastException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                End Try
            Catch exString2 As ArgumentException
                'Try to Integer
                Try
                    propertyObject.SetValue(instance, CType(dr(ColumnName), Integer), Nothing)
                Catch exInt32a As ArgumentException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                Catch exInt32b As InvalidCastException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                End Try
            End Try
        Catch exDefault2 As ArgumentException
            Try
                'Try to String
                propertyObject.SetValue(instance, CType(dr(ColumnName), String), Nothing)
            Catch exString1 As InvalidCastException
                'Try to Integer
                Try
                    propertyObject.SetValue(instance, CType(dr(ColumnName), Integer), Nothing)
                Catch exInt32a As ArgumentException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                Catch exInt32b As InvalidCastException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                End Try
            Catch exString2 As ArgumentException
                'Try to Integer
                Try
                    propertyObject.SetValue(instance, CType(dr(ColumnName), Integer), Nothing)
                Catch exInt32a As ArgumentException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                Catch exInt32b As InvalidCastException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                End Try
            End Try
        End Try
    End Sub

Maybe I’ll get lucky and someone will post up a “Oh you can just do this, which is new in .Net 3.5 or 4.0.. “ and I can get rid of this thing. But hey it works!

Resource: How to Consume WCF and ASP.Net Web Services in Silverlight

.Net Framework, Code Snippets, Programming, SilverLight, WCF, VB.NET , , ,

SilverLight Reference Controls

19. November 2009
Comments (1)

Reference a control that’s is outside your View, or on your MainPage if you’re using NavigationFrame or your “Parent” window.

Assumption: MainPage UserControl page is your starting page and has a NavigationFrame and a View is loaded in a content window.

Method 1: (Assuming “MainPage” is the name of your MainPage or the x:Class it uses, x:Class="<AppName>.MainPage" and the TextBlock named “lblStep1”)

Dim Main As MainPage = CType(<AppName>.App.Current.RootVisual, MainPage)
        CType(Main.FindName("lblStep1"), TextBlock).Text = "Hello Test123"

Or Method 2:

CType(CType(<AppName>.App.Current.RootVisual, MainPage).FindName("lblStep1"), TextBlock).Text = "Updated Text"
 

 

Reference a Control in a User Control that’s on the same view.

  1. CType(siTest.FindName("lblStep1"), TextBlock).Text = "Testing"

Code Snippets, SilverLight ,

SilverLight App Demonstrating Error Handling

4. May 2009
Comments (3)

Now first thing you should know is this SilverLight app is meant to error and crash.

I was messing around with some Error Handling and just thought I’d post up my demo app. I designed it using Expression Blend 2 SP1 and for SilverLight 2.0

Here’s the logic I wanted to portray…

User attempts to login and on doing so the SilverLight application crashes and they are forced to reload. Forcing the page to reload would typically lose your information. Also, user fails to try and login and we capture those errors and display them on the screen.

Now the output doesn’t look like much, the real value is in the code behind it.

On App Load:

1) App loads and looks for my webservice to provide the BirthYears which binds to the ComboBox. If it cannot find my WebSerivce or the service is down the app captures the error and display a friendly version on the control.

2) I check to see if you have data in the SilverLight Isolated Datastore and if you do I will populate the username into the textbox, simulating the effort of putting things back to the way they were before. (though it might seem like nothing to you, since most login boxes remember your username, this one does not. It’s a coded/manual process)

From my DataStore class which I call, these methods I placed into it

Public Function LoadUser() As User
    Dim User As User = Nothing
    Try
 
        'Instantiate App Store
        Using store As IsolatedStorageFile = IsolatedStorageFile.GetUserStoreForApplication()
 
            'If the Store is there
            If store.FileExists(DATA_STORE_NAME) Then
 
                'Lets read it and create a user from the info
                Dim sr As IsolatedStorageFileStream = store.OpenFile(DATA_STORE_NAME, IO.FileMode.Open)
 
                Using reader As New IO.StreamReader(sr)
 
                    Dim strDataLine As String = reader.ReadLine
 
                    If strDataLine IsNot Nothing Then
                        Dim userValues As String() = Split(strDataLine, ";")
                        'UserName.ToString & ";" & Password.ToString & ";" & BirthYear.ToString & ";" & strLastVisit & ";" & IsAuthenticated.ToString
                        Dim BirthYeaer As Integer
                        Integer.TryParse(userValues(2), BirthYeaer)
                        Dim IsAuthenticated As Boolean
                        Boolean.TryParse(userValues(4), IsAuthenticated)
                        User = New User(userValues(0), userValues(1), BirthYeaer, userValues(3), IsAuthenticated)
                    Else
                        User = New User()
                    End If
 
                End Using
 
            Else
                User = New User()
            End If
 
        End Using
    Catch ex As Exception
        Throw ex
    End Try
    Return User
End Function

Scenario 1: Attempt to login with no username or password. App page checks for it and display you a nice message. I’ve sent the error to window as an alert as well as the TextBlock control, just to demonstrate. Easy as pie.

If tbUsername.Text = String.Empty OrElse tbPassword.Password = String.Empty Then
     lblMessage.Text = "You must provide both a Username and a Password"
     HtmlPage.Window.Alert("You must provide both a Username and a Password")
Else
'...
End If

Scenario 2: Attempt to login with any information, doesn’t matter, as long as it’s not blank. This is there the big change comes in. When you try and login as anything but the only user hard-coded into the system. The app throws an error, some critcal error.  You get the alert to then reload the application. At this point in my try…catch I write out data to the SilverLight’s isolated datastore.

Public Sub SaveUser(ByVal User As User)
    Try
 
    
        'Instantiate App Store
        Using store As IsolatedStorageFile = IsolatedStorageFile.GetUserStoreForApplication()
 
            Dim sw As IsolatedStorageFileStream = store.OpenFile(DATA_STORE_NAME, IO.FileMode.OpenOrCreate)
 
            Using writer As New IO.StreamWriter(sw)
                writer.WriteLine(User.ToString)
            End Using
 
        End Using
 
    Catch ex As Exception
 
    End Try
End Sub

Unhandled Exceptions: These are a little different. However, in SilverLight you can use the event “Application_UnhandledException” in the App.xaml file and try and come back from an exception. Such as checking to see if you get a communication error and notifying the user, with the ability to cancel the exception and return back to the application.  Most times, we’ll do some cleanup if we can and log the error via a web service to a server to be handled.  The goal here would be to save some information about the application, maybe to have JavaScript fire on the onError event, and try and capture what data it can from the application. Then on reload try and put things back to the way they were before the crash. If the Handled property of ApplicationUnhandledExceptionEventArgs in App.xaml is set to false then JavaScript can capture the error (assuming you set the onError property on the control) and then you get your nice white screen of death. You can excute some js to reload the control.  I didn't demo this here as this plugin is running on my blog and I'd have to toss up some js to capture for it.

A decent book I’d recommend is this one:

 

 

 

Silverlight 2 Unleashed by Laurent Bugnion
Silverlight 2 Recipes: A Problem-Solution Approach by Jit Ghosh, Rob Cameron

Programming, SilverLight, VB.NET , , ,

Embedding SilverLight into my BlogEngine.Net site

3. May 2009
Comments (4)

Like others, people want to add SilverLight apps or plugins to their blog site and now so do I! However, on quick searching I found an Extension that I didn’t like. It’s using 1.0 older js file and seems ok but I wanted something more up-to-date. Others have pointed out flawless.code’s silverlight plugin but I kept looking.

I found a better one in my opinion, because it relies on me having the latest SilverLight.js file and I can put the content in another folder, which I am doing. So I tried out MonstersGotMy.Net’s SilverLight Extension for BlogEngine.Net and it was much more to my liking.

image

2009_3_SilverlightApplicationExtension.zip (1.51 kb)

My Website, Programming, SilverLight , ,