Learn, Troubleshoot BizTalk with Ashok Rajpurohit

Following SQL query is used to insert multiple record into table INSERT INTO tmpTable (field1, field2,field3) VALUES  ('74251', 'Black', '511black') INSERT INTO tmpTable  (field1, field2,field3) VALUES  ('74251', 'CharcoalF', '5145') INSERT INTO tmpTable  (field1, field2,field3) VALUES  ('74251', 'KhakiQ', '5165') INSERT INTO tmpTable  (field1, field2,field3) VALUES  ('74251', 'NavyA', '515') INSERT INTO tmpTable  (field1, field2,field3) VALUES  ('74251', 'OD', '511')

C# : Converting Stream to String and  String to Bytes Following code can be sued for converting stream to string and then stream to bytes. Stream Stream1 = bodyPart.GetOriginalDataStream();                              String test = new StreamReader(Stream1).ReadToEnd();                             System.Text.ASCIIEncoding encoding = new System.Text.ASCIIEncoding();                             Byte[] bytes = encoding.GetBytes(test);

Get MessageBodyPart as string in Custom Pipeline component execute method. In the follwoing code pInMsg.BodyPart is converted to String using stream. You can edit this messsage steam as per your requirement then assign to new message traceDataRequest.Message. Following code can be used for tracing the request message recived by BizTalk pipeline or to modifiy the request received. We have used eventlog entry to log the message for tracing.                            int bufferSize = 0x280; //  TODO move to external config                             int thresholdSize = 0x100000;   //  TODO move to external config              ...

SQL Query to get random records from table Following query is used to get random number of records from SQL table SELECT TOP 5 *   FROM [JukeBox].[dbo].[tbl_Debate]  ORDER BY NEWID() Following query is update with were clause SELECT TOP 5 *   FROM [JukeBox].[dbo].[tbl_Debate]   where ID not in (21,5,6,20,11,12)  ORDER BY NEWID()

SQL Query to check length of the field and using IF ELSE IF LEN ( @UserLike ) > 0 BEGIN UPDATE tbl_Kukoo SET UserLike = @UserLike where ID = @ID END LEN ( @UserLike ) > 0   - to get length of SQL field.

ASP.NET  : Regular expression to validate URL. Regex reg = new Regex(@" @"^(?:ftp|http|https):\/\/(?:[\w\.\-\+]+:{0,1}[\w\.\-\+]*@)?(?:[a-z0-9\-\.]+)(?::[0-9]+)?(?:\/|\/(?:[\w#!:\.\?\+=&%@!\-\/\(\)]+)|\?(?:[\w#!:\.\?\+=&%@!\-\/\(\)]+))?$ "); Response.Write(reg.IsMatch( txtwebsite .Text)); string regURL = @"^(?:ftp|http|https):\/\/(?:[\w\.\-\+]+:{0,1}[\w\.\-\+]*@)?(?:[a-z0-9\-\.]+)(?::[0-9]+)?(?:\/|\/(?:[\w#!:\.\?\+=&%@!\-\/\(\)]+)|\?(?:[\w#!:\.\?\+=&%@!\-\/\(\)]+))?$" ; if ( Regex .IsMatch(txtwebsite.Text, regURL)) { // string match with regExpression. } Else { //String does not validate }  

SQL TABLE ALTER SCRIPT Following script is used to alter sql table with default value. -- Adding Value with Default Value ALTER TABLE TableName ADD ColumnName INT NOT NULL DEFAULT ( 0 ) GO Script alter Column type ALTER TABLE mytable ALTER COLUMN mycolumn newtype