Hi,
There are 3 sales place, and the head office in different places. The data should be sent from sales place to head office. All sales place and head office using broad band router with high speed internet connection. All the sales place have output xml file, I need send this xml file to head office in every minute (1 transaction = 1 xml file). Im using VS2005 and sql server. My fren says, Ms-comm agent send xml file to head office. Is it possible? or any control available in vs2005 to send xml data?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi
another simple contribution
If all the sales place have a output xml file ! if they are able to host that xml file , then why not let the head office collect the xml data from each sales place instead ?
that way you would save all the trouble with sending files every minute , and it would only require a refresh timer from the application in the head office.
place a DataGrid1 on your form and imagine that this is the application in the head office that required online currencies data
Private Sub Opret_kildedata()
Dim reader As XmlTextReader = New System.Xml.XmlTextReader("
Dim dtbl As New DataTable
Dim dr As DataRow
Dim dv As New DataView(dtbl)
Dim objNodes As New System.Xml.XmlDocument
objNodes.Load(reader)
Dim oNodes As System.Xml.XmlNodeList
oNodes = objNodes.SelectNodes("//cu
dtbl.Columns.Add(New DataColumn("Currency", GetType(String)))
dtbl.Columns.Add(New DataColumn("Rate", GetType(String)))
Dim node As System.Xml.XmlNode
For Each node In oNodes
dr = dtbl.NewRow()
dr(0) = node.Attributes.GetNamedIt
dr(1) = node.Attributes.GetNamedIt
dtbl.Rows.Add(dr)
Next
DataGrid1.DataSource = dv
End Sub
the above code can off course be optimized to use stream and httpRequest's instead.
else for the most optimal solution you should adapt the suggestion provided by DarrenD.
vbturbo
Hi,
Thats a really neat solution vbturbo. I'm up to my eyes at the moment and I have training to give this week so I'm not in the office and so I won't be able to contribute more to this at the moment. Also I'm on holidays next week so if vbturbo wants to continue with the solution above or to show you the webservices one whichever you think, as I just have too much on this week.
Hope it all goes well.
Darren
Business Accounts
Answer for Membership
by: DarrenDPosted on 2007-01-19 at 07:56:04ID: 18350009
Hi,
There are a few solution to you problems,
Simple Solution:
You could just create a small application to FTP the file's from the three shops to the head office and then have a SQL Server run a Job which checks (polls) a certain directory , reads the XML file and performs the insert into the database when there is a file there.
You should probably store more than one transaction in an XML file but if that's what you need then go with it.
More Advanced:
You could create a webservice in the head office. Your application could then call the weservice and pass the XML as a string to the webservice and let the webservice perform the insert.
Or
Use MSCOMM32.OCX
There are loads of different ways fo doing this all you have to do is decide how much reliability, effort and time you have to get it done in.
Hope this helps,
Darren