.Net Application to Query MS SQL Database
£20-250 GBP
Bezahlt bei Lieferung
We require a vb.net application to query a MS SQL Database. Will need to query 3 different databases and each database has different various queries that need to be executed. Connection to the SQL Server must be via Trusted_Connection. Various settings must be stored in a configuration file.
Queries will need to be executed in the order they are listed. FROM and TO dates must be replaced, FROM_DATE will equal LAST_RUN_DATE minus 24hours and TO_DATE will be current date and time. LAST_RUN_DATE must be updated.
Query can be posted to a URL and saved as files on the system with both needing the option of either CSV or XML formatting. When dealing with the result of the queries, need to properly deal with escaping special characters.
When posting to an address, need to keep a log of whether it was successful or not.
EXAMPLE SETTINGS FILE
connection:
SERVER: 'sage200'
Trusted_Connection: TRUE/FALSE
database:
1: 'DATABASE1_NAME'
2: 'DATABASE2_NAME'
3: 'DATABASE3_NAME'
queries:
QUERY1: "SELECT * FROM SYSCountryCode WHERE [login to view URL] >= '{{FROM_DATE}}' AND [login to view URL] < '{{TO_DATE}}'"
QUERY2: "SELECT * FROM StocktakeType"
QUERY3: "SELECT * FROM StocktakeSelector"
QUERY4: "SELECT * FROM AnalysisCodeValue WHERE [login to view URL] >= '{{FROM_DATE}}' AND [login to view URL] < '{{TO_DATE}}' AND [login to view URL] IN(SELECT [login to view URL] FROM AnalysisCode)"
variables:
LAST_RUN_DATE: '09/23/2022' (mm/dd/yyyy)
output:
file:
enable: TRUE/FALSE
location: 'C:\Documents\{{DATABASE_KEY}}\{{QUERY_KEY}}\{{QUERY_KEY}}_{{EPOCH_TIME}}.{{TYPE}}'
type: CSV/XML
post:
enabled: TRUE/FALSE
address: '[login to view URL]{{DATABASE_KEY}}/{{QUERY_KEY}}'
type: CSV/XML
Projekt-ID: #34736842
Über das Projekt
Vergeben an:
Hello, I have 10+ years of experience in programming using c#, vb.net, mssql, asp.net. I have read the requirement and i am sure that i can build an application that will query the 3 databases in sequence. Please let Mehr
50 Freelancer bieten im Durchschnitt £196 für diesen Job
Hello, I have 14+ years of web development experience in ASP.NET Core, ASP.NET MVC, Azure. AWS Apis, C# web forms, VB.NET, Classic ASP, SQL Server, HTML, CSS, javascript, jQuery, JSON and XML. I have handled various Mehr
Since 2000 I am working on Visual Basic (VB6 and VB.NET) and MSSQL, and MS Access MDB. Also Excel spread sheet. So more than 20 years of experience in Visual Basic to build any kind of Windows application. I have creat Mehr
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Mehr
Hi, Being experienced in working on several VB.Net applications connecting to various databases based on that I can help you out in getting an application build as per your need. Application can run in command window Mehr
Hi! It's great to bid for your project. I have more than 17 years of experience in Web & Desktop Development (Database Integration / C# / VB.Net / ASP.Net / MVC). Thanks.
Oh you poor soul... SAGE 200 and VB.NET. I'm a Colorado (USA)-based software engineer... and I've done both of those technologies. Give me a ring and we can discuss your project. Thanks, RC
Hi there, I am a professional full-stack .Web developer with more than 3 years of rich experience in .Web development and I am 100% confident that I am perfectly fit for this job. Please send me a message in chat so we Mehr
Hello sir, This is tomas, I have read your post carefully. I am a c++/c#, python, opencv expert with 6+ years experience. so i have developed a lots of apps similar to yours.I am sure I can meet it and complete it p Mehr
I read your project description carefully and have a great interest in your project. I'm very familar with C# & VB ., MS SQL, My SQL. I have a deep understanding and 20 years experience in C# ,VB and ASP.NET, and previ Mehr
After reading in detail the requirements of your project and concluding that they match my areas of knowledge and skills, I would like to introduce myself. My name is Pravin Jaiswal and I am Full stack Dotnet and MS S Mehr
Hello Sir/Madam I have development experience in various Programming Languages, OOP, Data Structures, Database Driven applications, APIs, Files handling and Data Transformation, ETL and various frameworks. I assure Mehr
Hello, Dear Client, Hope you doing well. I have gone through your requirement and as per my previous work experience, I am ready to start work immediately on your project. .I have achieved 8+ years of experience as an Mehr
Hello, I'm offering my experience in developing this application for you. It is pretty straight forward and i admire the well-described task :) For price specified and in less than a week this project can be done. Mehr