xml to dataset !!



Category : ASP & ASP.net

i use the following code to write sql data to xml file.

SqlDataAdapter ad = new SqlDataAdapter("SELECT name AS [@label], salary AS [@value] FROM Employee FOR XML PATH('set'),ROOT('chart')", cnn); cnn.Close(); DataSet ds = new DataSet("chart"); ad.Fill(ds,"set"); XmlDataDocument doc = new XmlDataDocument(ds); doc.Save(Server.MapPath(Request.ApplicationPath)+" .xml");

i get the file as

<chart><set><xml><chart><set label=""abcd value="abcd" /></chart></xml></set></chart>

i want to remove the first three tags; ie, <chart>,<set> and


View Replies
Tags : xml dataset

Related to : xml to dataset !!


Populating an ASP.Net Drop Down List with DataSet data from DataSet created with DataSet designer
Category : ASP & ASP.net

We have an ASP.Net / VB.Net web form containing a drop down list in the markup of the aspx file. There is also a DataSet created with the DataSet designer.


We would like to populate the drop down with data from the DataSet.


Can you show me some sample markup and / or VB.Ne


View Replies


How to update or refresh a Typed DataSet (xsd file) in the DataSet Designer in Visual Studio?
Category : ASP & ASP.net

Hi,

I am using typed dataset in my application and stored procedure.

I have added new field in the database table abc. and modified the stored procedure.

now i have configure the typed dataset in visual studio the new added field is show at the bottom of the dataset.

It is


View Replies


How to Connect Typed DataSet using DataSet.XSD file & Insert, Delete and Update the Database.
Category : ASP & ASP.net

Hi,

Today I am&nbsp; facing the problem with Typed DataSet using DataSet.XSd file, And How to fetch, Delete and Update the Database through Dataset.xsd file.



Prasanna y

&lt;input id=&quot;gwProxy&quot; type=&quot;hidden&quot;&


View Replies


Unable to cast object of type System.Data.DataSet to Typed DataSet
Category : Development
Hi everyone,
I currently develop an application in vs.net 2005 with vb.net.
I was trying to use typed dataset and Ive got in trouble for
converting untyped dataset
into Typed DataSet. I dont know why I cannot perform this casting
operation properly.
First off, Ive got

View Replies


ObjectDataSource tied to a Dataset/report.rdlc. How to set dataset contents on page load
Category : ASP & ASP.net

I have report.rdlc defined to use dataset1.&nbsp; dataset1 is defined to have 1 input parameter.

On the aspx page that holds the report viewer control, I have an ObjectDataSource&nbsp;defined to use a page control as the input to the DataSet1.

This works great for the initial


View Replies


copying a datatable content from an untyped dataset into a table which is inside a typed dataset
Category : Development
Hi Techies,
I am facing problem in copying content of table from a untyped dataset into
to a table inside the typed dataset. I wanted to copy the data into typed
dataset in order to ease the further processing using typed references.
DataSet ds = getDataFromDB(); - i am gettin

View Replies


webservice class inherite DataSet and client generate the force dataset issues
Category : Development
Using WebServices, and server add the new class PersonSet that inherite
DataSet,follow down:
public class PersonSet:DataSet
{
private string _strB;
public string strB
{
get
{
return _strB;
}
set
{
_strB=value;
}
}
public

View Replies


how to add stored procedure result set columns to Typed dataset and this dataset to RDLC file?
Category : ASP & ASP.net

Hi All,
Till now I used to design RDLC file before and assigned typed dataset table columns.Report processing mode is local. But now my stored procedure returns different columns based on condition i.e columns are not fixed every time. Now I need to add that columns to typed dataset and datase


View Replies


Ccopying a datatable content from an untyped dataset into a table which is inside a typed dataset
Category : Development
Hi All,
I am facing problem in copying content of table from a untyped dataset into
to a table inside the typed dataset. I wanted to copy the data into typed
dataset in order to ease the further processing using typed references.
DataSet ds = getDataFromDB(); - i am getting th

View Replies


Unable to cast object of type 'System.Data.DataSet' to Typed DataSet
Category : ASP & ASP.net

Hi every one,

I currently develop an application&nbsp;in vs.net 2005&nbsp;with vb.net.
I was&nbsp;trying to use typed dataset and&nbsp; I've got in trouble for converting untyped dataset
into Typed DataSet.&nbsp;I don't know why I cannot&nbsp;perform this casti


View Replies


2012 / 2017 Copyrights BigHow , All Rights Reserved .