Re: xml - C# Discussion Boards

Re: xml Document

arkiboys12-Oct-09 19:55

arkiboys

12-Oct-09 19:55

ok, thanks

Learning foreach...

JollyMansArt12-Oct-09 13:12

JollyMansArt

12-Oct-09 13:12

What I would like to do is instead of manually parsing for each table and row. I would like to learn how to do a foreach to dynamically find each table and each row in a database. Here is what I curently have, All I am asking is how to use the foreach command to do this.

1) How would you say:
foreach(table in database)

then how would you say
foreach(row in table)

New experimental project I am playing with. I will post back when I find something. Just thought I would ask.

string sConnectString = "Driver={QODBC Driver for QuickBooks};DFQ=C:\\Quickbooks\\sample_company_file.qbw;OpenMode=M;OLE DB Services=-2;";
           string sSQL = "SELECT Name FROM Employee";

           OdbcConnection cn;
           OdbcCommand cmd;

           //string MyString;
           //MyString="Select * from Customers";
           //cn = new OdbcConnection("Driver={SQL Server};Server=mySQLServer;UID=sa;PWD=myPassword;Database=Northwind;");

           cn = new OdbcConnection(sConnectString);
           cmd =new OdbcCommand(sSQL,cn);


           //cn.Open();
           //MessageBox.Show("Connected");
           //cn.Close();

           try
              {
                 cn.Open();
               MessageBox.Show("open");
               //odbcconnection1.GetSchema("tables")
               //odbcconnection1.GetSchema("columns")
               //http://www.daniweb.com/forums/thread194354.html
               OdbcDataReader dr = cmd.ExecuteReader();

               dr.GetSchemaTable().
               MessageBox.Show(dr.GetSchemaTable().TableName);





              }
           catch (OdbcException ex)
              {
                 MessageBox.Show(ex.Message);//<BR/>   There should be no <BR/>
              }
           finally
              {
                  cn.Close();
              }

Re: Learning foreach...

Luc Pattyn12-Oct-09 13:37

Luc Pattyn

12-Oct-09 13:37

Hi,

1.
obviously you get all rows in a table by selecting everything as in "SELECT * FROM tablename", so just skip the WHERE clause.

2.
how you get information on the tables themselves probably depends on the database; in MySQL it simply is "SHOW TABLES"

Look in the documentation for your database!

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: Learning foreach...

OriginalGriff12-Oct-09 22:20

OriginalGriff

12-Oct-09 22:20

JollyMansArt wrote:
1) How would you say:
foreach(table in database)

then how would you say
foreach(row in table)

foreach is not a realy usable construct for examining database tables, I would normally use

reader = sqlCmd.ExecuteReader();
while (reader.Read())
    {
    ...
    }

Think about it: if you were dealing with a file, you would say:

string[] lines = inFile.ReadAllLines();
foreach(string s in lines)
   {
   ...
   }

rather than trying:

foreach(LineOfText line in inFile)
   {
   ...
   }

You can't use foreach for the columns, either - there isn't an Items collection - but even if you could, it really wouldn't be too helpfull:

foreach(var v in reader.Items)
   {
   ... Workout what type it is and what to do with it...
   }

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

dataGridView and dataView

mahraja12-Oct-09 12:51

mahraja

12-Oct-09 12:51

Hi I have a datagridview (in a windows application) which its data comes from executing a StoredProcedure. This SP joins two tables and derives the data needed.

what is the role of dataview in inserting a new row and updating dgv rows (and validating them) and delete rows?
Can a dataview save these changes? and somehow apply them to the DB all toghether?
I've done these before by applying every change to the DB and refill the dgv after that. But I think it's not the right way. and I didn't find a full sample that can guide me through this.

next, to search in dgv and find the word that user wants, and somehow specify the found results (for example bolding the found words) in dgv. how it should be done? by dataview?
please help

xml

arkiboys12-Oct-09 11:25

arkiboys

12-Oct-09 11:25

Hi,
I have an xml file with about 50, 000 records.
Each record has a lot of hierarchy i.e. elements, sub-elements...
I would like to be able to do the following i.e.

1-search for a value in one of the elements
2-delete a row i.e. a sub-element in an element
3-modify a row

What is the best way to start this with?
Should I use xmlDocument?

Thanks