Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

XML Database Question

JCrouchJCrouch Member Posts: 9
I'm switching my existing app which uses an Access database to a XML database. I imported the xml, created a schema and from that let C# make a dataSet class for me. I am able to bind the XML to a dataGrid and update it and all that. So far so good.

But how can I use Sql statements when only using XML?

db = new CHECKINGTRANS(); // Create a new dataSet off of my class
db.ReadXml("CHECKINGTRANSACTIONS.xml"); // Read the XML document

then I bind the data to the grid:

dataGrid1.DataSource = db.Tables[0].DefaultView;

How can I apply an Sql statement to the .ReadXml?


Comments

  • Shawn CarterShawn Carter Member Posts: 0

    ___ \ http://forcoder.org \ free video tutorials and ebooks about [ Delphi, Assembly, PHP, Java, Visual Basic, Ruby, Python, C#, PL/SQL, C++, Objective-C, Visual Basic .NET, Go, JavaScript, C, Swift, R, MATLAB, Scratch, Perl Prolog, Transact-SQL, Clojure, ABAP, SAS, Lua, Rust, COBOL, Crystal, Scala, Scheme, ML, Kotlin, Fortran, Dart, Apex, Awk, VBScript, Logo, LabVIEW, Julia, Alice, D, FoxPro, F#, Erlang, Hack, Lisp, Bash, Ada ] __

Sign In or Register to comment.