Recently I constantly encountered ‘Failed to Enable constraints…’ error when working with DataTables. .Net doesn’t provide any detailed information for this error.
This error might be due to
a) Query columns and Fill method columns mismatch
b) Column maxlength exceeded
c) Duplicate rows(when some join)
d) some other when loading data into the DataTable.
 
I have had used step through debug to know what caused this error and it was time consuming. But .Net provides a workaround solution for this in the form of DataTable GetErrors method. To know what exactly causing this error(column data), I have used below method to get all the DataTable errors that saved my debugging time.
 

[code:c#]

        public string GetErrors(DataTable table)
        {
            StringBuilder s = new StringBuilder();
             // Test if the table has errors. If not, skip it.
            if (table.HasErrors)
           {
              // Print the error of each column in each row.
               foreach (DataRow row in table.GetErrors())
              {
                  foreach (DataColumn column in table.Columns)
                  {
                      s.Append(column.ColumnName + "-" + row.GetColumnError(column));
                   }
                   // Clear the row errors
                   row.ClearErrors();
              }
            }

            return s.ToString();
        }

[/code]

Happy Debugging….
 

“Reference” comment in the JS file allows you to see JScript functions and objects from any external file whether it could be an another JS file or a web page or a web service or even an embedded resource.

The common usage is

[code:c#]

///<reference path=”path of webservice or jsfile or webpage” />

[/code]

or

[code:c#]

///<reference name=”resource-name” assembly=”assembly-name” />

[/code]

Example:

To reference Ajax library

[code:c#]

/// <reference name="MicrosoftAjax.js"/>

[/code]

 

Happy coding…

Welcome to my technical blog. Today I upgraded this site to BlogEngine.Net 1.4.5 with SQL Server as DB provider. What I noticed was BlogEngine.Net with roles will only run in medium trust or higher. I’m running this site on a shared hosting account, and custom overrides of trust configuration were not allowed. 

Initially I tried with SQLite DB(thought it would be more faster ). My hosting provider doesn’t allow to change default directory permissions. At last I switched to SQL server, site was running up with in few minutes.