Typed DataSet & SQL XML/Urgently help needed.

[Linesh Gajera]

Hi Guys

i having the same problem with Strongly typed dataset, I have created
a stronsetly typed dataset by draging table from Server explorer and
now i have retreived xml from SQL server 2000 and tried to populate
dataset but it populates 0 rows even though ml contains rows. If i use
regular Dataset instead of Typed dataset, then everything works just
fine..please help me as soon as possible, here is my code snippet.

I think you have solution to this prolem and could you please code
snippet to solve this problem.

using Microsoft.Data. SqlXml;

private void button3_Click(o bject sender, System.EventArg s e)
{
String connectionStrin g =
"Provider=SQLOL EDB;Server=loca l);database=Opu s;user id=sa";

SqlXmlCommand command = new SqlXmlCommand(c onnectionString );

command.Command Text = "SELECT * FROM Contracts FOR XML
AUTO,XMLDATA";
command.RootTag = "root";

//dsContract is typed dataset created by dropping table for server
explorer
dsContract datasetContract = new dsContract();

SqlXmlAdapter adp = new SqlXmlAdapter(c ommand);
adp.Fill(datase tContract);

dataGrid1.DataS ource = datasetContract ;
}

but above code does not fill dsContract dataset even though sqlCommand
does retrive rows.

I am seeking help desparately.

Waiting for positive reply.

Many thanks in advance.

Linesh

[SQL Server Development Team [MSFT]]

Hi,

Have you tried :
DataSet ds = new DatSet(); ?
Thank you,
Monica Frintu

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Linesh Gajera" <li***********@ hotmail.com> wrote in message
news:22******** *************** ***@posting.goo gle.com...

Hi Guys

i having the same problem with Strongly typed dataset, I have created
a stronsetly typed dataset by draging table from Server explorer and
now i have retreived xml from SQL server 2000 and tried to populate
dataset but it populates 0 rows even though ml contains rows. If i use
regular Dataset instead of Typed dataset, then everything works just
fine..please help me as soon as possible, here is my code snippet.

I think you have solution to this prolem and could you please code
snippet to solve this problem.

using Microsoft.Data. SqlXml;

private void button3_Click(o bject sender, System.EventArg s e)
{
String connectionStrin g =
"Provider=SQLOL EDB;Server=loca l);database=Opu s;user id=sa";

SqlXmlCommand command = new SqlXmlCommand(c onnectionString );

command.Command Text = "SELECT * FROM Contracts FOR XML
AUTO,XMLDATA";
command.RootTag = "root";

//dsContract is typed dataset created by dropping table for server
explorer
dsContract datasetContract = new dsContract();

SqlXmlAdapter adp = new SqlXmlAdapter(c ommand);
adp.Fill(datase tContract);

dataGrid1.DataS ource = datasetContract ;
}

but above code does not fill dsContract dataset even though sqlCommand
does retrive rows.

I am seeking help desparately.

Waiting for positive reply.

Many thanks in advance.

Linesh