Mar 06, 2009 - 08:07 PM
I'm not sure why you want to bulk insert, so if you explained the circumstances a bit more, it might be easier to help.
Nevertheless T-SQL (sql server) does have a BULK INSERT function to insert records from a text file.
You can see the specifications here: http://doc.ddart.net/mssql/sql70/ba-b...
And see an example here: http://www.developerfusion.com/code/5...
If that's not what you want I would create a for loop and insert the records one by one, depending on the condition you mentioned.
Hope this helps, otherwise, please give some more information.
Mar 09, 2009 - 10:19 PM
Mar 09, 2009 - 11:30 PM
You didn't mention where the fees details come from. Is it a file, do you type it in manually on a webpage?
Mar 13, 2009 - 05:18 AM
Mar 16, 2009 - 10:58 PM
I'm not going to program the whole thing for you, but I'll be happy to give advice.
Mar 20, 2009 - 04:39 AM
Jun 04, 2009 - 06:33 PM
The Quomon Team
Mar 21, 2012 - 01:19 AM
1. create a .class file
this file contain 1 function for insert i.e. execute(str). if u want the internal code then i will send u after u like this logic. then after create a object of this file in ur code. then using this object u can call this function.now take the function call in loop.
i.e obj.execute("insert query").
using this function u can perform all type of insert, update and delete operation on database.
1 function = 3 operation.