P
Peter Savas
I am new to programming in C#, but have been a VB coder for 16 years,
and am facing a problem which I could use some help with:
I have an XML file which I am reading into a C# DataSet object with the
following line of code:
ds.ReadXML(InputFileName);
Against this DataSet, I need to be able to run SQL Queries, with the
ultimate goal of inserting (almost) all of the data in the DataSet into
table structures on an SQL Server.
Is there a way to execute T-SQL statements against the DataSet object?
In particular, I need to exclude certain records based on CAST
transformations, and then INSERT the remaining records in the DataSet
into the server-hosted tables. I would prefer not to step through the
records one at a time if possible.
Any help would be appreciated.
Thank you,
pete
and am facing a problem which I could use some help with:
I have an XML file which I am reading into a C# DataSet object with the
following line of code:
ds.ReadXML(InputFileName);
Against this DataSet, I need to be able to run SQL Queries, with the
ultimate goal of inserting (almost) all of the data in the DataSet into
table structures on an SQL Server.
Is there a way to execute T-SQL statements against the DataSet object?
In particular, I need to exclude certain records based on CAST
transformations, and then INSERT the remaining records in the DataSet
into the server-hosted tables. I would prefer not to step through the
records one at a time if possible.
Any help would be appreciated.
Thank you,
pete