sql to textbox to excel (formatted) to mail

See more:

VB

ASP.NET

Visual-Studio

ADO.NET

, +

i have a small form

employeenumber ---textbox

employee name ---- textbox

employee department ---- textbox

employee sal ----- textbox

employee age ---- textbox



now i have a webpage with search textbos

employeenumber ----- textbox (search crtiretia)

when user types employee number all the sql realted data should fill the form conataineing employee name, sal, age , dept etc.

next

i have 2 buttons

excel export

automail



in excel export i have a specified format




WHAT I ACTUALLY NEED IS

WHEN I CLICK EXPORT BUTTON TEXTBOX DATA SHOULD BE SEND TO EXCEL FILE

AND PARTICULAR TEXTBOX DATA SHOULD BE RECEIVED AT PARTICULAR CELL.

E.G:- TEXTBOX1 TO SEND TO C3 OR C4

TEXTBOX 2 TO SEND G9



WHEN I CLICK MAIL BUTTON

THAT DATA SHOULD BE SEND TO EXCEL AND AUTOMAILED AS ATTACHMENT





, I HAVE 3 EXCEL FILES WITH DIFFERENT FORMATS

EXPORT BUTTON SHOULD VIEW ALL THE EXCEL FILES WITH THEIR RESPECTIVE DATA

AND MAIL BUTTON SHOULD SEND MAIL THE EXCEL FILES WITH DATA , 1 USER I EXCEL FILE

2ND USER 2ND EXCEL FILE

3RD USER 3 EXCEL FILE




PLEASE HELP , ITS VERY URGENT

AND PLEASE HELP WITH COMPLETE SOLUTION.