In Progress

Add SQL Builder feature to existing windows form application

This project is for adding a new feature to an existing windows desktop application called DataDQ. DataDQ is a Data Quality software suite developed using Visual Studio 2010 C#. This is a windows desktop application that allows users to import text files or SQL Server tables then use features to profile or clean data from the imported file. There is also a feature called the MAP that will allow users to optionally save imported text files to SQL Server tables. This project is to add a new feature that will allow users to define and run SQL Server commands against imported SQL Server tables and/or text files. In addition, user will have the ability to save the SQL commands they enter which can later be opened and edited. The saved SQL Commands will be used in later feature to produce a score card report.

The scope of this project is as follows:

• Create a new tab called “SQL Command” as shown in the screen print attached.

• Create a new window form containing the controls shown in the screen print above.

• This project solution should not relay on a SQL Server connection. The solution must work independent of

SQL Server.

• Users will be able to create, open and delete a business rule set which is a collection of business rules.

• Users will be able to create, open, edit, and delete a business rule which is an entered SQL Command.

• Users will be able to save the results as a delimited text file.

• Users will be able to use this feature with open text files and SQL server table files.

• The solution should contain a SQL Command Syntax control. This control would validate the entered SQL

command and display an error message to the user

• Users will be able to use the following SQL Clauses - Add, Drop, Create, Insert, Select, Update, Replace

and Delete. At a minimum the highlighted clauses must be supported all others can be discussed. It is

understood that some commands above would only apply to SQLO Server table like the CREATE.

• The perfect solution would be to support the following SQL command features but I would like to know if any

of the commands below would be difficult to develop. At a minimum the highlighted commands must be

supported all others can be discussed.

o SQL Select

o SQL Insert Into

o SQL Where

o SQL Distinct

o SQL Update

o SQL Delete

o SQL Truncate Table

o SQL Order By

o SQL Aggregate functions

o SQL Group By

o SQL Having

o SQL Operators (i.e., And, Or

o SQL JOIN

o SQL Union

Please see the attached specificastion for more details. The ideal cannidate for this project should have the following experience:

1. Excellent expereince and knowledge using C#, Visiual Studio 2007 - 2010 to develop windows forms.

2. Must have SQL Server experience

3. Peferred to hire someone who has already completed a similuar project.

4. Must write clean and efficent code. All code will be review by a senior developer.

5. The selected developer will be provided with a minimized version of the DataDQ application.

Skills: C# Programming, SQL

See more: windows form builder, sql insert builder, windows form application sql, windows forms sql insert, insert sql windows forms, sql builder, sql builder windows application, where to hire application developer, union c programming, to hire someone, the perfect business card, tab scope, syntax programming, syntax in programming, sql software developer, sql developer to hire, set union, set o application, scope programming, scope application form

About the Employer:
( 50 reviews ) Powder Springs, United States

Project ID: #1379500

11 freelancers are bidding on average $846 for this job

tejas34

Please check PMB for more details.

$850 USD in 20 days
(34 Reviews)
6.1
thariyarox

Let me do the project. Please check my message for details. Thanks.

$500 USD in 20 days
(4 Reviews)
2.4
hatem87

I have Master Degree in Software and Computer Sciences. Please check my offer in PM. Thanks.

$660 USD in 15 days
(2 Reviews)
2.4
orangelab

Hi, Greetings! I've gone through your requirements to add a new feature to an existing windows desktop application, DataDQ and so glad to bid on the project as we have tremendous expertise and we would like to ha More

$730 USD in 28 days
(1 Review)
1.4
pramodv

I have very good experience of software development using Foxpro2.6(dos), Visual Foxpro 6 & 9, SQL Server 2000,2005,2008, C#, ASP.Net, Crystal Reports,MySql, HTML, CSS, JavaScript and jQuery.

$1200 USD in 30 days
(1 Review)
0.2
muhammadibaad

Sir, I have expertise to fullfill all your requirement,plz check pmb for more detail. Regards,

$550 USD in 25 days
(0 Reviews)
0.0
codexplorer

Please Check the PM

$700 USD in 30 days
(0 Reviews)
0.0
asharda

we have around 10 yrs of exp and have the team of expertise in various technologies. our last project is also window based which were then modified in client server technology and then we released its web version. Giv More

$1000 USD in 30 days
(0 Reviews)
0.0
buddhikam

Love to code with C# and interesting spec. Cannot wait. High Quality and Time line GUARANTEED.

$700 USD in 8 days
(0 Reviews)
0.0
MosesEdetek

I have been developing an ETL software using C#.Net in our company which can convert our business rule to SAS script and SQL Script for more than 3 years. At the past days, we also developed a tool which tranlated SQL More

$699 USD in 21 days
(0 Reviews)
0.0
vsevolodeu

Hello. My name is Vsevolod. I'm team leader in Russian software develpment company. We are ready to accomplish your project as soon as possible. Also we offer a free technical support for 3 month and discounts ob f More

$2200 USD in 20 days
(0 Reviews)
0.0
MK32z

Check PMB please.

$250 USD in 1 day
(0 Reviews)
0.0