Help needed - unwanted regular expressions returned in query

[S. H.]

I am using a small function to return information from an Access
database.

Whether I use xml formatted text or otherwise, the results are
returned to me in a formatted way. I'm new to C#, so I'm not certain
if I'm missing something or this is just the tough breaks with this
language. What I need is either a proper way of extracting the data
need WITHOUT the regular expressions or a work around - some way to
parse the results.

Here's the function that returns the code -- very basic stuff:

public DataSet DataQuery(strin g dbConnectionStr ing, string
sqlStatement)
{
OleDbConnection conn;
OleDbDataAdapte r cmd;
DataSet results = new DataSet();

conn = new OleDbConnection (dbConnectionSt ring);
cmd = new OleDbDataAdapte r(sqlStatement, conn);
conn.Open();
cmd.Fill(result s);
conn.Close();
}

Here is a sample of the data in the field I am returning, taken
straight from the database:

<?xml version="1.0" encoding="utf-8" ?>
<HCData HCDataID="0" Version="1.0" >

Here's what it looks like after the results dataset is filled:
<?xml version=\"1.0\" encoding=\"utf-8\" ?> \r\n<HCData HCDataID=\"0\"
Version=\"1.0\" >

Even with a regular statement - it adds the unwanted expressions:

Test = "test"
Test = \"test\"

Any help on this issue would be most appreciated!

S.H.

[Dmitriy Lapshin [C# / .NET MVP]]

Hi,

How do you actually retrieve the resultant data from the data set? And where
do you see the result being escaped? Do you inspect a data row in a Watch
window?

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"S. H." <ms*@plantdata. com> wrote in message
news:39******** *************** ***@posting.goo gle.com...

I am using a small function to return information from an Access
database.

Whether I use xml formatted text or otherwise, the results are
returned to me in a formatted way. I'm new to C#, so I'm not certain
if I'm missing something or this is just the tough breaks with this
language. What I need is either a proper way of extracting the data
need WITHOUT the regular expressions or a work around - some way to
parse the results.

Here's the function that returns the code -- very basic stuff:

public DataSet DataQuery(strin g dbConnectionStr ing, string
sqlStatement)
{
OleDbConnection conn;
OleDbDataAdapte r cmd;
DataSet results = new DataSet();

conn = new OleDbConnection (dbConnectionSt ring);
cmd = new OleDbDataAdapte r(sqlStatement, conn);
conn.Open();
cmd.Fill(result s);
conn.Close();
}

Here is a sample of the data in the field I am returning, taken
straight from the database:

<?xml version="1.0" encoding="utf-8" ?>
<HCData HCDataID="0" Version="1.0" >

Here's what it looks like after the results dataset is filled:
<?xml version=\"1.0\" encoding=\"utf-8\" ?> \r\n<HCData HCDataID=\"0\"
Version=\"1.0\" >

Even with a regular statement - it adds the unwanted expressions:

Test = "test"
Test = \"test\"

Any help on this issue would be most appreciated!

S.H.