Quick .NET job

Closed - This job posting has been filled and work has been completed.
Web & Mobile Development Desktop Software Development Posted 2 years ago

Fixed Price

Delivery by December 3, 2012

$15.00

Budget

Details

Quick console app with a function... that I can reuse

requirements:
- codes with vb.net 2005 express version
- compatible with .net framework 2.0 and later
- compatible with sqlserver 2005 express and later

specification:
  exportSQL2Excel(connectionString, sqlStatement, columnHeader, outputExcelFile, outputExcelSheet)

So what the function will do is:
a. connects to a SQL server based on connectionString, and retrieves a set of data based on sqlStatement.
b. write the the column headers, defined by columnHeader to the first row of outputExcelSheet of outputExcelFile.
c. write the retrieved set of data to the outputExcelSheet of outputExcelFile starting on second row.

So for the 5 arguments:
- connectionString: is a sqlserver connection string
- sqlStatement: is a select sql statement
- columnHeader: is a string of multiple column names separated by comma (,), and the column names may contain space (it is assumed that the column names listed in column Header will match what is being extracted by the sqlStatement).
- outputExcelFile: is a string of full path of location and name of an excel file
- outputExcelSheet: is name of an Excel Sheet (if it doesn't exist in outputExcelFile, then the function will create it as a new Sheet)

---
Skills: .net, visual-basic.net


About the Client

(5.00) 126 reviews

Canada
Edmonton 03:12 PM

290 Jobs Posted
57% Hire Rate, 1 Open Job

Over $50,000 Total Spent
178 Hires, 0 Active

$15.05/hr Avg Hourly Rate Paid
7,769 Hours

Member Since Apr 18, 2011