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.
Greetings! This is Amine and I work as a Business Intelligence consultant for several key accounts in my country (Morocco). Also, I am a Microsoft Certified Professional in Implementing a Data Warehouse with SQL Server 2012. I will be pleased to work with you on this project. Please feel free to check my Linkedin profil ([login to view URL]) or to start a discussion to talk about details. Thank you!
$100 USD w 3 dni
5,0 (8 opinii)
3,9
3,9
9 freelancerzy składają oferty o średniej wysokości $182 USD dla tej pracy
hi. I've worked a lot in C# with databases (MySQL, MS-SQL etc).
I understand this project and I'm very much interested in it. I have the skills to accomplish it for you. we can discuss further before we begin.
hope to have a good business with you :)
waiting for your response...
Having excellent knowledge of c#, sql etc and I am certified on these languages from freelancer team. I can make this query for you. Please contact me for the same. Thanks
I have read your requirement and can develop the document and application as well. I have six years of asp.net development application on which i have developed 30 + web application and many a windows application. I always complete the task before deadline. I will surely provide you a error free solution.