hi there i need a simple app that takes XML form and update or add it into MS SQL database
i have the XML file and i have the MS SQL update and insert commands all i need is for someone to make me a simple UI for the user to open the XML file and hit Update and it will update or insert into the MS SQL
thank you
Hello,
As an expert .Net developer and having sound knowledge in ms sql server, i am very much interested to do this project. Please let me see the xml file.
Thanks
Hi,
I am experienced .NET full stack developer having 7.5+ years of experience and have already did similar functionality.
I can do update the XML file to SQL server database as well I can do validation to avoid in valid data or if record doesn't exists into database and user will try to update then it will show message and if we have to return result file if there is any error.
Also if you would like to do in web or window, I can do it for you and recently I did same way for Lead and if there is duplicate or existing then update.
I can deliver work on time with very good quality.
Please let me know if you need any further information from me.
Please can you send me sample xml file and database script if you have.
Thanks.
Regards,
Nagajan Kariya
Seems a very easy requirement but I don't want to comment until I will not check the XML file and your ready database. So, I am requesting you to send me all the details so that I can investigate on it and can give you a final confirmation.
Look, to be very honest, I don't want to commit anything until I am not 100% clear with the requirement. I hope you will not sense it my negative character :)
Will wait for your message to move further.
Hi,
It will be achieved by designing a C# win-forms application that will have option to choose a file using windows file dialog. There will be Update button to connect with SQL Server and pass XML to process it. Proper error handling and logging will be implemented. OPENXML will be used to parse input xml in SQL Server.
I have 10 years experience in development and worked on many C# win-forms applications with SQL Server as back-end. Involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views.
Thanks
Hi,
Greeting! Hope you are doing well
Please initiate chat to discuss your requirement in details.I will create a simple web app which will allow you to browse and upload the XML file and it will insert the record into the desired MS SQL Database table .
8 years of experience as full stack ASP.net Developer
Thanks
Karun
Hello
I am professional Windows desktop developer, i am experienced in both XML and SQL processing.
I need XML file to calculate time needed to complete task, but it shouldn't take more than few hours.
I'm available, i can start right away
Hello, I read your whole proposal, and thanks for your post on my good experience.
This is very good job for me.
So I think I can do this in high quality.
My releavant skill is:
NET, C# Programming, Microsoft SQL Server, SQL, XML
I want to further discuss with you.
I look forward to working together in partnership on your project and into the future.
Regards
I can create simple GUI app that will allow you to select XML file (using standard File Open dialogue) and click Update button to insert/update information into MS SQL database).
All I need to start is XML sample and your database schema.
Thanks.
Roman
seems like a super-quick to do work, I can make a minimal UI with Python (using MS-SQL module, easy) you can run it in Windows with no pain!
I suppose you have INSERT/UPDATE commands already configured for your XML data and corresponding DB ?
Hi
I'm an expert in .Net technologies and SQL Server.
I have been working in software development for the last 20 years
I'm a specialist in web solutions and desktop applications
I'm also available 24 x 7
Regards
Carlos
I have more than 11 years of professional software development experience mainly but not limited to Microsoft Technologies as a full-stack developer. I have previous experience on application development, XML and MS-SQL database.
Hi there,
It is a easy job, so that I can do it in less than 2 hours. Please let me help you. I only get money after I deliver code and application to you, because I would like to work for a long term.
Regards,
Nguyen Chi Thanh
Hello Sir,
For this we can do like provide a UI to upload a XMl file on uploading file user can review the by clicking grid which will filled immediately after upload process and once he/she reviewed the data, user can finally update the data by clicking on Update button, which stores data into server by using command you have. Below are the process I am thinking about.
1) On uploading file I will store it on server and returns all data in JSON format which bind user side grid.
2) User can review the data and initiate update process.
3) On success all controls reset to normal
Many Thanks,
Nirmal
Hello Sir
> You want to store the XML Object in database?
> Or you want to parse it first and want to create column for each xml node, sub node there relationship etc?
> I can give you super easy UI, do you need it to be in winform or web page?
I can do this task for you super fast. as i have super extensive 6 years of experience with .NET.