February 2004 Entries
BizTalk Orchestration DesignerVisually define and build robust, distributed business processes. Long-Running TransactionsEnsure transactional integrity on asynchronous transactions that span minutes, days, or even weeks. Concurrency and SynchronizationInitiate several independent business processes simultaneously and synchronize them at defined meeting points. Advanced Process CorrelationManage multiple independent simultaneous instances of business processes. Business Process State ManagementTrack...
Support for SOAP Version 1.1Get full support for the Simple Object Access Protocol (SOAP) 1.1 document envelope. Support for XML Version 1.0Get full support for Extensible Markup Language (XML) 1.0 data definition. Support for XSLTTransform documents between definitions by using Extensible Stylesheet Language Transformations (XSLT). Support for UN/EDIFACT and ANSI X12 EDIEnjoy support for United Nations Electronic Interchange for Administration, Commerce and Transport (UN/EDIFACT) and EDI standard...
BizTalk EditorEasily define and edit document schema for any structured document type, including XML, electronic data interchange (EDI), and flat files. BizTalk MapperBuild document maps that allow applications and business partners who use different document definitions to communicate with each other. BizTalk Orchestration DesignerVisually define and build robust, distributed business processes. BizTalk Messaging ManagerUse this wizard-based tool to rapidly define trading partner relationships....
Data Reader: Forward-only data read Equivalent to: Recordset's CursorType = adOpenForwardOnly, LockType = adLockReadOnly (often referred to as a "fire-hose" cursor) DataReader Four Execute Methods through Command object: ExecuteReader - Simply executes the SQL query against the database, using the Read() method to traverse through data, as illustrated below ExecuteNonQuery - Used whenever you work with SQL stored procedures with parameters, as illustrated in the Stored Procedures section below ExecuteScalar...
Using C#: using System.Data.SqlClient;...Sq... oSQLConn = new SqlConnection();oSQLConn.Co... = "Data Source=(local);" + "Initial Catalog=mySQLServerDBName;" + "Integrated Security=SSPI";oSQLConn.Ope... Using VB.NET: Imports System.Data.SqlClient...Dim oSQLConn As SqlConnection = New SqlConnection()oSQLConn.Con... = "Data Source=(local);" & _ "Initial Catalog=mySQLServerDBName;" & _ "Integrated Security=SSPI"oSQLConn.Open() If connection to a remote server (via...