Input Group of data - Help needed ASAP

[srijyothi]

Hi,

I am beginner at VB.Net, and I need to implement Employee Training Application.

First one admin screen----------admin adds the employee info into Database.each time an employee takes a training course. Then it will be entered into the system via this screen.
So, we have fields like
1. EmpID

Requirement:
Group of 30 or 40 employees will take same course at the same time. We need to input all 30 or 40 employee names at a time instead of inputting each EmpID information.

I am expecting code sample or logic, please help me.


I had one solution, please correct me or suggest me, if you have good solution.

My solution: By uploading text file or Excel file with EmpID list.



Thanks in advance

Regards
Jyothi.

[swamivishal1]

Hi,

I am beginner at VB.Net, and I need to implement Employee Training Application.

First one admin screen----------admin adds the employee info into Database.each time an employee takes a training course. Then it will be entered into the system via this screen.
So, we have fields like
1. EmpID

Requirement:
Group of 30 or 40 employees will take same course at the same time. We need to input all 30 or 40 employee names at a time instead of inputting each EmpID information.

I am expecting code sample or logic, please help me.


I had one solution, please correct me or suggest me, if you have good solution.

My solution: By uploading text file or Excel file with EmpID list.



Thanks in advance

Regards
Jyothi.

hi jyothi,

the ideal plan will be to allow the user to upload a txt or excel file with empID l;ist then your code will take all these ID's and fetch the required info from the database and place these all info in the required place .

on how to read the excel file contents refer here (http://vishalswami.blogspot.com/2007/06/how-to-read-excel-file-using-c-code.html) :wave: