Lengkap

Load XML file into database (C#/SQL)

I need a C# function that can take a specified XML string and convert it into a SQL table with a few (4-8) additional simple fields added that are not in the XML. The C# function will validate each field based on the PAD specification format. If a field fails validation, the function will return an appropriate identifying error. If all of the XML fields are correct, the fields are saved to a new record in the database.

The PAD specification has Regex validation on every field and the function should account for that, as well as the SQL data field.

The XML is complicated, but you can likely just convert it to XSD and use that as the basis for the database creation.

The PAD format is very well-documented.

[login to view URL]

[login to view URL]

[login to view URL]

What I expect:

Create a small winform project that demos the function. Visual Studio 2017, C# .net (4.6~)

Create a new database and table for the PAD structure and other additional columns.

Create a form with a multiline textbox that you paste in the XML. A button calls the function and imports that XML into the database table in the appropriate fields or throws an appropriate error.

Kemahiran: Pengaturcaraan C#, SQL, XML, .NET

Lihat lagi: dumping xml file database contents, xml file database using vbnet, save xml file database, example xml file database vbnet, inser xml file database, net insert xml file database, sql server insert xml file database, xml file database table php, insert xml file database vbnet, aspnet vbnet insert xml file database, load excel file database php function, procedure sql insert xml file database, save xml file database php, insert xml file database sql server xml type, import xml file database using php, large xml file database php, load csv file to azure sql database

Tentang Majikan:
( 5 ulasan ) Clearwater, United States

ID Projek: #20236347

Dianugerahkan kepada:

                                                    okzhang321
                                                's Profile Picture"                                                    >
                                                </a>
                                            </figure>
                                        </div>
                                        <div class=
okzhang321

Hello. ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time. I am well experienced and skillful C# and SQL programmer. I ha Lagi

$100 USD dalam sehari
(27 Ulasan)
5.1

23 pekerja bebas membida secara purata $189 untuk pekerjaan ini

Piao217

Hi I see you are looking for someone to read xml file and convert into SQL Table. I am expert in C , C++, C#, .NET Framework, Software Architecture, Python, Java, SQL, etc.. So I am very interested in your project and Lagi

$250 USD dalam 7 hari
(89 Ulasan)
7.5
adeelpirzada

Hi Good Day, My video portfolio: [login to view URL] My Reputation: I am rated in top 3% freelancers here on my .Net C# Programming skills. I have completed numerous projects on MVC and .Net Cor Lagi

$175 USD dalam 7 hari
(30 Ulasan)
6.3
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. Here are my working result in c# [login to view URL] h Lagi

$155 USD dalam 3 hari
(24 Ulasan)
5.3
naryl

Hello. This project can be very clearly broken up in pieces, that's: 1. Reading the XML. 2. Creating the database according to XML schema. 3. Validating fields according to PAD 4. Writing the data. 5. Winforms GUI. I c Lagi

$250 USD dalam 7 hari
(18 Ulasan)
4.9
wulongzhu87

Hi there! My name is Longzhu and I’m a professional developer with 7+ years of experience. I'm honesty, communicable, responsible and passionate about web programming holding my hand on a pulse of a new technologies e Lagi

$200 USD dalam 5 hari
(5 Ulasan)
5.0
trustworthyDev

Hi, I have already worked to convert XML data into the database and c# is my favorite language. I will implement your features according to PAD specification and create it using Win Form Solution. Feel free to contact Lagi

$800 USD dalam 7 hari
(4 Ulasan)
4.9
angnut

Hello, I am very much interested in working with you on this project. I have a lot of experience on import data using C#, SQL and XML (or other format). Please contact me to start. Angelo

$190 USD dalam 4 hari
(9 Ulasan)
4.6
xinglong717

I have many experiences in java, SQL, data process. I can show you my projects via chatting. I can complete your project successfully. Thanks.

$250 USD dalam 7 hari
(18 Ulasan)
4.7
maryumakhter5

Greetings I am an experienced ASP.NET developer with six years behind the keyboard. I have been on the lookout for new opportunities and was fortunate enough to come across your current listing on the Live Career webs Lagi

$140 USD dalam 7 hari
(7 Ulasan)
4.0
TakaAlex

Hi there! Much interested in your project. I can do it in a 5 hours hire me, Thanks --------------------------------------------------------------------

$140 USD dalam sehari
(6 Ulasan)
4.0
TalAkerele

HI.dear. Nice to meet you. Happy to bid your project. I am very interested in your project. I read your requirements carefully.I see what you mean. I have so many experiences with xml,.net,C#,vb.net,sql, I'd like to wo Lagi

$100 USD dalam sehari
(6 Ulasan)
3.4
bluestar1027

Hello. How are you? I have read your requirements carefully. Your post for the project stood out to me because it is extremely similar to the work I’ve provided for many of my other clients. The biggest mistake I’ve s Lagi

$140 USD dalam 7 hari
(7 Ulasan)
3.6
xiaowu81

Hi I am c sharp expert. I have good experience with xml. Xml is used for input or output and is saved into db in my progrmas(ExecuteXmlReader()). I finished many programs(desktop LED, android, ios) such as UWP, Xamarin Lagi

$250 USD dalam 7 hari
(3 Ulasan)
3.4
HighDevleoper

Hello, We are IT-Engineers and Business Analysts, creating complete web and mobile solutions, for already more than 10 years, supporting our products with custom digital marketing strategies and instruments. We Exper Lagi

$50 USD dalam sehari
(3 Ulasan)
3.1
logos106

Hello, Sir. I am so interested in this work and would be happy if I can do it for you. I have Visual Studio 2017 Community Edition installed now and have been using it for developing C# applications. Also I have good Lagi

$120 USD dalam 7 hari
(2 Ulasan)
2.3
susanna2018

⭐⭐⭐ Hi, Dear client. ⭐⭐⭐ I'm very interested your project. I read your description carefully. I'm very talented C# developer. if you assign to me this project, you can get a cool result. please contact me. thanks. Lagi

$140 USD dalam 7 hari
(2 Ulasan)
2.1
Friends4it

We already have built large scale applications, CRMs, ERPs and huge systems can be found at our website. Like [login to view URL] [login to view URL] [login to view URL] [login to view URL] https: Lagi

$250 USD dalam 7 hari
(4 Ulasan)
5.4
realstar84

Hello! I recently have developed Freight Booking System with C#, .NET, MSSQL Server, ASP.NET MVC. You can check our website here: https://www.mainfreight.com. I have 5+ years of experience in .NET Software Development. Lagi

$150 USD dalam sehari
(1 Ulasan)
0.7
farmanali0124

Hi there, I have checked the details. I have rich experience with .NET, C# Programming, SQL, XML. Please initiate the chat so we can discuss this job in detail. I am new to freelancer.com but I assure you that I can d Lagi

$155 USD dalam 6 hari
(0 Ulasan)
0.0
dreamgirl1992010

Hello, Sir I have just read your requirements and I can help you with my skills and experiences. I am an expert in C# programming with rich experience. I am sure that I will make the perfect product you are satisfied w Lagi

$70 USD dalam 7 hari
(0 Ulasan)
0.0