Cyberactiva - webmaster tutorials, programming and videogames tricks

Home

Web Marketing

News

WebSerive DataSet

WebSerive DataSet

Hello,
I am quite new in asp.net, here is the code I retrieve data from a web service
SVP.ThisWebService.loadMethod lm = new SVP.ThisWebService.loadMethod();
System.IO.StringReader sr = new System.IO.StringReader(lm.loadXlm());
DataSet ds = new DataSet();
ds.ReadXlm(new System.Xlm.XlmTextReader(sr)) ;

Now, I have data in ds, what is the easiest way to dump this dataset into a
table?

Hi Altaf,
Thanks for the reply, as you see in the code my dataset is a new instance,
and filled in with ReadXMl, it is not linked to a table, I need to dump the
content to a sql server table. Any idea?

"Altaf Al-Amin Najwani" wrote:

> Hello,
> my friend Dataset is itselt mini database, When you load data into dataset ,
> you have already loaded data into table . You can access tables by
> DataSet.Tables[Tablename]. This is what you mean to say by loading?
>
> "JIM.H." wrote:
> > Hello,
> > I am quite new in asp.net, here is the code I retrieve data from a web service
> > SVP.ThisWebService.loadMethod lm = new SVP.ThisWebService.loadMethod();
> > System.IO.StringReader sr = new System.IO.StringReader(lm.loadXlm());
> > DataSet ds = new DataSet();
> > ds.ReadXlm(new System.Xlm.XlmTextReader(sr)) ;
> >
> > Now, I have data in ds, what is the easiest way to dump this dataset into a
> > table?

Yes you can insert data from dataset into sql server by using variety of
solutions. If you have loaded your data using dataadater then this is easy
but as have loaded xml into data set then you can do it by using OPENXML
avaiable by the SQL Server 2000, Make sure that your xml is relational and
you can use openxml to insert this xml as bulk data into sql server tables.
See following url

http://blogs.netindonesia.net/melvin/articles/1986.aspx

Tell me if my answer was helpful to you.

"JIM.H." wrote:

> Hi Altaf,
> Thanks for the reply, as you see in the code my dataset is a new instance,
> and filled in with ReadXMl, it is not linked to a table, I need to dump the
> content to a sql server table. Any idea?
>
> "Altaf Al-Amin Najwani" wrote:
> > Hello,
> > my friend Dataset is itselt mini database, When you load data into dataset ,
> > you have already loaded data into table . You can access tables by
> > DataSet.Tables[Tablename]. This is what you mean to say by loading?
> >
> > "JIM.H." wrote:
> > > Hello,
> > > I am quite new in asp.net, here is the code I retrieve data from a web service
> > > SVP.ThisWebService.loadMethod lm = new SVP.ThisWebService.loadMethod();
> > > System.IO.StringReader sr = new System.IO.StringReader(lm.loadXlm());
> > > DataSet ds = new DataSet();
> > > ds.ReadXlm(new System.Xlm.XlmTextReader(sr)) ;
> > >
> > > Now, I have data in ds, what is the easiest way to dump this dataset into a
> > > table?