The important
namespaces that you have to import for working with XML and ADO.Net
in ASP.Net pages are System.Data, System.Data.OleDb or System.Data.SqlClient,
System.Xml, and System.Xml.Xsl
_______________________________________________
_______________________________________________
To
work with the ADO.Net you have to first open a connection object, for
example with an OleDbConnection. The connection string can be stored
in a string variable and this variable can be passed to the connection
object, to open a connection with the database.
Then create
a query string variable to hold the query and pass the connection object
and the query string to the DataAdapter object to create a DataAdapter.
Now create a DataSet object and fill the DataAdapter object with the
DataSet.
Now you
can close the connection. Now you can work with the dataset object to
display the data in the asp.net page.It is possible to create an xml
document from the data that is got in the dataset and transform that
document with the help of the xsl style sheet.
Recent Original Stories (OS News)
"One of the things my team has been working to enable has been the ability for .NET developers to download and browse the source code of the .NET Framework libraries, and to easily enable debugging support in them.
Related Articles (New Mobile Computing)
Apress' open source series of books recently unveiled Mark Mamone's " Practical Mono ", a book targetting new .NET developers. We take a quick look at the book below.