Northwind jobs
I am interested in creating an editable database in MS access where I can enter and in the future edit: 1. Customer Data: Customer Co, Contact First Name, Last Name, Ad...received. 6. I also need a separate report that I can transfer to excel or directly to quickbooks with the Subcontractor, Job Name and amount due to Subcontractor based on the Job Subcontractor Rate times the manifest tones for the week. Only two people will be editing the data and I would like it to be accessed online. I like the user-friendly look of the sample template MS Access has for Northwind. I will the form I currently use in excel. I want it to be more user friendly. I also use data from here to calculate the hours of a few drivers listed and to calculate who will receive invoice-factoring (P...
Dear freelancer THIS IS URGENT: I need this completed within 12 hours I need help learning how to do a few specific things in MS Access 2007. So I preferably want a simple video-clip showing the steps (or an intiutive step by step guide). Prerequisite: From within Access download the sample database Northwind and understand the basics in it. Task 1: - build these SQL queries and execute them in Access: a) Sum of all sales in 2006 b) Number of sales in 2006 Task 2: Use Access's built in Report Generator to produce these two reports: - Produce a report showing all sales in 2006 sorted by size of orders - Produce a report of all customers and their orders/purchases sorted by largest customers Happy bidding
This project will involve using the OledbDataConnection, OleDbCommand and OleDbDataAdapter objects. the task is to design and implement a Windows Form application that will allow a Sales Representative for Northwind traders to take orders via telephone from Northwind customers. The following operations are to be implemented: Sales representative sign in (gets the employeeID for the session) Find the customerID, or create a new customer Create a new order (You can assume that the ShipAddress is the same as the customer address) Select Products, Quantity and enter any discount for Order_Details for the new created Order. Upon processing the order, the OrderID is to be communicated to the customer.
Create one MS Access form which displays a hierarchy of employees from Northwind Traders which permits drag and drop reorganization of hierarchy, changing the reporting relationships between employees. This form must use the exontrol's ExGrid activeX control rather than the MS TreeView control.? ExGrid allows the first column to display a hierarchy like TreeView and allows other columns to display information about the value displayed in the grid. Here's a simple example: Employee? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Job Title? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Fax number John? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? President? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 111-111-1111 -- Mary? ? ? ? ? ? ? ? ? ...
I need to have a script developed that performs the following: 1) this script is called via a URL (eg. ) and parameters are passed via this URL to the script (eg. http://get...). 2) the script will generate a SQL query to MS SQL Server database. 3) The SQL results are then converted into XML data format and stored in an XML file. I already have the parts of the script for 2) and 3) and it works on the demo Northwind database in SQL Server. What I need is for some one to complete 1) based on the script that I will send over. ## Deliverables Attached is the partial script that already works for item 2) and 3) on the MS SQL Server Northwind database and information about script for your reference. ** **
...produce your solution. This will involve using the OledbDataConnection, OleDbCommand and OleDbDataAdapter mobjects instead of the more familiar SqlConnection, SqlCommand and SqlDataAdapter objects. You have tried most of these in the scheduled laboratory sessions. Your task is to design and implement a Windows Form application that will allow a Sales Representative for Northwind traders to take orders via telephone from Northwind customers. You are already familiar with the Database. The following operations are to be implemented: Sales representative sign in (gets the employeeID for the session) Find the customerID, or create a new customer Create a new order (You can assume that the ShipAddress is the same as the customer address) Select Products, Quantity ...
Use the Northwind Database for this assignment – create a single SQL script file to do all of these. Show the number of each statement by using SQL comments 1. Get a count of employees. Make the title of the result ‘Employee Count' select COUNT(*) as 'Employee Count' from Employees 2. Get a count of each employee by title. For example we want to know how many Sales Representatives there are etc. Show the title, and the count (as Employee Count), order the results by Title. select Title,COUNT(Title) as 'Employee Count' from Employees group by Title 3. Show the order id and the average unit price from the Order Details table group by the OrderID and sort ascending by the average unit price. Title the average column as ‘Aver...
...part of the CR .NET SDK starting with XI R2 and CR 2008. Normally, the activex viewing of reports is supported by SAP/BusinessOjects only via BOE. But since the Activex viewer is capable of viewing EPF pages, I need someone to demonstrate the concept of generating EPF's via the so called in-process RAS. The deliverable will be a sample ASP.NET application which will connect to the sample Pubs or Northwind database. Coders with 0 rating are welcome to bid as long as you can demonstrate you have this working - a sample video would be sufficient. Please DO NOT BID by COPY / PASTE of a standard text stating your experience, etc, as I won't read it. Note: I will wave the expert guarantee requirement for the qualified person. ## Deliverables 1) Complete and fully-functiona...
Use the Northwind Database for this assignment – create a single SQL script file to do all of these. Show the number of each statement by using SQL comments 1. Get a count of employees. Make the title of the result ‘Employee Count' select COUNT(*) as 'Employee Count' from Employees 2. Get a count of each employee by title. For example we want to know how many Sales Representatives there are etc. Show the title, and the count (as Employee Count), order the results by Title. select Title,COUNT(Title) as 'Employee Count' from Employees group by Title 3. Show the order id and the average unit price from the Order Details table group by the OrderID and sort ascending by the average unit price. Title the average column as ‘Aver...
Write a SQL statement that will return all the Orders and Order Details. Sort the results by Ship Via and Unit Price. As part of the results show the total price of each Order Detail row. (Must use the Northwind database that is attached. Microsoft SQL management server studio manager will restore the database)
I need to create a web project using Northwind DB using C# 1. From Employee table using xsd String strCmd = ""; strCmd += "Select EmployeeID, LastName, FirstName, Title, BirthDate, "; strCmd += "Address, City, Region, PostalCode, Country, HomePhone "; strCmd += "From Employees "; 2. From Store procedure ( direct w/ paramenters) CustOrderHist should be in crystal viewer and pdf Sample below: private void Button1_Click(object sender, e) { MemoryStream oStream; // using oStream = (MemoryStream) (); (); Response.Buffer= true; = "application/pdf"; (()); Response
...part of the CR .NET SDK starting with XI R2 and CR 2008. Normally, the activex viewing of reports is supported by SAP/BusinessOjects only via BOE. But since the Activex viewer is capable of viewing EPF pages, I need someone to demonstrate the concept of generating EPF's via the so called in-process RAS. The deliverable will be a sample ASP.NET application which will connect to the sample Pubs or Northwind database. Coders with 0 rating are welcome to bid as long as you can demonstrate you have this working - a sample video would be sufficient. Please DO NOT BID by COPY / PASTE of a standard text stating your experience, etc, as I won't read it. Note: I will wave the expert guarantee requirement for the qualified person. ## Deliverables 1) Complete and fully-functiona...
2007 Microsoft Access’ “Northwind?? template modification is required to be complete within? 48 hours. Adding some features and taking away some features. I am also looking for input in order to achieve maximum usefulness. The specifications are on the next step. ## Deliverables Microsoft Access (Northwind Template) database with the following modifications: 1.? ? ? ? ? Ability to delete/modify/etc orders that are invoiced 2.? ? ? ? ? Ability to see on home page invoices that have not been paid (similar to active orders in the template version) based on date due relative to current date. 3.? ? ? ? ? Ability to create backorders, see backorders on a separate page as well as on the customer’s page, and have ability to see on home page based on date cr...
Need example: 1) How to use DoJo DijitGrid with C# back-end. The DijitGrid should be able to populate itself add/edit/delete (and post back items) 2) How to use DoJo Dijit Tree with C# back-end. The Dijit Tree should be able to populate itself, add/edit/delete. Assume you are working with dynamic database, you ne...Agreement). - Working ASPX page with Dojo Toolkit integrated in it, - Working DoJo Dijit Tree able to communicate with back-end C#/ASPX page - Dijit Tree able to add/edit/delete and populate itself from dynamic database source. - Working DoJo Dijit Grid able to communicate with back-end C#/ASPX page - Dijit Grid able to add/edit/delete and populate itself from dynamic database source. - Use NorthWind MSSQL database an example database to use. ## Platform JavaScript, ...
.net and code generation I am looking for a simple example of working with C# and CodeSmith (code generation demo available) using DAAB - generated off Northwind. There is a product called MyGeneration (free and does doodads and/or DAAB) and a product called LLBLGen that does its own thing too, which are possibilities but the trial version of codesmith is good too. i.e. Codesmith has many building avenues and features and one is using Microsoft DAAB. It will generate tiered classes and get all stored procedures and their parameter automatically all tiered up. But it simple creates the project stub with exposure to the Class Factory. You then need to start coding the stub project and reference
Very small project. Modify attached excel file to... 1. Change odometer start and finish to 'Mileage" and "Tolls" 2. At top add area for fiscal year date, and starting and ending odometer reading (ie jan 1 and Dec 31), and total business mileage to date. 3....reimbursed mileage in some way. 5. User can print certain dates for reimbursement or at end of fiscal year, print entire sheet for year. 3. add drop down list to Second Column, so you could pick from a list that would also pre-populate next columns associates with list item. ie, in attached example, you could click on Home Office cell, and it would give you list, such as... Home Office Northwind traders Client Meeting 10 miles 2.50 (tolls) Total (ie 10miles X plus tol...
...consistency check at this step with all the datatype check,duplicates,error/quality of data Step 3: Log in the record which failed in data quality in step2 and step1 and apply business rule to route the record Step 4: Load data in the integration area where the good data and the processed data are integrated . Step 5:Final load into the database The coder can use a sample data in NorthWind or AdventureWorks . You can also mail me at zinrac2 at gmail if you need further details or what needs to be done before start working . Once spoken with the coder on the approach i can post a refined description on RAC and the coder can start working on the sample stored procedure based on the agreed and redefined project description . Please do not post if you do no...
What I need are 2 projects completed plus a file The first project needed is a data service project (using the northwind database and using LINQ To SQL). The second project is a WPF application that will use the service. The WPF Application needs to have databinding as well in addition to validation. They need to be programmed in Visual Basic (using the .net framework 3.5 service pack 1). The connection string needs to be in the file (so I can change to my connection to the northwind database). The project should show about 3 tables being used. The purpose of this project is for me to learn databinding and wcf web services (dataservices). Needs web service instead of just using the LINQ To SQL class on the WPF application because the target machine for the WPF will only
...SQL - Sample Database - Northwind / Pubs Task 1 :- Create two Pages Login Page - Simple Login Page Should Use the Master Page, Header Control / Footer Control, CSS 2.0, Skins & Themes Objective :- To verify Master Page, Skins / Themes, Header / Footer Controls, CSS ? work in all the pages. Task 2:- I have attached the Requirement Screen Shot - Doc Please Refer to it :-? I need a same Menu Bar and Sub Menu Bar. Sub Menu Bar - Should have Link Buttons as similar to I need same Layout - Square / Rectangle Box in the Right Hand Side having Static Information. Same Skins / Themes / Header Control / Footer Control. In every Menu - I need to have a GridView - Populating from Database ( Northwind, Pubs ) - SQL ...
Enclosed is a sample site that allows a person to edit the northwind customers. However; there is one problem. When it goes to edit mode; the country shows the first one on the list instead of showing the country the customer is from to begin with. That needs to be fixed. I also need a text file to show what else was done to make it work. This is in VB.net and must remain in VB.net. ## Deliverables The source code and a to show the extra steps needed to bind the values of the one selected so when editing it; the country previously entered will show as being selected. Must work on buyers environment. ## Platform Windows XP Home Edition.
I need a sample program to show transactions working using LINQ To SQL. Must use local transactions; not distributed transactions. Must work where the work will not be saved until the commit (or something like that is called; not submitchanges). The purpose of this is I may have 2 datacontexes that either they both have to be successful or none (for saving changes). Can use the northwind database. Must be in Visual using visual studio 2008. Must use LINQ to SQL; not any other ways to communicate with the data (using the linq to sql class). ## Deliverables The sample exe and the source code for the work completed. Must work on buyers environment and work with SQL Server 2000 Enterprise Edition. ## Platform Windows 2003 Server Edition, SQL Server 2000 Enterprise Edition.
Skills :- ASP.Net, VB.Net or C#.Net, AJAX, Javascript Database :- Use sample database - Pubs or Northwind of SQL Server 2005 Two Task to do :- Task 1 :- AJAX Enabled - Multicolumn Dropdownlist box. [Please Note :-? I dont want any Thirdparty Controls like Infragistics - WebCombo or Rad Controls or EO Controls etc..!] This AJAX enabled Multicolumn Dropdownlist box should be editable. Task 2 :- AJAX Enabled - Grid View with Pop Up window. Grid View should have Insert, Update, Delete Functionality. Insertion should take place directly to the database. [Assumption] :- Gridview has? 3 Columns Column1 :- Multicolumn Dropdownlist Box Column 2 :- TextBox - Readonly = True [NON EDITABLE] - On mouse Over - Popup window should show brief mes...
I need a sample project that uses the northwind database. Needs to use the LINQ To SQL class for it. The only table needed is the Customers. The project needs to be a console one. When ran; it will print out how many customers where the region is null to the console. Then I have to hit enter to contine (so i can see the results). Cannot use dynamic sql (using executecommand or executequery) because if those 2 things are used; then intellisense is lost. Plus cannot use the .ToList first either (where i have to create an entire list first). The purpose of this project is I have found cases where i need to search for nulls using linq to sql and I cannot get the nullable(Of string) to work at all. ## Deliverables The source code only to show the linq to sql query to find columns ...
I want a sample project built. Must be with Visual Basic with the .net framework 3.5 service pack 1 with visual studio 2008 service pack 1. What is needed are the following. 2 Data Context classes. Can use the northwind database. The reason for 2 is because I need to support transactions (so if the submitchanges on one is successful but not on the second; then the first changes will be rolled back afterall. Must work even when accessing it from a network. I am able to get something working when only the local computer is accessing it. However; must work even from networked computers. ## Deliverables The sample exe to show transactions working on networked computers. Must work on buyers environment. If you need to connect to my PC; then must use Team Viewer since I am behind a...
I need someone to perform creative work and create 5 or 6 sample databases for an application. This means to actually use the software and create sample projects/databases by populating each sample with records and pictures that make sense. (If you want, this is something like what Microsoft did by creating and populating the pubs or northwind databases for Access and SQL Server.) My software can be used for a variety of business needs and I can provide you with examples and also information on competing products so you can understand the possible applications. You need to be creative and come up with ideas on how the software can be used, what kind of companies can use it and in what particular scenarios. You need to be able to understand easily the potential business uses and appl...
Project Description: Modify Existing DLL in C++ to add additional functionality Language: C++ (Managed) Background Information: The attached DLL connects to the local default instance of SQL Server and Backs up the database using the Virtual ...2. Add Support for multiple devices. device count is set with [ = 1;] I need this to be able to return a variable number of streams to C# using multiple threads for speed. I also need an example in C# of how to use these streams with multiple threads. In C# I would like to be able to call a function like this: BackupDatabase("northwind", "C:", 3) The result of whcih would back up the northwind database over 3 files called:
I need someone to perform creative work and create 5 or 6 sample databases for an application. This means to actually use the software and create sample projects/databases by populating each sample with records and pictures that make sense. (If you want, this is something like what Microsoft did by creating and populating the pubs or northwind databases for Access and SQL Server.) My software can be used for a variety of business needs and I can provide you with examples and also information on competing products so you can understand the possible applications. You need to be creative and come up with ideas on how the software can be used, what kind of companies can use it and in what particular scenarios. You need to be able to understand easily the potential business uses and appl...
My development environment is Flex 3 running on WAMP. My client is running MS Sql 2000 and his web server is running iis7/asp. I want one Flex 3 form. I want an internet user to be able to add/edit/delete records from the northwind employee table on my clients MS Sql 2000 database. And I want to be able modify this from in my environment.
My development environment is Flex 3 running on WAMP. My client is running MS Sql 2000 and his web server is running iis7/asp. I want one Flex 3 form. I want an internet user to be able to add/edit/delete records from the northwind employee table on my clients MS Sql 2000 database. And I want to be able modify this from in my environment.
I need a VB.Net application (3.5) that will * Extract all images (on forms and controls) from an access application (NorthWind) * the images should be pulled out and saved to disk * I also want a test application that reads those images into .Net (win form) *All image handling code should be in one or more class libraries ## Deliverables * This application will use the Microsoft Access object model to extract images using VB.Net * The test application must demonstrate that all saved images can be used in a .Net PictureBox * I presume that this project will result in at least 2 .Net projects
...section of the bottom left Picker Label) then we need that data to spill onto the new sheet in the bottom left section. If a customer purchases an excessive amount of items we would expect there could be many sheets printed. This is acceptable. **The goal is to line everything up to the mock-up since our mock-up is formatted to fit our paper exactly**. This custom report is similar to the Northwind Database Customer Invoice Report in Microsoft Access....
...and will create the web services, the XML and XSD files, and the SQL Database using SQL Server or SQL Express and the Northwind Database.? .NET 3.5 framework is to be used for web services. ## Deliverables Here are the additional requirements that the project must meet: The project will use the Microsoft Northwind Database In the Northwind Database, add a column to the Customers Table called NewRecord. This column will be a bit field with a default value of 1. This field will be used to identify customer records that are newly added to the Customers table. Update all existing customer records in the Customers table so that the NewRecord field has a value of 1. In the Northwind database, add a column to the Orders table called NewRecord. This column will be...
Flash9, Action script 3.0 MS SQL 2000 ASP Add, delete, edit or search(last name) of an employee record in the NorthWind database. It needs to be well documented, so I can modifiy it to fit my needs of my real database.I want to be able to change the connection string and field names without to much trouble. How much and how long?
I'm Looking for someone to do some fusioncharts(Or recomend another) in flash cs3. The data for the charts will come from MS-Sql 2000. The first chart will be on some test data from the NorthWind database. The info needed for these charts is here. Guide for flash developers These charts are swf's that take xml data. The deliverable I want is total sales, for the top 15 compaines, by the year, in a , that can be added to, or made into, a movie clip in flash cs3.
...This site will be hosted by a competitor of them, so the source must need to be protected. I like to have the code behind of an aspx or ascx be inherited from a public class. Some of the form will contem the RadGrid from telerik that you can find here <> The technology is VS 2008 C#, MSSQL 2005 you can use the Northwind (Customer and Order tables) application for your code. I’m having problems with the PlaceHolder, I have expend too much time on this is time to ask for help. Or if you have any suggestion how to protect the code behind, I’m listing. Thanks...
what i'm looking for is for an sample of how you would build a web page using c#, vs2005 that would build ad-hoc queries and show them to you in a table that had sorting, paging and printing. you can utilize the northwind database but i would like the page built as a base that i could add additional functionality to. i will only use escrow and please show me either a sample of what you'd do to build this or let me see some of your work.
I need a database that will track employee training days and hours through multiple positions leading up to final qualification at all positions. Forms required will be: Basic info (name, date hired, title...) Data entry form for each person at ea...takes employees to qualify at a certain position. Report that shows each day an employee worked, how long they worked that day... I have a basic understanding of MS Access and will be able to provide finer detail to the designer. I am not looking for anything over the top---just a better way to track training progression with the ability to print reports with up to date information. The Northwind template (Access) offered on the MS template website is great looking and functional, I would like a similar design. Thanks i...
The chart I need is a swf. And it gets populated with asp or ...populated with asp or xml I think. For now I am looking to buy one chart so I test a few things. I will post a larger "real" project in the near future. You can use the FusionChart demo for this. Or if you have another flash charting program you already know I might be interested. Bottom line: I have to make some flash charts and get the data from MS_SQL2000. MS-SQL 2000 – Northwind FusionCharts: 1. Total orders group by month for 1998. 2. Total orders shipped by month for 1998. 3. Pick any one you want, as this is just a test. I am new here and looking for a reliable freelancer. I will always do an escrow for a project (as soon as I figure it out how).
More Information in The attachment “Requirements for GLS?? Actually we have an internal software for managing only the outbound chain: Based on the Northwind example of Access, ten years ago we developed this system as follow: - delivery documents, - Invoicing, - sales rep control and reporting - lots of reports and statistics only on sales. ** Module 1 - Improvement of the actual: **- (integration with a bar code reader) for outgoing goods - management of price lists, we would need assistance to edit pro-forma invoices and offers. - management of incoming orders - improvement of the management of the packing lists. We need to be able to scan a carton and being able to know what is inside. We need assistance for knowing how to integrate a bar code scann...
Need some help setting up a performance tester for a MS SQL 2005 server. Someone who could help me run through this (maybe over MSN Messegner/Skype) would be great: <> But any ready made Csharp tool, or even TSQL script which can give some performance stattics on a DB sever running commands on a Northwind database would be fine. Thanks, Nick ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables
I need help with four basic things in C#.NET windows app that is talking to Database SQL SERVER 2000: 1) I need to dynamically load names of the databases from my machine as Radio buttons on my win-form (say for ex: Pubs, Northwind, Adventureworks..etc..etc) 2) When I click on each such Radio button (like Pubs), it should again dynamically load all the tables of that database as individual checkboxes, one checkbox for everytable. 3) When I click on each such checkbox, it should display say 50 rows of that particular table. 4) Finally, if I select a particular table's checkbox and click on a button it should save those 50 rows either as text file, csv or pdf. I have done some work on my own but unable to dynamically load as radio buttons and checkboxes.....
Crystal Report Client Printing ActiveX This is for a web application. Crystal Reports needs to print at the local client machine printer rather than at the host machine. The developed component needs to pass the report itself to the local machine where is can be printed. This needs to be achieved with one click WITHOUT having to preview. Printing destinat...window printing, or conversion to other formats such as PDF then printing. In your bid, please specify your approach, some approaches (as outlined above) may not be acceptable. Developing a small activeX (similar to the one by crystal ) is what I have in mind, but would be open to other solutions if discussed first. Use any basic crytal reports with northwind or I can create some for you.
grip-electric is a web application i have partially written. i am a self taught computer user, not a trained programmer. please keep this in mind. the purpose of the grip electric program is to allow people in the motion picture production business to manipulate lists of grip and electric equipment. the database is fashioned similar to the sample database that comes with the microsoft program "access" (northwind). in particular my database has a similar junction table with two foriegn keys (used for 'orders'). my database is currently microsoft's SQL, and i have been using visual with visual basic code behind the asp pages. i am using microsoft's IIS 'server' to create the web application and test it. overview regarding grip electric us...
I want you to use Report Viewer in Visual Web Developer and create an order with a header, details and footer based on the Order and Order details table in the Northwind database in SQL Server 2005. The header should contain: OrderID, OrderDate, ShipAddress The details should contain: ProductID, UnitPrice, Quantity, Discount, Amount (UnitPrice * Quantity * (1-Discount)) The footer should contain: OrderSum It should read the OrderID to show from the querystring. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intende...
Need a strong C# / MS SQL developer. We need to create a tool to let users define their own Filters in Microsoft SQL. Please see attached document for screenshot of the current system. Deliverables: (1) 1st page: Web Tool to allow users set criteria and save it in database. (2) 2nd page: click on the view name and run associate query with that view and load data. You can use Northwind database in order to build the tool. Sagi
