Posted on: 7/14/2013 12:27:15 PM | Views : 276

Hi, 
I will enter maybe more than 1 student ID into a textbox, each new student id will separate by "newline".Why i doing this is because maybe 5 student will add same subject and i dont have to insert one by one. I can straight away enter 5 different student id and insert 5 data into database. Student ID that i enter  as you can see at below:
1119789 1117859 1257896 I need to put all this student id into a array list and  insert into database one by one.. Below is the sql insert statement :
insert into SubjectInfo (ID, StudentID, Subject, Class) VALUES ('3','1119789','Programming','IT'); Can anyone guide how to go about this?  
...

Go to the complete details ...