Skip to main content

Related Articles

Loading...

Working With Dataset And XML In ASP.NET 2.0

XML data definition format is heavily used in nowadays applications since it is very rich data definition method. Working with XML data is very customizable, easy and reliable. Important features of XML language are;

  • well defined schema
  • purely character based data definition method
  • customizable tags
  • easy validation of XML documents
In ASP.NET it provides lot of shortcut methods to work with XML data. Actually .NET Frameworks most of the components fully based on XML languages. Few examples are Data Grid, Data Set and Class Designer etc. Due to this reason you can easily convert data in dataset to XML document and read data from XML document to feed into dataset. Why it is important to convert dataset into XML documents is a good question to analyze. There are few reasons to explain here, first thing is dataset is a kind of a special data format and not exchangeable with different applications. Transfer through web protocols is not straight forward with dataset, but XML data is based on characters and easily pass through the network. Most importantly validation of data is very easier with XML data that data in dataset. There are buit in validation functions with XML documents in ASP.NET.

Generate XML file from dataset

// Connect to database
OleDbConnection con = new OleDbConnection('');

// Create new dataset
DataSet ds = new DataSet();
// Create new data adapter
OleDbDataAdapter da = new OleDbDataAdapter();

// Create SQL command
OleDbCommand cmd = new OleDbCommand("SELECT * FROM tblMyData", con);

// Set SQL command to data adapter
da.SelectCommand = cmd;
// Fill dataset
da.Fill(ds);

// Write data from dataset to XML file called "YourXMLFile.xml"
ds.WriteXml("c://YourXMLFile.xml");

Read data from XML file and fill dataset

"WriteXML()" method is used to write XML data from dataset into physical file, memory stream or character stream. In same way you can use "ReadXML()" method to read data from XML file and assigned to dataset.

Comments

Post a Comment

Popular posts from this blog

The Power of ChatGPT and Whisper Models

A Deep Dive into Natural Language Processing Natural Language Processing (NLP) has seen a significant boost in recent years due to advancements in artificial intelligence and machine learning. Two models that have shown remarkable success in NLP are ChatGPT and Whisper. In this article, we will delve into the power of these models and their applications in the field of NLP. ChatGPT is a transformer-based language model developed by OpenAI that uses unsupervised learning to predict the next word in a sentence based on the context of previous words. ChatGPT is a generative model that is trained on large datasets of text, such as books and articles, and can be fine-tuned for specific tasks, such as question-answering or dialogue generation. ChatGPT is known for its ability to produce human-like text, making it an ideal tool for applications such as chatbots, content creation, and language translation. Whisper, on the other hand, is a paraphrasing model developed by Google that is based on...
Post a Comment
Read more

When Submit A Post To Pligg Site I Am Getting "Wrong Step" Error

Recently I noticed that my Pligg social bookmarking site does not get any new post from the community. Then I try to submit a post to the site and on the second step of the article submission page I got the error "Wrong Step". I was really confused and try to figure out the issue. When I search on the web, I found few answers and none of the solutions were addressed my issue. Some of the reasons that the support forums were discussed are: 1. "Wrong Step" error might occur due to new template you use for your pligg site. 2. Configuration changes, basically f_open() function configuration. Most of the time this could happen when your hosting company upgrade their servers or change the security configuration of their servers.
Post a Comment
Read more

SMPP protocol library for fast and easy SMSC(Short Message Service Centre) client development even for non-telecom guys

SMS sending through .NET C# is really easy. But most of the guys face many issues with SMSC client developments. SMPP protocol has many parameters to configure, but for simple SMPP gateway application you need very few of them to configure correctly. This article will cover how to implement SMSC client application using EasySMPP library. EasySMPP is a free SMPP library used by many people to implement SMS sending applications. There are many SMPP libraries but EasySMPP library is very easy to use and relatively stable. EasySMPP library mainly contain five class library projects. KernelParameters, SMPPClient, SMSClient, SMSService and Tools are the library projects and you only need to use SMSClient library to implement SMPP client application. First download EasySMPP library and add class library project to your .NET C# solution.  1. public bool SendSms( string from, string to, string text)
Post a Comment
Read more