XML file and Database
-
Hi all, I want to build an application in which I have an XML files which contains the connection string and credentials to connect to multiple databases. I want to connect to these databases and run a stored procedure on these database and close the connection. Can anyone guide how to proceed on this. I want to have front end which will fetch the data from the XML file for database connection, make the connection, run the stored procedure and Close the connection. Any Idea How can this be implemented. Sankalp
-
Hi all, I want to build an application in which I have an XML files which contains the connection string and credentials to connect to multiple databases. I want to connect to these databases and run a stored procedure on these database and close the connection. Can anyone guide how to proceed on this. I want to have front end which will fetch the data from the XML file for database connection, make the connection, run the stored procedure and Close the connection. Any Idea How can this be implemented. Sankalp
Just use XPath to select the nodes containing your connection strings, then use them to connect. Which bit are you stuck on ?
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
Hi all, I want to build an application in which I have an XML files which contains the connection string and credentials to connect to multiple databases. I want to connect to these databases and run a stored procedure on these database and close the connection. Can anyone guide how to proceed on this. I want to have front end which will fetch the data from the XML file for database connection, make the connection, run the stored procedure and Close the connection. Any Idea How can this be implemented. Sankalp
sir , i have a que is that how to acess xml in database ragini