Quick .NET job

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

Fixed Price

Delivery by December 3, 2012




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

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

  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) 155 reviews

Edmonton 12:44 PM

379 Jobs Posted
54% Hire Rate, 2 Open Jobs

Over $50,000 Total Spent
225 Hires, 5 Active

$14.62/hr Avg Hourly Rate Paid
8,369 Hours

Member Since Apr 18, 2011