Hi, I have created a sub that will allow me to collect data from a sql database and save the results into an xml file as follows:
[HTML]Sub Page_Load(Sourc e as Object, E as EventArgs)
Dim strCon as string = ConfigurationSe ttings.AppSetti ngs("SystemConn ectionNew")
Dim strSQL as string = "SELECT Top 10 * FROM tbl_ACCO_EU_Con tacts"
Dim objDataSet as New DataSet()
Dim objCon as SQLConnection
Dim objAdapter as SQLDataAdapter
objCon = New SQLConnection(s trCon)
objAdapter = New SQLDataAdapter( strSQL, objCon)
objAdapter.Fill (objDataSet, "Records")
objDataSet.Writ eXml(Server.Map Path("xml_file. xml"))
end sub[/HTML]
What i need to know now is how to then send this file on to a client through a webservice.
Cheers
Adz
[HTML]Sub Page_Load(Sourc e as Object, E as EventArgs)
Dim strCon as string = ConfigurationSe ttings.AppSetti ngs("SystemConn ectionNew")
Dim strSQL as string = "SELECT Top 10 * FROM tbl_ACCO_EU_Con tacts"
Dim objDataSet as New DataSet()
Dim objCon as SQLConnection
Dim objAdapter as SQLDataAdapter
objCon = New SQLConnection(s trCon)
objAdapter = New SQLDataAdapter( strSQL, objCon)
objAdapter.Fill (objDataSet, "Records")
objDataSet.Writ eXml(Server.Map Path("xml_file. xml"))
end sub[/HTML]
What i need to know now is how to then send this file on to a client through a webservice.
Cheers
Adz