Find Jobs
Hire Freelancers

Fix Visual Basic Application - Connects to MS SQL Server and returns unique values

$10-30 AUD

Completed
Posted about 6 years ago

$10-30 AUD

Paid on delivery
Hi, I have a failed project attempted on another platform for a Windows Form Visual Basic application that interfaces with SQL Server Express 2008. The form design has been created and some very basic programming has been done but the project is unfinished. The project is originally created in VS Community 2017. The application must be able to build a user specified SQL connection string, connect to a database and read a single column of data from a single table. Matching data will be provided by the user in the form of an input CSV file. Any data that appears in the input CSV file but not the database will be exported to an output csv file for the user to review. The form has been design as such: btnBuild (Build Connection) - This button takes information from the four text boxes and builds the connections string to connect to the SQL server btncn (Test Connection) - This button tests the connection string by connecting to the database, closing the database and reporting success or fail btnIN (Specify Input CSV) - This button opens an OpenFileDialog for the user to specify the input CSV file and enters the file location in [login to view URL] btnOUT (Specify Output CSV) - This button opens an OpenFileDialog for the user to specify where they want the new output CSV file to be created and enters the file location in [login to view URL] btnGO (Run) - This button: (a) connects to the database using the connection string (b) opens the input CSV file and takes the first column data which is unique rows (c) checks the first column of data (unique item codes) against the unique items in the specified table (d) returns any item codes that are present in Input CSV but not present in SQL Database table into Output CSV File Input CSV File Example: 11223344,55 22334455,2 3344556,287 Output CSV File Example: 3344556 The item codes reside in the specified database in the physical table, called item_code (SELECT item_code FROM physical...) There is no lab for this project, it must be tested in production environment and it may take some time for testing however competent programmer should have no need to test MS SQL connection strings. Successful applicant will be provided with code or with entire project upon request. Sample code is attached to this task. Thank you
Project ID: 16595116

About the project

11 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
11 freelancers are bidding on average $49 AUD for this job
User Avatar
Hi there..... Warm Greetings We came along with your request for Visual Basic Application and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of SQL, Visual Basic We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$100 AUD in 2 days
5.0 (97 reviews)
6.9
6.9
User Avatar
Can you please share database structure as well?
$50 AUD in 2 days
4.8 (114 reviews)
5.7
5.7
User Avatar
I'd like to work with you on the project,Having 9+ Years of Experience as a Software Developer, successfully completed many projects (please see my reviews). Experienced in ASP.Net, C#, VB.Net, MVC, WPF, Visual Basic, Excel VBA, MS SQL Server, MYSQL, Oracle, MS Access, Crystal Report, Telerik, Bootstrap, HTML 5, CSS,Java Script.
$100 AUD in 1 day
5.0 (28 reviews)
5.0
5.0
User Avatar
I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.
$100 AUD in 3 days
4.9 (28 reviews)
4.9
4.9
User Avatar
Hi, how are you doing? I read your request. I can complete the Visual Basic project and provide you with the complete source code within 2 days max.
$40 AUD in 2 days
4.5 (4 reviews)
2.7
2.7
User Avatar
Hi There, I am having almost 12 years of experience in .Net & SQL programming. Skills includes all Microsoft Technologies and different domains. I am sure that I can help you better in this regard. Thanks
$15 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience in VB.NET and MS SQL. I had done 3 projects in my jobs to import data from csv file to database.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Brisbane, Australia
5.0
5
Member since Jun 12, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.