ASP.NET: How to read XML Data String to Dataset

The output of XML String:

<?xml version="1.0" encoding="utf-8" ?>
- <NewDataSet>
- <Table>
 <CONDOM>Durex</CONDOM>
 <SIZE>XL</SIZE>
 <QTY>123</QTY>
 <COLOR>616</COLOR>
 </Table>
 </NewDataSet>

In order to convert from XML to dataset, this is the code:

     Dim MyDS as new Dataset("Table1")
     Dim strReader As StringReader = New StringReader(YourXmlString)
     MyDS.ReadXml(strReader)

Tags: ASP.NET, Convert xml to dataset, dataset, How to convert XML data of web service into DataSet, How to read XML Data String to Dataset, XML

Related Posts
Comments (0)

No comments yet.

No trackbacks yet.

VB.NET – ASP.NET communication between user control and web page using event handler

April 21, 2011 - 5:09 pm

Posted in ASP.NET | No comments

In this post, we want to show how button in user control communicate with web page in asp.net
First create user control called button.ascx.
Add 3 button, name it btnSave, btnEdit and btnCancel.
in button.ascx back code, add this code:

Public Partial Class button
Inherits System.Web.UI.UserControl
Public Event btnSaveHandler As System.EventHandler
[...]

How to set command Timeout for getData() in TableAdapter

February 4, 2010 - 11:26 am

Posted in VB.NET | 1 comment

One of the disadvantages when we using tableadapter to retrieve the data from database is they do not provide property to set command timeout (SHIT). This giving me a huge headache for my project which most of the entire project is using tableadapter instead of creating my own DAL or class.
After do some research on [...]

ASP.NET: Convert String XML to XML Node

December 2, 2009 - 1:42 pm

Posted in VB.NET | No comments

For example I have string value like this:

<?xml version="1.0"?>
<Product type="Condom">
<CondomName>durex</CondomName>
[...]

ASP.NET: How to use Javascript alert inside AJAX UpdatePanel

December 2, 2009 - 1:12 pm

Posted in VB.NET | 1 comment

Normally when we add Javascript Alert to our asp.net it will be like this:

Page. ClientScript.RegisterStartupScript(this.GetType(), "winPop", "alert(’Update is successful’)

but this code is not working if you using the code inside update panel.

So in order to add javascript in update panel you need to register you client script to your script manager as shown below:

ScriptManager.RegisterClientScriptBlock(Page, [...]

ASP.NET – Convert CSV to Dataset

July 17, 2009 - 6:29 am

Posted in VB.NET | 1 comment

In this post I will show you how to convert from .csv files to dataset in ASP.NET

Here is the function to convert CSV file to dataset in asp.net using vb.net.
First you need to upload the csv file into your web server, then save the file path.
Add this function code:

Private Shared Function [...]

Connecting asp.net to Sql server 2005 stored procedures into dataset

June 10, 2009 - 7:20 am

Posted in VB.NET | No comments

This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter.
1 step create store procedure

Create Procedure GetAuthorsByLastName1 (@au_lname varchar(40), @RowCount int output)
as

select * from authors where au_lname like @au_lname;

/* @@ROWCOUNT returns the number of [...]

Sending Email by your own Gmail account + Attachment using ASP.NET 2.0 and VB.NET

June 6, 2009 - 6:28 pm

Posted in VB.NET | No comments

First of all, you need need to set something in your gmail account to enable sending email using asp.net
1. Open you gmail account and go to setting
2. Click on Forwarding and POP/IMAP
3. Choose Enable POP for mail that arrives from now on
4. Click save changes
Here is the code for sending email from asp.net by using [...]