[thelist] iterate through SQL results without knowing column names

[Anthony Baratta]

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.

        public DataSet execSPForDataSet(string sConnectString, string sProcName, string sDataSetName, Hashtable htSQL)
        {
            SqlConnection dbConn = new SqlConnection();
            DataSet ds = new DataSet();
            SqlDataAdapter sqlAdpt = new SqlDataAdapter();

            try
            {
                dbConn = OpenConnection(sConnectString);
            }
            catch
            {
                return ds;
            }

            SqlCommand cmd = new SqlCommand(sProcName, dbConn);
            cmd.CommandTimeout = cmdTimeout;
            cmd.CommandType = CommandType.StoredProcedure;

            AddSqlParameters(cmd, htSQL);

            try
            {
                sqlAdpt.SelectCommand = cmd;
                sqlAdpt.AcceptChangesDuringFill = false;
                sqlAdpt.Fill(ds, sDataSetName);
            }
            catch (Exception exp)
            {
                dbConn.Close();
                DBError(exp, "execSPForDataSet: sqlAdpt.SelectCommand/Fill (" + sProcName + ")");
                return ds;
            }

            dbConn.Close();
            return ds;
        }

-----Original message-----
From: "Joel D Canfield" joel at streamliine.com
Date: Thu, 09 Aug 2007 15:22:24 -0700
To: thelist at lists.evolt.org
Subject: [thelist] iterate through SQL results without knowing column names

> I need to write the results of a SQL query to a textfile using ASP.NET -
> the problem is that the query, which I don't have access to change, is a
> 'select * from blah' query so I can't iterate through the values and
> write each one into a CSV file.
> 
> Is there a way to iterate through each row, then through each field,
> without knowing what the column names are?
> 
> Or, in fact, what db this is talking to, other than it's probably not
> MSSQL, and might be Access.
> 
> Thanks.
> 
> joel
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
>