Hi Mike,
I need to create the XML to a file (ie. F:\OutXml\filename) on disk so that I may email it as an attachment or send it directly somehow. I considered ftp the file. It may be the easy way.
What would be the coding to write the XML file to the dirctory and filename. What is the extension of the XML file ? .XML
Any easy way to create an email in vb and then send it via the pop3 email. Need to run a job that selects certain rows from an SQL table, format the data into an email format with the usual address stuff along with the message being the formatted data. Also need to be scheduled to run at say 1:30Pm daily.
Thanks for your help...
Roland
=========================================================================
>>I need to create an XML Table from a Windows Form using an SQL table as the source. Know very little about XML.
>
>
>SqlConnection data = new SqlConnection(connectionString);
>DataSet dataSet = new DataSet();
>SqlDataAdapter getTable = new SqlDataAdapter("select * from table", data);
>getTable.Fill(dataSet, "table");
>textBox1.Text = dataSet.GetXml();
>
>Does it need to be any fancier than that?