[thelist] iterate through SQL results without knowing columnnames

[Anthony Baratta]

here's an quick non-working example using the function call I sent you:

 FileInfo scanLog = new FileInfo(sLog);

DataSet dsDBData = db.execSPForDataSet("[SP_GET_TABLE_DATA]", "dataSetName", htParameters);
        DataColumnCollection dcColumns = dsDBData.Tables[0].Columns;
        foreach(DataRow myRow in dsDBData.Tables[0].Rows)
        {
            string sText;
            foreach( DataColumn dColumn in dcColumns)
            {
                sText += "|" + myRow[dColumn.ColumnName.ToString()].ToString();
            }

            using (StreamWriter sw = scanLog.AppendText())
            {
                sw.WriteLine(sText);
            }


-----Original message-----
From: "Joel D Canfield" joel at streamliine.com
Date: Thu, 09 Aug 2007 16:29:10 -0700
To: "Anthony Baratta" anthony at baratta.com, thelist at lists.evolt.org
Subject: RE: [thelist] iterate through SQL results without knowing columnnames

> > Here's an example from my code base that opens an SQL Adapter 
> > Connection and dumps that to a dataset object. Then with the 
> > dataset object you can do your business with the data returned.
> 
> er, how? is there a way to just write the contents of the dataset to a
> text file? I'm comfortable with creating, writing, appending
> to/from/with text files, just don't know how to get the dataset from an
> object to text to put in the file.
> 
> thanks, yet once again
> 
> joel
>