Uncategorized

You can download training kit for biztalk 2010 with videos form this link
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c8fb51-a1e3-496e-841a-b48701a80c40

For the BizTalk solution deployment, strong key is required. For this purpose you have to create on. Open visual studio Command prompt, on my machine I have install visual studio 2008. I found from here.

Open it as administer option.   Write the following command at command prompt.

sn –k <file name>

for my case I generate the test.snk.

snk –k c:test.snk

You can copy this file in your BizTalk solution and used it in your application.

For detail information visit at following link:

http://msdn.microsoft.com/en-us/library/6f05ezxy%28v=vs.71%29.aspx

I got this error while working on BizTalk application development

Error Message: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

Solution i found

You would try to change the Receive pipeline to “XMLReceive”, instead of “PassThruReceive”, this way is worthy to try as one of the possibilities.

reference :

http://blogs.msdn.com/b/kerreybpi/archive/2007/06/07/biztalk-error-the-published-message-could-not-be-routed.aspx

very nice video about worring

[youtube=http://www.youtube.com/watch?v=3K4Sa6M_b9E]

Being a .net technologies guy I never be go on database level. but last night I have to face a small problem . I have to done 50000 record entries in one of table with relation to parent table. I used Pl Sql cursor. You already know much about Cursor they exists both in Oracle and Sql server and even My Sql. Following is a solution of insertion
Using Cusros so I insert 50000  in child table with respect to parent table..

DECLARE

/* Output variables to hold the result of the query: */

a Teacher.teacher_code %TYPE;

/* Cursor declaration: */

CURSOR T1Cursor IS
SELECT teacher_Code

FROM Teacher

FOR UPDATE;

BEGIN

OPEN T1Cursor;

LOOP

/* Retrieve each row of the result of the above query

into PL/SQL variables: */

FETCH T1Cursor INTO a;

/* If there are no more rows to fetch, exit the loop: */

EXIT WHEN T1Cursor%NOTFOUND;

/* Delete the current tuple: */

/* Insert the reverse tuple: */

INSERT INTO Teacher_ChildTable (Teacher_code,Class_code,Teaching_Mode,Period)    VALUES(a,’0324′,’01’,450);

END LOOP;

/* Free cursor used by the query. */

CLOSE T1Cursor;

END;

Have a nice day.

read the following link

http://www.asp.net/learn/whitepapers/aspnet40/

While searching the identifying and non identification releationship database concept.

An identifying relationship means that the child table cannot be uniquely identified without the parent. For example, you have this situation in the intersection table used to resolve a many-to-many relationship where the intersecting table’s Primary Key is a composite of the left and right (parents) table’s Primary Keys.

Example…
Account (AccountID, AccountNum, AccountTypeID)
PersonAccount (AccountID, PersonID, Balance)
Person(PersonID, Name)

The Account to PersonAccount relationship and the Person to PersonAccount relationship are identifying because the child row (PersonAccount) cannot exist without having been defined in the parent (Account or Person). In other words: there is no personaccount when there is no Person or when there is no Account.

A non-identifying relationship is one where the child can be identified independently of the parent ( Account – AccountType)

Example…
Account( AccountID, AccountNum, AccountTypeID )
AccountType( AccountTypeID, Code, Name, Description )

The relationship between Account and AccountType is non-identifying because each AccountType can be identified without having to exist in the parent table.

You can define the relationship type (identifying/non identifying) in the DeZign for Databases in the relationship dialog. Double click on the relationship line in the diagram window to display the relationship dialog.

reference : http://www.datanamic.com/support/relationshiptypes.html

Scenario I got while developing some application. I required month and year view in drop down list between contract starting and ending date. Like “March 2009” “April 2009” until march 2011 so on.

I handled it as follow

DateTime _LoopDate = “1/1/2009”;
string month = string.Empty;
DateTime _EndDate = “1/1/2011”;

while (_LoopDate <= _EndDate)
{
System.Globalization.DateTimeFormatInfo d = new System.Globalization.DateTimeFormatInfo();
month = d.MonthNames[_LoopDate.Month – 1];

drpDate.Items.Add(new ListItem(month + ” ” + _LoopDate.Year.ToString(), _LoopDate.Month.ToString() + ” ” + _LoopDate.Year.ToString()));
//drpdate is dropdownlist
_LoopDate= _LoopDate.AddMonths(1);
}

i found a use full regular expression vaildating input string, you can use it to filter sql injection attacks while taking input for username, title ect.

^[a-zA-Z]+(([.- ][a-zA-Z0-9 ])?[a-zA-Z0-9]*)*$