Find Jobs
Hire Freelancers

Desktop application in C# connecting to local database

$15-25 USD / hour

Completed
Posted about 8 years ago

$15-25 USD / hour

Hello, I need help using MS Visual Studio 2015 (the free version) to do the following. 1 - Create a C# WIndows Forms application 2 - Create a local MDF database in this way: Right click on the project > Add > New Item > Data > Service-based Database 3 - Click on the Project > Add New Data Source…>Database (next)> Dataset (next)>Pick the connection created automatically in step 2 (by default will be [login to view URL])>Next, Next > Finish 4 - Click Build Solution to refresh the screen 5 - Right click on [login to view URL] in the project and choose Open 6 - Right click on Tables and add 1 table (name it CTest) with these fields: id (in by default, change to identity), AName varchar(10), ATrue (bit), AGender char(10), ADateOf (date), ATimeOf (time(7)) 7 - After you’ve run the auto generated script the program creates for you as you design the table, the table is now added 8 - Click Build Solution to refresh the screens 9 - Go back to CTest and right click > Show Table Data> add a record, Id field will auto populate with a 1 (if you made it identity in step 6), In AName type “Joe”, in ATrue type false, the rest can be left to NULL, move off the record to save it 10 - Click on the project >[login to view URL] (named by default) > right click > open 11 - Click on the Solution explorer and expand tables > drag CTest onto the [login to view URL] screen 12 - Click save all 13 - Click on the Form1 form > add the following controls Textbox, Checkbox, Combobox (use the properties to give it two choices , “male and female”), DateTimePicker (configure for date), DateTimePicker (configure for time) 14 - Using ADO on the load event of Form1, create a SQL Data reader to read the CTest table and retrieve the row where ID = 1 and populate the controls 15 - Create a button on the Form1 form, add click event for the button to read the contents of the of controls and save them to the same record (ID=1) USING ADO SQLDATACOMAND to run a SQL UPDATE using parameters. Example on item 16 below . 16 - UPDATE Table1 SET LastModifiedDate = @LastModifiedDate WHERE Key = @Key AND LastModifiedDate = @old_LastModifiedDate 17 - Note Combobox and bool checkbox are tricky (to me anyway), I need them to correctly save when the button is clicked if the user changes any of the controls or even if the user CHANGES NOTHING 18 - Run Start and confirm you can see the controls populated from the load event, click save without changing anything, close the form 19 - Run Start again, this time change each control and click save, close the form 20 - Run Start and confirm you can see the controls populated from the load event 21 - Now the tricky part, Add two new fields to the existing CTest table, AMaritialStaus Char(10), ACurrentOwner (bit), run update to update the table, Run Build to refresh 22 - This is the part I’m not sure how to do CORRECTLY, refresh the [login to view URL] screen so it correctly reflects the two added fields 23 - Add two controls to the form and set the AMaritialStaus Combox you add to have (“married, single, divorced”) as choices, a ACurrentOwner checkbox 24 - Alter the ADO so the load event and update click events to work with those two new controls 25 - Run Start and confirm you can see the controls populated from the load event, click save without changing anything, close the form 26 - Run Start again, this time change each control and click save, close the form 27 - Run Start and confirm you can see the controls populated from the load event I need to learn how to do this using MS Visual Studio 2015 and you MUST know how to do this too before we meet up. If you’re a “I do everything from notepad guy” that’s not going to help me. I have a tool I want to use, MS Visual Studio 2015, and need help using that tool. I am on the east coast, time zone wise. If you are SURE you can help me achieve *all of the above*, let me know, thanks
Project ID: 10050180

About the project

