Monday, November 23, 2009

Microsoft Biz Talk Server 2009

Simply we can say the BizTalk is a Messaging Based Integration Tool and uses XML as the common data exchange language for eCommerce and application integration in the WWW. 

In other words we can say that BizTalk is the main interface in between multiple systems and based on some definitions we can say as "BizTalk Server is Microsoft's central platform for Enterprise Application Integration (EAI) and Business Process Management (BPM) and embodies the integration and automation capabilities of XML and Web Services technologies. BizTalk Server functions as a process execution engine and as a multi-transport hub for messaging and document transformations. It is a Windows Server System product that helps customers efficiently and effectively integrate systems, employees and trading partners".

Biz2009 BizTalk_bt_1

you can understand what is happening inside BizTalk by viewing the following animated jpeg file :


if you can’t view the animation please do not hesitate to click this link:

Monday, November 09, 2009

Cannot implicitly convert type 'System.DBNull' to 'int'

There will be situations where you have to set null values to an Integer field. So when you tried to assign a DBNull.Value to an integer varialbe you will prompt for the error : "Cannot implicitly convert type 'System.DBNull' to 'int' ".

to resolve this matter, let it be as its in the interface level, but at the time of passing the parameter to the Database just make it DBNull.Value.

'With your command object

1: myCmd.Parameters.Add("@myParameter",SQLDBType.INT).Value = IIf(myTextBox.Text <> "", myTextBox.Text, DBNull.Value)

another code snippet :
  1. if (Employee.EmployeeManagerID == 0) { AddParameter("@EmployeeManagerID", DBNull.Value, DbType.Int32, null, ParameterDirection.Input); } else AddParameter("@Manager",Employee.EmployeeManagerID, DbType.Int32, null, ParameterDirection.Input);

Microsoft JScript runtime error: 'Sys' is undefined

After some time back was working in a Development project and was came across an error :

Microsoft JScript runtime error: 'Sys' is undefined,

as i went on hunting for the solution for this there are so many answers i was able to find. But the error which was triggerd in my application was due to not specifying httphandlers and httpmodules handlers in web.conf file.

I will try to post the code later as for the moment i couldn't post html stuffs in blogger.