Find Jobs
Hire Freelancers

Access data from two related SQL Server tables

$30-250 USD

Geschlossen
Veröffentlicht vor fast 10 Jahren

$30-250 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 6254241

Über das Projekt

18 Vorschläge
Remote Projekt
Aktiv vor 10 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
18 Freelancer bieten im Durchschnitt $170 USD für diesen Auftrag
Avatar des Nutzers
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 Tagen
5,0 (4 Bewertungen)
5,4
5,4
Avatar des Nutzers
A proposal has not yet been provided
$250 USD in 10 Tagen
5,0 (15 Bewertungen)
4,5
4,5
Avatar des Nutzers
Hello , as disscused in message expert in C# , databases choose me to begin Regards
$100 USD in 2 Tagen
5,0 (22 Bewertungen)
4,2
4,2
Avatar des Nutzers
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 Tagen
5,0 (9 Bewertungen)
3,5
3,5
Avatar des Nutzers
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 Tagen
5,0 (1 Bewertung)
2,0
2,0
Avatar des Nutzers
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 Tagen
5,0 (3 Bewertungen)
0,6
0,6
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
0,6
0,6
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$177 USD in 10 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Aucune proposition n'a encore été fournie.
$155 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$111 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
La propuesta todavía no ha sido proveída
$110 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von INDIA
India
0,0
0
Mitglied seit Juli 26, 2014

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.