There are many techniques of using SQLXML and .NET for data integration let us have glance at all those ways in a nutshell the sql client data provider supports Execute xml reader it can consume directly the result of it in order to do the xml query the xml reader might be used directly. In order to serialize the resulting document to a stream for transmission to a biz talk server. The document can be serialized to disk by using an xml text reader. And this can be read directly into the data set.Certain precautions should be taken before
"The SqlClient data provider supports ExecuteXmlReader, a provider-specific method on the SqlCommand class. Rather than provide a SqlDataReader to process the result of a SQL query, ExecuteXmlReader produces an XmlReader, which can be used to directly consume the results of a SELECT ... FOR XML query. The XmlReader might be used directly—for example, to serialize the resulting document to a Stream for transmission to a BizTalk server. The document could be serialized to disk by using an XmlTextReader. It could be read directly into the DataSet by
Overview
Data binding provides a way for developers to create a read/write link between the controls on a form and the data in their application (their data model). Classically, data binding was used within applications to take advantage of data stored in databases. Windows Forms data binding allows you to access data from databases as well as data in other structures, such as arrays and collections.
Binding Context
Each Windows Form has at least one BindingContext object that manages the CurrencyManager objects for the form. For each data
At the time of this writing (June 2005), the standard Windows Forms .NET TreeView control doesn't support the concept of databinding like the ASP.NET TreeView control does. So, we are left writing our own solutions. Recently, I was assigned a UI project exploration task regarding the use of databinding with the Windows Forms .NET TreeView control. This functionality would enable us to quickly develop user-friendly ways to create complex data analysis models for a new application we're designing. By the time I was done, I had written a custom class