11 proposals
Remote project
Active 8 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
Dear Sir/Madam, We can start immediately RK Websoft Technologies is a software designing and development Team. We are having very experience, enthusiastic and talented team with more than 5 years of experience on .Net Technologies MVC5, JQuery, Javascript, Entity Framework, bootstrap, media query, etc. Please find some of our work below: [login to view URL] User Name:system,Pass:alplglp@002 [login to view URL](use Name:admin pass; admin)Angular js [login to view URL] (UserName: admin, Password: admin) [login to view URL] (Company Code: rk0001,UserName: fdu, Password: 123) [login to view URL] [login to view URL] [login to view URL] [login to view URL] Thank you
$15 USD in 10 days
5.0 (7 reviews)
3.0
3.0
11 freelancers are bidding on average $19 USD/hour for this job
User Avatar
i am a senior software engineer and responsible for creating web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
$15 USD in 10 days
4.6 (67 reviews)
6.3
6.3
User Avatar
Dear Sir, Let me do it for you ! Have 7 years experienced in .Net C# development, especially in website building within ASP.Net, MVC Pattern, WCF Service, Entity Framework, Web API, Angular JS within Bootstrap and Responsive Design. I can help you build the win form application, interacting with mdf attached database file. I'm looking for long-term cooperation in freelancing work with you ! Please discuss project details via message inbox. Hope to get work for you on this project and keep good relationship for future jobs. Thanks and Best Regards.
$15 USD in 40 days
4.8 (57 reviews)
6.0
6.0
User Avatar
Hi, I have experience in Desktop C# VS developing. I can do your project. Slavi.
$22 USD in 10 days
4.9 (7 reviews)
4.3
4.3
User Avatar
Hi, Thanks for the project posting. I am very interested in this project and look forward to discussing with you regarding more project details. Thanks again. MM
$22 USD in 10 days
5.0 (1 review)
2.4
2.4
User Avatar
Hello, I would love to work for you. I have more than 2 year of practical work experience in the field computer science. I am accustomed to working with all sorts of products and services, and in a variety of industries. I have a deep passion for my work and guarantee that all of my work is 100% original. Currently I am doing my masters in USA. In the past I have worked with a software company which made a product ERP system and the front end layer was made using WPF (Windows Presentation Framework) and C#.Net framework was used. I can assure you that I have all the technical skills needed and will be able complete to complete this project on time. I feel certain you have specific requirements and expectations. My enthusiasm and experience make me a great fit for this position. I’m glad to answer any questions you may have! Thank you for your time, Moeen Ahmed
$15 USD in 10 days
5.0 (1 review)
0.9
0.9
User Avatar
Hello, I would like to know if the help you need will be provided by a screen sharing tool, phone or any other communication tool, or in a live way. Thank you
$15 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, I have read your project description & first of all, I wanted to know that you want a Desktop Application using Windows Form or WPF? Because these days mostly Desktop Applications are developed using WPF, so thought to ask you. About the estimate, you want to work on hourly basis, as you posted your project under hourly or you want to work on the total cost basis? Let me assure you that our team can deliver all the features but I would like to schedule a meeting to discuss everything in depth. May I suggest that we schedule one to one technical meeting to discuss everything more in depth, as it is important to make sure that we are both on the same page in terms of requirement understanding, after that we can finalize everything to kick started. Look forward to hearing from you. Regards, YK LEADconcept
$26 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Adel Khalifa, from Egypt, Graduated from Faculty of computers and information systems. I noticed your advertisement and think I would make an excellent candidate for it. I will go the extra mile to get things done, then I am your man. There is nothing I cannot or will not do to ensure that your business is a success. For the last two years I have been working in a similar role to the one you are advertising, and have been responsible for designing, building, testing and supporting Java applications. Being a key member of my existing team means that I have been put in charge of providing coding and analysis relative to assignments, and performing unit testing on applicable code. I have extensive experience of C# .NET, Windows Forms, WPF Applications, Java (Core), JavaScript, Java web development, Java/J2EE code, Oracle SQL, HTML, XML, NetBeans and Eclipse. I consider myself an expert at resolving application defects, and at testing, debugging, and refining software to produce the required product. On a personal level I have the ability to stay organized and on top of my work at all times. In addition to this I am constantly seeking to improve my skills and am fully aware of the latest developments in the world.
$22 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Vienna, United States
5.0
2
Payment method verified
Member since Mar 25, 2016

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.