Find Jobs
Hire Freelancers

Access data from two related SQL Server tables

$30-250 USD

Closed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
1. Document how to create a method to access data from two related tables, each residing on its own separate database of a Microsoft SQL Server instance. The method could involve, for example: - the creation of a Windows 7 desktop application - the accessing a web server interfacing to the databases Among other fields, the child table has: - a date field and - a string field The method should: - work with the 2008 version of an SQL Server - present a table-like control acting as a view on the two tables - allow the defining of a time span consisting of two dates - allow the hiding of records outside the mentioned time span - allow the selection of multiple lines - allow the simultaneous global updating selection's two fields by the pressing of one button The table-like control could be, for instance, a C# DataGrid. The updating should: - set the date field to the current date - append the current date to the string field The access should be remote, concurrent and transactional. For example, from 2 workstations different than the machine hosting the SQL server. A Windows SBS 2008 Premium is available on my side. This includes IIS, SQL Server, SSMS etc. The tools involved in creating a possible desktop client application should be open source. For example, Microsoft Visual Studio Express 2013. C# is preferable to VB. 2. Provide the source code of the software and the database from point 1.
Project ID: 6254241

About the project

18 proposals
Remote project
Active 10 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
18 freelancers are bidding on average $170 USD for this job
User Avatar
I am certificated .NET/C# programmer working .NET 12 years. Your task may be solved if: 1) if both servers are installed on the same network, 2) Distributed Transaction Service (DTS) is installed and covers both SQL servers. I'll build you WPF application demonstrating all mentioned actions if your network satisfies mentioned conditions. If you want WEB application, I'll build ASP.NET MVC application. It is important to know, that having now full powered DTS (Windows Server WEB Edition, for example) the task may be solved in one case only: both SQL servers and client application are located on the same computer. Building WEB application is mandatory in this case, IIS and both SQL servers must be installed on the same computer.
$200 USD in 5 days
5.0 (4 reviews)
5.4
5.4
User Avatar
A proposal has not yet been provided
$250 USD in 10 days
5.0 (15 reviews)
4.5
4.5
User Avatar
Hello , as disscused in message expert in C# , databases choose me to begin Regards
$100 USD in 2 days
5.0 (22 reviews)
4.2
4.2
User Avatar
Expert in SQL, C#, Asp.net, MVC, Entity framework, Javascript, Jquery etc. I have gone through your requirement and I can do this as per your requirement.
$200 USD in 7 days
5.0 (9 reviews)
3.5
3.5
User Avatar
Hi, I would love to work with you on this project. I can create a WPF desktop application that accesses the database via entity framework and binds the data to a WPF Extended Toolkit DataGrid. Just some background information on myself, I am a senior software engineer with over 10 years of experience, specialising on the Microsoft technology stack (WPF, WCF, SQL Server). I am dedicated to producing quality and robust code. Look forward to hearing from you Regards, Brian
$250 USD in 3 days
5.0 (1 review)
2.0
2.0
User Avatar
We are software development group having experience in developing software for open source technologies and microsoft technologies. Since 2010, we have served as a software engineer, where we have been repeatedly recognized for developing innovative solutions for multimillion-dollar, globally deployed software and systems. We build full lifecycle development of next-generation software, from initial requirement gathering to design, coding, testing, documentation and implementation. We are known for excellent client-facing skills, we also excel in merging business and user needs into high-quality, cost-effective design solutions while keeping within budgetary constraints. My technical expertise includes cross-platform proficiency (Windows & Web using .Net); fluency in 13 scripting/programming languages (including C, C++, VB, C#, PHP, javascript, jquery, SQL and MySQL); and advanced knowledge of developer applications, tools, methodologies and best practices (including OOD, client/server architecture and self-test automation). We have built task management system in past which is related to your requirements. We also work with windows and mobile app platform and combining architectures for building service oriented mobile apps.
$222 USD in 3 days
5.0 (3 reviews)
0.6
0.6
User Avatar
i already done so many project so please give me chance i will do my best we have done 10 .net projects.
$123 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
Hello, Would love to help you out with this project. Over 15 years of development experience with over 8 years at Microsoft.
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I read your project detail and I can work as per your requirement. I can spend maximum hours for this project. I have 6 year experience in software field. I have sound knowledge of .NET. I will plan to complete this project within deadline. I kindly request to provide more detail about project. Waiting for your positive reply. u can also do raghuviroverseas at hot mail Have a good day
$222 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Développeur VisualStudio et CrystalReport depuis 2008 j'ai acquis une bonne expérience que ce soit en application WindowsForm comme en WebForm. j'ai à mon actif une vingtaine d'applications métiers développées en VB6, VB.Net et Asp.Net pour de grande multinationales et des clients particulier. Je vous présentes ci-dessous une liste de quelques unes des mes application : GESTION DEPOT DE BOISSON - Language ASP.Net; - 110 Pages; - 150 Etats; - Lecture de Code Barre; - Edition de badge; - Messagerie Interne. - Envoie de SMS aux Clients - Sql Serveur GESTION DE CONSTRUCTION ET DE PROMOTION IMMOBILIERE - Language C#; - 198 Formulaires; - 260 Etats; - Lecture de Code Barre; - Messagerie Interne; - Import et Export de Données vers Sage(SAARI) - Envoi Automatique de SMS au Clients. - Oracle GESTION D’AMBASSADE - Language ASP.Net; - 132 Pages; - 150 Etats; - Messagerie Interne. - Oracle GESTION DES PROJETS (BAD, BANQUE MONDIALE) - Language ASP.Net; - 100 Pages; - 170 Etats; - Messagerie Interne ; - Envoi Automatique de SMS. - Oracle GESTION DES RESSOURCES HUMAINES - Language ASP.Net; - 125 Formulaires; - 178 Etats; - Pointage Biométrique des Présences ; - Messagerie Interne. - Oracle GESTION DE STOCK - Language ASP.Net; - 75 Pages; - 80 Etats. - MySql GESTION DE FERME - Language Vb6; - 50 Formulaires; - 90 Etats; - Sql Serveur GESTION DE MAQUIS ET BARS - Language Vb.Net - 35 Formulaires; - 48 Etats; - Lecture de Code Barre. - Sql Serveur
$223 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 2.6 years of professional experience in .net at SHARP. I am good in .net and c#. I was sent onsite and worked in japan during the critical stage of the project (Search for Pensoftware 3.0 on youtube to know more about the product) to the market.I can work under pressure and i can assure you that the work will be done within the given time.I do not have any recommendations here but if you give me a chance i'd like to work on this project. Thank you.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hard and smart work are the key factors with me. If we collaborated, my experience would give a boost to the company's efficiency and would take the targets of the company to highest level. I have 12 years of experience. I have done MCA from a premier institute. My primary skills : ASP.NET, C# , SQL server, WCF, AJAX, WPF, JS
$166 USD in 22 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I will do this in Visual Basic using Visual Studio 2013. Firstly I would do 2 async processes to connect to those sql servers. If error, handle it, and give user possibility to change sql connection settings.(server, database, user, pass). Working asynchronously is better if you want to minimize the delay time, i'm using it for my sms marketing software. Once connected create a hidden dataset. Fill dataset with data from db1. Match dataset entries to db2 and update datagridview. Data grid view can be edited. If edit occurred check if its in db1 or db2. Update db1/db2 in real time or by clicking Apply(your choice) based on the user edit. The program's interface will contain a date/time filter to hide records.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$177 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
La propuesta todavía no ha sido proveída
$110 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Jul 26, 2014

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.