Завершен

.Net Application to Query MS SQL Database

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

Навыки: VB.NET, SQL-сервер Microsoft, .NET, SQL, Программирование на C#

О клиенте:
( 6 отзыв(-а, -ов) ) Watford, United Kingdom

ID проекта: #34736842

Поручен:

goswamiarpit475

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 Больше

£100 GBP за 7 дней(-я)
(52 отзывов(-а))
5.8

51 фрилансеров(-а) готовы выполнить эту работу в среднем за £195

(51 отзывов(-а))
8.5
(169 отзывов(-а))
7.6
(42 отзывов(-а))
7.3
(82 отзывов(-а))
7.3
apgrl123

I CAN COMPLETE YOUR PROJECT EASILY Hello, I am programmer with enough experiences on C#/.NET, VB.NET for 10+ years. C#/.NET, VB.NET is nice programming language and I am majoring on it for long years so I have confiden Больше

£200 GBP за 7 дней(-я)
(16 отзывов(-а))
6.6
deepindersingh

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 Больше

£250 GBP за 7 дней(-я)
(62 отзывов(-а))
6.6
SPARKtechBD

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 Больше

£250 GBP за 7 дней(-я)
(28 отзывов(-а))
6.2
schoudhary1553

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 Больше

£220 GBP за 5 дней(-я)
(52 отзывов(-а))
6.4
(133 отзывов(-а))
6.7
(94 отзывов(-а))
6.2
(70 отзывов(-а))
5.9
(48 отзывов(-а))
6.0
mail2vimalarora

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 Больше

£170 GBP за 5 дней(-я)
(123 отзывов(-а))
6.1
(21 отзывов(-а))
5.8
(33 отзывов(-а))
5.4
(32 отзывов(-а))
5.1
topithub

Hi, hope you are doing well, I am free nowadays and can start your work. For my experience kindly once have a look on my profile and check my work samples which I attached on my profile. Send me a text for further dis Больше

£180 GBP за 2 дней(-я)
(13 отзывов(-а))
5.2
malkesh3m

Hi, I can start immediately and can offer 40+ hours per week. I read your project post . .Net Application to Query MS SQL Database My key skill expertise are in C#, .Net Core, ASP.Net Core, ASP.NET Identity, Entity Fr Больше

£250 GBP за 7 дней(-я)
(23 отзывов(-а))
4.5
bizmanas

Hi I have 15 years of experience in Sql server database development. I will be able to help you with this project. Please ping me offline discuss further. Besides Sql server i have wirked in mysql,c#,pyhton and power B Больше

£300 GBP за 1 день
(13 отзывов(-а))
4.6
abbascsp

Hi! You need a VB .Net desktop application to query multiple SQL servers and store and output the results. I can help you build this application as I am over 11 years experienced in .Net and SQL Server. So send me a me Больше

£200 GBP за 7 дней(-я)
(4 отзывов(-а))
4.2