Thanks Erv for the explanation. I am outputting an xml file from this stored procedure where each row of the returned column is a line of xml.
I want to write this to a file so I have been taking the output from the DataTable, iterating through it and using a streamWriter.WriteLine to write each row. Can I write this output from the fill method directly to a fileStream of some kind and skip the extra steps? Rick -----Original Message----- From: Ervin Kleinschmidt [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 5:41 PM To: [EMAIL PROTECTED]; For users and developers of the Firebird .NET providers Subject: RE: [Firebird-net-provider] Call tableadapter stored procedurefromcode A data adapter object utilizes the Fill method to populate a DataSet or a DataTable object with data retrieved by a SELECT command. Internally, the Fill method makes use of a data reader to get to the data and the metadata that describe the structure and content of the source tables. The data read is then copied into ad hoc memory containers (that is, the DataTable). If the GetData method cannot find data in the specified format, it attempts to convert the data to the format. If the data cannot be converted to the specified format, this method returns a null reference (Nothing in Visual Basic). To determine whether data is associated with, or can be converted to, a format, call GetDataPresent before calling GetData. Call GetFormats for a list of valid formats for the data stored in this instance. Note Data can be converted to another format if it was stored specifying that conversion is allowed, and if the requested format is compatible with the stored format. For example, data stored as Unicode can be converted to text. Return Value from GetData will be a null reference (Nothing in Visual Basic). If you have a write with no results you could use the Getdata in Visual Basic Erv ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
